SAP ABAP Table CRM_ISU_EPREI (Master Pricing Table for All Prices)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU (Application Component) Utilities Industry
     ⤷ CRM_IU_IL_BICO (Package) Utilities: Billing and Invoicing Documents (GenIL)

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_ISU_EPREI	Table Relationship Diagram
Short Description	Master Pricing Table for All Prices

Delivery and Maintenance

Pool/cluster
Delivery Class
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	*
2	PREIS	☐	CRM_ISU_E_PREIS	CRM_ISU_E_PREIS	CHAR	10	0	Price
3	PREISTYP	☐	CRM_ISU_PREISTYP	CRM_ISU_PREISTYP	CHAR	1	0	Price Category
4	PREISTUF	☐	CRM_ISU_PREISTUF	CRM_ISU_PREISTUF	CHAR	10	0	Price Level
5	SPARTE	☐	CRM_ISU_SPARTE	CRM_ISU_SPART	CHAR	2	0	Division
6	MASS	☐	CRM_ISU_E_MASS	MEINS	UNIT	3	0	Unit of Measurement	*
7	AKLASSE	☐	CRM_ISU_AKLASSE	CRM_ISU_AKLASSE	CHAR	4	0	Billing Class
8	TIMBASIS	☐	CRM_ISU_TIMBASIS	CRM_ISU_TIMBASIS	CHAR	3	0	Time Basis
9	TIMTYP	☐	CRM_ISU_TIMTYP	CRM_ISU_TIMTYP	CHAR	1	0	Time Category (Days or Months)
10	PREIGKL	☐	CRM_ISU_PREIGKL	CRM_ISU_PREIGKL	CHAR	10	0	Price Adjustment Clause
11	MITTELPR	☐	CRM_ISU_MITTELPR	CRM_ISU_MITTELPR	CHAR	1	0	Calculation of an Average Price When Price Change Occurs
12	DPREIKZ	☐	CRM_ISU_DPREIKZ	CRM_ISU_DPREIKZ	CHAR	1	0	Average Price
13	RUNDART	☐	CRM_ISU_RUNDART	CRM_ISU_RUNDART	CHAR	1	0	Rounding Category
14	RUNDUNG	☐	CRM_ISU_E_RUNDUNG	CRM_ISU_E_RUNDUNG	CHAR	2	0	Starting Point for Rounding
15	PREISART	☐	CRM_ISU_E_PREISART	CRM_ISU_E_PREISART	CHAR	1	0	Price Type
16	.INCLUDE	☐				0	0	Creation Data and Change Data (Author, Group, 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	☐	CRM_ISU_INDEXP	CRM_ISU_INDEXP	CHAR	1	0	Index-Based Price
25	NEXTINT	☐	CRM_ISU_NEXTINT	CRM_ISU_NEXTINT	CHAR	1	0	Valuate Quantity Portions Already Started Using Full Price
26	FRAN_TYPE	☐	CRM_ISU_FRAN_TYPE	CRM_ISU_FRAN_TYPE	CHAR	1	0	Franchise Fee Category
27	EXTPRICE	☐	CRM_ISU_EXTPRICE	CRM_ISU_EXTPRICE	CHAR	1	0	External Price
28	PRCZONAJ	☐	CRM_ISU_PRCZONAJ	CRM_ISU_PRCZONAJ	CHAR	1	0	Type of Price Block Adjustment
29	PRCZOMIN	☐	CRM_ISU_PRCZOMIN	CRM_ISU_PRCZOMIN	NUMC	3	0	Lower Limit of Interval for Price Block Adjustment in Days
30	PRCZOMAX	☐	CRM_ISU_PRCZOMAX	CRM_ISU_PRCZOMAX	NUMC	3	0	Upper Limit of Interval for Price Block Adjustment in Days
31	KA_GRENZPREIS	☐	CRM_ISU_KA_GRENZPREIS	CRM_ISU_KENNZX	CHAR	1	0	Price Limit in Franchise Fee
32	GROSSPRICE	☐	CRM_ISU_GROSSPRICE	CRM_ISU_KENNZX	CHAR	1	0	Gross Price
33	PRICEORIGIN	☐	CRM_ISU_PRICEORIGIN	CRM_ISU_PRICEORIGIN	CHAR	3	0	Price Origin
34	ANLAGE	☐	CRM_ISU_ANLAGE	CRM_ISU_ANLAGE	CHAR	10	0	Installation
35	RABART	☐	CRM_ISU_RABART	CRM_ISU_RABART	CHAR	1	0	Discount Type
36	RABTYP	☐	CRM_ISU_RABTYP	CRM_ISU_RABTYP	CHAR	1	0	Discount Category

History

Last changed by/on	SAP	20130604
SAP Release Created in	713