LOYD_MSH_MEMS is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of LOYD_MSH_MEMS in SAP.
- Table description : Loyalty Membership Table
- Module : CRM-LOY-MSH
- Parent Module : CRM
- Package : LOY_MSH_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_MSH_MEMS 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 |
| MEMB_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| PA_SET_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| OBJECT_ID | Membership ID | LOY_MEMS_ID | LOY_MEMS_ID |
| MEMS_TYPE | Membership Types | LOY_MSH_MEMS_TYPE | |
| LOY_PROG_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| EMPL_RESP_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| NOMINATOR_ID | Membership ID | LOY_MEMS_ID | LOY_MEMS_ID |
| START_DATE | Date | LOY_MEMS_DATE | DATS |
| END_DATE | Date | LOY_MEMS_DATE | DATS |
| PURPOSE_OF_USE | Purpose of Use | LOY_MSH_PURPOSE_OF_USE | LOY_MSH_PURPOSE_OF_USE |
| CREATED_VIA | Origin | LOY_MSH_CREATED_VIA | LOY_MSH_CREATED_VIA |
| STATUS | Status | LOY_MSH_STATUS | TEXT30 |
| STATUS_CH_DATE | Date | LOY_MEMS_DATE | DATS |
| STATUS_REASON | Status Reason | LOY_MSH_STATUS_REASON | CHAR132 |
| LAST_TXN_DATE | Date | LOY_MEMS_DATE | DATS |
| .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 |
| OS_GUID | Globally Unique Identifier | OS_GUID | SYSUUID |
| .INCLUDE | Structure for status in loyalty | ||
| ISTAT | Element for System Status | LOY_FRW_JISTAT | J_ISTAT |
| ESTAT | User Status | LOY_FRW_JESTAT | J_ESTAT |
| CAMPAIGN_CODE | Object GUID | LOY_FRW_GUID | SYSUUID |
| MEMBER_COUNTRY | Country Key | LAND1 | LAND1 |
| REG_BY_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| AGENT | Business Partner Number | BU_PARTNER | BU_PARTNER |
| ACCOUNT_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| DEF_MEMS_TYPE | Membership Types | LOY_MSH_MEMS_TYPE | |
| .INCLUDE | Include Structure for Membership | ||
| MEMBERSHIP_DUMMY | Dummy function in length 1 | DUMMY | DUMMY |
| .INCLUDE |
LOYD_MSH_MEMS related tables
| Table | Note |
|---|---|
| LOYD_MSH_MEMS | Loyalty Membership Table |
| LOYD_ACTMEM_BNFT | Loyalty Account Membership Agreement Benefits |
| LOYC_MSH_CHECKS | LOY : Customer Customizing table for Membership Checks |
| LOYC_MSH_CRVIA | LOY : Customer Customizing table for Membership Created Via |
| LOYC_MSH_CRVIA_T | Text Table for Membership Created Via |
| LOYC_MSH_MSTYPE | LOY : Customer Customizing table for Membership Type |
| LOYC_MSH_MSTYTXT | Text Table for Membership Types |
| LOYD_MSH_AGR | Membership Agreements Table |
| LOYD_MSH_INITTL | Table for Initial Tier Levels for Account/Org Membership |
| LOYD_MSH_MS_MEMB | Link Table for Membership and Member |
| CCMACTPROF | Loggable activity code group membership |
| CMSD_GRP_MEM_MST | Group Membership |
| CRMC_LPE_RO_PTMS | Membership Tier Group # Point Type RO |
| LOYD_LPE_SRULES | LPE: Membership - Scheduled Reward Rules |
| LOYD_MSH_BNFTS | Membership Benefits |
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