In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_coup table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_MKTPL_COUP what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_MKTPL_COUP....Right lets get started!
Object Name: CRMD_MKTPL_COUP
Dictionary Type: Transparent table
Description: Coupon assignment attributes
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRM_MKTPL_COUPON_GUID | RAW | 16(0) | GUID for a Coupon | SYSUUID | CRM | ||||||
| PROJECT_GUID | CGPL_GUID16 | RAW | 16(0) | Project Planning: 16-Character GUID for Projects and Activts | CGPL_PROJECT_GUID | CRM | ||||||
| TASK_GUID | CGPL_GUID16 | RAW | 16(0) | Project Planning: 16-Character GUID for Projects and Activts | CGPL_PROJECT_GUID | CRM | ||||||
| CLEARING_HOUSE | CRM_MKTPL_CLEARING_HOUSE | RAW | 16(0) | Clearing House for Coupon Assignment | SYSUUID | CRM | ||||||
| OFRCODE | CRM_MKTPL_OFRCODE | CHAR | 16(0) | Coupon Code | CRM_MKTPL_OFRCODE | CRM | ||||||
| CHECK_DIGIT | CRM_MKTPL_CHECK_DIGIT | CHAR | 1(0) | Check Digit of Coupon Code for Coupon | CRM_MKTPL_CHECK_DIGIT | CRM | ||||||
| FCO_COUNTRY | CRM_MKTPL_FCO_COUNTRY | CHAR | 3(0) | T005 | Country of the Family Code for a Coupon | LAND1 | CRM | |||||
| FAMCODE | CRM_MKTPL_FAMCODE | CHAR | 4(0) | * | Family Code for Coupon | CRM_MKTPL_FAMCODE | CRM | |||||
| VALCODE | CRM_MKTPL_VALCODE | CHAR | 3(0) | Value Code for Coupon | CRM_MKTPL_VALCODE | CRM | ||||||
| MANUFACTCODE | CRM_MKTPL_MANUCODE | CHAR | 8(0) | Manufacturer Code for Coupon | CRM_MKTPL_MANUCODE | CRM | ||||||
| BARCODE_TYPE | CRM_MKTPL_BARCODE_TYPE | CHAR | 20(0) | CRMC_MKTPL_BCO | Barcode Type for Coupon | CRM_MKTPL_BARCODE_TYPE | CRM | |||||
| SAVE_COUPON_IND | CRM_MKTPL_SAVE_COUPON_IND | CHAR | 1(0) | Save Coupon Indicator | CRM_BOOLEAN | CRM | ||||||
| RETAIL_SAVE_IND | CRM_MKTPL_RETAILER_SAVE_IND | CHAR | 1(0) | Sorted coupons by retailer | CRM_BOOLEAN | CRM | ||||||
| DISTMETHOD | CRM_MKTPL_DISTMETHOD | CHAR | 10(0) | CRMC_MKTPL_DISTM | Distribution Method for Coupon | CRM_MKTPL_DISTMETHOD | CRM | |||||
| EXP_DATE | CRM_MKTPL_EXP_DATE | DATS | 8(0) | Expiration Date for Coupon | CRM_MKTPL_EXP_DATE | CRM | ||||||
| OFR_BRAND_ID | CRM_MKTPL_OFR_BRAND | CHAR | 20(0) | Coupon Product Category | COM_CATEGORY_ID | CRM | ||||||
| OFR_BRAND_GUID | CRM_MKTPL_OFR_BRAND_GUID | RAW | 16(0) | GUID for Product Category | SYSUUID | CRM | ||||||
| COUPON_TYPE | CRM_MKTPL_COUPON | CHAR | 1(0) | Campaign Type for Coupon | CRM_MKTPL_COUPON | CRM |