SAP ABAP Table VLOYD_MSH_MEMS (Change Document Structure; Generated by RSSCD000)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY-MSH (Application Component) Membership
⤷ LOY_MSH_DB (Package) Loyalty Management Membership Database
⤷ CRM-LOY-MSH (Application Component) Membership
⤷ LOY_MSH_DB (Package) Loyalty Management Membership Database
Basic Data
Table Category | INTTAB | Structure |
Structure | VLOYD_MSH_MEMS | Table Relationship Diagram |
Short Description | Change Document Structure; Generated by RSSCD000 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Loyalty Membership Table | |||||
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 | ||
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 | MEMB_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
10 | PA_SET_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
11 | OBJECT_ID | LOY_MEMS_ID | LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
12 | MEMS_TYPE | LOY_MSH_MEMS_TYPE | CHAR | 20 | 0 | Membership Types | |||
13 | LOY_PROG_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
14 | EMPL_RESP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
15 | NOMINATOR_ID | LOY_MEMS_ID | LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
16 | START_DATE | LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
17 | END_DATE | LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
18 | PURPOSE_OF_USE | LOY_MSH_PURPOSE_OF_USE | LOY_MSH_PURPOSE_OF_USE | CHAR | 50 | 0 | Purpose of Use | ||
19 | CREATED_VIA | LOY_MSH_CREATED_VIA | LOY_MSH_CREATED_VIA | CHAR | 20 | 0 | Origin | ||
20 | STATUS | LOY_MSH_STATUS | TEXT30 | CHAR | 30 | 0 | Status | ||
21 | STATUS_CH_DATE | LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
22 | STATUS_REASON | LOY_MSH_STATUS_REASON | CHAR132 | CHAR | 132 | 0 | Status Reason | ||
23 | LAST_TXN_DATE | LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
24 | .INCLUDE | 0 | 0 | LOY FRW : Administrative Include | |||||
25 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
26 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
27 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
28 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
29 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
30 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
31 | OS_GUID | OS_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique Identifier | ||
32 | .INCLUDE | 0 | 0 | Structure for status in loyalty | |||||
33 | ISTAT | LOY_FRW_JISTAT | J_ISTAT | CHAR | 5 | 0 | Element for System Status | * | |
34 | ESTAT | LOY_FRW_JESTAT | J_ESTAT | CHAR | 5 | 0 | User Status | * | |
35 | CAMPAIGN_CODE | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
36 | MEMBER_COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
37 | REG_BY_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
38 | AGENT | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
39 | ACCOUNT_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
40 | DEF_MEMS_TYPE | LOY_MSH_MEMS_TYPE | CHAR | 20 | 0 | Membership Types | |||
41 | .INCLUDE | 0 | 0 | Include Structure for Membership | |||||
42 | MEMBERSHIP_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
43 | .INCLUDE | 0 | 0 | ||||||
44 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
45 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |