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 |