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

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_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	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Table for member activity specific attributes
2	.INCLUDE	☐				0	0	LOY FRW : Primary key Include
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
5	.INCLUDE	☐				0	0	LOY FRW : Non-Key Framework Include
6	REF_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MA_GENATTR
7	APPLICATION	☐	LOY_FRW_APPLICATION	LOY_FRW_APPLICATION	CHAR	4	0	Application
8	PROCESS_TYPE	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
9	.INCLUDE	☐				0	0	Structure for specific attributes, airline industry
10	TICKETING_DATE	☐	LOY_ADM_TICKETING_DATE	DATS	DATS	8	0	Ticketing Date of flight booking
11	AIRLINE_ID	☐	LOY_ADM_AIRLINE_ID	LOY_ADM_AIRLINE_ID	CHAR	3	0	ICAO Code of the Airline
12	BOOKING_CLASS	☐	LOY_ADM_BOOK_CODE	LOY_ADM_BOOK_CODE	CHAR	2	0	Booking Class Code
13	BOOK_CLASS_MUL	☐	LOY_ADM_MUL	LOY_ADM_MULTI	DEC	6	2	Booking Class Multiplier
14	ORIGIN_AIRPORT	☐	LOY_ADM_ORIG_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Origin Airport
15	DEST_AIRPORT	☐	LOY_ADM_DEST_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Destination Airport
16	FLIGHT_CATEGORY	☐	LOY_ADM_CATEGORY	LOY_ADM_CATEGORY	CHAR	4	0	Flight Category
17	FLIGHT_NUMBER	☐	LOY_MA_FLGT_NUM	LOY_MA_FLGT_NUM	CHAR	30	0	Flight Number
18	BASE_MILES	☐	LOY_ADM_BASE_MILES	LOY_ADM_BASE_MILES	DEC	11	2	Base Miles for the flight segment
19	TICKET_NUMBER	☐	LOY_MA_TKT_NUM	LOY_MA_TKT_NUM	CHAR	30	0	Ticket Number
20	PNR	☐	LOY_MA_PNR	LOY_MA_PNR	CHAR	30	0	Passenger Name Record (PNR) from reservation system
21	FARE_BASIS	☐	LOY_ADM_FARE_CODE	LOY_ADM_FARE_CODE	CHAR	3	0	Fare Basis for the flight
22	FARE_BASIS_MUL	☐	LOY_ADM_FARE_BASIS_MUL	LOY_ADM_MULTI	DEC	6	2	Fare Basis Multiplier
23	.INCLUDE	☐				0	0	Structure for member activity specific attr, across industry
24	POINT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
25	POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
26	POINT_QUAL	☐	LOY_PT_QUAL_TYPE	LOY_PTQUALTYPE	CHAR	20	0	Point Qualification Type
27	PRODUCT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
28	PROD_CAT_GUID	☐	LOY_MA_CATEGORY_GUID_C	SYSUUID_C	CHAR	32	0	Product Category GUID for Member Activity
29	PRODUCT_QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
30	TIER_GROUP	☐	LOY_MA_TIER_GROUP	LOY_MA_TIER_GROUP	CHAR	10	0	Tier Group
31	TIER	☐	LOY_MA_TIER	LOY_MA_TIER	CHAR	10	0	Tier Level
32	CAMPAIGN_CODE	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
33	AMOUNT	☐	LOY_MA_AMOUNT	LOY_MA_AMOUNT	CURR	19	2	Amount for the activity
34	CURRENCY	☐	LOY_MA_CURR	WAERS	CUKY	5	0	Currency	*
35	REWARD_RULE	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
36	ORDER_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
37	ORDER_ITEM_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
38	PROCESS_QTY_UNIT	☐	LOY_MA_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in which the Product is Sold	*
39	OBJ_REF_TYPE	☐	LOY_MA_OBJ_REF_TYPE	LOY_MA_OBJ_REF_TYPE	CHAR	15	0	Member Activity (Specific Attribute) Reference Object Type
40	OBJ_REF_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
41	OBJ_REF_ITM_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
42	RETAIL_STORE_ID	☐	LOY_RETAIL_STORE_ID		CHAR	20	0	Retail Store ID
43	TRAN_SEQ_NUM	☐	LOY_TRAN_SEQ_NUM		CHAR	30	0	Transaction Sequence Number
44	.INCLUDE	☐				0	0	LOY FRW : Administrative Include
45	CREATED_ON	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
46	CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
47	CREATED_AT	☐	LOY_FRW_CREATED_AT	LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
48	CHANGED_ON	☐	LOY_FRW_CHANGED_ON	SYDATS	DATS	8	0	Changed On - OBSOLETE !!!
49	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
50	CHANGED_AT	☐	LOY_FRW_CHANGED_AT	LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
51	.INCLUDE	☐				0	0	Extensibility Include Structure for Member Activity Specific
52	MASPECATTR_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
53	.INCLUDE	☐				0	0
54	.INCLUDE	☐				0	0	Member Activity Specific Benefit Attributes
55	BENEFIT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
56	NO_OF_USAGES	☐	LOY_BNFT_USAGE	LOY_BNFT_USAGE	INT2	5	0	Loyalty Benefit Usage
57	UNRESTRICTED	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
58	ORIGIN	☐	LOY_BNFT_ORIGIN	LOY_BNFT_ORIGIN	CHAR	40	0	Benefit Origin
59	.INCLUDE	☐				0	0	LOY FRW : Actions Include
60	PROCESS_MODE	☐	LOY_FRW_MODE	LOY_FRW_MODE	CHAR	1	0	Mode
61	.INCLUDE	☐				0	0	Structure for MA specific attributes IDs
62	PRODUCT_ID	☐	LOY_MA_PRODUCT_ID	LOY_MA_PRODUCT_ID	CHAR	40	0	Product
63	CAMPAIGN_CODE_ID	☐	LOY_MA_CAMPAIGN_CODE_ID	LOY_MA_CAMPAIGN_CODE_ID	CHAR	24	0	Campaign
64	REWARD_RULE_ID	☐	LOY_MA_REWARD_RULE_ID	LOY_MA_REWARD_RULE_ID	CHAR	24	0	Reward Rule
65	ORDER_ID	☐	LOY_MA_ORDER_ID	LOY_MA_ORDER_ID	CHAR	10	0	Order
66	PRODCATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
67	PRODUCT_DESC	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
68	PRODUCT_CAT_DESC	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
69	BOOKING_DESCR	☐	LOY_ADM_DESC	LOY_ADM_DESC	CHAR	40	0	Booking Class Description
70	FARE_DESCR	☐	LOY_ADM_FARE_DESCR	LOY_ADM_DESC	CHAR	40	0	Fare Basis Description
71	AIRLINE_NAME	☐	LOY_ADM_AIRLINE_NAME	LOY_ADM_DESC	CHAR	40	0	Airline
72	ORIGIN_AIRPORT_NAME	☐	LOY_ADM_AIRPORT_NAME	LOY_ADM_DESC	CHAR	40	0	Origin Airport Name
73	DEST_AIRPORT_NAME	☐	LOY_ADM_DEST_AIRPORT_NAME	LOY_ADM_DESC	CHAR	40	0	Destination Airport Name
74	OBJ_REF_ID	☐	LOY_MA_ACT_ID	LOY_MA_ACTID	CHAR	10	0	Member Activity ID
75	OBJ_REF_ITM_ID	☐	LOY_MA_ACT_ID	LOY_MA_ACTID	CHAR	10	0	Member Activity ID
76	PROD_HIER_GUID	☐	COMT_HIERARCHY_GUID	SYSUUID	RAW	16	0	Category Hierarchy GUID
77	.INCLUDE	☐				0	0	Extensibility Include Struct for Member Activity Specific ID
78	MASPECATTR_ID_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
79	.INCLUDE	☐				0	0
80	.INCLUDE	☐				0	0	Structure for Unbound Fields for Member Activity Benefits
81	BENEFIT_ID	☐	LOY_BNFT_ID	LOY_BNFT_ID	CHAR	10	0	Loyalty Benefit ID
82	BENEFIT_DESC	☐	LOY_BNFT_DESCRIPTION	LOY_BNFT_DESCRIPTION	CHAR	60	0	Data Element for Benefit Description
83	BENEFIT_TYPE	☐	LOY_BNFT_TYPE	LOY_BNFT_TYPE	CHAR	20	0	Loyalty Benefit Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LOYS_MA_SPECIFIC_ATTR	REF_GUID	LOYD_MA_GENATTR	CLIENT	KEY	1	1

History

Last changed by/on	SAP	20110908
SAP Release Created in	700