SAP ABAP Table CRMS_MKTPL_IB_CPG_COUP (Attributes of Campaign 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

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_CPG_COUP	Table Relationship Diagram
Short Description	Attributes of Campaign 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	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	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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_IB_CPG_COUP	BARCODE_TYPE	CRMC_MKTPL_BCO	BARCODE_TYPE
2	CRMS_MKTPL_IB_CPG_COUP	DISTMETHOD	CRMC_MKTPL_DISTM	DISTMETHOD
3	CRMS_MKTPL_IB_CPG_COUP	FCO_COUNTRY	T005	LAND1

History

Last changed by/on	SAP	20110909
SAP Release Created in	510