SAP ABAP Table LOYMSH_MSHIDQRMSG_SYNC (Loyalty Programme Membership By ID Response - MDT)

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_MSHIDQRMSG_SYNC	Table Relationship Diagram
Short Description	Loyalty Programme Membership By ID Response - MDT

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	MESSAGE_HEADER	☐	LOY_BASIC_BUSINESS_DOCUMENT_ME		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	ID	☐	LOY_BUS_DOC_MSG_ID		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	SCHEME_ID	☐			CHAR	60	0
7	SCHEME_AGENCY_ID	☐			CHAR	60	0
8	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
9	CONTENT	☐	LOY_BUSINESS_DOCUMENT_MESSAGE		CHAR	35	0	Unique identifier of a business document in a (technical) me
10	UUID	☐	LOY_ATTRIBUTEINDEPENDENT_UUID		CHAR	36	0	Universally Unique Identifier (without attributes)
11	REFERENCE_ID	☐	LOY_BUS_DOC_MSG_ID		STRU	0	0
12	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
13	SCHEME_ID	☐			CHAR	60	0
14	SCHEME_AGENCY_ID	☐			CHAR	60	0
15	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
16	CONTENT	☐	LOY_BUSINESS_DOCUMENT_MESSAGE		CHAR	35	0	Unique identifier of a business document in a (technical) me
17	REFERENCE_UUID	☐	LOY_ATTRIBUTEINDEPENDENT_UUID		CHAR	36	0	Universally Unique Identifier (without attributes)
18	LOYALTY_PROGRAMME_MEMBERSHIP	☐	LOYMSH_MSHIDQR_LOYPROGMBRSHP		STRU	0	0
19	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
20	ID	☐	LOY_LOYALTY_PROG_MEMBERSHIP_ID		STRU	0	0
21	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
22	SCHEME_ID	☐			CHAR	60	0
23	SCHEME_VERSION_ID	☐			CHAR	15	0
24	SCHEME_AGENCY_ID	☐			CHAR	60	0
25	CONTENT	☐	LOY_LOYALTY_PROGRAMME_MEMBERSH		CHAR	40	0	Proxy Data Element (generated)
26	CHANGE_STATE_ID	☐	LOY_CHANGE_STATE_ID		CHAR	40	0	Proxy Data Element (generated)
27	LOYALTY_PROGRAMME_ID	☐	LOY_LOYALTY_PROGRAMME_ID		STRU	0	0
28	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
29	SCHEME_ID	☐			CHAR	60	0
30	SCHEME_VERSION_ID	☐			CHAR	15	0
31	SCHEME_AGENCY_ID	☐			CHAR	60	0
32	CONTENT	☐	LOY_LOYALTY_PROGRAMME_ID_CONTE		CHAR	24	0	Proxy Data Element (generated)
33	LOYALTY_PROGRAMME_DESCRIPTION	☐	LOY_MEDIUM_DESCRIPTION		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
36	CONTENT	☐	LOY_MEDIUM_DESCRIPTION_CONTENT		CHAR	80	0	Proxy Data Element (generated)
37	CAMPAIGN_ID	☐	LOY_CAMPAIGN_ID1		STRU	0	0
38	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
39	SCHEME_ID	☐			CHAR	60	0
40	SCHEME_VERSION_ID	☐			CHAR	15	0
41	SCHEME_AGENCY_ID	☐			CHAR	60	0
42	CONTENT	☐	LOY_CAMPAIGN_ID_CONTENT		CHAR	24	0	Proxy Data Element (generated)
43	CAMPAIGN_DESCRIPTION	☐	LOY_MEDIUM_DESCRIPTION		STRU	0	0
44	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
45	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
46	CONTENT	☐	LOY_MEDIUM_DESCRIPTION_CONTENT		CHAR	80	0	Proxy Data Element (generated)
47	LOYALTY_PROGRAMME_POINT_ACCOUN	☐	LOY_LOYLTY_PROG_PTACCT_GROUPID		STRU	0	0
48	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
49	SCHEME_ID	☐			CHAR	60	0
50	SCHEME_VERSION_ID	☐			CHAR	15	0
51	SCHEME_AGENCY_ID	☐			CHAR	60	0
52	CONTENT	☐	LOY_LOYALTY_PROGRAMME_POINT_AC		CHAR	15	0	Proxy Data Element (generated)
53	START_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
54	END_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
55	USER_STATUS	☐	LOY_USER_STATUS		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	CODE	☐	LOY_USER_STATUS_CODE		STRU	0	0
58	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
59	LIST_ID	☐			CHAR	60	0
60	LIST_VERSION_ID	☐			CHAR	15	0
61	LIST_AGENCY_ID	☐			CHAR	60	0
62	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
63	LIST_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
64	CONTENT	☐	LOY_USER_STATUS_CODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
65	NAME	☐	LOY_LEN30_NAME		STRU	0	0
66	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
67	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
68	CONTENT	☐	LOY_LEN30_NAME_CONTENT		CHAR	30	0	Proxy Data Element (generated)
69	ORDINAL_NUMBER_VALUE	☐	LOY_ORDINAL_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
70	ACTIVE_INDICATOR	☐	LOY_INDICATOR	XSDBOOLEAN	CHAR	1	0	Representation of two mutually exclusive Boolean value
71	MEMBER_PARTY	☐	LOYMSH_LOYLTY_PROG_MBRSHP_TAB9		TTYP	0	0
72	AGENT_PARTY	☐	LOYMSH_MSHIDQR_AGTPTY		STRU	0	0
73	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
74	ID	☐	LOY_PARTY_ID		STRU	0	0
75	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
76	SCHEME_ID	☐			CHAR	60	0
77	SCHEME_AGENCY_ID	☐			CHAR	60	0
78	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
79	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
80	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
81	FORMATTED_NAME	☐	LOY_LONG_NAME		STRU	0	0
82	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
83	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
84	CONTENT	☐	LOY_LONG_NAME_CONTENT		CHAR	80	0	Proxy Data Element (generated)
85	TIER	☐	LOYMSH_LOYLTY_PROG_MBRSH_TAB11		TTYP	0	0
86	POINT_ACCOUNT	☐	LOYMSH_LOYLTY_PROG_MBRSH_TAB10		TTYP	0	0
87	LOG	☐	LOY_LOG		STRU	0	0
88	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
89	PROCESSING_RESULT_CODE	☐	LOY_PROCESSING_RESULT_CODE		CHAR	2	0	Proxy Data Element (generated)
90	MAXIMUM_LOG_ITEM_SEVERITY_CODE	☐	LOY_LOG_ITEM_SEVERITY_CODE		CHAR	1	0	Proxy Data Element (generated)
91	ITEM	☐	LOY_LOG_ITEM_TAB		TTYP	0	0

History

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