SAP ABAP Table CRMS_MKTPL_IB_CPT_COUP (Attributes of Campaign Element Coupon (IBOM MKTPL))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_IB_CPG (Package) CRM Marketing: iBom for Campaign
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_IB_CPG (Package) CRM Marketing: iBom for Campaign
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_MKTPL_IB_CPT_COUP | Table Relationship Diagram |
Short Description | Attributes of Campaign Element Coupon (IBOM MKTPL) |
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 | Coupon assignment attributes | |||||
2 | .INCLUDE | 0 | 0 | Coupon assignment key attributes | |||||
3 | GUID | CRM_MKTPL_COUPON_GUID | SYSUUID | RAW | 16 | 0 | GUID for a Coupon | ||
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 | * | |
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 | * | |
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 | * | |
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 | Coupon Assignment External Attributes | |||||
34 | BARCODE_TEXT | CRM_MKTPL_BARCODE_TYPE_T | CRM_MKTPL_BARCODE_TYPE_T | CHAR | 40 | 0 | Description of Barcode Type for Coupon | ||
35 | DISTMETHOD_TEXT | CRM_MKTPL_DISTMETHOD_T | CRM_MKTPL_DISTMETHOD_T | CHAR | 40 | 0 | Description of Distribution Method for Coupon | ||
36 | FAMCODE_TEXT | CRM_MKTPL_FAMCODE_T | CRM_MKTPL_FAMCODE_T | CHAR | 40 | 0 | Description of Family Code for Coupon | ||
37 | CLEARING_HOUSE_NR | CRM_MKTPL_CLEARING_HOUSE_NR | BU_PARTNER | CHAR | 10 | 0 | Clearing House | * | |
38 | CLEARING_HOUSE_TEXT | CRM_MKTPL_CLEARING_HOUSE_TEXT | CHAR | 40 | 0 | Clearing House Description | |||
39 | OFR_BRAND_TEXT | CRM_MKTPL_PRD_BRAND_TEXT | CHAR | 40 | 0 | Product Category Description | |||
40 | MANUFACTCODE_TEXT | CRM_MKTPL_MANUCODE_TEXT | CRM_MKTPL_MANUCODE_TEXT | CHAR | 40 | 0 | Description for Manufacturer Code | ||
41 | .INCLUDE | 0 | 0 |
History
Last changed by/on | SAP | 20110909 |
SAP Release Created in | 510 |