EPREI SAP (Mstr Pricing Table for All Prices) Table details

Dictionary Type: Table
Description: Mstr Pricing Table for All Prices




ABAP Code to SELECT data from EPREI
Related tables to EPREI
Access table EPREI




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 cust
Display/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
MANDTClient MANDTCLNT3T000MANDT
PREISPrice E_PREISCHAR10ALPHAE_PREISPRXISU_F4_PREIS
PREISTYPPrice category PREISTYPCHAR1PREISTYPPRY
PREISTUFPrice level PREISTUFCHAR10TE471PREISTUFPRZ
SPARTEDivision SPARTECHAR2TSPASPARTSPA
MASSUnit of Measurement E_MASSUNIT3T006CUNITMEINS
AKLASSEBilling class AKLASSECHAR4EAKLASSEAKLASSEAKL
TIMBASISTime Basis TIMBASISCHAR3TIMBASIS
TIMTYPTime category (days or months) TIMTYPCHAR1TIMTYP
PREIGKLPrice adjustment clause PREIGKLCHAR10EPRESCLPREIGKLPAC
MITTELPRCalculation of an average price when price change occurs MITTELPRCHAR1MITTELPR
DPREIKZAverage Price DPREIKZCHAR1DPREIKZ
RUNDARTRounding Category RUNDARTCHAR1RUNDART
RUNDUNGStarting Point for Rounding E_RUNDUNGCHAR2E_RUNDUNG
PREISARTPrice type E_PREISARTCHAR1E_PREISART
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion Indicator LOEVMCHAR1XFELD
INDEXPIndex-Based Price INDEXPCHAR1INDEXP
NEXTINTValuate quantity portions already started using full price NEXTINTCHAR1NEXTINT
FRAN_TYPEFranchise Fee Category FRAN_TYPECHAR1FRAN_TYPE
EXTPRICEExternal Price EXTPRICECHAR1EXTPRICE
PRCZONAJType of Price Block Adjustment PRCZONAJCHAR1PRCZONAJ
PRCZOMINLower limit of interval for price block adjustment in days PRCZOMINNUMC3PRCZOMIN
PRCZOMAXUpper limit of interval for price block adjustment in days PRCZOMAXNUMC3PRCZOMAX
KA_GRENZPREISPrice Limit in Franchise Fee KA_GRENZPREISCHAR1KENNZX
GROSSPRICEGross Price GROSSPRICECHAR1KENNZX
PRICEORIGINPrice Origin PRICEORIGINCHAR3PRICEORIGIN
ANLAGEInstallation ANLAGECHAR10Assigned to domainALPHAANLAGEANLEANL
RABARTDiscount type RABARTCHAR1RABART
RABTYPDiscount category RABTYPCHAR1RABTYP

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!