SAP ABAP Table LOYS_ACTJRNL_SINGLE (Loyalty Program Activity Journal Structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-LOY (Application Component) Loyalty
⤷
LOY_ESOA (Package) ESOA enablement for Loyalty Management

⤷

⤷

Basic Data
Table Category | INTTAB | Structure |
Structure | LOYS_ACTJRNL_SINGLE |
![]() |
Short Description | Loyalty Program Activity Journal 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 | ![]() |
CRMS_LOY_MA_GEN_ATTR | STRU | 0 | 0 | ||||
2 | ![]() |
0 | 0 | LOY : Loyalty Key Structure | |||||
3 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | ||
4 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
5 | ![]() |
0 | 0 | LOY : Loyalty Object Strucure | |||||
6 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
7 | ![]() |
CRM_LOY_COM_APPLICATION | CRM_LOY_COM_APPLICATION | CHAR | 4 | 0 | LOY : Application | ||
8 | ![]() |
CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
9 | ![]() |
0 | 0 | Struture for member activity generic attributes | |||||
10 | ![]() |
CRM_LOY_MA_ACT_ID | CRM_LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
11 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
12 | ![]() |
CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
13 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
14 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
15 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
16 | ![]() |
CRM_LOY_MA_CAT_ID | CRM_LOY_MA_CAT_ID | CHAR | 30 | 0 | Member Activity Category ID | ||
17 | ![]() |
0 | 0 | CRM LOY : Structure for Status in Loyalty | |||||
18 | ![]() |
CRM_LOY_COM_JISTAT | J_ISTAT | CHAR | 5 | 0 | CRM LOY : Element for System Status | ||
19 | ![]() |
CRM_LOY_COM_JESTAT | J_ESTAT | CHAR | 5 | 0 | CRM LOY : Element For User Status | ||
20 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
21 | ![]() |
CRM_LOY_COM_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Data element for time stamp | ||
22 | ![]() |
CRM_LOY_MA_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Member Activity Timezone | ||
23 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
24 | ![]() |
CRM_LOY_MA_ERR_CODE | CHAR | 12 | 0 | Twelve Character Error Code | |||
25 | ![]() |
0 | 0 | LOY : Loyalty Admin Structure | |||||
26 | ![]() |
CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! | ||
27 | ![]() |
CRM_LOY_COM_CREATED_BY | UNAME | CHAR | 12 | 0 | LOY: Created By | ||
28 | ![]() |
CRM_LOY_COM_CREATED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
29 | ![]() |
CRM_LOY_COM_CHANGED_ON | SYDATS | DATS | 8 | 0 | LOY : Changed On - OBSOLETE !!! | ||
30 | ![]() |
CRM_LOY_COM_CHANGED_BY | UNAME | CHAR | 12 | 0 | LOY : Changed By | ||
31 | ![]() |
CRM_LOY_COM_CHANGED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
32 | ![]() |
0 | 0 | Extensibility Include Structure for Member Activity Generic | |||||
33 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
34 | ![]() |
0 | 0 | ||||||
35 | ![]() |
0 | 0 | structure for PSH attributes in CRM box | |||||
36 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
37 | ![]() |
CRM_LOY_MA_PART_EXT_ID | CRM_LOY_MA_PART_EXT_ID | CHAR | 10 | 0 | CRM LOY MEMBER ACTIVITY PARTNER EXTERNAL ID | ||
38 | ![]() |
CRM_LOY_MA_PART_EXT_DESC | CRM_LOY_MA_PART_EXT_DESC | CHAR | 50 | 0 | crm MA External Partnership Description | ||
39 | ![]() |
CRM_LOY_PSH_ID | CRM_LOY_PSH_ID | CHAR | 10 | 0 | Partnership ID | ||
40 | ![]() |
CRM_LOY_PSH_EXT_REF | CRM_LOY_PSH_EXT_REF | CHAR | 40 | 0 | Partnership External Reference | ||
41 | ![]() |
0 | 0 | LOY : Loaylty Action Structure | |||||
42 | ![]() |
CRM_LOY_COM_MODE | CRM_LOY_COM_MODE | CHAR | 1 | 0 | LOY: Loyalty Mode | ||
43 | ![]() |
0 | 0 | Structure to include all the ID's | |||||
44 | ![]() |
CRM_LOY_MEMS_ID | CRM_LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
45 | ![]() |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | ||
46 | ![]() |
CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
47 | ![]() |
CRM_CRD_CARD_ID | CRM_CRD_CARD_ID | CHAR | 16 | 0 | Card ID | ||
48 | ![]() |
CRM_MKTGS_SHORTTEXT | TEXT40 | CHAR | 40 | 0 | MKTGS: Short text | ||
49 | ![]() |
BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
50 | ![]() |
BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | ||
51 | ![]() |
BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
52 | ![]() |
CRM_LOY_MA_SHORT_CODE | CHAR | 20 | 0 | Short Code | |||
53 | ![]() |
CRM_LOY_ERR_CODE_DESCR | CHAR | 255 | 0 | Error Code Description | |||
54 | ![]() |
CRM_LOY_CRD_CARD_EXT_ID | CRM_LOY_CRD_CARD_EXT_ID | CHAR | 25 | 0 | External Card ID | ||
55 | ![]() |
0 | 0 | Extensibility Include Struct for Member Activity Generic IDs | |||||
56 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
57 | ![]() |
0 | 0 | ||||||
58 | ![]() |
CRMS_LOY_MA_SPECIFIC_ATTR | STRU | 0 | 0 | ||||
59 | ![]() |
0 | 0 | LOY : Loyalty Key Structure | |||||
60 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | ||
61 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
62 | ![]() |
0 | 0 | LOY : Loyalty Object Strucure | |||||
63 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
64 | ![]() |
CRM_LOY_COM_APPLICATION | CRM_LOY_COM_APPLICATION | CHAR | 4 | 0 | LOY : Application | ||
65 | ![]() |
CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
66 | ![]() |
0 | 0 | Structure for specific attributes, airline industry | |||||
67 | ![]() |
DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
68 | ![]() |
CRM_LOY_AIR_ID | CRM_LOY_AIR_ID | CHAR | 3 | 0 | Unique Three Character ICAO Code of the Airline | ||
69 | ![]() |
CRM_LOY_BOOK_CODE | CRM_LOY_BOOK_CODE | CHAR | 2 | 0 | Code to Identify the Booking Class | ||
70 | ![]() |
CRM_LOY_MUL | CRM_LOY_MUL | DEC | 6 | 2 | Multiplier Used in Point Determination | ||
71 | ![]() |
CRM_LOY_AIRPORTID | CRM_LOY_AIRPORTID | CHAR | 4 | 0 | Unique four Character ICAO Code of Airport | ||
72 | ![]() |
CRM_LOY_AIRPORTID | CRM_LOY_AIRPORTID | CHAR | 4 | 0 | Unique four Character ICAO Code of Airport | ||
73 | ![]() |
CRM_LOY_CATEGORY | CRM_LOY_CATEGORY | CHAR | 4 | 0 | Category to which the Segment is Assigned | ||
74 | ![]() |
CRM_LOY_MA_FLGT_NUM | CRM_LOY_MA_FLGT_NUM | CHAR | 30 | 0 | Member Activity Flight Number | ||
75 | ![]() |
CRM_LOY_BASE_MILES | CRM_LOY_BASE_MILES | DEC | 11 | 2 | Base Miles for the Segment | ||
76 | ![]() |
CRM_LOY_MA_TKT_NUM | CRM_LOY_MA_TKT_NUM | CHAR | 30 | 0 | Member Activity Ticket Number | ||
77 | ![]() |
CRM_LOY_MA_PNR | CRM_LOY_MA_PNR | CHAR | 30 | 0 | PNR Number | ||
78 | ![]() |
CRM_LOY_FARE_CODE | CRM_LOY_FARE_CODE | CHAR | 3 | 0 | Code to Identify the Fare Basis | ||
79 | ![]() |
CRM_LOY_MUL | CRM_LOY_MUL | DEC | 6 | 2 | Multiplier Used in Point Determination | ||
80 | ![]() |
0 | 0 | Structure for member activity specific attributes | |||||
81 | ![]() |
CRMT_MKTPL_LOY_POINT_NAME | CRM_MKTPL_LOY_POINT_NAME | CHAR | 20 | 0 | Description of Point | ||
82 | ![]() |
CRM_LOY_PT_POINT | DEC | 10 | 2 | Loyalty Point | |||
83 | ![]() |
CRM_LOY_PT_QUAL_TYPE | CHAR | 20 | 0 | Loyalty Point Qualification Type | |||
84 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
85 | ![]() |
COMT_CATEGORY_GUID_C | SYSUUID_C | CHAR | 32 | 0 | Category GUID | ||
86 | ![]() |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
87 | ![]() |
CRMT_MKTPL_LOY_TIERGRP_CODE | CRM_MKTPL_LOY_TIER_CODE | CHAR | 10 | 0 | ID of Tier Group | ||
88 | ![]() |
CRMT_MKTPL_LOY_TIERLEVEL_CODE | CRM_MKTPL_LOY_TIER_CODE | CHAR | 10 | 0 | ID of Tier | ||
89 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
90 | ![]() |
CRM_LOY_MA_AMOUNT | CRM_LOY_MA_AMOUNT | CURR | 19 | 2 | Member Activity Amount | ||
91 | ![]() |
CUKY | 5 | 0 | |||||
92 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
93 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
94 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
95 | ![]() |
CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | ||
96 | ![]() |
CRM_LOY_MA_OBJ_REF_TYPE | CRM_LOY_MA_OBJ_REF_TYPE | CHAR | 15 | 0 | Member Activity (Specific Attribute) Reference Object Type | ||
97 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
98 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
99 | ![]() |
CRM_LOY_RETAIL_STORE_ID | CHAR | 20 | 0 | Retail Store ID | |||
100 | ![]() |
CRM_LOY_TRAN_SEQ_NUM | CHAR | 30 | 0 | Transaction Sequence Number | |||
101 | ![]() |
0 | 0 | LOY : Loyalty Admin Structure | |||||
102 | ![]() |
CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! | ||
103 | ![]() |
CRM_LOY_COM_CREATED_BY | UNAME | CHAR | 12 | 0 | LOY: Created By | ||
104 | ![]() |
CRM_LOY_COM_CREATED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
105 | ![]() |
CRM_LOY_COM_CHANGED_ON | SYDATS | DATS | 8 | 0 | LOY : Changed On - OBSOLETE !!! | ||
106 | ![]() |
CRM_LOY_COM_CHANGED_BY | UNAME | CHAR | 12 | 0 | LOY : Changed By | ||
107 | ![]() |
CRM_LOY_COM_CHANGED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
108 | ![]() |
0 | 0 | Extensibility Include Structure for Member Activity Specific | |||||
109 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
110 | ![]() |
0 | 0 | ||||||
111 | ![]() |
0 | 0 | Member Activity Specific Benefit Attributes | |||||
112 | ![]() |
CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
113 | ![]() |
CRM_LOY_BNFT_USAGE | CRM_LOY_BNFT_USAGE | INT2 | 5 | 0 | Benefit Usage | ||
114 | ![]() |
BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
115 | ![]() |
CRM_LOY_BNFT_ORIGIN | CRM_LOY_BNFT_ORIGIN | CHAR | 40 | 0 | Loyalty Benefit Origin (Source) | ||
116 | ![]() |
0 | 0 | LOY : Loaylty Action Structure | |||||
117 | ![]() |
CRM_LOY_COM_MODE | CRM_LOY_COM_MODE | CHAR | 1 | 0 | LOY: Loyalty Mode | ||
118 | ![]() |
0 | 0 | Structure for Specific Attribute ID's | |||||
119 | ![]() |
COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
120 | ![]() |
CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
121 | ![]() |
CRM_MKTPL_REWARD_RULEID | CGPL_EXTID | CHAR | 24 | 0 | Reward Rule | ||
122 | ![]() |
CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
123 | ![]() |
COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
124 | ![]() |
COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
125 | ![]() |
COMT_CATEGORY_TEXT | TEXT80 | CHAR | 80 | 0 | Category Description | ||
126 | ![]() |
CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
127 | ![]() |
CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
128 | ![]() |
CRM_LOY_AIR_NAME | CRM_LOY_AIR_NAME | CHAR | 40 | 0 | Airline/Airport Name | ||
129 | ![]() |
CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
130 | ![]() |
CRM_LOY_DESC | CRM_LOY_DESC | CHAR | 40 | 0 | Description of the Booking Class | ||
131 | ![]() |
CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
132 | ![]() |
CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
133 | ![]() |
COMT_HIERARCHY_GUID | SYSUUID | RAW | 16 | 0 | Category Hierarchy GUID | ||
134 | ![]() |
0 | 0 | Extensibility Include Struct for Member Activity Specific ID | |||||
135 | ![]() |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
136 | ![]() |
0 | 0 | ||||||
137 | ![]() |
0 | 0 | Member Activity Specific Benefit Attributes ID's | |||||
138 | ![]() |
CRM_LOY_BNFT_ID | CRM_LOY_BNFT_ID | CHAR | 10 | 0 | Loyalty Benefit ID | ||
139 | ![]() |
CRM_LOY_BNFT_DESCRIPTION | CRM_LOY_BNFT_DESCRIPTION | CHAR | 60 | 0 | Loyalty Benefit Description | ||
140 | ![]() |
CRM_LOY_BNFT_TYPE | CRM_LOY_BNFT_TYPE | CHAR | 20 | 0 | Loyalty Benefit Usage |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |