SAP ABAP Table LOYMSH_MSHIDQR_TIER (Loyalty Programme Membership by ID Tier - 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_TIER	Table Relationship Diagram
Short Description	Loyalty Programme Membership by ID Tier - 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	TIERGROUPCODE	☐	LOY_TIER_LEVEL_CATEGORYCODE		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	LIST_ID	☐			CHAR	60	0
5	LIST_VERSION_ID	☐			CHAR	15	0
6	LIST_AGENCY_ID	☐			CHAR	60	0
7	CONTENT	☐	LOY_TIER_LEVEL_CATCODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
8	TIERGROUPNAME	☐	LOY_MEDIUM_NAME		STRU	0	0
9	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
10	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
11	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
12	TIERLEVELCODE	☐	LOY_TIER_LEVEL_CODE		STRU	0	0
13	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
14	LIST_ID	☐			CHAR	60	0
15	LIST_VERSION_ID	☐			CHAR	15	0
16	LIST_AGENCY_ID	☐			CHAR	60	0
17	CONTENT	☐	LOY_TIER_LEVEL_CODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
18	TIERLEVELNAME	☐	LOY_MEDIUM_NAME		STRU	0	0
19	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
20	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
21	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
22	PREVIOUSTIERLEVELCODE	☐	LOY_TIER_LEVEL_CODE		STRU	0	0
23	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
24	LIST_ID	☐			CHAR	60	0
25	LIST_VERSION_ID	☐			CHAR	15	0
26	LIST_AGENCY_ID	☐			CHAR	60	0
27	CONTENT	☐	LOY_TIER_LEVEL_CODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
28	PREVIOUSTIERLEVELNAME	☐	LOY_MEDIUM_NAME		STRU	0	0
29	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
30	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
31	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
32	START_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
33	END_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
34	EXPIRATION_DATE	☐	LOY_DATE	XSDDATE_D	DATS	8	0	Proxy Data Element (generated)
35	USER_STATUS	☐	LOY_USER_STATUS		STRU	0	0
36	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
37	CODE	☐	LOY_USER_STATUS_CODE		STRU	0	0
38	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
39	LIST_ID	☐			CHAR	60	0
40	LIST_VERSION_ID	☐			CHAR	15	0
41	LIST_AGENCY_ID	☐			CHAR	60	0
42	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
43	LIST_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
44	CONTENT	☐	LOY_USER_STATUS_CODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
45	NAME	☐	LOY_LEN30_NAME		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
48	CONTENT	☐	LOY_LEN30_NAME_CONTENT		CHAR	30	0	Proxy Data Element (generated)
49	ORDINAL_NUMBER_VALUE	☐	LOY_ORDINAL_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
50	ACTIVE_INDICATOR	☐	LOY_INDICATOR	XSDBOOLEAN	CHAR	1	0	Representation of two mutually exclusive Boolean value
51	QUALIFYING_POINT	☐	LOYMSH_LOYLTY_PROG_MBRSHP_TAB7		TTYP	0	0

History

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