SAP ABAP Table CRMS_MKTPL_IB_VOUCHER (MKTPL IBOM Voucher Root Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-ST-VOC (Application Component) Voucher/Coupon
     ⤷ CRM_MKTPL_VOUCHER (Package) CRM Marketing: Voucher Processing

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_VOUCHER	Table Relationship Diagram
Short Description	MKTPL IBOM Voucher Root Structure

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	GUID	☐	CRM_MKTPL_VOUCHER_GUID	SYSUUID	RAW	16	0	Voucher GUID
2	VOUCHER_CODE	☐	CRM_MKTPL_VOUCHER_CODE	CRM_MKTPL_VOUCHER_CODE	CHAR	30	0	Voucher Code
3	CAMPAIGN_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
4	CAMPAIGN_DESCRIPTION	☐	CRM_MKTPL_IB_CPG_TEXT	TEXT40	CHAR	40	0	Campaign Description
5	ACCOUNT_ID	☐	CRM_MKTPL_VOU_ACCT_ID	BU_PARTNER	CHAR	10	0	Marketing Voucher Account ID	*
6	ACCOUNT_DESC	☐	CRM_MKTPL_ACC_DESC	TEXT80	CHAR	80	0	Marketing Voucher Account Description
7	CONTACT_ID	☐	CRM_MKTPL_VOU_CONTACT_ID	BU_PARTNER	CHAR	10	0	Marketing: Voucher Contact ID	*
8	CONTACT_DESC	☐	CRM_MKTPL_VOU_CONTACT_DESC	TEXT80	CHAR	80	0	Marketing Voucher Contact Description
9	ORDER_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
10	MEMBERSHIP_ID	☐	CRM_LOY_MEMS_ID	CRM_LOY_MEMS_ID	CHAR	10	0	Membership ID
11	CREATED_ON	☐	CRM_MKTPL_CREATED_ON	BCOS_TSTMP	DEC	15	0	Date of Creation of Coupon
12	CONSUMED_ON	☐	CRM_MKTPL_VOU_CONSUMED_ON	BCOS_TSTMP	DEC	15	0	Date of Consumption of Coupon
13	STAGE	☐	CRM_MKTPL_VOUCHER_STAGE	CRM_MKTPL_VOUCHER_STAGE	CHAR	1	0	CRM Marketing: Voucher Stage
14	CONSUMED_BY_ACCOUNT_ID	☐	CRM_MKTPL_VOU_ACCT_ID	BU_PARTNER	CHAR	10	0	Marketing Voucher Account ID	*
15	CONSUMED_BY_CONTACT_ID	☐	CRM_MKTPL_VOU_CONTACT_ID	BU_PARTNER	CHAR	10	0	Marketing: Voucher Contact ID	*
16	RETAIL_STORE_ID	☐	CRM_RETAIL_STORE_ID		CHAR	20	0	Retail Store ID
17	TRAN_SEQ_NUM	☐	CRM_TRAN_SEQ_NUM		CHAR	30	0	Transaction Sequence Number (POS)
18	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
19	VOUCHER_TYPE	☐	CRM_MKTPL_COUPON	CRM_MKTPL_COUPON	CHAR	1	0	Campaign Type for Coupon
20	STAGE_TEXT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
21	USAGE_GUID	☐	CRM_MKTPL_VOU_USAGE_GUID	SYSUUID	RAW	16	0	Voucher Usage GUID
22	VOUCHER_TYP_TEXT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
23	PRGM_DESC	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
24	PRGM_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
25	.INCLUDE	☐				0	0	Voucher Value
26	DECIMAL_VALUE	☐	CRM_MKTPL_VOU_VAL	CHAR21	CHAR	21	0	Voucher Value
27	MEASURE_UNIT_CODE	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
28	CURRENCY_CODE	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code

History

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