SAP ABAP Table LOYV_MA_BI (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure LOYV_MA_BI   Table Relationship Diagram
Short Description Generated Table for View    
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 CLIENT MANDT MANDT CLNT 3   0   Client  
2 GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
3 PROCESS_TYPE LOY_FRW_PROCESS_TYPE LOY_FRW_PROCESS_TYPE CHAR 15   0   Process Type  
4 OBJECT_ID LOY_MA_ACT_ID LOY_MA_ACTID CHAR 10   0   Member Activity ID  
5 MEMBERSHIP_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID LOYD_MSH_MEMS
6 MEMBER_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID LOYD_MEM_MEMBER
7 PROGRAM_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
8 CARD_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID LOYD_CRD_CARD
9 CATEGORY LOY_MA_CAT_ID LOY_MA_CAT_ID CHAR 30   0   Member Activity Category ID LOYC_MA_CAT
10 ACTIVITY_DATE LOY_MA_TIMESTAMP BCOS_TSTMP DEC 15   0   Storing Time Stamp  
11 ACTIVITY_TZ LOY_MA_TIMEZONE TZNZONE CHAR 6   0   Member Activity Timezone  
12 CREATED_AT LOY_FRW_CREATED_AT LOY_TSTMP DEC 15   0   Created At (Output in User Time Zone)  
13 CHANGED_AT LOY_FRW_CHANGED_AT LOY_TSTMP DEC 15   0   Changed At (Output in User Time Zone)  
14 MAGENATTR_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
15 PARTNERSHIP_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
16 PARTNSHIP_EXT_ID LOY_MA_PART_EXT_ID LOY_MA_PARTNER_ID CHAR 10   0   MEMBER ACTIVITY PARTNERSHIP EXTERNAL ID  
17 AIRLINE_ID LOY_ADM_AIRLINE_ID LOY_ADM_AIRLINE_ID CHAR 3   0   ICAO Code of the Airline  
18 BOOKING_CLASS LOY_ADM_BOOK_CODE LOY_ADM_BOOK_CODE CHAR 2   0   Booking Class Code  
19 ORIGIN_AIRPORT LOY_ADM_ORIG_AIRPORT LOY_ADM_AIRPORT_ID CHAR 4   0   ICAO Code of the Origin Airport  
20 DEST_AIRPORT LOY_ADM_DEST_AIRPORT LOY_ADM_AIRPORT_ID CHAR 4   0   ICAO Code of the Destination Airport  
21 FLIGHT_CATEGORY LOY_ADM_CATEGORY LOY_ADM_CATEGORY CHAR 4   0   Flight Category  
22 FARE_BASIS LOY_ADM_FARE_CODE LOY_ADM_FARE_CODE CHAR 3   0   Fare Basis for the flight  
23 PRODUCT_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
24 PROD_CAT_GUID LOY_MA_CATEGORY_GUID_C SYSUUID_C CHAR 32   0   Product Category GUID for Member Activity  
25 PRODUCT_QUANTITY MENGE_D MENG13 QUAN 13   3   Quantity  
26 CAMPAIGN_CODE LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
27 OBJ_REF_TYPE LOY_MA_OBJ_REF_TYPE LOY_MA_OBJ_REF_TYPE CHAR 15   0   Member Activity (Specific Attribute) Reference Object Type  
28 OBJ_REF_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
29 OBJ_REF_ITM_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
30 RETAIL_STORE_ID LOY_RETAIL_STORE_ID   CHAR 20   0   Retail Store ID  
31 TRAN_SEQ_NUM LOY_TRAN_SEQ_NUM   CHAR 30   0   Transaction Sequence Number  
32 MASPECATTR_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
33 BENEFIT_GUID LOY_FRW_GUID SYSUUID RAW 16   0   Object GUID  
34 NO_OF_USAGES LOY_BNFT_USAGE LOY_BNFT_USAGE INT2 5   0   Loyalty Benefit Usage  
35 ORIGIN LOY_BNFT_ORIGIN LOY_BNFT_ORIGIN CHAR 40   0   Benefit Origin  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 LOYV_MA_BI CARD_GUID LOYD_CRD_CARD CLIENT 1 CN
2 LOYV_MA_BI CATEGORY LOYC_MA_CAT CAT_ID 1 CN
3 LOYV_MA_BI MEMBERSHIP_GUID LOYD_MSH_MEMS CLIENT 1 CN
4 LOYV_MA_BI MEMBER_GUID LOYD_MEM_MEMBER CLIENT 1 CN
History
Last changed by/on SAP  20110908 
SAP Release Created in