SAP ABAP Table CRMS_LOY_MSH_AGREEMENTS (Membership Agreements Structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY (Application Component) Loyalty
⤷ CRM_LOY_MSH_GENIL (Package) Loyalty Management Membership GENIL
⤷ CRM-LOY (Application Component) Loyalty
⤷ CRM_LOY_MSH_GENIL (Package) Loyalty Management Membership GENIL
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_LOY_MSH_AGREEMENTS | Table Relationship Diagram |
Short Description | Membership Agreements Structure |
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 | .INCLUDE | 0 | 0 | LOY : Loyalty Key Structure | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
4 | .INCLUDE | 0 | 0 | LOY : Loyalty Object Strucure | |||||
5 | REF_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
6 | APPLICATION | CRM_LOY_COM_APPLICATION | CRM_LOY_COM_APPLICATION | CHAR | 4 | 0 | LOY : Application | ||
7 | PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
8 | .INCLUDE | 0 | 0 | LOY : Loyalty Admin Structure | |||||
9 | CREATED_ON | CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! | ||
10 | CREATED_BY | CRM_LOY_COM_CREATED_BY | UNAME | CHAR | 12 | 0 | LOY: Created By | ||
11 | CREATED_AT | CRM_LOY_COM_CREATED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
12 | CHANGED_ON | CRM_LOY_COM_CHANGED_ON | SYDATS | DATS | 8 | 0 | LOY : Changed On - OBSOLETE !!! | ||
13 | CHANGED_BY | CRM_LOY_COM_CHANGED_BY | UNAME | CHAR | 12 | 0 | LOY : Changed By | ||
14 | CHANGED_AT | CRM_LOY_COM_CHANGED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
15 | .INCLUDE | 0 | 0 | CRM LOY : Structure for Status in Loyalty | |||||
16 | ISTAT | CRM_LOY_COM_JISTAT | J_ISTAT | CHAR | 5 | 0 | CRM LOY : Element for System Status | * | |
17 | ESTAT | CRM_LOY_COM_JESTAT | J_ESTAT | CHAR | 5 | 0 | CRM LOY : Element For User Status | * | |
18 | OBJECT_ID | CRM_LOY_AGR_ID | CRM_LOY_AGR_ID | CHAR | 10 | 0 | Loyalty Management: Domain for Membership | ||
19 | MEMBERSHIP_ID | CRM_LOY_MEMS_ID | CRM_LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
20 | ACCOUNT_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
21 | EMPL_RESP_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
22 | PA_SET_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
23 | LOY_PROG_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
24 | START_DATE | CRM_LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
25 | END_DATE | CRM_LOY_MEMS_DATE | DATS | DATS | 8 | 0 | Date | ||
26 | AGR_USAGE | CRM_LOY_MSH_PURPOSE_OF_USE | CRM_LOY_MSH_PURPOSE_OF_USE | CHAR | 50 | 0 | Purpose Of Usage | ||
27 | STATUS | CRM_LOY_MSH_STATUS | TEXT30 | CHAR | 30 | 0 | Membership Status | ||
28 | ORIGIN | CRM_LOY_MSH_CREATED_VIA | CRM_LOY_MSH_CREATED_VIA | CHAR | 20 | 0 | Origin | ||
29 | STATUS_REASON | CRM_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 | ||||||
33 | ACCOUNT_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
34 | PT_ACCT_SET_ID | CRM_LOY_PT_ACCT_SET_ID | CRM_LOY_PTACCTSET_ID | CHAR | 15 | 0 | Loyalty Management Point Account Set ID | ||
35 | LOY_PROG_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
36 | .INCLUDE | 0 | 0 | LOY : Loaylty Action Structure | |||||
37 | PROCESS_MODE | CRM_LOY_COM_MODE | CRM_LOY_COM_MODE | CHAR | 1 | 0 | LOY: Loyalty Mode | ||
38 | ACCOUNT_NAME | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
39 | EMPL_RESP_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
40 | EMPL_RESP_DESC | BU_NAME1TX | TEXT80 | CHAR | 80 | 0 | Full Name |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 701 |