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