SAP ABAP Table CRMS_LOY_MA_SPECIFIC_ATTR (Structure for member activity specific attributes)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

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_SPECIFIC_ATTR	Table Relationship Diagram
Short Description	Structure for member activity specific attributes

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	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	Structure for specific attributes, airline industry
9	TICKETING_DATE	DATS	DATS	DATS	8	0	Field of type DATS
10	AIRLINE_ID	CRM_LOY_AIR_ID	CRM_LOY_AIR_ID	CHAR	3	0	Unique Three Character ICAO Code of the Airline
11	BOOKING_CLASS	CRM_LOY_BOOK_CODE	CRM_LOY_BOOK_CODE	CHAR	2	0	Code to Identify the Booking Class
12	BOOK_CLASS_MUL	CRM_LOY_MUL	CRM_LOY_MUL	DEC	6	2	Multiplier Used in Point Determination
13	ORIGIN_AIRPORT	CRM_LOY_AIRPORTID	CRM_LOY_AIRPORTID	CHAR	4	0	Unique four Character ICAO Code of Airport
14	DEST_AIRPORT	CRM_LOY_AIRPORTID	CRM_LOY_AIRPORTID	CHAR	4	0	Unique four Character ICAO Code of Airport
15	FLIGHT_CATEGORY	CRM_LOY_CATEGORY	CRM_LOY_CATEGORY	CHAR	4	0	Category to which the Segment is Assigned
16	FLIGHT_NUMBER	CRM_LOY_MA_FLGT_NUM	CRM_LOY_MA_FLGT_NUM	CHAR	30	0	Member Activity Flight Number
17	BASE_MILES	CRM_LOY_BASE_MILES	CRM_LOY_BASE_MILES	DEC	11	2	Base Miles for the Segment
18	TICKET_NUMBER	CRM_LOY_MA_TKT_NUM	CRM_LOY_MA_TKT_NUM	CHAR	30	0	Member Activity Ticket Number
19	PNR	CRM_LOY_MA_PNR	CRM_LOY_MA_PNR	CHAR	30	0	PNR Number
20	FARE_BASIS	CRM_LOY_FARE_CODE	CRM_LOY_FARE_CODE	CHAR	3	0	Code to Identify the Fare Basis
21	FARE_BASIS_MUL	CRM_LOY_MUL	CRM_LOY_MUL	DEC	6	2	Multiplier Used in Point Determination
22	.INCLUDE				0	0	Structure for member activity specific attributes
23	POINT_TYPE	CRMT_MKTPL_LOY_POINT_NAME	CRM_MKTPL_LOY_POINT_NAME	CHAR	20	0	Description of Point
24	POINTS	CRM_LOY_PT_POINT		DEC	10	2	Loyalty Point
25	POINT_QUAL	CRM_LOY_PT_QUAL_TYPE		CHAR	20	0	Loyalty Point Qualification Type
26	PRODUCT_GUID	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
27	PROD_CAT_GUID	COMT_CATEGORY_GUID_C	SYSUUID_C	CHAR	32	0	Category GUID
28	PRODUCT_QUANTITY	MENGE_D	MENG13	QUAN	13	3	Quantity
29	TIER_GROUP	CRMT_MKTPL_LOY_TIERGRP_CODE	CRM_MKTPL_LOY_TIER_CODE	CHAR	10	0	ID of Tier Group
30	TIER	CRMT_MKTPL_LOY_TIERLEVEL_CODE	CRM_MKTPL_LOY_TIER_CODE	CHAR	10	0	ID of Tier
31	CAMPAIGN_CODE	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
32	AMOUNT	CRM_LOY_MA_AMOUNT	CRM_LOY_MA_AMOUNT	CURR	19	2	Member Activity Amount
33	CURRENCY			CUKY	5	0
34	REWARD_RULE	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
35	ORDER_GUID	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
36	ORDER_ITEM_GUID	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
37	PROCESS_QTY_UNIT	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
38	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
39	OBJ_REF_GUID	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
40	OBJ_REF_ITM_GUID	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
41	RETAIL_STORE_ID	CRM_LOY_RETAIL_STORE_ID		CHAR	20	0	Retail Store ID
42	TRAN_SEQ_NUM	CRM_LOY_TRAN_SEQ_NUM		CHAR	30	0	Transaction Sequence Number
43	.INCLUDE				0	0	LOY : Loyalty Admin Structure
44	CREATED_ON	CRM_LOY_COM_CREATED_ON	SYDATS	DATS	8	0	LOY : Created On - OBSOLETE !!!
45	CREATED_BY	CRM_LOY_COM_CREATED_BY	UNAME	CHAR	12	0	LOY: Created By
46	CREATED_AT	CRM_LOY_COM_CREATED_AT	CRM_LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
47	CHANGED_ON	CRM_LOY_COM_CHANGED_ON	SYDATS	DATS	8	0	LOY : Changed On - OBSOLETE !!!
48	CHANGED_BY	CRM_LOY_COM_CHANGED_BY	UNAME	CHAR	12	0	LOY : Changed By
49	CHANGED_AT	CRM_LOY_COM_CHANGED_AT	CRM_LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
50	.INCLUDE				0	0	Extensibility Include Structure for Member Activity Specific
51	MASPECATTR_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
52	.INCLUDE				0	0
53	.INCLUDE				0	0	Member Activity Specific Benefit Attributes
54	BENEFIT_GUID	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
55	NO_OF_USAGES	CRM_LOY_BNFT_USAGE	CRM_LOY_BNFT_USAGE	INT2	5	0	Benefit Usage
56	UNRESTRICTED	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
57	ORIGIN	CRM_LOY_BNFT_ORIGIN	CRM_LOY_BNFT_ORIGIN	CHAR	40	0	Loyalty Benefit Origin (Source)
58	.INCLUDE				0	0	LOY : Loaylty Action Structure
59	PROCESS_MODE	CRM_LOY_COM_MODE	CRM_LOY_COM_MODE	CHAR	1	0	LOY: Loyalty Mode
60	.INCLUDE				0	0	Structure for Specific Attribute ID's
61	PRODUCT_ID	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
62	CAMPAIGN_CODE_ID	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
63	REWARD_RULE_ID	CRM_MKTPL_REWARD_RULEID	CGPL_EXTID	CHAR	24	0	Reward Rule
64	ORDER_ID	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
65	PRODCATEGORY_ID	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
66	PRODUCT_DESC	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
67	PRODUCT_CAT_DESC	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
68	BOOKING_DESCR	CRM_LOY_DESC	CRM_LOY_DESC	CHAR	40	0	Description of the Booking Class
69	FARE_DESCR	CRM_LOY_DESC	CRM_LOY_DESC	CHAR	40	0	Description of the Booking Class
70	AIRLINE_NAME	CRM_LOY_AIR_NAME	CRM_LOY_AIR_NAME	CHAR	40	0	Airline/Airport Name
71	ORIGIN_AIRPORT_NAME	CRM_LOY_DESC	CRM_LOY_DESC	CHAR	40	0	Description of the Booking Class
72	DEST_AIRPORT_NAME	CRM_LOY_DESC	CRM_LOY_DESC	CHAR	40	0	Description of the Booking Class
73	OBJ_REF_ID	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
74	OBJ_REF_ITM_ID	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
75	PROD_HIER_GUID	COMT_HIERARCHY_GUID	SYSUUID	RAW	16	0	Category Hierarchy GUID
76	.INCLUDE				0	0	Extensibility Include Struct for Member Activity Specific ID
77	MASPECATTR_ID_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
78	.INCLUDE				0	0
79	.INCLUDE				0	0	Member Activity Specific Benefit Attributes ID's
80	BENEFIT_ID	CRM_LOY_BNFT_ID	CRM_LOY_BNFT_ID	CHAR	10	0	Loyalty Benefit ID
81	BENEFIT_DESC	CRM_LOY_BNFT_DESCRIPTION	CRM_LOY_BNFT_DESCRIPTION	CHAR	60	0	Loyalty Benefit Description
82	BENEFIT_TYPE	CRM_LOY_BNFT_TYPE	CRM_LOY_BNFT_TYPE	CHAR	20	0	Loyalty Benefit Usage