SAP ABAP Table CRMS_MKTPL_IB_QUERY_VOUCHER (MKTPL IBOM Voucher Query 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_QUERY_VOUCHER	Table Relationship Diagram
Short Description	MKTPL IBOM Voucher Query 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	VOUCHER_TYPE	☐	CRM_MKTPL_COUPON	CRM_MKTPL_COUPON	CHAR	1	0	Campaign Type for Coupon
4	CAMPAIGN_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
5	CAMPAIGN_DESCRIPTION	☐	CRM_MKTPL_IB_CPG_TEXT	TEXT40	CHAR	40	0	Campaign Description
6	ACCOUNT_ID	☐	CRM_MKTPL_VOU_ACCT_ID	BU_PARTNER	CHAR	10	0	Marketing Voucher Account ID	*
7	ACCOUNT_DESC	☐	CRM_MKTPL_ACC_DESC	TEXT80	CHAR	80	0	Marketing Voucher Account Description
8	CONTACT_ID	☐	CRM_MKTPL_VOU_CONTACT_ID	BU_PARTNER	CHAR	10	0	Marketing: Voucher Contact ID	*
9	CONTACT_DESC	☐	CRM_MKTPL_VOU_CONTACT_DESC	TEXT80	CHAR	80	0	Marketing Voucher Contact Description
10	ORDER_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
11	MEMBERSHIP_ID	☐	CRM_LOY_MEMS_ID	CRM_LOY_MEMS_ID	CHAR	10	0	Membership ID
12	CREATED_ON	☐	CRM_MKTPL_VOU_CREATED_ON	DATUM	DATS	8	0	Created on Date for Vouchers
13	CONSUMED_ON	☐	CRM_MKTPL_VOU_CONSUMED_DATE	DATUM	DATS	8	0	Consumed on Date for Vouchers
14	STAGE	☐	CRM_MKTPL_VOUCHER_STAGE	CRM_MKTPL_VOUCHER_STAGE	CHAR	1	0	CRM Marketing: Voucher Stage
15	CONSUMED_BY_ACCOUNT_ID	☐	CRM_MKTPL_VOU_ACCT_ID	BU_PARTNER	CHAR	10	0	Marketing Voucher Account ID	*
16	CONSUMED_BY_CONTACT_ID	☐	CRM_MKTPL_VOU_CONTACT_ID	BU_PARTNER	CHAR	10	0	Marketing: Voucher Contact ID	*
17	RETAIL_STORE_ID	☐	CRM_RETAIL_STORE_ID		CHAR	20	0	Retail Store ID
18	TRAN_SEQ_NUM	☐	CRM_TRAN_SEQ_NUM		CHAR	30	0	Transaction Sequence Number (POS)
19	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
20	LOY_PROGRAM_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
21	TEXT1	☐	CRM_MKTPL_IB_LOY_TEXT	CHAR40	CHAR	40	0	Description of Loyalty Program

History

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