SAP ABAP Table LOYS_MA_LSMW (Member Activity attributes for LSMW)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY-MA (Application Component) Member Activity
     ⤷ LOY_MEMBER_ACTIVITY (Package) Loyalty Member Activity

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_MA_LSMW	Table Relationship Diagram
Short Description	Member Activity attributes for LSMW

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	PROCESS_TYPE	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
2	CATEGORY	☐	LOY_MA_CAT_ID	LOY_MA_CAT_ID	CHAR	30	0	Member Activity Category ID
3	ACTIVITY_DATE	☐	CHAR15	CHAR15	CHAR	15	0	Char 15
4	ACTIVITY_TZ	☐	LOY_MA_TIMEZONE	TZNZONE	CHAR	6	0	Member Activity Timezone	*
5	MEMBERSHIP_ID	☐	LOY_MA_MEMBERSHIP_ID	LOY_MA_MEMBERSHIP_ID	CHAR	10	0	Membership ID
6	MEMBER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
7	CARD_ID	☐	LOY_CRD_CARD_ID	LOY_CRD_CARD_ID	CHAR	16	0	Card ID
8	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
9	ESTAT	☐	LOY_FRW_JESTAT	J_ESTAT	CHAR	5	0	User Status	*
10	POINT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
11	POINTS_EARNED	☐	CHAR13	CHAR13	CHAR	13	0	Character field 13 digits
12	POINT_QUAL	☐	LOY_PT_QUAL_TYPE	LOY_PTQUALTYPE	CHAR	20	0	Point Qualification Type
13	PRODUCT_ID	☐	LOY_MA_PRODUCT_ID	LOY_MA_PRODUCT_ID	CHAR	40	0	Product
14	PRODCATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
15	PRODUCT_QUANTITY	☐	CHAR13	CHAR13	CHAR	13	0	Character field 13 digits
16	PROCESS_QTY_UNIT	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
17	AMOUNT	☐	CHAR19	CHAR19	CHAR	19	0	19 Characters
18	CURRENCY	☐	CHAR5	CHAR5	CHAR	5	0	R/2 table
19	TIER_GROUP	☐	LOY_MA_TIER_GROUP	LOY_MA_TIER_GROUP	CHAR	10	0	Tier Group
20	TIER	☐	LOY_MA_TIER	LOY_MA_TIER	CHAR	10	0	Tier Level
21	CAMPAIGN_CODE_ID	☐	LOY_MA_CAMPAIGN_CODE_ID	LOY_MA_CAMPAIGN_CODE_ID	CHAR	24	0	Campaign
22	REWARD_RULE_ID	☐	LOY_MA_REWARD_RULE_ID	LOY_MA_REWARD_RULE_ID	CHAR	24	0	Reward Rule
23	TICKETING_DATE	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
24	AIRLINE_ID	☐	LOY_ADM_AIRLINE_ID	LOY_ADM_AIRLINE_ID	CHAR	3	0	ICAO Code of the Airline
25	BOOKING_CLASS	☐	LOY_ADM_BOOK_CODE	LOY_ADM_BOOK_CODE	CHAR	2	0	Booking Class Code
26	BOOK_CLASS_MUL	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
27	ORIGIN_AIRPORT	☐	LOY_ADM_AIRPORT_ID	LOY_ADM_AIRPORT_ID	CHAR	4	0	Unique Four Character ICAO Code of the Airport
28	DEST_AIRPORT	☐	LOY_ADM_AIRPORT_ID	LOY_ADM_AIRPORT_ID	CHAR	4	0	Unique Four Character ICAO Code of the Airport
29	FLIGHT_CATEGORY	☐	LOY_ADM_CATEGORY	LOY_ADM_CATEGORY	CHAR	4	0	Flight Category
30	FLIGHT_NUMBER	☐	LOY_MA_FLGT_NUM	LOY_MA_FLGT_NUM	CHAR	30	0	Flight Number
31	BASE_MILES	☐	CHAR9	CHAR9	CHAR	9	0	Character field of 9 digits
32	TICKET_NUMBER	☐	LOY_MA_TKT_NUM	LOY_MA_TKT_NUM	CHAR	30	0	Ticket Number
33	PNR	☐	LOY_MA_PNR	LOY_MA_PNR	CHAR	30	0	Passenger Name Record (PNR) from reservation system
34	FARE_BASIS	☐	LOY_ADM_FARE_CODE	LOY_ADM_FARE_CODE	CHAR	3	0	Fare Basis for the flight
35	FARE_BASIS_MUL	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
36	ORDER_ID	☐	LOY_MA_ORDER_ID	LOY_MA_ORDER_ID	CHAR	10	0	Order
37	PARTNERSHIP_ID	☐	LOY_PSH_ID	LOY_PSH_ID	CHAR	10	0	Partnership ID
38	PARTNSHIP_EXT_ID	☐	LOY_MA_PART_EXT_ID	LOY_MA_PARTNER_ID	CHAR	10	0	MEMBER ACTIVITY PARTNERSHIP EXTERNAL ID
39	PARSHIP_EXT_DES	☐	LOY_MA_PART_EXT_DESC	LOY_MA_PARTNER_DESC	CHAR	50	0	Member Activity External Partner Description
40	OBJ_REF_TYPE	☐	LOY_MA_OBJ_REF_TYPE	LOY_MA_OBJ_REF_TYPE	CHAR	15	0	Member Activity (Specific Attribute) Reference Object Type
41	OBJ_REF_ID	☐	LOY_MA_ACT_ID	LOY_MA_ACTID	CHAR	10	0	Member Activity ID
42	OBJ_REF_ITM_ID	☐	LOY_MA_ACT_ID	LOY_MA_ACTID	CHAR	10	0	Member Activity ID
43	RETAIL_STORE_ID	☐	LOY_RETAIL_STORE_ID		CHAR	20	0	Retail Store ID
44	TRAN_SEQ_NUM	☐	LOY_TRAN_SEQ_NUM		CHAR	30	0	Transaction Sequence Number
45	BENEFIT_ID	☐	LOY_BNFT_ID	LOY_BNFT_ID	CHAR	10	0	Loyalty Benefit ID
46	NO_OF_USAGES	☐			NUMC	5	0
47	UNRESTRICTED	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
48	ORIGIN	☐	LOY_BNFT_ORIGIN	LOY_BNFT_ORIGIN	CHAR	40	0	Benefit Origin
49	EXTERNAL_CARD_NU	☐	LOY_CRD_CARD_EXT_ID	LOY_CRD_CARD_EXT_ID	CHAR	25	0	External Card ID

History

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