EPREI SAP (Mstr Pricing Table for All Prices) Table details
Dictionary Type: Table
Description: Mstr Pricing Table for All Prices
Description: Mstr Pricing Table for All Prices
Table field list including key, data, relationships and ABAP select examples
EPREI is a standard SAP Table which is used to store Mstr Pricing Table for All Prices data and is available within R/3 SAP systems depending on the version and release level.
The EPREI table consists of various fields, each holding specific information or linking keys about Mstr Pricing Table for All Prices data available in SAP. These include PREIS (Price), PREISTYP (Price category), PREISTUF (Price level), SPARTE (Division).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP EPREI table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PREIS | Price | E_PREIS | CHAR | 10 | ALPHA | E_PREIS | PRX | ISU_F4_PREIS | |
PREISTYP | Price category | PREISTYP | CHAR | 1 | PREISTYP | PRY | |||
PREISTUF | Price level | PREISTUF | CHAR | 10 | TE471 | PREISTUF | PRZ | ||
SPARTE | Division | SPARTE | CHAR | 2 | TSPA | SPART | SPA | ||
MASS | Unit of Measurement | E_MASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
AKLASSE | Billing class | AKLASSE | CHAR | 4 | EAKLASSE | AKLASSE | AKL | ||
TIMBASIS | Time Basis | TIMBASIS | CHAR | 3 | TIMBASIS | ||||
TIMTYP | Time category (days or months) | TIMTYP | CHAR | 1 | TIMTYP | ||||
PREIGKL | Price adjustment clause | PREIGKL | CHAR | 10 | EPRESCL | PREIGKL | PAC | ||
MITTELPR | Calculation of an average price when price change occurs | MITTELPR | CHAR | 1 | MITTELPR | ||||
DPREIKZ | Average Price | DPREIKZ | CHAR | 1 | DPREIKZ | ||||
RUNDART | Rounding Category | RUNDART | CHAR | 1 | RUNDART | ||||
RUNDUNG | Starting Point for Rounding | E_RUNDUNG | CHAR | 2 | E_RUNDUNG | ||||
PREISART | Price type | E_PREISART | CHAR | 1 | E_PREISART | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
INDEXP | Index-Based Price | INDEXP | CHAR | 1 | INDEXP | ||||
NEXTINT | Valuate quantity portions already started using full price | NEXTINT | CHAR | 1 | NEXTINT | ||||
FRAN_TYPE | Franchise Fee Category | FRAN_TYPE | CHAR | 1 | FRAN_TYPE | ||||
EXTPRICE | External Price | EXTPRICE | CHAR | 1 | EXTPRICE | ||||
PRCZONAJ | Type of Price Block Adjustment | PRCZONAJ | CHAR | 1 | PRCZONAJ | ||||
PRCZOMIN | Lower limit of interval for price block adjustment in days | PRCZOMIN | NUMC | 3 | PRCZOMIN | ||||
PRCZOMAX | Upper limit of interval for price block adjustment in days | PRCZOMAX | NUMC | 3 | PRCZOMAX | ||||
KA_GRENZPREIS | Price Limit in Franchise Fee | KA_GRENZPREIS | CHAR | 1 | KENNZX | ||||
GROSSPRICE | Gross Price | GROSSPRICE | CHAR | 1 | KENNZX | ||||
PRICEORIGIN | Price Origin | PRICEORIGIN | CHAR | 3 | PRICEORIGIN | ||||
ANLAGE | Installation | ANLAGE | CHAR | 10 | Assigned to domain | ALPHA | ANLAGE | ANL | EANL |
RABART | Discount type | RABART | CHAR | 1 | RABART | ||||
RABTYP | Discount category | RABTYP | CHAR | 1 | RABTYP |
Key field | Non-key field |
How do I retrieve data from SAP table EPREI using ABAP code
The following ABAP code Example will allow you to do a basic selection on EPREI to SELECT all data from the tableDATA: WA_EPREI TYPE EPREI.
SELECT SINGLE *
FROM EPREI
INTO CORRESPONDING FIELDS OF WA_EPREI
WHERE...
How to access SAP table EPREI
Within an ECC or HANA version of SAP you can also view further information about EPREI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects