SAP ABAP Table CRMS_MKTPL_VO_BI (Extract structure for Voucher)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY (Application Component) Loyalty
     ⤷ CRM_LOY_BI (Package) Package for CRM Loyalty BI objects

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_VO_BI	Table Relationship Diagram
Short Description	Extract structure for Voucher

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	VO_USAGE_GUID	☐	CRM_MKTPL_VOUCHER_GUID	SYSUUID	RAW	16	0	Voucher GUID
3	VOUCHER_TYPE	☐	CRM_MKTPL_COUPON	CRM_MKTPL_COUPON	CHAR	1	0	Campaign Type for Coupon
4	VOUCHER_CODE	☐	CRM_MKTPL_VOUCHER_CODE	CRM_MKTPL_VOUCHER_CODE	CHAR	30	0	Voucher Code
5	VARIANT_TYPE	☐	CRM_MKTPL_VOUCODE_VARIANT	CRM_MKTPL_VOUCODE_VARIANT	CHAR	20	0	Voucher Code Variant
6	CAMPAIGN_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
7	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
8	ACCOUNT_ID	☐	CRM_MKTPL_VOU_ACCT_ID	BU_PARTNER	CHAR	10	0	Marketing Voucher Account ID	*
9	ACCOUNT_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
10	CONTACT_ID	☐	CRM_MKTPL_VOU_CONTACT_ID	BU_PARTNER	CHAR	10	0	Marketing: Voucher Contact ID	*
11	CONTACT_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
12	CONS_BY_ACC_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
13	CONS_BY_ACC_ID	☐	CRM_MKTPL_VOU_ACCT_ID	BU_PARTNER	CHAR	10	0	Marketing Voucher Account ID	*
14	CONS_BY_CON_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
15	CONS_BY_CON_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	CREATED_ON	☐	CRM_MKTPL_CREATED_ON	BCOS_TSTMP	DEC	15	0	Date of Creation of Coupon
18	CONSUMED_ON	☐	CRM_MKTPL_VOU_CONSUMED_ON	BCOS_TSTMP	DEC	15	0	Date of Consumption of Coupon
19	STAGE	☐	CRM_MKTPL_VOUCHER_STAGE	CRM_MKTPL_VOUCHER_STAGE	CHAR	1	0	CRM Marketing: Voucher Stage
20	PROGRAM_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
21	PROGRAM_GUID	☐	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
22	KF_CONSUMED	☐	CRM_BW_VO_STATUS	CRM_BW_VO_STATUS	INT1	3	0	Voucher Status Key Figures
23	KF_INVALID	☐	CRM_BW_VO_STATUS	CRM_BW_VO_STATUS	INT1	3	0	Voucher Status Key Figures
24	KF_TOTAL	☐	CRM_BW_VO_STATUS	CRM_BW_VO_STATUS	INT1	3	0	Voucher Status Key Figures
25	CHANGED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
26	VO_TYPE_FLAG	☐	CRM_BW_VO_TYPE_FLAG	CRM_BW_VO_TYPE_FLAG	INT1	3	0	Anonymous Voucher Flag

History

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