SAP ABAP Table LOYD_MSH_BNFTS (Membership Benefits)
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_MSH_BNFTS | Table Relationship Diagram |
Short Description | Membership Benefits |
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 | BENEFIT_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
5 | .INCLUDE | 0 | 0 | LOY FRW : Non-Key Framework Include | |||||
6 | REF_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
7 | APPLICATION | LOY_FRW_APPLICATION | LOY_FRW_APPLICATION | CHAR | 4 | 0 | Application | ||
8 | PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
9 | AVAILABLE | LOY_BNFT_AVAILABLE | LOY_BNFT_AVAILABLE | INT2 | 5 | 0 | Benefit Availability | ||
10 | USED | LOY_BNFT_AVAILABLE | LOY_BNFT_AVAILABLE | INT2 | 5 | 0 | Benefit Availability | ||
11 | .INCLUDE | 0 | 0 | LOY FRW : Administrative Include | |||||
12 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
13 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
14 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
15 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
16 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
17 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
18 | ORIGIN_REF | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
19 | ORIGIN | LOY_BNFT_ORIGIN | LOY_BNFT_ORIGIN | CHAR | 40 | 0 | Benefit Origin | ||
20 | UPDATED_AT | LOY_BNFT_UPDATED_AT | LOY_BNFT_UPDATED_AT | DATS | 8 | 0 | Benefit Last Updated At | ||
21 | VALID_FROM | LOY_BNFT_VALID_FROM | LOY_BNFT_VALID_FROM | DATS | 8 | 0 | Benefit Validity Start Date | ||
22 | VALID_TO | LOY_BNFT_VALID_TO | LOY_BNFT_VALID_TO | DATS | 8 | 0 | Benefit Validity End Date | ||
23 | .INCLUDE | 0 | 0 | Structure for status in loyalty | |||||
24 | ISTAT | LOY_FRW_JISTAT | J_ISTAT | CHAR | 5 | 0 | Element for System Status | * | |
25 | ESTAT | LOY_FRW_JESTAT | J_ESTAT | CHAR | 5 | 0 | 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 |
History
Last changed by/on | SAP | 20100420 |
SAP Release Created in | 701 |