SAP ABAP Table LOYMSH_MSHIDQR_MBRPTY (Loyalty Programme Membership by ID Member Party - IDT)

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_MSHIDQR_MBRPTY	Table Relationship Diagram
Short Description	Loyalty Programme Membership by ID Member Party - IDT

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_PARTY_ID		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	SCHEME_ID	☐			CHAR	60	0
5	SCHEME_AGENCY_ID	☐			CHAR	60	0
6	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
7	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
8	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
9	FORMATTED_NAME	☐	LOY_LONG_NAME		STRU	0	0
10	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
11	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
12	CONTENT	☐	LOY_LONG_NAME_CONTENT		CHAR	80	0	Proxy Data Element (generated)
13	VALIDITY_PERIOD	☐	LOYMSH_CLOSED_DATE_PERIOD		STRU	0	0
14	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
15	START_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
16	END_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
17	MAIN_INDICATOR	☐	LOY_INDICATOR	XSDBOOLEAN	CHAR	1	0	Representation of two mutually exclusive Boolean value
18	STREET_NAME	☐	LOY_STREET_NAME		CHAR	60	0	Proxy Data Element (generated)
19	CITY_NAME	☐	LOY_MEDIUM_NAME		STRU	0	0
20	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
21	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
22	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
23	REGION_CODE	☐	LOY_REGION_CODE		STRU	0	0
24	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
25	LIST_ID	☐			CHAR	60	0
26	LIST_VERSION_ID	☐			CHAR	15	0
27	LIST_AGENCY_ID	☐			CHAR	60	0
28	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
29	LIST_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
30	CONTENT	☐	LOY_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (generated)
31	REGION_NAME	☐	LOY_LANG_INDE_MEDIUM_NAME		CHAR	40	0	Proxy Data Element (generated)
32	COUNTRY_CODE	☐	LOY_COUNTRY_CODE		CHAR	3	0	Country Code
33	COUNTRY_NAME	☐	LOY_MEDIUM_NAME		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_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
37	POSTAL_CODE	☐	LOY_POSTAL_CODE		CHAR	10	0	Proxy Data Element (generated)
38	EMAIL_URI	☐	LOY_EMAIL_URI		STRU	0	0
39	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
40	SCHEME_ID	☐			CHAR	60	0
41	CONTENT	☐			STRG	0	0
42	PHONE_NUMBER	☐	LOY_PHONE_NUMBER		STRU	0	0
43	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
44	AREA_ID	☐	LOY_PHONE_NUMBER_AREA_ID		CHAR	10	0	Phobne Number Area ID
45	SUBSCRIBER_ID	☐	LOY_PHONE_NUMBER_SUBSCRIBER_ID		CHAR	30	0	Proxy Data Element (generated)
46	EXTENSION_ID	☐	LOY_PHONE_NUMBER_EXTENSION_ID		CHAR	10	0	Phone Number extension ID
47	COUNTRY_CODE	☐	LOY_COUNTRY_CODE		CHAR	3	0	Country Code
48	COUNTRY_DIALLING_CODE	☐	LOY_COUNTRY_DIALLING_CODE		CHAR	10	0	Country Dialling Code
49	COUNTRY_NAME	☐	LOY_MEDIUM_NAME		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
52	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
53	CUSTOMER_CARD	☐	LOYMSH_LOYLTY_PROG_MBRSHP_TAB8		TTYP	0	0

History

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