SAP ABAP Table LOYS_MSH_BI (Extract Structure: Membership)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY (Application Component) Loyalty
     ⤷ LOY_BI (Package) Loyalty BI objects

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_MSH_BI	Table Relationship Diagram
Short Description	Extract Structure: 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	MSH_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
2	MSH_ID	☐	LOY_MEMS_ID	LOY_MEMS_ID	CHAR	10	0	Membership ID
3	LOY_PROG_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
4	LOY_PROG_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
5	MSH_TYPE	☐	LOY_MSH_MEMS_TYPE		CHAR	20	0	Membership Types
6	START_DATE	☐	LOY_MEMS_DATE	DATS	DATS	8	0	Date
7	END_DATE	☐	LOY_MEMS_DATE	DATS	DATS	8	0	Date
8	STATUS_REASON	☐	LOY_MSH_STATUS_REASON	CHAR132	CHAR	132	0	Status Reason
9	LAST_TXN_DATE	☐	LOY_MEMS_DATE	DATS	DATS	8	0	Date
10	STATUS_CH_DATE	☐	LOY_MEMS_DATE	DATS	DATS	8	0	Date
11	MAIN_MEM_ID	☐	LOY_MA_MEMBER_ID	LOY_MA_MEMBER_ID	CHAR	10	0	MA member ID
12	BASIC_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
13	LAST_BASIC_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
14	LIFETIME_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
15	BWSTLOYMSHS	☐	CRMBWSTAT2	CRMBWSTAT	CHAR	4	0	BW Status Object
16	BWSTLOYMSHU	☐	CRMBWSTAT2	CRMBWSTAT	CHAR	4	0	BW Status Object
17	CHANGED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
18	ISTAT	☐	LOY_FRW_JISTAT	J_ISTAT	CHAR	5	0	Element for System Status	*
19	ESTAT	☐	LOY_FRW_JESTAT	J_ESTAT	CHAR	5	0	User Status	*
20	MEMB_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID

History

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