SAP ABAP Table LOYMSH_LOYLTY_PROG_MBRSHP_CRM8 (IDT - Member Party from Membership Search Basic Data By Elem)

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_CRM8	Table Relationship Diagram
Short Description	IDT - Member Party from Membership Search Basic Data By Elem

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

History

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