SAP ABAP Table LOYMSH_MSHCRTCO_LOYLTYPROGMSH (IDT - Loyalty Programme Membership)

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_MSHCRTCO_LOYLTYPROGMSH	Table Relationship Diagram
Short Description	IDT - Loyalty Programme Membership

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	CHANGE_STATE_ID	☐	LOY_CHANGE_STATE_ID		CHAR	40	0	Proxy Data Element (generated)
9	LOYALTY_PROGRAMME_ID	☐	LOY_LOYALTY_PROGRAMME_ID		STRU	0	0
10	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
11	SCHEME_ID	☐			CHAR	60	0
12	SCHEME_VERSION_ID	☐			CHAR	15	0
13	SCHEME_AGENCY_ID	☐			CHAR	60	0
14	CONTENT	☐	LOY_LOYALTY_PROGRAMME_ID_CONTE		CHAR	24	0	Proxy Data Element (generated)
15	LOYALTY_PROGRAMME_DESCRIPTION	☐	LOY_MEDIUM_DESCRIPTION		STRU	0	0
16	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
17	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
18	CONTENT	☐	LOY_MEDIUM_DESCRIPTION_CONTENT		CHAR	80	0	Proxy Data Element (generated)
19	CAMPAIGN_ID	☐	LOY_CAMPAIGN_ID1		STRU	0	0
20	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
21	SCHEME_ID	☐			CHAR	60	0
22	SCHEME_VERSION_ID	☐			CHAR	15	0
23	SCHEME_AGENCY_ID	☐			CHAR	60	0
24	CONTENT	☐	LOY_CAMPAIGN_ID_CONTENT		CHAR	24	0	Proxy Data Element (generated)
25	CAMPAIGN_DESCRIPTION	☐	LOY_MEDIUM_DESCRIPTION		STRU	0	0
26	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
27	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
28	CONTENT	☐	LOY_MEDIUM_DESCRIPTION_CONTENT		CHAR	80	0	Proxy Data Element (generated)
29	START_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
30	END_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
31	USER_STATUS	☐	LOY_USER_STATUS		STRU	0	0
32	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
33	CODE	☐	LOY_USER_STATUS_CODE		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	LIST_ID	☐			CHAR	60	0
36	LIST_VERSION_ID	☐			CHAR	15	0
37	LIST_AGENCY_ID	☐			CHAR	60	0
38	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
39	LIST_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
40	CONTENT	☐	LOY_USER_STATUS_CODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
41	NAME	☐	LOY_LEN30_NAME		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
44	CONTENT	☐	LOY_LEN30_NAME_CONTENT		CHAR	30	0	Proxy Data Element (generated)
45	ORDINAL_NUMBER_VALUE	☐	LOY_ORDINAL_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
46	ACTIVE_INDICATOR	☐	LOY_INDICATOR	XSDBOOLEAN	CHAR	1	0	Representation of two mutually exclusive Boolean value
47	MEMBER_PARTY	☐	LOYMSH_MSHCRTCO_MBRPTY		STRU	0	0
48	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
49	MEMBER_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	MEMBER_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)
60	CUSTOMER_CARD	☐	LOYMSH_MSHCRTCO_CUSTCARD		STRU	0	0
61	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
62	ID	☐	LOY_SMART_CARD_ID		STRU	0	0
63	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
64	SCHEME_ID	☐			CHAR	60	0
65	SCHEME_VERSION_ID	☐			CHAR	15	0
66	SCHEME_AGENCY_ID	☐			CHAR	60	0
67	CONTENT	☐	LOY_SMART_CARD_ID_CONTENT		CHAR	25	0	Proxy Data Element (generated)
68	CARD_TYPE_CODE	☐	LOY_MSH_CARD_TYPECODE		STRU	0	0
69	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
70	LIST_ID	☐			CHAR	60	0
71	LIST_VERSION_ID	☐			CHAR	15	0
72	LIST_AGENCY_ID	☐			CHAR	60	0
73	CONTENT	☐	LOY_MSH_CARD_TYPECODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
74	CARD_TYPE_NAME	☐	LOY_MEDIUM_NAME		STRU	0	0
75	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
76	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
77	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)

History

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