SAP ABAP View LOYV_PSH_BI (Loyalty Partnership: 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_PSH_BI
Short Description	Loyalty Partnership: Data Selection View
Root table	LOYD_PSH	Loyalty Partnership Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LOYD_PSH	LOYD_PSH

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LOYD_PSH	ISTAT		NE	'I8151'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	LOYD_PSH	*		☐		☐
2	CLIENT	LOYD_PSH	CLIENT		☐	MANDT	☐	Client
3	-	LOYD_PSH	REF_GUID		☐	LOY_FRW_GUID	☐	Object GUID
4	-	LOYD_PSH	APPLICATION		☐	LOY_FRW_APPLICATION	☐	Application
5	-	LOYD_PSH	PROCESS_TYPE		☐	LOY_FRW_PROCESS_TYPE	☐	Process Type
6	-	LOYD_PSH	PA_SET_GUID		☐	LOY_FRW_GUID	☐	Object GUID
7	PSH_TYPE	LOYD_PSH	PSH_TYPE		☐	LOY_PSH_TYPE	☐	Partnership Type
8	-	LOYD_PSH	EXT_REFERENCE		☐	LOY_PSH_EXT_REF	☐	Partnership External Reference
9	EXT_REFERENCE_UC	LOYD_PSH	EXT_REFERENCE_UC		☐	LOY_PSH_EXT_REF_UC	☐	Partnership Desc uppercase
10	LOY_PROG_GUID	LOYD_PSH	LOY_PROG_GUID		☐	LOY_FRW_GUID	☐	Object GUID
11	-	LOYD_PSH	PART_LOY_PROG_ID		☐	LOY_PART_PROG_ID	☐	Loyalty Partner Program ID
12	PROG_PART_GUID	LOYD_PSH	PROG_PART_GUID		☐	LOY_FRW_GUID	☐	Object GUID
13	START_DATE	LOYD_PSH	START_DATE		☐	LOY_PSH_DATE	☐	Date
14	END_DATE	LOYD_PSH	END_DATE		☐	LOY_PSH_DATE	☐	Date
15	-	LOYD_PSH	STATUS_REASON		☐	LOY_PSH_STATUS_REASON	☐	Status Reason
16	-	LOYD_PSH	CREATED_ON		☐	LOY_FRW_CREATED_ON	☐	Created On - OBSOLETE !!!
17	-	LOYD_PSH	CREATED_BY		☐	LOY_FRW_CREATED_BY	☐	Created By
18	CREATED_AT	LOYD_PSH	CREATED_AT		☐	LOY_FRW_CREATED_AT	☐	Created At (Output in User Time Zone)
19	-	LOYD_PSH	CHANGED_ON		☐	LOY_FRW_CHANGED_ON	☐	Changed On - OBSOLETE !!!
20	-	LOYD_PSH	CHANGED_BY		☐	LOY_FRW_CHANGED_BY	☐	Changed By
21	CHANGED_AT	LOYD_PSH	CHANGED_AT		☐	LOY_FRW_CHANGED_AT	☐	Changed At (Output in User Time Zone)
22	ISTAT	LOYD_PSH	ISTAT		☐	LOY_FRW_JISTAT	☐	Element for System Status
23	ESTAT	LOYD_PSH	ESTAT		☐	LOY_FRW_JESTAT	☐	User Status
24	-	LOYD_PSH	ACTIVATED_DATE		☐	LOY_PSH_DATE	☐	Date
25	LOY_PSH_DUMMY	LOYD_PSH	LOY_PSH_DUMMY		☐	DUMMY	☐	Dummy function in length 1
26	PSH_GUID	LOYD_PSH	GUID		☐	LOY_FRW_GUID	☐	Object GUID
27	PSH_ID	LOYD_PSH	OBJECT_ID		☐	LOY_PSH_ID	☐	Partnership ID

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	20110908
SAP Release Created in	701