SAP ABAP View LOYV_MSH_BI (Loyallty Membership: Data Selection View)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	LOYV_MSH_BI
Short Description	Loyallty Membership: Data Selection View
Root table	LOYD_MSH_MEMS	Loyalty Membership Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LOYD_MSH_MEMS	LOYD_MSH_MEMS
2	LOYD_MSH_MS_MEMB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LOYD_MSH_MEMS	CLIENT	JL	EQ				0	0
2	LOYD_MSH_MS_MEMB	CLIENT	JR	EQ			AND	0	0
3	LOYD_MSH_MEMS	GUID	JL	EQ				0	0
4	LOYD_MSH_MS_MEMB	MEMS_GUID	JR	EQ			AND	0	0
5	LOYD_MSH_MS_MEMB	MAIN_MEMBER		EQ	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	LOYD_MSH_MEMS	*		☐		☐
2	CLIENT	LOYD_MSH_MEMS	CLIENT		☐	MANDT	☐	Client
3	-	LOYD_MSH_MEMS	REF_GUID		☐	LOY_FRW_GUID	☐	Object GUID
4	-	LOYD_MSH_MEMS	APPLICATION		☐	LOY_FRW_APPLICATION	☐	Application
5	-	LOYD_MSH_MEMS	PROCESS_TYPE		☐	LOY_FRW_PROCESS_TYPE	☐	Process Type
6	-	LOYD_MSH_MEMS	MEMB_GUID		☐	LOY_FRW_GUID	☐	Object GUID
7	-	LOYD_MSH_MEMS	PA_SET_GUID		☐	LOY_FRW_GUID	☐	Object GUID
8	LOY_PROG_GUID	LOYD_MSH_MEMS	LOY_PROG_GUID		☐	LOY_FRW_GUID	☐	Object GUID
9	-	LOYD_MSH_MEMS	EMPL_RESP_GUID		☐	LOY_FRW_GUID	☐	Object GUID
10	-	LOYD_MSH_MEMS	NOMINATOR_ID		☐	LOY_MEMS_ID	☐	Membership ID
11	START_DATE	LOYD_MSH_MEMS	START_DATE		☐	LOY_MEMS_DATE	☐	Date
12	END_DATE	LOYD_MSH_MEMS	END_DATE		☐	LOY_MEMS_DATE	☐	Date
13	-	LOYD_MSH_MEMS	PURPOSE_OF_USE		☐	LOY_MSH_PURPOSE_OF_USE	☐	Purpose of Use
14	-	LOYD_MSH_MEMS	CREATED_VIA		☐	LOY_MSH_CREATED_VIA	☐	Origin
15	-	LOYD_MSH_MEMS	STATUS		☐	LOY_MSH_STATUS	☐	Status
16	STATUS_CH_DATE	LOYD_MSH_MEMS	STATUS_CH_DATE		☐	LOY_MEMS_DATE	☐	Date
17	STATUS_REASON	LOYD_MSH_MEMS	STATUS_REASON		☐	LOY_MSH_STATUS_REASON	☐	Status Reason
18	LAST_TXN_DATE	LOYD_MSH_MEMS	LAST_TXN_DATE		☐	LOY_MEMS_DATE	☐	Date
19	-	LOYD_MSH_MEMS	CREATED_ON		☐	LOY_FRW_CREATED_ON	☐	Created On - OBSOLETE !!!
20	-	LOYD_MSH_MEMS	CREATED_BY		☐	LOY_FRW_CREATED_BY	☐	Created By
21	CREATED_AT	LOYD_MSH_MEMS	CREATED_AT		☐	LOY_FRW_CREATED_AT	☐	Created At (Output in User Time Zone)
22	-	LOYD_MSH_MEMS	CHANGED_ON		☐	LOY_FRW_CHANGED_ON	☐	Changed On - OBSOLETE !!!
23	-	LOYD_MSH_MEMS	CHANGED_BY		☐	LOY_FRW_CHANGED_BY	☐	Changed By
24	CHANGED_AT	LOYD_MSH_MEMS	CHANGED_AT		☐	LOY_FRW_CHANGED_AT	☐	Changed At (Output in User Time Zone)
25	-	LOYD_MSH_MEMS	OS_GUID		☐	OS_GUID	☐	Globally Unique Identifier
26	ISTAT	LOYD_MSH_MEMS	ISTAT		☐	LOY_FRW_JISTAT	☐	Element for System Status
27	ESTAT	LOYD_MSH_MEMS	ESTAT		☐	LOY_FRW_JESTAT	☐	User Status
28	-	LOYD_MSH_MEMS	CAMPAIGN_CODE		☐	LOY_FRW_GUID	☐	Object GUID
29	-	LOYD_MSH_MEMS	MEMBER_COUNTRY		☐	LAND1	☐	Country Key
30	-	LOYD_MSH_MEMS	REG_BY_GUID		☐	LOY_FRW_GUID	☐	Object GUID
31	-	LOYD_MSH_MEMS	AGENT		☐	BU_PARTNER	☐	Business Partner Number
32	-	LOYD_MSH_MEMS	ACCOUNT_GUID		☐	LOY_FRW_GUID	☐	Object GUID
33	-	LOYD_MSH_MEMS	DEF_MEMS_TYPE		☐	LOY_MSH_MEMS_TYPE	☐	Membership Types
34	MEMBERSHIP_DUMMY	LOYD_MSH_MEMS	MEMBERSHIP_DUMMY		☐	DUMMY	☐	Dummy function in length 1
35	MSH_GUID	LOYD_MSH_MEMS	GUID		☐	LOY_FRW_GUID	☐	Object GUID
36	MSH_ID	LOYD_MSH_MEMS	OBJECT_ID		☐	LOY_MEMS_ID	☐	Membership ID
37	MSH_TYPE	LOYD_MSH_MEMS	MEMS_TYPE		☐	LOY_MSH_MEMS_TYPE	☐	Membership Types
38	MEMB_GUID	LOYD_MSH_MS_MEMB	MEMB_GUID		☐	LOY_FRW_GUID	☐	Object GUID

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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