SAP ABAP Table CRMS_LOY_MA_RESULT_ATTR (Member activity result structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL-LOY (Application Component) Loyalty Marketing
⤷ CRM_LOY_MEMBER_ACTIVITY (Package) Loyalty Member activity
⤷ CRM-MKT-MPL-LOY (Application Component) Loyalty Marketing
⤷ CRM_LOY_MEMBER_ACTIVITY (Package) Loyalty Member activity
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_LOY_MA_RESULT_ATTR | Table Relationship Diagram |
Short Description | Member activity 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 | .INCLUDE | 0 | 0 | LOY : Loyalty Key Structure | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
4 | .INCLUDE | 0 | 0 | LOY : Loyalty Object Strucure | |||||
5 | REF_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
6 | APPLICATION | CRM_LOY_COM_APPLICATION | CRM_LOY_COM_APPLICATION | CHAR | 4 | 0 | LOY : Application | ||
7 | PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
8 | .INCLUDE | 0 | 0 | Struture for member activity generic attributes | |||||
9 | OBJECT_ID | CRM_LOY_MA_ACT_ID | CRM_LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
10 | MEMBERSHIP_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
11 | IS_SHARE_PT_ACCT | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
12 | MEMBER_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
13 | PROGRAM_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
14 | CARD_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
15 | CATEGORY | CRM_LOY_MA_CAT_ID | CRM_LOY_MA_CAT_ID | CHAR | 30 | 0 | Member Activity Category ID | ||
16 | .INCLUDE | 0 | 0 | CRM LOY : Structure for Status in Loyalty | |||||
17 | ISTAT | CRM_LOY_COM_JISTAT | J_ISTAT | CHAR | 5 | 0 | CRM LOY : Element for System Status | * | |
18 | ESTAT | CRM_LOY_COM_JESTAT | J_ESTAT | CHAR | 5 | 0 | CRM LOY : Element For User Status | * | |
19 | PARTNER_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
20 | ACTIVITY_DATE | CRM_LOY_COM_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Data element for time stamp | ||
21 | ACTIVITY_TZ | CRM_LOY_MA_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Member Activity Timezone | * | |
22 | PT_ACCT_SET_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
23 | ERR_CODE | CRM_LOY_MA_ERR_CODE | CHAR | 12 | 0 | Twelve Character Error Code | |||
24 | .INCLUDE | 0 | 0 | LOY : Loyalty Admin Structure | |||||
25 | CREATED_ON | CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! | ||
26 | CREATED_BY | CRM_LOY_COM_CREATED_BY | UNAME | CHAR | 12 | 0 | LOY: Created By | ||
27 | CREATED_AT | CRM_LOY_COM_CREATED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
28 | CHANGED_ON | CRM_LOY_COM_CHANGED_ON | SYDATS | DATS | 8 | 0 | LOY : Changed On - OBSOLETE !!! | ||
29 | CHANGED_BY | CRM_LOY_COM_CHANGED_BY | UNAME | CHAR | 12 | 0 | LOY : Changed By | ||
30 | CHANGED_AT | CRM_LOY_COM_CHANGED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
31 | .INCLUDE | 0 | 0 | Structure to include all the ID's | |||||
32 | MEMBERSHIP_ID | CRM_LOY_MEMS_ID | CRM_LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
33 | MEMBER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
34 | PROGRAM_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
35 | CARD_ID | CRM_CRD_CARD_ID | CRM_CRD_CARD_ID | CHAR | 16 | 0 | Card ID | ||
36 | PROGRAM_DESC | CRM_MKTGS_SHORTTEXT | TEXT40 | CHAR | 40 | 0 | MKTGS: Short text | ||
37 | PARTNER_DESC | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
38 | PARTNER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
39 | MEMBER_DESC | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
40 | SHORT_ERR_CODE | CRM_LOY_MA_SHORT_CODE | CHAR | 20 | 0 | Short Code | |||
41 | SHORT_ERR_DESC | CRM_LOY_ERR_CODE_DESCR | CHAR | 255 | 0 | Error Code Description | |||
42 | EXTERNAL_CARD_NU | CRM_LOY_CRD_CARD_EXT_ID | CRM_LOY_CRD_CARD_EXT_ID | CHAR | 25 | 0 | External Card ID | ||
43 | .INCLUDE | 0 | 0 | Extensibility Include Struct for Member Activity Generic IDs | |||||
44 | MAGENATTR_ID_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
45 | .INCLUDE | 0 | 0 | ||||||
46 | .INCLUDE | 0 | 0 | Structure for specific attributes, airline industry | |||||
47 | TICKETING_DATE | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
48 | AIRLINE_ID | CRM_LOY_AIR_ID | CRM_LOY_AIR_ID | CHAR | 3 | 0 | Unique Three Character ICAO Code of the Airline | ||
49 | BOOKING_CLASS | CRM_LOY_BOOK_CODE | CRM_LOY_BOOK_CODE | CHAR | 2 | 0 | Code to Identify the Booking Class | ||
50 | BOOK_CLASS_MUL | CRM_LOY_MUL | CRM_LOY_MUL | DEC | 6 | 2 | Multiplier Used in Point Determination | ||
51 | ORIGIN_AIRPORT | CRM_LOY_AIRPORTID | CRM_LOY_AIRPORTID | CHAR | 4 | 0 | Unique four Character ICAO Code of Airport | ||
52 | DEST_AIRPORT | CRM_LOY_AIRPORTID | CRM_LOY_AIRPORTID | CHAR | 4 | 0 | Unique four Character ICAO Code of Airport | ||
53 | FLIGHT_CATEGORY | CRM_LOY_CATEGORY | CRM_LOY_CATEGORY | CHAR | 4 | 0 | Category to which the Segment is Assigned | ||
54 | FLIGHT_NUMBER | CRM_LOY_MA_FLGT_NUM | CRM_LOY_MA_FLGT_NUM | CHAR | 30 | 0 | Member Activity Flight Number | ||
55 | BASE_MILES | CRM_LOY_BASE_MILES | CRM_LOY_BASE_MILES | DEC | 11 | 2 | Base Miles for the Segment | ||
56 | TICKET_NUMBER | CRM_LOY_MA_TKT_NUM | CRM_LOY_MA_TKT_NUM | CHAR | 30 | 0 | Member Activity Ticket Number | ||
57 | PNR | CRM_LOY_MA_PNR | CRM_LOY_MA_PNR | CHAR | 30 | 0 | PNR Number | ||
58 | FARE_BASIS | CRM_LOY_FARE_CODE | CRM_LOY_FARE_CODE | CHAR | 3 | 0 | Code to Identify the Fare Basis | ||
59 | FARE_BASIS_MUL | CRM_LOY_MUL | CRM_LOY_MUL | DEC | 6 | 2 | Multiplier Used in Point Determination | ||
60 | .INCLUDE | 0 | 0 | Structure for member activity specific attributes | |||||
61 | POINT_TYPE | CRMT_MKTPL_LOY_POINT_NAME | CRM_MKTPL_LOY_POINT_NAME | CHAR | 20 | 0 | Description of Point | ||
62 | POINTS | CRM_LOY_PT_POINT | DEC | 10 | 2 | Loyalty Point | |||
63 | POINT_QUAL | CRM_LOY_PT_QUAL_TYPE | CHAR | 20 | 0 | Loyalty Point Qualification Type | |||
64 | PRODUCT_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
65 | PROD_CAT_GUID | COMT_CATEGORY_GUID_C | SYSUUID_C | CHAR | 32 | 0 | Category GUID | ||
66 | PRODUCT_QUANTITY | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
67 | TIER_GROUP | CRMT_MKTPL_LOY_TIERGRP_CODE | CRM_MKTPL_LOY_TIER_CODE | CHAR | 10 | 0 | ID of Tier Group | ||
68 | TIER | CRMT_MKTPL_LOY_TIERLEVEL_CODE | CRM_MKTPL_LOY_TIER_CODE | CHAR | 10 | 0 | ID of Tier | ||
69 | CAMPAIGN_CODE | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
70 | AMOUNT | CRM_LOY_MA_AMOUNT | CRM_LOY_MA_AMOUNT | CURR | 19 | 2 | Member Activity Amount | ||
71 | CURRENCY | CUKY | 5 | 0 | |||||
72 | REWARD_RULE | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
73 | ORDER_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
74 | ORDER_ITEM_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
75 | PROCESS_QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
76 | OBJ_REF_TYPE | CRM_LOY_MA_OBJ_REF_TYPE | CRM_LOY_MA_OBJ_REF_TYPE | CHAR | 15 | 0 | Member Activity (Specific Attribute) Reference Object Type | ||
77 | OBJ_REF_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
78 | OBJ_REF_ITM_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
79 | RETAIL_STORE_ID | CRM_LOY_RETAIL_STORE_ID | CHAR | 20 | 0 | Retail Store ID | |||
80 | TRAN_SEQ_NUM | CRM_LOY_TRAN_SEQ_NUM | CHAR | 30 | 0 | Transaction Sequence Number | |||
81 | .INCLUDE | 0 | 0 | Extensibility Include Structure for Member Activity Specific | |||||
82 | MASPECATTR_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
83 | .INCLUDE | 0 | 0 | ||||||
84 | .INCLUDE | 0 | 0 | Structure for Specific Attribute ID's | |||||
85 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
86 | CAMPAIGN_CODE_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
87 | REWARD_RULE_ID | CRM_MKTPL_REWARD_RULEID | CGPL_EXTID | CHAR | 24 | 0 | Reward Rule | ||
88 | ORDER_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
89 | PRODCATEGORY_ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
90 | PRODUCT_DESC | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
91 | PRODUCT_CAT_DESC | COMT_CATEGORY_TEXT | TEXT80 | CHAR | 80 | 0 | Category Description | ||
92 | BOOKING_DESCR | CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
93 | FARE_DESCR | CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
94 | AIRLINE_NAME | CRM_LOY_AIR_NAME | CRM_LOY_AIR_NAME | CHAR | 40 | 0 | Airline/Airport Name | ||
95 | ORIGIN_AIRPORT_NAME | CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
96 | DEST_AIRPORT_NAME | CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
97 | OBJ_REF_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
98 | OBJ_REF_ITM_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
99 | PROD_HIER_GUID | COMT_HIERARCHY_GUID | SYSUUID | RAW | 16 | 0 | Category Hierarchy GUID | ||
100 | .INCLUDE | 0 | 0 | Extensibility Include Struct for Member Activity Specific ID | |||||
101 | MASPECATTR_ID_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
102 | .INCLUDE | 0 | 0 | ||||||
103 | .INCLUDE | 0 | 0 | Extensibility Include Structure for Member Activity Generic | |||||
104 | MAGENATTR_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
105 | .INCLUDE | 0 | 0 | ||||||
106 | .INCLUDE | 0 | 0 | structure for PSH attributes in CRM box | |||||
107 | PARTNERSHIP_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
108 | PARTNSHIP_EXT_ID | CRM_LOY_MA_PART_EXT_ID | CRM_LOY_MA_PART_EXT_ID | CHAR | 10 | 0 | CRM LOY MEMBER ACTIVITY PARTNER EXTERNAL ID | ||
109 | PARSHIP_EXT_DES | CRM_LOY_MA_PART_EXT_DESC | CRM_LOY_MA_PART_EXT_DESC | CHAR | 50 | 0 | crm MA External Partnership Description | ||
110 | PARTNERSHIP_ID | CRM_LOY_PSH_ID | CRM_LOY_PSH_ID | CHAR | 10 | 0 | Partnership ID | ||
111 | PARTNERSHIP_DESC | CRM_LOY_PSH_EXT_REF | CRM_LOY_PSH_EXT_REF | CHAR | 40 | 0 | Partnership External Reference |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |