SAP ABAP Table CRM_MKTPL_COU_CD (Marketing Planning: Change Doc. Struct. for CRMD_MKTPL_COUP.)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL (Package) CRM Marketing Planning - User Interfaces

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_MKTPL_COU_CD	Table Relationship Diagram
Short Description	Marketing Planning: Change Doc. Struct. for CRMD_MKTPL_COUP.

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
3	.INCLUDE	☐				0	0	Coupon assignment non key attributes
4	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
5	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
6	CLEARING_HOUSE	☐	CRM_MKTPL_CLEARING_HOUSE	SYSUUID	RAW	16	0	Clearing House for Coupon Assignment
7	OFRCODE	☐	CRM_MKTPL_OFRCODE	CRM_MKTPL_OFRCODE	CHAR	16	0	Coupon Code
8	CHECK_DIGIT	☐	CRM_MKTPL_CHECK_DIGIT	CRM_MKTPL_CHECK_DIGIT	CHAR	1	0	Check Digit of Coupon Code for Coupon
9	FCO_COUNTRY	☐	CRM_MKTPL_FCO_COUNTRY	LAND1	CHAR	3	0	Country of the Family Code for a Coupon	T005
10	FAMCODE	☐	CRM_MKTPL_FAMCODE	CRM_MKTPL_FAMCODE	CHAR	4	0	Family Code for Coupon
11	VALCODE	☐	CRM_MKTPL_VALCODE	CRM_MKTPL_VALCODE	CHAR	3	0	Value Code for Coupon
12	MANUFACTCODE	☐	CRM_MKTPL_MANUCODE	CRM_MKTPL_MANUCODE	CHAR	12	0	Manufacturer Code for Coupon
13	BARCODE_TYPE	☐	CRM_MKTPL_BARCODE_TYPE	CRM_MKTPL_BARCODE_TYPE	CHAR	20	0	Barcode Type for Coupon	CRMC_MKTPL_BCO
14	SAVE_COUPON_IND	☐	CRM_MKTPL_SAVE_COUPON_IND	CRM_BOOLEAN	CHAR	1	0	Save Coupon Indicator
15	RETAIL_SAVE_IND	☐	CRM_MKTPL_RETAILER_SAVE_IND	CRM_BOOLEAN	CHAR	1	0	Sorted coupons by retailer
16	DISTMETHOD	☐	CRM_MKTPL_DISTMETHOD	CRM_MKTPL_DISTMETHOD	CHAR	10	0	Distribution Method for Coupon	CRMC_MKTPL_DISTM
17	EXP_DATE	☐	CRM_MKTPL_EXP_DATE	CRM_MKTPL_EXP_DATE	DATS	8	0	Expiration Date for Coupon
18	OFR_BRAND_ID	☐	CRM_MKTPL_OFR_BRAND	COM_CATEGORY_ID	CHAR	20	0	Coupon Product Category
19	OFR_BRAND_GUID	☐	CRM_MKTPL_OFR_BRAND_GUID	SYSUUID	RAW	16	0	GUID for Product Category
20	COUPON_TYPE	☐	CRM_MKTPL_COUPON	CRM_MKTPL_COUPON	CHAR	1	0	Campaign Type for Coupon
21	CODE_TYPE	☐	CRM_MKTPL_CODE_TYPE	CRM_MKTPL_CODE_TYPE	CHAR	1	0	Unique or Identical code
22	ORDER_USAGE	☐	CRM_MKTPL_ORDER_USAGE	CRM_MKTPL_ORDER_USAGE	CHAR	1	0	Usage Restrictions
23	CODE_COUNT	☐	CRM_MKTPL_CODE_COUNT	CRM_MKTPL_CODE_COUNT	INT4	10	0	Number of Anonymous Vouchers
24	VARIANT_TYPE	☐	CRM_MKTPL_VOUCODE_VARIANT	CRM_MKTPL_VOUCODE_VARIANT	CHAR	20	0	Voucher Code Variant
25	POINTS	☐	CRM_LOY_PT_POINT		DEC	10	2	Loyalty Point
26	POINT_TYPE	☐	CRM_LOY_PT_TYPE		CHAR	20	0	Loyalty Management Point Type
27	POINT_QUAL_TYPE	☐	CRM_LOY_PT_QUAL_TYPE		CHAR	20	0	Loyalty Point Qualification Type
28	SO_CANCELLATION	☐	CRM_MKTPL_SO_CANC	CRM_MKTPL_SO_CANC	CHAR	1	0	voucher Behaviour based on SO cancellation
29	BTCHJOB_GUID	☐	CRMT_BTCHJOB_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Batch Job for Target Group Transfer
30	.INCLUDE	☐				0	0	Extension Include - Coupon Assignment
31	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	CRM_MKTPL_COU_CD	BARCODE_TYPE	CRMC_MKTPL_BCO	BARCODE_TYPE
2	CRM_MKTPL_COU_CD	DISTMETHOD	CRMC_MKTPL_DISTM	DISTMETHOD
3	CRM_MKTPL_COU_CD	FCO_COUNTRY	T005	LAND1

History

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