SAP ABAP Table LOYD_BNFT_HDR (Loyalty Benefits Header Table)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY (Application Component) Loyalty
⤷ LOY_BNFT_DB (Package) Loyalty Management Benefits Database
⤷ CRM-LOY (Application Component) Loyalty
⤷ LOY_BNFT_DB (Package) Loyalty Management Benefits Database
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | LOYD_BNFT_HDR | Table Relationship Diagram |
Short Description | Loyalty Benefits Header Table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 FRW : Primary key Include | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
4 | LOYL_PRG | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
5 | PRODUCT_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
6 | .INCLUDE | 0 | 0 | LOY FRW : Non-Key Framework Include | |||||
7 | REF_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
8 | APPLICATION | LOY_FRW_APPLICATION | LOY_FRW_APPLICATION | CHAR | 4 | 0 | Application | ||
9 | PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
10 | OBJECT_ID | LOY_BNFT_ID | LOY_BNFT_ID | CHAR | 10 | 0 | Loyalty Benefit ID | ||
11 | DESCRIPTION | LOY_BNFT_DESCRIPTION | LOY_BNFT_DESCRIPTION | CHAR | 60 | 0 | Data Element for Benefit Description | ||
12 | DESCRIPTION_UC | LOY_BNFT_DESCRIPTION_UC | LOY_BNFT_DESCRIPTION_UC | CHAR | 60 | 0 | Data Element for Loyalty Benefit Description in Upper Case | ||
13 | START_DATE | LOY_BNFT_DATE | LOY_BNFT_DATE | DATS | 8 | 0 | Benefit Date | ||
14 | END_DATE | LOY_BNFT_DATE | LOY_BNFT_DATE | DATS | 8 | 0 | Benefit Date | ||
15 | SINCE_DATE | LOY_BNFT_DATE | LOY_BNFT_DATE | DATS | 8 | 0 | Benefit Date | ||
16 | TYPE | LOY_BNFT_TYPE | LOY_BNFT_TYPE | CHAR | 20 | 0 | Loyalty Benefit Type | ||
17 | HANDLING | LOY_BNFT_HANDLING | LOY_BNFT_HANDLING | CHAR | 20 | 0 | Loyalty Benefit Handling | ||
18 | LIMITS | LOY_BNFT_LIMIT | LOY_BNFT_LIMIT | CHAR | 32 | 0 | Loyalty Benefit Limit | ||
19 | TIMEFRAME | LOY_BNFT_TIMEFRAME | LOY_BNFT_TIMEFRAME | CHAR | 50 | 0 | Benefit Period | ||
20 | THRESHOLD | LOY_BNFT_THRESHOLD | LOY_BNFT_THRESHOLD | INT2 | 5 | 0 | Benefit Usage Threshold for Manual Assignment | ||
21 | USAGES | LOY_BNFT_USAGE | LOY_BNFT_USAGE | INT2 | 5 | 0 | Loyalty Benefit Usage | ||
22 | .INCLUDE | 0 | 0 | LOY FRW : Administrative Include | |||||
23 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
24 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
25 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
26 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
27 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
28 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
29 | CAMPAIGN_CODE | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
30 | .INCLUDE | 0 | 0 | Structure for status in loyalty | |||||
31 | ISTAT | LOY_FRW_JISTAT | J_ISTAT | CHAR | 5 | 0 | Element for System Status | * | |
32 | ESTAT | LOY_FRW_JESTAT | J_ESTAT | CHAR | 5 | 0 | User Status | * | |
33 | NOTES | LOY_BNFT_NOTES | 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 |
History
Last changed by/on | SAP | 20100420 |
SAP Release Created in | 701 |