SAP ABAP Table CRMD_MKTPL_COUP (Coupon assignment attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_ASSIGN_COUPON (Package) CRM Marketing Planning - Assignments: Coupon

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_MKTPL_COUP	Table Relationship Diagram
Short Description	Coupon assignment attributes

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
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

Foreign Keys

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

History

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