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

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-BI (Application Component) Contract Billing
     ⤷ EE20 (Package) IS-U: Billing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EPREI	Table Relationship Diagram
Short Description	Mstr Pricing Table for All Prices

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PREIS	☑	E_PREIS	E_PREIS	CHAR	10	0	Price
3	PREISTYP	☑	PREISTYP	PREISTYP	CHAR	1	0	Price category
4	PREISTUF	☑	PREISTUF	PREISTUF	CHAR	10	0	Price level	TE471
5	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
6	MASS	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
7	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	EAKLASSE
8	TIMBASIS	☐	TIMBASIS	TIMBASIS	CHAR	3	0	Time Basis
9	TIMTYP	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
10	PREIGKL	☐	PREIGKL	PREIGKL	CHAR	10	0	Price adjustment clause	EPRESCL
11	MITTELPR	☐	MITTELPR	MITTELPR	CHAR	1	0	Calculation of an average price when price change occurs
12	DPREIKZ	☐	DPREIKZ	DPREIKZ	CHAR	1	0	Average Price
13	RUNDART	☐	RUNDART	RUNDART	CHAR	1	0	Rounding Category
14	RUNDUNG	☐	E_RUNDUNG	E_RUNDUNG	CHAR	2	0	Starting Point for Rounding
15	PREISART	☐	E_PREISART	E_PREISART	CHAR	1	0	Price type
16	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
17	.INCLUDE	☐				0	0	Creation and Change Data
18	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
19	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
21	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
22	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
23	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
24	INDEXP	☐	INDEXP	INDEXP	CHAR	1	0	Index-Based Price
25	NEXTINT	☐	NEXTINT	NEXTINT	CHAR	1	0	Valuate quantity portions already started using full price
26	FRAN_TYPE	☐	FRAN_TYPE	FRAN_TYPE	CHAR	1	0	Franchise Fee Category
27	EXTPRICE	☐	EXTPRICE	EXTPRICE	CHAR	1	0	External Price
28	PRCZONAJ	☐	PRCZONAJ	PRCZONAJ	CHAR	1	0	Type of Price Block Adjustment
29	PRCZOMIN	☐	PRCZOMIN	PRCZOMIN	NUMC	3	0	Lower limit of interval for price block adjustment in days
30	PRCZOMAX	☐	PRCZOMAX	PRCZOMAX	NUMC	3	0	Upper limit of interval for price block adjustment in days
31	KA_GRENZPREIS	☐	KA_GRENZPREIS	KENNZX	CHAR	1	0	Price Limit in Franchise Fee
32	GROSSPRICE	☐	GROSSPRICE	KENNZX	CHAR	1	0	Gross Price
33	PRICEORIGIN	☐	PRICEORIGIN	PRICEORIGIN	CHAR	3	0	Price Origin
34	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	*
35	RABART	☐	RABART	RABART	CHAR	1	0	Discount type
36	RABTYP	☐	RABTYP	RABTYP	CHAR	1	0	Discount category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EPREI	AKLASSE	EAKLASSE	AKLASSE	KEY
2	EPREI	MANDT	T000	MANDT		1	CN
3	EPREI	MASS	T006	MSEHI		1	CN
4	EPREI	PREIGKL	EPRESCL	PREIGKL	KEY
5	EPREI	PREISTUF	TE471	PREISTUF	KEY
6	EPREI	SPARTE	TSPA	SPART	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in