SAP ABAP Table CRMS_LOY_MSH_BNFT (Attribute structure for Loyalty Membership Benefits)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY (Application Component) Loyalty
⤷ CRM_LOY_BNFT (Package) Loyalty Management - Member Benefits
⤷ CRM-LOY (Application Component) Loyalty
⤷ CRM_LOY_BNFT (Package) Loyalty Management - Member Benefits
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_LOY_MSH_BNFT | Table Relationship Diagram |
Short Description | Attribute structure for Loyalty Membership Benefits |
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 | BENEFIT_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
5 | .INCLUDE | 0 | 0 | LOY : Loyalty Object Strucure | |||||
6 | REF_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
7 | APPLICATION | CRM_LOY_COM_APPLICATION | CRM_LOY_COM_APPLICATION | CHAR | 4 | 0 | LOY : Application | ||
8 | PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
9 | AVAILABLE | CRM_LOY_BNFT_AVAILABLE | CRM_LOY_BNFT_AVAILABLE | INT2 | 5 | 0 | Loyalty Benefit Available | ||
10 | USED | CRM_LOY_BNFT_AVAILABLE | CRM_LOY_BNFT_AVAILABLE | INT2 | 5 | 0 | Loyalty Benefit Available | ||
11 | .INCLUDE | 0 | 0 | LOY : Loyalty Admin Structure | |||||
12 | CREATED_ON | CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! | ||
13 | CREATED_BY | CRM_LOY_COM_CREATED_BY | UNAME | CHAR | 12 | 0 | LOY: Created By | ||
14 | CREATED_AT | CRM_LOY_COM_CREATED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
15 | CHANGED_ON | CRM_LOY_COM_CHANGED_ON | SYDATS | DATS | 8 | 0 | LOY : Changed On - OBSOLETE !!! | ||
16 | CHANGED_BY | CRM_LOY_COM_CHANGED_BY | UNAME | CHAR | 12 | 0 | LOY : Changed By | ||
17 | CHANGED_AT | CRM_LOY_COM_CHANGED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
18 | ORIGIN_REF | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
19 | ORIGIN | CRM_LOY_BNFT_ORIGIN | CRM_LOY_BNFT_ORIGIN | CHAR | 40 | 0 | Loyalty Benefit Origin (Source) | ||
20 | UPDATED_AT | CRM_LOY_BNFT_UPDATED_AT | CRM_LOY_BNFT_UPDATED_AT | DATS | 8 | 0 | Benefit last Updated At | ||
21 | VALID_FROM | CRM_LOY_BNFT_DATE | CRM_LOY_BNFT_DATE | DATS | 8 | 0 | Loyalty Benefit Date | ||
22 | VALID_TO | CRM_LOY_BNFT_DATE | CRM_LOY_BNFT_DATE | DATS | 8 | 0 | Loyalty Benefit Date | ||
23 | .INCLUDE | 0 | 0 | CRM LOY : Structure for Status in Loyalty | |||||
24 | ISTAT | CRM_LOY_COM_JISTAT | J_ISTAT | CHAR | 5 | 0 | CRM LOY : Element for System Status | * | |
25 | ESTAT | CRM_LOY_COM_JESTAT | J_ESTAT | CHAR | 5 | 0 | CRM LOY : Element For User Status | * | |
26 | .INCLUDE | 0 | 0 | Extensibility include for Loyalty Membership Benefits object | |||||
27 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
28 | .INCLUDE | 0 | 0 | ||||||
29 | .INCLUDE | 0 | 0 | LOY : Loaylty Action Structure | |||||
30 | PROCESS_MODE | CRM_LOY_COM_MODE | CRM_LOY_COM_MODE | CHAR | 1 | 0 | LOY: Loyalty Mode | ||
31 | TYPE | CRM_LOY_BNFT_TYPE | CRM_LOY_BNFT_TYPE | CHAR | 20 | 0 | Loyalty Benefit Usage | ||
32 | LIMITS | CRM_LOY_BNFT_LIMIT | CRM_LOY_BNFT_LIMIT | CHAR | 32 | 0 | Loyalty Benefit Limits | ||
33 | OBJECT_ID | CRM_LOY_BNFT_ID | CRM_LOY_BNFT_ID | CHAR | 10 | 0 | Loyalty Benefit ID | ||
34 | ORIGIN_ID | CRM_LOY_BNFT_ID | CRM_LOY_BNFT_ID | CHAR | 10 | 0 | Loyalty Benefit ID | ||
35 | DESCRIPTION | CRM_LOY_BNFT_DESCRIPTION | CRM_LOY_BNFT_DESCRIPTION | CHAR | 60 | 0 | Loyalty Benefit Description | ||
36 | REMAINING | CRM_LOY_BNFT_AVAILABLE | CRM_LOY_BNFT_AVAILABLE | INT2 | 5 | 0 | Loyalty Benefit Available | ||
37 | SKIPBNFTVALIDATION | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
38 | HANDLING | CRM_LOY_BNFT_HANDLING | CRM_LOY_BNFT_HANDLING | CHAR | 20 | 0 | Loyalty Benefit Handling |
History
Last changed by/on | SAP | 20100420 |
SAP Release Created in | 701 |