SAP Table EREWARD
Reward Item
EREWARD (Reward Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EREWARD to other SAP tables.
EREWARD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| LP_RWRD | Reward Code | LP_RWRD | CHAR | 10 | 0 | |||
| LP_RWRDCAT | Reward Category | LP_RWRDCAT | ERWRDCAT | CHAR | 10 | 0 | ||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| LP_CODE | Loyalty program code | LP_CODE | ELOYALPRG | CHAR | 10 | 0 | ||
| LP_VALIDFM | Valid from Date | LP_VALIDFM | DATS | 8 | 0 | |||
| LP_VALIDTO | Valid-To Date | LP_VALIDTO | DATS | 8 | 0 | |||
| LP_PT_REQ | Points Required | LP_PT_REQ | DEC | 10 | 0 | |||
| LP_RWD_UNIT | Unit of Measurement | E_MASS | T006 | UNIT | 3 | 0 | ||
| LP_SPONSOR | Sponsor | LP_SPONSOR | BUT000 | CHAR | 10 | 0 | ||
| LP_FORMKEY | Application Form for Loyalty Redemption Credit Memo | LP_FORMKEY | EFRM | CHAR | 30 | 0 | ||
EREWARD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EREWARD | BUKRS | EREWARD | BUKRS | T001 | Company Codes | BUKRS |
| EREWARD | BUKRS | EREWARD | MANDT | T001 | Company Codes | MANDT |
| EREWARD | LP_CODE | EREWARD | MANDT | ELOYALPRG | Loyalty Program | MANDT |
| EREWARD | LP_CODE | EREWARD | LP_CODE | ELOYALPRG | Loyalty Program | LP_CODE |
| EREWARD | LP_FORMKEY | EREWARD | MANDT | EFRM | Print Workbench: Application Forms | CLIENT |
| EREWARD | LP_FORMKEY | EREWARD | LP_FORMKEY | EFRM | Print Workbench: Application Forms | FORMKEY |
| EREWARD | LP_RWD_UNIT | EREWARD | MANDT | T006 | Units of Measurement | MANDT |
| EREWARD | LP_RWD_UNIT | EREWARD | LP_RWD_UNIT | T006 | Units of Measurement | MSEHI |
| EREWARD | LP_RWRDCAT | EREWARD | MANDT | ERWRDCAT | Reward Category | MANDT |
| EREWARD | LP_RWRDCAT | EREWARD | LP_RWRDCAT | ERWRDCAT | Reward Category | LP_RWRDCAT |
| EREWARD | LP_SPONSOR | EREWARD | MANDT | BUT000 | BP: General data I | CLIENT |
| EREWARD | LP_SPONSOR | EREWARD | LP_SPONSOR | BUT000 | BP: General data I | PARTNER |
| EREWARD | MANDT | EREWARD | MANDT | T000 | Clients | MANDT |
