SAP table EREWARD (Reward Item)
SAP table EREWARD has 2 primary key fields being MANDT,LP_RWRD.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| LP_RWRD | Reward Code | CHAR | 10 | 0 | LP_RWRD | ||
| LP_RWRDCAT | Reward Category | CHAR | 10 | 0 | ERWRDCAT | LP_RWRDCAT | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| LP_CODE | Loyalty program code | CHAR | 10 | 0 | ELOYALPRG | LP_CODE | |
| LP_VALIDFM | Valid from Date | DATS | 8 | 0 | LP_VALIDFM | ||
| LP_VALIDTO | Valid-To Date | DATS | 8 | 0 | LP_VALIDTO | ||
| LP_PT_REQ | Points Required | DEC | 10 | 0 | LP_PT_REQ | ||
| LP_RWD_UNIT | Unit of Measurement | UNIT | 3 | 0 | T006 | E_MASS | |
| LP_SPONSOR | Sponsor | CHAR | 10 | 0 | BUT000 | LP_SPONSOR | |
| LP_FORMKEY | Application Form for Loyalty Redemption Credit Memo | CHAR | 30 | 0 | EFRM | LP_FORMKEY |
EREWARD foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EREWARD | BUKRS | T001 | Company Codes | BUKRS |
| 1 EREWARD | LP_CODE | ELOYALPRG | Loyalty Program | LP_CODE |
| 0 EREWARD | LP_FORMKEY | EFRM | Print Workbench: Application Forms | FORMKEY |
| 1 EREWARD | LP_RWD_UNIT | T006 | Units of Measurement | MANDT |
| 0 EREWARD | LP_RWRDCAT | ERWRDCAT | Reward Category | MANDT |
| 0 EREWARD | LP_RWRDCAT | ERWRDCAT | Reward Category | LP_RWRDCAT |
| 1 EREWARD | LP_SPONSOR | BUT000 | BP: General data I | PARTNER |
| 0 EREWARD | MANDT | T000 | Clients | MANDT |