SAP ABAP Table LOYD_MA_SPECATTR (Table 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	TRANSP	Transparent table
Transparent table	LOYD_MA_SPECATTR	Table Relationship Diagram
Short Description	Table for member activity specific attributes

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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 FRW : Primary key Include
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
4	.INCLUDE	☐				0	0	LOY FRW : Non-Key Framework Include
5	REF_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MA_GENATTR
6	APPLICATION	☐	LOY_FRW_APPLICATION	LOY_FRW_APPLICATION	CHAR	4	0	Application
7	PROCESS_TYPE	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
8	.INCLUDE	☐				0	0	Structure for specific attributes, airline industry
9	TICKETING_DATE	☐	LOY_ADM_TICKETING_DATE	DATS	DATS	8	0	Ticketing Date of flight booking
10	AIRLINE_ID	☐	LOY_ADM_AIRLINE_ID	LOY_ADM_AIRLINE_ID	CHAR	3	0	ICAO Code of the Airline
11	BOOKING_CLASS	☐	LOY_ADM_BOOK_CODE	LOY_ADM_BOOK_CODE	CHAR	2	0	Booking Class Code
12	BOOK_CLASS_MUL	☐	LOY_ADM_MUL	LOY_ADM_MULTI	DEC	6	2	Booking Class Multiplier
13	ORIGIN_AIRPORT	☐	LOY_ADM_ORIG_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Origin Airport
14	DEST_AIRPORT	☐	LOY_ADM_DEST_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Destination Airport
15	FLIGHT_CATEGORY	☐	LOY_ADM_CATEGORY	LOY_ADM_CATEGORY	CHAR	4	0	Flight Category
16	FLIGHT_NUMBER	☐	LOY_MA_FLGT_NUM	LOY_MA_FLGT_NUM	CHAR	30	0	Flight Number
17	BASE_MILES	☐	LOY_ADM_BASE_MILES	LOY_ADM_BASE_MILES	DEC	11	2	Base Miles for the flight segment
18	TICKET_NUMBER	☐	LOY_MA_TKT_NUM	LOY_MA_TKT_NUM	CHAR	30	0	Ticket Number
19	PNR	☐	LOY_MA_PNR	LOY_MA_PNR	CHAR	30	0	Passenger Name Record (PNR) from reservation system
20	FARE_BASIS	☐	LOY_ADM_FARE_CODE	LOY_ADM_FARE_CODE	CHAR	3	0	Fare Basis for the flight
21	FARE_BASIS_MUL	☐	LOY_ADM_FARE_BASIS_MUL	LOY_ADM_MULTI	DEC	6	2	Fare Basis Multiplier
22	.INCLUDE	☐				0	0	Structure for member activity specific attr, across industry
23	POINT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
24	POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
25	POINT_QUAL	☐	LOY_PT_QUAL_TYPE	LOY_PTQUALTYPE	CHAR	20	0	Point Qualification Type
26	PRODUCT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
27	PROD_CAT_GUID	☐	LOY_MA_CATEGORY_GUID_C	SYSUUID_C	CHAR	32	0	Product Category GUID for Member Activity
28	PRODUCT_QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
29	TIER_GROUP	☐	LOY_MA_TIER_GROUP	LOY_MA_TIER_GROUP	CHAR	10	0	Tier Group
30	TIER	☐	LOY_MA_TIER	LOY_MA_TIER	CHAR	10	0	Tier Level
31	CAMPAIGN_CODE	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
32	AMOUNT	☐	LOY_MA_AMOUNT	LOY_MA_AMOUNT	CURR	19	2	Amount for the activity
33	CURRENCY	☐	LOY_MA_CURR	WAERS	CUKY	5	0	Currency	*
34	REWARD_RULE	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
35	ORDER_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
36	ORDER_ITEM_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
37	PROCESS_QTY_UNIT	☐	LOY_MA_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in which the Product is Sold	*
38	OBJ_REF_TYPE	☐	LOY_MA_OBJ_REF_TYPE	LOY_MA_OBJ_REF_TYPE	CHAR	15	0	Member Activity (Specific Attribute) Reference Object Type
39	OBJ_REF_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
40	OBJ_REF_ITM_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
41	RETAIL_STORE_ID	☐	LOY_RETAIL_STORE_ID		CHAR	20	0	Retail Store ID
42	TRAN_SEQ_NUM	☐	LOY_TRAN_SEQ_NUM		CHAR	30	0	Transaction Sequence Number
43	.INCLUDE	☐				0	0	LOY FRW : Administrative Include
44	CREATED_ON	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
45	CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
46	CREATED_AT	☐	LOY_FRW_CREATED_AT	LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
47	CHANGED_ON	☐	LOY_FRW_CHANGED_ON	SYDATS	DATS	8	0	Changed On - OBSOLETE !!!
48	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
49	CHANGED_AT	☐	LOY_FRW_CHANGED_AT	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	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
55	NO_OF_USAGES	☐	LOY_BNFT_USAGE	LOY_BNFT_USAGE	INT2	5	0	Loyalty Benefit Usage
56	UNRESTRICTED	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
57	ORIGIN	☐	LOY_BNFT_ORIGIN	LOY_BNFT_ORIGIN	CHAR	40	0	Benefit Origin

Foreign Keys

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

History

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