EPREI - Mstr Pricing Table for All Prices
Mstr Pricing Table for All Prices information is stored in SAP table EPREI.
It is part of development package EE20 in software component IS-U-BI. This development package consists of objects that can be grouped under "IS-U: Billing".
It is part of development package EE20 in software component IS-U-BI. This development package consists of objects that can be grouped under "IS-U: Billing".
Fields for table EPREI
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
PREIS | Price | X | E_PREIS | CHAR | 20 | |
PREISTYP | Price category | X | PREISTYP | CHAR | 2 | |
PREISTUF | Price level | X | PREISTUF | CHAR | 20 | TE471 |
SPARTE | Division | SPARTE | CHAR | 4 | TSPA | |
MASS | Unit of Measurement | E_MASS | UNIT | 6 | T006 | |
AKLASSE | Billing Class | AKLASSE | CHAR | 8 | EAKLASSE | |
TIMBASIS | Time Basis | TIMBASIS | CHAR | 6 | ||
TIMTYP | Time category (days or months) | TIMTYP | CHAR | 2 | ||
PREIGKL | Price adjustment clause | PREIGKL | CHAR | 20 | EPRESCL | |
MITTELPR | Calculation of an average price when price change occurs | MITTELPR | CHAR | 2 | ||
DPREIKZ | Average Price | DPREIKZ | CHAR | 2 | ||
RUNDART | Rounding Category | RUNDART | CHAR | 2 | ||
RUNDUNG | Starting Point for Rounding | E_RUNDUNG | CHAR | 4 | ||
PREISART | Price type | E_PREISART | CHAR | 2 | ||
.INCLUDE | ISU_ADMIN | 0 | ||||
.INCLUDE | ISU_ADMINL | 0 | ||||
ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
BEGRU | Authorization Group | BEGRU | CHAR | 8 | ||
LOEVM | Deletion Indicator | LOEVM | CHAR | 2 | ||
INDEXP | Index-Based Price | INDEXP | CHAR | 2 | ||
NEXTINT | Valuate quantity portions already started using full price | NEXTINT | CHAR | 2 | ||
FRAN_TYPE | Franchise Fee Category | FRAN_TYPE | CHAR | 2 | ||
EXTPRICE | External Price | EXTPRICE | CHAR | 2 | ||
PRCZONAJ | Type of Price Block Adjustment | PRCZONAJ | CHAR | 2 | ||
PRCZOMIN | Lower limit of interval for price block adjustment in days | PRCZOMIN | NUMC | 6 | ||
PRCZOMAX | Upper limit of interval for price block adjustment in days | PRCZOMAX | NUMC | 6 | ||
KA_GRENZPREIS | Price Limit in Franchise Fee | KA_GRENZPREIS | CHAR | 2 | ||
GROSSPRICE | Gross Price | GROSSPRICE | CHAR | 2 | ||
PRICEORIGIN | Price Origin | PRICEORIGIN | CHAR | 6 | ||
ANLAGE | Installation | ANLAGE | CHAR | 20 | * | |
RABART | Discount type | RABART | CHAR | 2 | ||
RABTYP | Discount category | RABTYP | CHAR | 2 |