SAP ABAP Table CRMS_MKTPL_COUPON_NON_KEY (Coupon assignment non key 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	INTTAB	Structure
Structure	CRMS_MKTPL_COUPON_NON_KEY	Table Relationship Diagram
Short Description	Coupon assignment non key attributes

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

History

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