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".

Fields for table EPREI

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
PREISPriceXE_PREISCHAR20
PREISTYPPrice categoryXPREISTYPCHAR2
PREISTUFPrice levelXPREISTUFCHAR20TE471
SPARTEDivisionSPARTECHAR4TSPA
MASSUnit of MeasurementE_MASSUNIT6T006
AKLASSEBilling ClassAKLASSECHAR8EAKLASSE
TIMBASISTime BasisTIMBASISCHAR6
TIMTYPTime category (days or months)TIMTYPCHAR2
PREIGKLPrice adjustment clausePREIGKLCHAR20EPRESCL
MITTELPRCalculation of an average price when price change occursMITTELPRCHAR2
DPREIKZAverage PriceDPREIKZCHAR2
RUNDARTRounding CategoryRUNDARTCHAR2
RUNDUNGStarting Point for RoundingE_RUNDUNGCHAR4
PREISARTPrice typeE_PREISARTCHAR2
.INCLUDEISU_ADMIN0
.INCLUDEISU_ADMINL0
ERDATDate on which the record was createdERDATDATS16
ERNAMName of Person Responsible for Creating the ObjectERNAMCHAR24
AEDATLast Changed OnAEDATDATS16
AENAMName of Person Who Changed ObjectAENAMCHAR24
BEGRUAuthorization GroupBEGRUCHAR8
LOEVMDeletion IndicatorLOEVMCHAR2
INDEXPIndex-Based PriceINDEXPCHAR2
NEXTINTValuate quantity portions already started using full priceNEXTINTCHAR2
FRAN_TYPEFranchise Fee CategoryFRAN_TYPECHAR2
EXTPRICEExternal PriceEXTPRICECHAR2
PRCZONAJType of Price Block AdjustmentPRCZONAJCHAR2
PRCZOMINLower limit of interval for price block adjustment in daysPRCZOMINNUMC6
PRCZOMAXUpper limit of interval for price block adjustment in daysPRCZOMAXNUMC6
KA_GRENZPREISPrice Limit in Franchise FeeKA_GRENZPREISCHAR2
GROSSPRICEGross PriceGROSSPRICECHAR2
PRICEORIGINPrice OriginPRICEORIGINCHAR6
ANLAGEInstallationANLAGECHAR20*
RABARTDiscount typeRABARTCHAR2
RABTYPDiscount categoryRABTYPCHAR2
Privacy Policy