SAP ABAP Table CRMS_LOY_BNFT_HDR_RES_ATTR (Benefit Header Search Attribute Structure)
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_BNFT_HDR_RES_ATTR | Table Relationship Diagram |
Short Description | Benefit Header Search Attribute 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 | LOYL_PRG | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
5 | PRODUCT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
6 | .INCLUDE | 0 | 0 | LOY : Loyalty Object Strucure | |||||
7 | REF_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
8 | APPLICATION | CRM_LOY_COM_APPLICATION | CRM_LOY_COM_APPLICATION | CHAR | 4 | 0 | LOY : Application | ||
9 | PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
10 | OBJECT_ID | CRM_LOY_BNFT_ID | CRM_LOY_BNFT_ID | CHAR | 10 | 0 | Loyalty Benefit ID | ||
11 | DESCRIPTION | CRM_LOY_BNFT_DESCRIPTION | CRM_LOY_BNFT_DESCRIPTION | CHAR | 60 | 0 | Loyalty Benefit Description | ||
12 | DESCRIPTION_UC | CRM_LOY_BNFT_DESCRIPTION_UC | CRM_LOY_BNFT_DESCRIPTION_UC | CHAR | 60 | 0 | Loyalty Benefit Description Upper Case | ||
13 | START_DATE | CRM_LOY_BNFT_DATE | CRM_LOY_BNFT_DATE | DATS | 8 | 0 | Loyalty Benefit Date | ||
14 | END_DATE | CRM_LOY_BNFT_DATE | CRM_LOY_BNFT_DATE | DATS | 8 | 0 | Loyalty Benefit Date | ||
15 | SINCE_DATE | CRM_LOY_BNFT_DATE | CRM_LOY_BNFT_DATE | DATS | 8 | 0 | Loyalty Benefit Date | ||
16 | TYPE | CRM_LOY_BNFT_TYPE | CRM_LOY_BNFT_TYPE | CHAR | 20 | 0 | Loyalty Benefit Usage | ||
17 | HANDLING | CRM_LOY_BNFT_HANDLING | CRM_LOY_BNFT_HANDLING | CHAR | 20 | 0 | Loyalty Benefit Handling | ||
18 | LIMITS | CRM_LOY_BNFT_LIMIT | CRM_LOY_BNFT_LIMIT | CHAR | 32 | 0 | Loyalty Benefit Limits | ||
19 | TIMEFRAME | CRM_LOY_BNFT_TIMEFRAME | CRM_LOY_BNFT_TIMEFRAME | CHAR | 50 | 0 | Loyalty Benefit Timeframe | ||
20 | THRESHOLD | CRM_LOY_BNFT_THRESHOLD | CRM_LOY_BNFT_THRESHOLD | INT2 | 5 | 0 | Loyalty Benefit Threshold | ||
21 | USAGES | CRM_LOY_BNFT_USAGE | CRM_LOY_BNFT_USAGE | INT2 | 5 | 0 | Benefit Usage | ||
22 | .INCLUDE | 0 | 0 | LOY : Loyalty Admin Structure | |||||
23 | CREATED_ON | CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! | ||
24 | CREATED_BY | CRM_LOY_COM_CREATED_BY | UNAME | CHAR | 12 | 0 | LOY: Created By | ||
25 | CREATED_AT | CRM_LOY_COM_CREATED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
26 | CHANGED_ON | CRM_LOY_COM_CHANGED_ON | SYDATS | DATS | 8 | 0 | LOY : Changed On - OBSOLETE !!! | ||
27 | CHANGED_BY | CRM_LOY_COM_CHANGED_BY | UNAME | CHAR | 12 | 0 | LOY : Changed By | ||
28 | CHANGED_AT | CRM_LOY_COM_CHANGED_AT | CRM_LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
29 | CAMPAIGN_CODE | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
30 | .INCLUDE | 0 | 0 | CRM LOY : Structure for Status in Loyalty | |||||
31 | ISTAT | CRM_LOY_COM_JISTAT | J_ISTAT | CHAR | 5 | 0 | CRM LOY : Element for System Status | * | |
32 | ESTAT | CRM_LOY_COM_JESTAT | J_ESTAT | CHAR | 5 | 0 | CRM LOY : Element For User Status | * | |
33 | NOTES | CRM_LOY_BNFT_NOTES | CRM_LOY_BNFT_NOTES | CHAR | 250 | 0 | Loyalty Benefits Notes | ||
34 | .INCLUDE | 0 | 0 | Extensibility include for Loyalty Benefits object | |||||
35 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
36 | .INCLUDE | 0 | 0 | ||||||
37 | .INCLUDE | 0 | 0 | LOY : Loaylty Action Structure | |||||
38 | PROCESS_MODE | CRM_LOY_COM_MODE | CRM_LOY_COM_MODE | CHAR | 1 | 0 | LOY: Loyalty Mode | ||
39 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
40 | PRODUCT_DESC | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
41 | EXTERNAL_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
42 | LOYL_PRG_DESC | COMT_LOYLPRGTEXTX | TEXT40 | CHAR | 40 | 0 | Loyalty Program Description | ||
43 | CAMPAIGN_ID | CRM_LOY_CAMPAIGN_CODE_ID | CRM_LOY_CAMPAIGN_CODE_ID | CHAR | 24 | 0 | CRMLOY: Campaign ID | ||
44 | CAMPAIGN_DESC | CHAR40 | CHAR40 | CHAR | 40 | 0 | Character field of length 40 |
History
Last changed by/on | SAP | 20100420 |
SAP Release Created in | 701 |