LOYD_MA_SPECATTR is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of LOYD_MA_SPECATTR in SAP.
- Table description : Table for member activity specific attributes
- Module : CRM-LOY-MA
- Parent Module : CRM
- Package : LOY_MEMBER_ACTIVITY_DB
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP LOYD_MA_SPECATTR Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| .INCLUDE | LOY FRW : Primary key Include | ||
| CLIENT | Client | MANDT | MANDT |
| GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| .INCLUDE | LOY FRW : Non-Key Framework Include | ||
| REF_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| APPLICATION | Application | LOY_FRW_APPLICATION | LOY_FRW_APPLICATION |
| PROCESS_TYPE | Process Type | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE |
| .INCLUDE | Structure for specific attributes, airline industry | ||
| TICKETING_DATE | Ticketing Date of flight booking | LOY_ADM_TICKETING_DATE | DATS |
| AIRLINE_ID | ICAO Code of the Airline | LOY_ADM_AIRLINE_ID | LOY_ADM_AIRLINE_ID |
| BOOKING_CLASS | Booking Class Code | LOY_ADM_BOOK_CODE | LOY_ADM_BOOK_CODE |
| BOOK_CLASS_MUL | Booking Class Multiplier | LOY_ADM_MUL | LOY_ADM_MULTI |
| ORIGIN_AIRPORT | ICAO Code of the Origin Airport | LOY_ADM_ORIG_AIRPORT | LOY_ADM_AIRPORT_ID |
| DEST_AIRPORT | ICAO Code of the Destination Airport | LOY_ADM_DEST_AIRPORT | LOY_ADM_AIRPORT_ID |
| FLIGHT_CATEGORY | Flight Category | LOY_ADM_CATEGORY | LOY_ADM_CATEGORY |
| FLIGHT_NUMBER | Flight Number | LOY_MA_FLGT_NUM | LOY_MA_FLGT_NUM |
| BASE_MILES | Base Miles for the flight segment | LOY_ADM_BASE_MILES | LOY_ADM_BASE_MILES |
| TICKET_NUMBER | Ticket Number | LOY_MA_TKT_NUM | LOY_MA_TKT_NUM |
| PNR | Passenger Name Record (PNR) from reservation system | LOY_MA_PNR | LOY_MA_PNR |
| FARE_BASIS | Fare Basis for the flight | LOY_ADM_FARE_CODE | LOY_ADM_FARE_CODE |
| FARE_BASIS_MUL | Fare Basis Multiplier | LOY_ADM_FARE_BASIS_MUL | LOY_ADM_MULTI |
| .INCLUDE | Structure for member activity specific attr, across industry | ||
| POINT_TYPE | Point Type | LOY_PT_TYPE | LOY_PT_TYPE |
| POINTS | Number of Points | LOY_PT_POINT | |
| POINT_QUAL | Point Qualification Type | LOY_PT_QUAL_TYPE | LOY_PTQUALTYPE |
| PRODUCT_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| PROD_CAT_GUID | Product Category GUID for Member Activity | LOY_MA_CATEGORY_GUID_C | SYSUUID_C |
| PRODUCT_QUANTITY | Quantity | MENGE_D | MENG13 |
| TIER_GROUP | Tier Group | LOY_MA_TIER_GROUP | LOY_MA_TIER_GROUP |
| TIER | Tier Level | LOY_MA_TIER | LOY_MA_TIER |
| CAMPAIGN_CODE | Object GUID | LOY_FRW_GUID | SYSUUID |
| AMOUNT | Amount for the activity | LOY_MA_AMOUNT | LOY_MA_AMOUNT |
| CURRENCY | Currency | LOY_MA_CURR | WAERS |
| REWARD_RULE | Object GUID | LOY_FRW_GUID | SYSUUID |
| ORDER_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| ORDER_ITEM_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| PROCESS_QTY_UNIT | Unit of Measure in which the Product is Sold | LOY_MA_PROCESS_QTY_UNIT | MEINS |
| OBJ_REF_TYPE | Member Activity (Specific Attribute) Reference Object Type | LOY_MA_OBJ_REF_TYPE | LOY_MA_OBJ_REF_TYPE |
| OBJ_REF_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| OBJ_REF_ITM_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| RETAIL_STORE_ID | Retail Store ID | LOY_RETAIL_STORE_ID | |
| TRAN_SEQ_NUM | Transaction Sequence Number | LOY_TRAN_SEQ_NUM | |
| .INCLUDE | LOY FRW : Administrative Include | ||
| CREATED_ON | Created On - OBSOLETE !!! | LOY_FRW_CREATED_ON | SYDATS |
| CREATED_BY | Created By | LOY_FRW_CREATED_BY | UNAME |
| CREATED_AT | Created At (Output in User Time Zone) | LOY_FRW_CREATED_AT | LOY_TSTMP |
| CHANGED_ON | Changed On - OBSOLETE !!! | LOY_FRW_CHANGED_ON | SYDATS |
| CHANGED_BY | Changed By | LOY_FRW_CHANGED_BY | UNAME |
| CHANGED_AT | Changed At (Output in User Time Zone) | LOY_FRW_CHANGED_AT | LOY_TSTMP |
| .INCLUDE | Extensibility Include Structure for Member Activity Specific | ||
| MASPECATTR_DUMMY | Dummy function in length 1 | DUMMY | DUMMY |
| .INCLUDE | |||
| .INCLUDE | Member Activity Specific Benefit Attributes | ||
| BENEFIT_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| NO_OF_USAGES | Loyalty Benefit Usage | LOY_BNFT_USAGE | LOY_BNFT_USAGE |
| UNRESTRICTED | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | BOOLEAN |
| ORIGIN | Benefit Origin | LOY_BNFT_ORIGIN | LOY_BNFT_ORIGIN |
LOYD_MA_SPECATTR related tables
| Table | Note |
|---|---|
| LOYD_MA_SPECATTR | Table for member activity specific attributes |
| LOYD_MA_GENATTR | Table to store member activity generic attributes |
| CRMC_LOY_MA_TY | table for member activity types |
| LOYC_MA_CAT | Table for member activity categories |
| LOYC_MA_CAT_T | Text table for member activity category |
| LOYC_MA_CAT_TYPE | Table for Member Activity Category Type relations |
| LOYC_MA_ERR_CODE | Table to maintain Error Codes for Member activity |
| LOYC_MA_TYPE | Table for Member Activity Types |
| LOYC_MA_TYPE_T | Text table for Member Activity Types |
| LOYD_MA_LOG_CLST | Logs table for Member Activity |
| LOYD_MA_NOT_PROC | Table for member activity un processed records(obsolete!!!) |
| LOY_LOGS_CLST_MS | Logs table for Member Activity |
| LOY_LOGS_CLST_PA | Logs table for Member Activity |
| LOYC_MA_TYPCLASS | Loyalty Member activity type classification |
| CRMD_ENR_MEMBER | CRM Enrollment Member Table |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP