SAP ABAP Table LOYMSH_LOYLTY_PROG_MBRSHP_CR10 (IDT - Loyalty Program Membership from Membership Search CRM)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY-INT-POS (Application Component) Loyalty POS Integration
     ⤷ LOY_MSH_XI_PROXY (Package) Loyalty Membership XI Proxy Generation

Basic Data

Table Category	INTTAB	Structure
Structure	LOYMSH_LOYLTY_PROG_MBRSHP_CR10	Table Relationship Diagram
Short Description	IDT - Loyalty Program Membership from Membership Search CRM

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	ID	☐	LOY_LOYALTY_PROG_MEMBERSHIP_ID		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	SCHEME_ID	☐			CHAR	60	0
5	SCHEME_VERSION_ID	☐			CHAR	15	0
6	SCHEME_AGENCY_ID	☐			CHAR	60	0
7	CONTENT	☐	LOY_LOYALTY_PROGRAMME_MEMBERSH		CHAR	40	0	Proxy Data Element (generated)
8	LOYALTY_PROGRAMME_ID	☐	LOY_LOYALTY_PROGRAMME_ID		STRU	0	0
9	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
10	SCHEME_ID	☐			CHAR	60	0
11	SCHEME_VERSION_ID	☐			CHAR	15	0
12	SCHEME_AGENCY_ID	☐			CHAR	60	0
13	CONTENT	☐	LOY_LOYALTY_PROGRAMME_ID_CONTE		CHAR	24	0	Proxy Data Element (generated)
14	LOYALTY_PROGRAMME_DESCRIPTION	☐	LOY_MEDIUM_DESCRIPTION		STRU	0	0
15	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
16	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
17	CONTENT	☐	LOY_MEDIUM_DESCRIPTION_CONTENT		CHAR	80	0	Proxy Data Element (generated)
18	CAMPAIGN_ID	☐	LOY_CAMPAIGN_ID1		STRU	0	0
19	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
20	SCHEME_ID	☐			CHAR	60	0
21	SCHEME_VERSION_ID	☐			CHAR	15	0
22	SCHEME_AGENCY_ID	☐			CHAR	60	0
23	CONTENT	☐	LOY_CAMPAIGN_ID_CONTENT		CHAR	24	0	Proxy Data Element (generated)
24	CAMPAIGN_DESCRIPTION	☐	LOY_MEDIUM_DESCRIPTION		STRU	0	0
25	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
26	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
27	CONTENT	☐	LOY_MEDIUM_DESCRIPTION_CONTENT		CHAR	80	0	Proxy Data Element (generated)
28	START_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
29	END_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
30	USER_STATUS	☐	LOY_USER_STATUS		STRU	0	0
31	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
32	CODE	☐	LOY_USER_STATUS_CODE		STRU	0	0
33	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
34	LIST_ID	☐			CHAR	60	0
35	LIST_VERSION_ID	☐			CHAR	15	0
36	LIST_AGENCY_ID	☐			CHAR	60	0
37	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
38	LIST_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
39	CONTENT	☐	LOY_USER_STATUS_CODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
40	NAME	☐	LOY_LEN30_NAME		STRU	0	0
41	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
42	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
43	CONTENT	☐	LOY_LEN30_NAME_CONTENT		CHAR	30	0	Proxy Data Element (generated)
44	ORDINAL_NUMBER_VALUE	☐	LOY_ORDINAL_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
45	ACTIVE_INDICATOR	☐	LOY_INDICATOR	XSDBOOLEAN	CHAR	1	0	Representation of two mutually exclusive Boolean value
46	MEMBER_PARTY	☐	LOYMSH_LOYLTY_PROG_MBRSHP_TAB6		TTYP	0	0
47	AGENT_PARTY	☐	LOYMSH_MSHELMNTSRQ_LOYPRGPTPTY		STRU	0	0
48	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
49	ID	☐	LOY_PARTY_ID		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	SCHEME_ID	☐			CHAR	60	0
52	SCHEME_AGENCY_ID	☐			CHAR	60	0
53	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
54	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
55	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
56	FORMATTED_NAME	☐	LOY_LONG_NAME		STRU	0	0
57	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
58	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
59	CONTENT	☐	LOY_LONG_NAME_CONTENT		CHAR	80	0	Proxy Data Element (generated)

History

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