SAP ABAP Table CRMS_ESOA_VOUCHER (Voucher data)

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_ESOA_VOUCHER	Table Relationship Diagram
Short Description	Voucher data

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	MKTPL IBOM Voucher Root Structure
2	GUID	☐	CRM_MKTPL_VOUCHER_GUID	SYSUUID	RAW	16	0	Voucher GUID
3	VOUCHER_CODE	☐	CRM_MKTPL_VOUCHER_CODE	CRM_MKTPL_VOUCHER_CODE	CHAR	30	0	Voucher Code
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_CREATED_ON	BCOS_TSTMP	DEC	15	0	Date of Creation of Coupon
13	CONSUMED_ON	☐	CRM_MKTPL_VOU_CONSUMED_ON	BCOS_TSTMP	DEC	15	0	Date of Consumption of Coupon
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	VOUCHER_TYPE	☐	CRM_MKTPL_COUPON	CRM_MKTPL_COUPON	CHAR	1	0	Campaign Type for Coupon
21	STAGE_TEXT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
22	USAGE_GUID	☐	CRM_MKTPL_VOU_USAGE_GUID	SYSUUID	RAW	16	0	Voucher Usage GUID
23	VOUCHER_TYP_TEXT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
24	PRGM_DESC	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
25	PRGM_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
26	.INCLUDE	☐				0	0	Voucher Value
27	DECIMAL_VALUE	☐	CRM_MKTPL_VOU_VAL	CHAR21	CHAR	21	0	Voucher Value
28	MEASURE_UNIT_CODE	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
29	CURRENCY_CODE	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
30	CONSUMED_BY_CONTACT	☐	CRM_MKTPL_CONSUMED_VOU_BY_CONT	TEXT80	CHAR	80	0	Voucher Consumed by Contact
31	CONSUMED_BY_ACCOUNT	☐	CRM_MKTPL_CONSUMED_VOU_BY_ACCT	TEXT80	CHAR	80	0	Voucher Consumed by Account
32	VOUCHER_TYPE_NAME	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
33	NAME_REQUIRED_INDICATOR	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
34	PRE_VALIDATION_INDICATOR	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
35	SALES_ORDER_REF_CODE	☐			CHAR	5	0
36	MESSAGE_HEADER	☐	CRMST_MESSAGE_HEADER		STRU	0	0
37	ID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
38	UUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form

History

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