SAP ABAP Table MKTCRM_MKTPL_COU_CD (Change Document Structure; Generated by RSSCD000)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL (Package) CRM Marketing Planning - User Interfaces
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL (Package) CRM Marketing Planning - User Interfaces
Basic Data
Table Category | INTTAB | Structure |
Structure | MKTCRM_MKTPL_COU_CD | Table Relationship Diagram |
Short Description | Change Document Structure; Generated by RSSCD000 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Marketing Planning: Change Doc. Struct. for CRMD_MKTPL_COUP. | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | ||
4 | .INCLUDE | 0 | 0 | Coupon assignment non key attributes | |||||
5 | PROJECT_GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | ||
6 | TASK_GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | ||
7 | CLEARING_HOUSE | CRM_MKTPL_CLEARING_HOUSE | SYSUUID | RAW | 16 | 0 | Clearing House for Coupon Assignment | ||
8 | OFRCODE | CRM_MKTPL_OFRCODE | CRM_MKTPL_OFRCODE | CHAR | 16 | 0 | Coupon Code | ||
9 | CHECK_DIGIT | CRM_MKTPL_CHECK_DIGIT | CRM_MKTPL_CHECK_DIGIT | CHAR | 1 | 0 | Check Digit of Coupon Code for Coupon | ||
10 | FCO_COUNTRY | CRM_MKTPL_FCO_COUNTRY | LAND1 | CHAR | 3 | 0 | Country of the Family Code for a Coupon | T005 | |
11 | FAMCODE | CRM_MKTPL_FAMCODE | CRM_MKTPL_FAMCODE | CHAR | 4 | 0 | Family Code for Coupon | ||
12 | VALCODE | CRM_MKTPL_VALCODE | CRM_MKTPL_VALCODE | CHAR | 3 | 0 | Value Code for Coupon | ||
13 | MANUFACTCODE | CRM_MKTPL_MANUCODE | CRM_MKTPL_MANUCODE | CHAR | 12 | 0 | Manufacturer Code for Coupon | ||
14 | BARCODE_TYPE | CRM_MKTPL_BARCODE_TYPE | CRM_MKTPL_BARCODE_TYPE | CHAR | 20 | 0 | Barcode Type for Coupon | CRMC_MKTPL_BCO | |
15 | SAVE_COUPON_IND | CRM_MKTPL_SAVE_COUPON_IND | CRM_BOOLEAN | CHAR | 1 | 0 | Save Coupon Indicator | ||
16 | RETAIL_SAVE_IND | CRM_MKTPL_RETAILER_SAVE_IND | CRM_BOOLEAN | CHAR | 1 | 0 | Sorted coupons by retailer | ||
17 | DISTMETHOD | CRM_MKTPL_DISTMETHOD | CRM_MKTPL_DISTMETHOD | CHAR | 10 | 0 | Distribution Method for Coupon | CRMC_MKTPL_DISTM | |
18 | EXP_DATE | CRM_MKTPL_EXP_DATE | CRM_MKTPL_EXP_DATE | DATS | 8 | 0 | Expiration Date for Coupon | ||
19 | OFR_BRAND_ID | CRM_MKTPL_OFR_BRAND | COM_CATEGORY_ID | CHAR | 20 | 0 | Coupon Product Category | ||
20 | OFR_BRAND_GUID | CRM_MKTPL_OFR_BRAND_GUID | SYSUUID | RAW | 16 | 0 | GUID for Product Category | ||
21 | COUPON_TYPE | CRM_MKTPL_COUPON | CRM_MKTPL_COUPON | CHAR | 1 | 0 | Campaign Type for Coupon | ||
22 | CODE_TYPE | CRM_MKTPL_CODE_TYPE | CRM_MKTPL_CODE_TYPE | CHAR | 1 | 0 | Unique or Identical code | ||
23 | ORDER_USAGE | CRM_MKTPL_ORDER_USAGE | CRM_MKTPL_ORDER_USAGE | CHAR | 1 | 0 | Usage Restrictions | ||
24 | CODE_COUNT | CRM_MKTPL_CODE_COUNT | CRM_MKTPL_CODE_COUNT | INT4 | 10 | 0 | Number of Anonymous Vouchers | ||
25 | VARIANT_TYPE | CRM_MKTPL_VOUCODE_VARIANT | CRM_MKTPL_VOUCODE_VARIANT | CHAR | 20 | 0 | Voucher Code Variant | ||
26 | POINTS | CRM_LOY_PT_POINT | DEC | 10 | 2 | Loyalty Point | |||
27 | POINT_TYPE | CRM_LOY_PT_TYPE | CHAR | 20 | 0 | Loyalty Management Point Type | |||
28 | POINT_QUAL_TYPE | CRM_LOY_PT_QUAL_TYPE | CHAR | 20 | 0 | Loyalty Point Qualification Type | |||
29 | SO_CANCELLATION | CRM_MKTPL_SO_CANC | CRM_MKTPL_SO_CANC | CHAR | 1 | 0 | voucher Behaviour based on SO cancellation | ||
30 | BTCHJOB_GUID | CRMT_BTCHJOB_GUID | SYSUUID | RAW | 16 | 0 | CRM Marketing: GUID of Batch Job for Target Group Transfer | ||
31 | .INCLUDE | 0 | 0 | Extension Include - Coupon Assignment | |||||
32 | MKTPL_COUPON | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
33 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
34 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MKTCRM_MKTPL_COU_CD | BARCODE_TYPE | CRMC_MKTPL_BCO | BARCODE_TYPE | |||
2 | MKTCRM_MKTPL_COU_CD | DISTMETHOD | CRMC_MKTPL_DISTM | DISTMETHOD | |||
3 | MKTCRM_MKTPL_COU_CD | FCO_COUNTRY | T005 | LAND1 |
History
Last changed by/on | SAP | 20110909 |
SAP Release Created in |