SAP ABAP Table LOYS_MA_BI (Extract Structure: Member Activity)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_MA_BI	Table Relationship Diagram
Short Description	Extract Structure: Member Activity

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	GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
2	OBJECT_ID	☐	LOY_MA_ACT_ID	LOY_MA_ACTID	CHAR	10	0	Member Activity ID
3	MEMBERSHIP_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
4	PROGRAM_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
5	LOY_PROG_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
6	PROCESS_TYPE	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
7	CATEGORY	☐	LOY_MA_CAT_ID	LOY_MA_CAT_ID	CHAR	30	0	Member Activity Category ID
8	ACTIVITY_DATE	☐	LOY_MA_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Storing Time Stamp
9	ACT_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
10	PARTNERSHIP_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
11	CARD_TYPE	☐	LOY_CRD_CARD_CTYPE	LOY_CRD_CARD_CTYPE	CHAR	5	0	Card Type
12	CAMPAIGN_CODE	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
13	LOY_CAMP_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
14	BOOKING_CLASS	☐	LOY_ADM_BOOK_CODE	LOY_ADM_BOOK_CODE	CHAR	2	0	Booking Class Code
15	ORIGIN_AIRPORT	☐	LOY_ADM_ORIG_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Origin Airport
16	DEST_AIRPORT	☐	LOY_ADM_DEST_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Destination Airport
17	AIRLINE_ID	☐	LOY_ADM_AIRLINE_ID	LOY_ADM_AIRLINE_ID	CHAR	3	0	ICAO Code of the Airline
18	FLIGHT_CATEGORY	☐	LOY_ADM_CATEGORY	LOY_ADM_CATEGORY	CHAR	4	0	Flight Category
19	FARE_BASIS	☐	LOY_ADM_FARE_CODE	LOY_ADM_FARE_CODE	CHAR	3	0	Fare Basis for the flight
20	PRODUCT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
21	PRODUCT_CATEGORY	☐	LOY_MA_CATEGORY_GUID_C	SYSUUID_C	CHAR	32	0	Product Category GUID for Member Activity
22	MAIN_MEM_ID	☐	LOY_MA_MEMBER_ID	LOY_MA_MEMBER_ID	CHAR	10	0	MA member ID
23	BASIC_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
24	LIFETIME_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
25	CHANGED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
26	BENEFIT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
27	NO_OF_USAGES	☐	LOY_BNFT_USAGE	LOY_BNFT_USAGE	INT2	5	0	Loyalty Benefit Usage
28	NO_OF_BNFT_BGHT	☐	LOY_BNFT_USAGE	LOY_BNFT_USAGE	INT2	5	0	Loyalty Benefit Usage
29	PRODUCT_QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
30	ORIGIN	☐	LOY_BNFT_ORIGIN	LOY_BNFT_ORIGIN	CHAR	40	0	Benefit Origin
31	MEMBER_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
32	ACTIVITY_TZ	☐	LOY_MA_TIMEZONE	TZNZONE	CHAR	6	0	Member Activity Timezone	*
33	ACTVT_DATE	☐	CHAR15	CHAR15	CHAR	15	0	Char 15

History

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