SAP ABAP View LOYV_MA_BI (Loyallty Member Activityp: 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_MA_BI
Short Description	Loyallty Member Activityp: Data Selection View
Root table	LOYD_MA_GENATTR	Table to store member activity generic attributes

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LOYD_MA_GENATTR	LOYD_MA_GENATTR
2	LOYD_MA_SPECATTR
3	LOYD_MSH_MS_MEMB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LOYD_MA_GENATTR	CLIENT	JL	EQ				0	0
2	LOYD_MA_SPECATTR	CLIENT	JR	EQ			AND	0	0
3	LOYD_MA_GENATTR	GUID	JL	EQ				0	0
4	LOYD_MA_SPECATTR	REF_GUID	JR	EQ			AND	0	0
5	LOYD_MA_GENATTR	MEMBERSHIP_GUID	JL	EQ				0	0
6	LOYD_MSH_MS_MEMB	MEMS_GUID	JR	EQ			AND	0	0
7	LOYD_MA_GENATTR	ISTAT		EQ	'I8123'		AND	0	0
8	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_MA_GENATTR	*		☐		☐
2	CLIENT	LOYD_MA_GENATTR	CLIENT		☐	MANDT	☐	Client
3	GUID	LOYD_MA_GENATTR	GUID		☐	LOY_FRW_GUID	☐	Object GUID
4	-	LOYD_MA_GENATTR	REF_GUID		☐	LOY_FRW_GUID	☐	Object GUID
5	-	LOYD_MA_GENATTR	APPLICATION		☐	LOY_FRW_APPLICATION	☐	Application
6	PROCESS_TYPE	LOYD_MA_GENATTR	PROCESS_TYPE		☐	LOY_FRW_PROCESS_TYPE	☐	Process Type
7	OBJECT_ID	LOYD_MA_GENATTR	OBJECT_ID		☐	LOY_MA_ACT_ID	☐	Member Activity ID
8	MEMBERSHIP_GUID	LOYD_MA_GENATTR	MEMBERSHIP_GUID		☐	LOY_FRW_GUID	☐	Object GUID
9	-	LOYD_MA_GENATTR	IS_SHARE_PT_ACCT		☐	LOY_MA_BOOLEAN	☐	Type Boolean
10	MEMBER_GUID	LOYD_MA_GENATTR	MEMBER_GUID		☐	LOY_FRW_GUID	☐	Object GUID
11	PROGRAM_GUID	LOYD_MA_GENATTR	PROGRAM_GUID		☐	LOY_FRW_GUID	☐	Object GUID
12	CARD_GUID	LOYD_MA_GENATTR	CARD_GUID		☐	LOY_FRW_GUID	☐	Object GUID
13	CATEGORY	LOYD_MA_GENATTR	CATEGORY		☐	LOY_MA_CAT_ID	☐	Member Activity Category ID
14	-	LOYD_MA_GENATTR	ISTAT		☐	LOY_FRW_JISTAT	☐	Element for System Status
15	-	LOYD_MA_GENATTR	ESTAT		☐	LOY_FRW_JESTAT	☐	User Status
16	-	LOYD_MA_GENATTR	PARTNER_GUID		☐	LOY_FRW_GUID	☐	Object GUID
17	ACTIVITY_DATE	LOYD_MA_GENATTR	ACTIVITY_DATE		☐	LOY_MA_TIMESTAMP	☐	Storing Time Stamp
18	ACTIVITY_TZ	LOYD_MA_GENATTR	ACTIVITY_TZ		☐	LOY_MA_TIMEZONE	☐	Member Activity Timezone
19	-	LOYD_MA_GENATTR	PT_ACCT_SET_GUID		☐	LOY_FRW_GUID	☐	Object GUID
20	-	LOYD_MA_GENATTR	ERR_CODE		☐	LOY_MA_ERR_CODE	☐	Twelve Character Error Code
21	-	LOYD_MA_GENATTR	CREATED_ON		☐	LOY_FRW_CREATED_ON	☐	Created On - OBSOLETE !!!
22	-	LOYD_MA_GENATTR	CREATED_BY		☐	LOY_FRW_CREATED_BY	☐	Created By
23	CREATED_AT	LOYD_MA_GENATTR	CREATED_AT		☐	LOY_FRW_CREATED_AT	☐	Created At (Output in User Time Zone)
24	-	LOYD_MA_GENATTR	CHANGED_ON		☐	LOY_FRW_CHANGED_ON	☐	Changed On - OBSOLETE !!!
25	-	LOYD_MA_GENATTR	CHANGED_BY		☐	LOY_FRW_CHANGED_BY	☐	Changed By
26	CHANGED_AT	LOYD_MA_GENATTR	CHANGED_AT		☐	LOY_FRW_CHANGED_AT	☐	Changed At (Output in User Time Zone)
27	MAGENATTR_DUMMY	LOYD_MA_GENATTR	MAGENATTR_DUMMY		☐	DUMMY	☐	Dummy function in length 1
28	PARTNERSHIP_GUID	LOYD_MA_GENATTR	PARTNERSHIP_GUID		☐	LOY_FRW_GUID	☐	Object GUID
29	PARTNSHIP_EXT_ID	LOYD_MA_GENATTR	PARTNSHIP_EXT_ID		☐	LOY_MA_PART_EXT_ID	☐	MEMBER ACTIVITY PARTNERSHIP EXTERNAL ID
30	-	LOYD_MA_GENATTR	PARSHIP_EXT_DES		☐	LOY_MA_PART_EXT_DESC	☐	Member Activity External Partner Description
31	*	LOYD_MA_SPECATTR	*		☐		☐
32	-	LOYD_MA_SPECATTR	CLIENT		☐	MANDT	☐	Client
33	-	LOYD_MA_SPECATTR	GUID		☐	LOY_FRW_GUID	☐	Object GUID
34	-	LOYD_MA_SPECATTR	REF_GUID		☐	LOY_FRW_GUID	☐	Object GUID
35	-	LOYD_MA_SPECATTR	APPLICATION		☐	LOY_FRW_APPLICATION	☐	Application
36	-	LOYD_MA_SPECATTR	PROCESS_TYPE		☐	LOY_FRW_PROCESS_TYPE	☐	Process Type
37	-	LOYD_MA_SPECATTR	TICKETING_DATE		☐	LOY_ADM_TICKETING_DATE	☐	Ticketing Date of flight booking
38	AIRLINE_ID	LOYD_MA_SPECATTR	AIRLINE_ID		☐	LOY_ADM_AIRLINE_ID	☐	ICAO Code of the Airline
39	BOOKING_CLASS	LOYD_MA_SPECATTR	BOOKING_CLASS		☐	LOY_ADM_BOOK_CODE	☐	Booking Class Code
40	-	LOYD_MA_SPECATTR	BOOK_CLASS_MUL		☐	LOY_ADM_MUL	☐	Booking Class Multiplier
41	ORIGIN_AIRPORT	LOYD_MA_SPECATTR	ORIGIN_AIRPORT		☐	LOY_ADM_ORIG_AIRPORT	☐	ICAO Code of the Origin Airport
42	DEST_AIRPORT	LOYD_MA_SPECATTR	DEST_AIRPORT		☐	LOY_ADM_DEST_AIRPORT	☐	ICAO Code of the Destination Airport
43	FLIGHT_CATEGORY	LOYD_MA_SPECATTR	FLIGHT_CATEGORY		☐	LOY_ADM_CATEGORY	☐	Flight Category
44	-	LOYD_MA_SPECATTR	FLIGHT_NUMBER		☐	LOY_MA_FLGT_NUM	☐	Flight Number
45	-	LOYD_MA_SPECATTR	BASE_MILES		☐	LOY_ADM_BASE_MILES	☐	Base Miles for the flight segment
46	-	LOYD_MA_SPECATTR	TICKET_NUMBER		☐	LOY_MA_TKT_NUM	☐	Ticket Number
47	-	LOYD_MA_SPECATTR	PNR		☐	LOY_MA_PNR	☐	Passenger Name Record (PNR) from reservation system
48	FARE_BASIS	LOYD_MA_SPECATTR	FARE_BASIS		☐	LOY_ADM_FARE_CODE	☐	Fare Basis for the flight
49	-	LOYD_MA_SPECATTR	FARE_BASIS_MUL		☐	LOY_ADM_FARE_BASIS_MUL	☐	Fare Basis Multiplier
50	-	LOYD_MA_SPECATTR	POINT_TYPE		☐	LOY_PT_TYPE	☐	Point Type
51	-	LOYD_MA_SPECATTR	POINTS		☐	LOY_PT_POINT	☐	Number of Points
52	-	LOYD_MA_SPECATTR	POINT_QUAL		☐	LOY_PT_QUAL_TYPE	☐	Point Qualification Type
53	PRODUCT_GUID	LOYD_MA_SPECATTR	PRODUCT_GUID		☐	LOY_FRW_GUID	☐	Object GUID
54	PROD_CAT_GUID	LOYD_MA_SPECATTR	PROD_CAT_GUID		☐	LOY_MA_CATEGORY_GUID_C	☐	Product Category GUID for Member Activity
55	PRODUCT_QUANTITY	LOYD_MA_SPECATTR	PRODUCT_QUANTITY		☐	MENGE_D	☐	Quantity
56	-	LOYD_MA_SPECATTR	TIER_GROUP		☐	LOY_MA_TIER_GROUP	☐	Tier Group
57	-	LOYD_MA_SPECATTR	TIER		☐	LOY_MA_TIER	☐	Tier Level
58	CAMPAIGN_CODE	LOYD_MA_SPECATTR	CAMPAIGN_CODE		☐	LOY_FRW_GUID	☐	Object GUID
59	-	LOYD_MA_SPECATTR	AMOUNT		☐	LOY_MA_AMOUNT	☐	Amount for the activity
60	-	LOYD_MA_SPECATTR	CURRENCY		☐	LOY_MA_CURR	☐	Currency
61	-	LOYD_MA_SPECATTR	REWARD_RULE		☐	LOY_FRW_GUID	☐	Object GUID
62	-	LOYD_MA_SPECATTR	ORDER_GUID		☐	LOY_FRW_GUID	☐	Object GUID
63	-	LOYD_MA_SPECATTR	ORDER_ITEM_GUID		☐	LOY_FRW_GUID	☐	Object GUID
64	-	LOYD_MA_SPECATTR	PROCESS_QTY_UNIT		☐	LOY_MA_PROCESS_QTY_UNIT	☐	Unit of Measure in which the Product is Sold
65	OBJ_REF_TYPE	LOYD_MA_SPECATTR	OBJ_REF_TYPE		☐	LOY_MA_OBJ_REF_TYPE	☐	Member Activity (Specific Attribute) Reference Object Type
66	OBJ_REF_GUID	LOYD_MA_SPECATTR	OBJ_REF_GUID		☐	LOY_FRW_GUID	☐	Object GUID
67	OBJ_REF_ITM_GUID	LOYD_MA_SPECATTR	OBJ_REF_ITM_GUID		☐	LOY_FRW_GUID	☐	Object GUID
68	RETAIL_STORE_ID	LOYD_MA_SPECATTR	RETAIL_STORE_ID		☐	LOY_RETAIL_STORE_ID	☐	Retail Store ID
69	TRAN_SEQ_NUM	LOYD_MA_SPECATTR	TRAN_SEQ_NUM		☐	LOY_TRAN_SEQ_NUM	☐	Transaction Sequence Number
70	-	LOYD_MA_SPECATTR	CREATED_ON		☐	LOY_FRW_CREATED_ON	☐	Created On - OBSOLETE !!!
71	-	LOYD_MA_SPECATTR	CREATED_BY		☐	LOY_FRW_CREATED_BY	☐	Created By
72	-	LOYD_MA_SPECATTR	CREATED_AT		☐	LOY_FRW_CREATED_AT	☐	Created At (Output in User Time Zone)
73	-	LOYD_MA_SPECATTR	CHANGED_ON		☐	LOY_FRW_CHANGED_ON	☐	Changed On - OBSOLETE !!!
74	-	LOYD_MA_SPECATTR	CHANGED_BY		☐	LOY_FRW_CHANGED_BY	☐	Changed By
75	-	LOYD_MA_SPECATTR	CHANGED_AT		☐	LOY_FRW_CHANGED_AT	☐	Changed At (Output in User Time Zone)
76	MASPECATTR_DUMMY	LOYD_MA_SPECATTR	MASPECATTR_DUMMY		☐	DUMMY	☐	Dummy function in length 1
77	BENEFIT_GUID	LOYD_MA_SPECATTR	BENEFIT_GUID		☐	LOY_FRW_GUID	☐	Object GUID
78	NO_OF_USAGES	LOYD_MA_SPECATTR	NO_OF_USAGES		☐	LOY_BNFT_USAGE	☐	Loyalty Benefit Usage
79	-	LOYD_MA_SPECATTR	UNRESTRICTED		☐	BOOLEAN	☐	Boolean Variable (X=True, -=False, Space=Unknown)
80	ORIGIN	LOYD_MA_SPECATTR	ORIGIN		☐	LOY_BNFT_ORIGIN	☐	Benefit Origin
81	-	LOYD_MA_SPECATTR	REF_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	20110908
SAP Release Created in	701