SAP ABAP Table LOYS_MA_RESULT_ATTR_AC (Member activity archive result structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-LOY-MA (Application Component) Member Activity
⤷
LOY_MEMBER_ACTIVITY_DB (Package) Loyalty Member Activity

⤷

⤷

Basic Data
Table Category | INTTAB | Structure |
Structure | LOYS_MA_RESULT_ATTR_AC |
![]() |
Short Description | Member activity archive result structure |
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 | ![]() |
0 | 0 | LOY FRW : Primary key Include | |||||
2 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
4 | ![]() |
0 | 0 | LOY FRW : Non-Key Framework Include | |||||
5 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
6 | ![]() |
LOY_FRW_APPLICATION | LOY_FRW_APPLICATION | CHAR | 4 | 0 | Application | ||
7 | ![]() |
LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
8 | ![]() |
0 | 0 | Struture for member activity generic attributes | |||||
9 | ![]() |
LOY_MA_ACT_ID | LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
10 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
11 | ![]() |
LOY_MA_BOOLEAN | LOY_MA_BOOLEAN | CHAR | 1 | 0 | Type Boolean | ||
12 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
13 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
14 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
15 | ![]() |
LOY_MA_CAT_ID | LOY_MA_CAT_ID | CHAR | 30 | 0 | Member Activity Category ID | ||
16 | ![]() |
0 | 0 | Structure for status in loyalty | |||||
17 | ![]() |
LOY_FRW_JISTAT | J_ISTAT | CHAR | 5 | 0 | Element for System Status | * | |
18 | ![]() |
LOY_FRW_JESTAT | J_ESTAT | CHAR | 5 | 0 | User Status | * | |
19 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
20 | ![]() |
LOY_MA_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Storing Time Stamp | ||
21 | ![]() |
LOY_MA_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Member Activity Timezone | * | |
22 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
23 | ![]() |
LOY_MA_ERR_CODE | LOY_MA_ERR_CODE | CHAR | 12 | 0 | Twelve Character Error Code | ||
24 | ![]() |
0 | 0 | LOY FRW : Administrative Include | |||||
25 | ![]() |
LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
26 | ![]() |
LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
27 | ![]() |
LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
28 | ![]() |
LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
29 | ![]() |
LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
30 | ![]() |
LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
31 | ![]() |
0 | 0 | Structure for MA generic attribute IDs | |||||
32 | ![]() |
LOY_MA_MEMBERSHIP_ID | LOY_MA_MEMBERSHIP_ID | CHAR | 10 | 0 | Membership ID | ||
33 | ![]() |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
34 | ![]() |
CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
35 | ![]() |
LOY_CRD_CARD_ID | LOY_CRD_CARD_ID | CHAR | 16 | 0 | Card ID | ||
36 | ![]() |
CHAR | 40 | 0 | |||||
37 | ![]() |
BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
38 | ![]() |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
39 | ![]() |
BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
40 | ![]() |
LOY_MA_SHORT_CODE | LOY_MA_SHORT_CODE | CHAR | 20 | 0 | Short Code | ||
41 | ![]() |
LOY_ERR_CODE_DESCR | LOYM_ERR_CODE_DESCR | CHAR | 255 | 0 | Error Code Description | ||
42 | ![]() |
LOY_CRD_CARD_EXT_ID | LOY_CRD_CARD_EXT_ID | CHAR | 25 | 0 | External Card ID | ||
43 | ![]() |
0 | 0 | Extensibility Include Struct for Member Activity Generic IDs | |||||
44 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
45 | ![]() |
0 | 0 | ||||||
46 | ![]() |
0 | 0 | Structure for specific attributes, airline industry | |||||
47 | ![]() |
LOY_ADM_TICKETING_DATE | DATS | DATS | 8 | 0 | Ticketing Date of flight booking | ||
48 | ![]() |
LOY_ADM_AIRLINE_ID | LOY_ADM_AIRLINE_ID | CHAR | 3 | 0 | ICAO Code of the Airline | ||
49 | ![]() |
LOY_ADM_BOOK_CODE | LOY_ADM_BOOK_CODE | CHAR | 2 | 0 | Booking Class Code | ||
50 | ![]() |
LOY_ADM_MUL | LOY_ADM_MULTI | DEC | 6 | 2 | Booking Class Multiplier | ||
51 | ![]() |
LOY_ADM_ORIG_AIRPORT | LOY_ADM_AIRPORT_ID | CHAR | 4 | 0 | ICAO Code of the Origin Airport | ||
52 | ![]() |
LOY_ADM_DEST_AIRPORT | LOY_ADM_AIRPORT_ID | CHAR | 4 | 0 | ICAO Code of the Destination Airport | ||
53 | ![]() |
LOY_ADM_CATEGORY | LOY_ADM_CATEGORY | CHAR | 4 | 0 | Flight Category | ||
54 | ![]() |
LOY_MA_FLGT_NUM | LOY_MA_FLGT_NUM | CHAR | 30 | 0 | Flight Number | ||
55 | ![]() |
LOY_ADM_BASE_MILES | LOY_ADM_BASE_MILES | DEC | 11 | 2 | Base Miles for the flight segment | ||
56 | ![]() |
LOY_MA_TKT_NUM | LOY_MA_TKT_NUM | CHAR | 30 | 0 | Ticket Number | ||
57 | ![]() |
LOY_MA_PNR | LOY_MA_PNR | CHAR | 30 | 0 | Passenger Name Record (PNR) from reservation system | ||
58 | ![]() |
LOY_ADM_FARE_CODE | LOY_ADM_FARE_CODE | CHAR | 3 | 0 | Fare Basis for the flight | ||
59 | ![]() |
LOY_ADM_FARE_BASIS_MUL | LOY_ADM_MULTI | DEC | 6 | 2 | Fare Basis Multiplier | ||
60 | ![]() |
0 | 0 | Structure for member activity specific attr, across industry | |||||
61 | ![]() |
LOY_PT_TYPE | LOY_PT_TYPE | CHAR | 20 | 0 | Point Type | ||
62 | ![]() |
LOY_PT_POINT | DEC | 10 | 2 | Number of Points | |||
63 | ![]() |
LOY_PT_QUAL_TYPE | LOY_PTQUALTYPE | CHAR | 20 | 0 | Point Qualification Type | ||
64 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
65 | ![]() |
LOY_MA_CATEGORY_GUID_C | SYSUUID_C | CHAR | 32 | 0 | Product Category GUID for Member Activity | ||
66 | ![]() |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
67 | ![]() |
LOY_MA_TIER_GROUP | LOY_MA_TIER_GROUP | CHAR | 10 | 0 | Tier Group | ||
68 | ![]() |
LOY_MA_TIER | LOY_MA_TIER | CHAR | 10 | 0 | Tier Level | ||
69 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
70 | ![]() |
LOY_MA_AMOUNT | LOY_MA_AMOUNT | CURR | 19 | 2 | Amount for the activity | ||
71 | ![]() |
LOY_MA_CURR | WAERS | CUKY | 5 | 0 | Currency | * | |
72 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
73 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
74 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
75 | ![]() |
LOY_MA_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in which the Product is Sold | * | |
76 | ![]() |
LOY_MA_OBJ_REF_TYPE | LOY_MA_OBJ_REF_TYPE | CHAR | 15 | 0 | Member Activity (Specific Attribute) Reference Object Type | ||
77 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
78 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
79 | ![]() |
LOY_RETAIL_STORE_ID | CHAR | 20 | 0 | Retail Store ID | |||
80 | ![]() |
LOY_TRAN_SEQ_NUM | CHAR | 30 | 0 | Transaction Sequence Number | |||
81 | ![]() |
0 | 0 | Extensibility Include Structure for Member Activity Specific | |||||
82 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
83 | ![]() |
0 | 0 | ||||||
84 | ![]() |
0 | 0 | Structure for MA specific attributes IDs | |||||
85 | ![]() |
LOY_MA_PRODUCT_ID | LOY_MA_PRODUCT_ID | CHAR | 40 | 0 | Product | ||
86 | ![]() |
LOY_MA_CAMPAIGN_CODE_ID | LOY_MA_CAMPAIGN_CODE_ID | CHAR | 24 | 0 | Campaign | ||
87 | ![]() |
LOY_MA_REWARD_RULE_ID | LOY_MA_REWARD_RULE_ID | CHAR | 24 | 0 | Reward Rule | ||
88 | ![]() |
LOY_MA_ORDER_ID | LOY_MA_ORDER_ID | CHAR | 10 | 0 | Order | ||
89 | ![]() |
COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
90 | ![]() |
COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
91 | ![]() |
COMT_CATEGORY_TEXT | TEXT80 | CHAR | 80 | 0 | Category Description | ||
92 | ![]() |
LOY_ADM_DESC | LOY_ADM_DESC | CHAR | 40 | 0 | Booking Class Description | ||
93 | ![]() |
LOY_ADM_FARE_DESCR | LOY_ADM_DESC | CHAR | 40 | 0 | Fare Basis Description | ||
94 | ![]() |
LOY_ADM_AIRLINE_NAME | LOY_ADM_DESC | CHAR | 40 | 0 | Airline | ||
95 | ![]() |
LOY_ADM_AIRPORT_NAME | LOY_ADM_DESC | CHAR | 40 | 0 | Origin Airport Name | ||
96 | ![]() |
LOY_ADM_DEST_AIRPORT_NAME | LOY_ADM_DESC | CHAR | 40 | 0 | Destination Airport Name | ||
97 | ![]() |
LOY_MA_ACT_ID | LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
98 | ![]() |
LOY_MA_ACT_ID | LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
99 | ![]() |
COMT_HIERARCHY_GUID | SYSUUID | RAW | 16 | 0 | Category Hierarchy GUID | ||
100 | ![]() |
0 | 0 | Extensibility Include Struct for Member Activity Specific ID | |||||
101 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
102 | ![]() |
0 | 0 | ||||||
103 | ![]() |
0 | 0 | Extensibility Include Structure for Member Activity Generic | |||||
104 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
105 | ![]() |
0 | 0 | ||||||
106 | ![]() |
0 | 0 | Partnership Attributes to be added to the Member Activity | |||||
107 | ![]() |
LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
108 | ![]() |
LOY_MA_PART_EXT_ID | LOY_MA_PARTNER_ID | CHAR | 10 | 0 | MEMBER ACTIVITY PARTNERSHIP EXTERNAL ID | ||
109 | ![]() |
LOY_MA_PART_EXT_DESC | LOY_MA_PARTNER_DESC | CHAR | 50 | 0 | Member Activity External Partner Description | ||
110 | ![]() |
LOY_PSH_ID | LOY_PSH_ID | CHAR | 10 | 0 | Partnership ID | ||
111 | ![]() |
LOY_PSH_EXT_REF | LOY_PSH_EXT_REF | CHAR | 40 | 0 | Partnership External Reference | ||
112 | ![]() |
0 | 0 | LOY FRW: Archive Include for Archive Search Result Structure | |||||
113 | ![]() |
ARKEY | ARKEY | CHAR | 20 | 0 | Key for Archive File | ||
114 | ![]() |
ADMI_OFFST | INT4 | 10 | 0 | Archive file data object offset | |||
115 | ![]() |
STRG | 0 | 0 |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |