SAP ABAP Table CRMS_MKTPL_COUPON_ATTRIBUTES (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	INTTAB	Structure
Structure	CRMS_MKTPL_COUPON_ATTRIBUTES	Table Relationship Diagram
Short Description	Coupon assignment 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	.INCLUDE	☐				0	0	Coupon assignment key attributes
2	GUID	☐	CRM_MKTPL_COUPON_GUID	SYSUUID	RAW	16	0	GUID for a Coupon
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
32	.INCLUDE	☐				0	0	Coupon Assignment External Attributes
33	BARCODE_TEXT	☐	CRM_MKTPL_BARCODE_TYPE_T	CRM_MKTPL_BARCODE_TYPE_T	CHAR	40	0	Description of Barcode Type for Coupon
34	DISTMETHOD_TEXT	☐	CRM_MKTPL_DISTMETHOD_T	CRM_MKTPL_DISTMETHOD_T	CHAR	40	0	Description of Distribution Method for Coupon
35	FAMCODE_TEXT	☐	CRM_MKTPL_FAMCODE_T	CRM_MKTPL_FAMCODE_T	CHAR	40	0	Description of Family Code for Coupon
36	CLEARING_HOUSE_NR	☐	CRM_MKTPL_CLEARING_HOUSE_NR	BU_PARTNER	CHAR	10	0	Clearing House	*
37	CLEARING_HOUSE_TEXT	☐	CRM_MKTPL_CLEARING_HOUSE_TEXT		CHAR	40	0	Clearing House Description
38	OFR_BRAND_TEXT	☐	CRM_MKTPL_PRD_BRAND_TEXT		CHAR	40	0	Product Category Description
39	MANUFACTCODE_TEXT	☐	CRM_MKTPL_MANUCODE_TEXT	CRM_MKTPL_MANUCODE_TEXT	CHAR	40	0	Description for Manufacturer Code
40	.INCLUDE	☐				0	0

Foreign Keys

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

History

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