SAP ABAP Table LOYV_MA_BI (Generated Table for View), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `LOYV_MA_BI` {Generated Table for View}

Home

                title {label: "SAP ABAP table LOYV_MA_BI {Generated Table for View}", size: "20"}

# Entities

[LOYV_MA_BI] {bgcolor: "tomato"}
*CLIENT {label: "CLNT (3)"}
*GUID {label: "RAW (16)"}
*PROCESS_TYPE {label: "CHAR (15)"}
*OBJECT_ID {label: "CHAR (10)"}
*+MEMBERSHIP_GUID {label: "RAW (16)"}
*+MEMBER_GUID {label: "RAW (16)"}
*PROGRAM_GUID {label: "RAW (16)"}
*+CARD_GUID {label: "RAW (16)"}
*+CATEGORY {label: "CHAR (30)"}
*ACTIVITY_DATE {label: "DEC (15)"}
*ACTIVITY_TZ {label: "CHAR (6)"}
*CREATED_AT {label: "DEC (15)"}
*CHANGED_AT {label: "DEC (15)"}
*MAGENATTR_DUMMY {label: "CHAR (1)"}
*PARTNERSHIP_GUID {label: "RAW (16)"}
*PARTNSHIP_EXT_ID {label: "CHAR (10)"}
*AIRLINE_ID {label: "CHAR (3)"}
*BOOKING_CLASS {label: "CHAR (2)"}
*ORIGIN_AIRPORT {label: "CHAR (4)"}
*DEST_AIRPORT {label: "CHAR (4)"}
*FLIGHT_CATEGORY {label: "CHAR (4)"}
*FARE_BASIS {label: "CHAR (3)"}
*PRODUCT_GUID {label: "RAW (16)"}
*PROD_CAT_GUID {label: "CHAR (32)"}
*PRODUCT_QUANTITY {label: "QUAN (13)"}
*CAMPAIGN_CODE {label: "RAW (16)"}
*OBJ_REF_TYPE {label: "CHAR (15)"}
*OBJ_REF_GUID {label: "RAW (16)"}
*OBJ_REF_ITM_GUID {label: "RAW (16)"}
*RETAIL_STORE_ID {label: "CHAR (20)"}
*TRAN_SEQ_NUM {label: "CHAR (30)"}
*MASPECATTR_DUMMY {label: "CHAR (1)"}
*BENEFIT_GUID {label: "RAW (16)"}
*NO_OF_USAGES {label: "INT2 (5)"}
*ORIGIN {label: "CHAR (40)"}

[LOYC_MA_CAT] {bgcolor: "#d0e0d0"}
*CLIENT {label: "CLNT (3)"}
*CAT_ID {label: "CHAR (30)"}

[LOYD_CRD_CARD] {bgcolor: "#d0e0d0"}
*CLIENT {label: "CLNT (3)"}
*GUID {label: "RAW (16)"}

[LOYD_MEM_MEMBER] {bgcolor: "#d0e0d0"}
*CLIENT {label: "CLNT (3)"}
*GUID {label: "RAW (16)"}

[LOYD_MSH_MEMS] {bgcolor: "#d0e0d0"}
*CLIENT {label: "CLNT (3)"}
*GUID {label: "RAW (16)"}

# Relationships

LOYV_MA_BI 1--* LOYD_CRD_CARD {label: "LOYV_MA_BI-CARD_GUID = LOYD_CRD_CARD-CLIENT"}
LOYV_MA_BI 1--* LOYC_MA_CAT {label: "LOYV_MA_BI-CATEGORY = LOYC_MA_CAT-CAT_ID"}
LOYV_MA_BI 1--* LOYD_MSH_MEMS {label: "LOYV_MA_BI-MEMBERSHIP_GUID = LOYD_MSH_MEMS-CLIENT"}
LOYV_MA_BI 1--* LOYD_MEM_MEMBER {label: "LOYV_MA_BI-MEMBER_GUID = LOYD_MEM_MEMBER-CLIENT"}

E-R Diagram for table LOYV_MA_BI (Generated Table for View)

Foreign Key tables (4)

LOYC_MA_CAT {Table for member activity categories}
LOYD_CRD_CARD {Cards table}
LOYD_MEM_MEMBER {Loyalty Menagement : Database Table for Member}
LOYD_MSH_MEMS {Loyalty Membership Table}

SAP ABAP Table LOYV_MA_BI {Generated Table for View}

Foreign Key tables (4)

SAP ABAP Table `LOYV_MA_BI` {Generated Table for View}