SAP ABAP Table LOYD_MSH_AGR (Membership Agreements Table)
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 | TRANSP | Transparent table |
Transparent table | LOYD_MSH_AGR | Table Relationship Diagram |
Short Description | Membership Agreements Table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | 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 | ||
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 | LOY FRW : Administrative Include | |||||
9 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
10 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
11 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
12 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
13 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
14 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
15 | .INCLUDE | 0 | 0 | Structure for status in loyalty | |||||
16 | ISTAT | LOY_FRW_JISTAT | J_ISTAT | CHAR | 5 | 0 | Element for System Status | * | |
17 | ESTAT | LOY_FRW_JESTAT | J_ESTAT | CHAR | 5 | 0 | User Status | * | |
18 | OBJECT_ID | LOY_AGR_ID | LOY_AGR_ID | CHAR | 10 | 0 | Loyalty Management: Agreements ID | ||
19 | MEMBERSHIP_ID | LOY_MEMS_ID | LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
20 | ACCOUNT_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
21 | EMPL_RESP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
22 | PA_SET_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
23 | LOY_PROG_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
24 | START_DATE | LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
25 | END_DATE | LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
26 | AGR_USAGE | LOY_MSH_PURPOSE_OF_USE | LOY_MSH_PURPOSE_OF_USE | CHAR | 50 | 0 | Purpose of Use | ||
27 | STATUS | LOY_MSH_STATUS | TEXT30 | CHAR | 30 | 0 | Status | ||
28 | ORIGIN | LOY_MSH_CREATED_VIA | LOY_MSH_CREATED_VIA | CHAR | 20 | 0 | Origin | ||
29 | STATUS_REASON | LOY_MSH_STATUS_REASON | CHAR132 | CHAR | 132 | 0 | Status Reason | ||
30 | .INCLUDE | 0 | 0 | Include Structure for Membership | |||||
31 | AGREEMENTS_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
32 | .INCLUDE | 0 | 0 |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 701 |