SAP ABAP Table EGRIDRATE_CRM (Rate Data and Prices for Grid)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
     ⤷ EECC_EDI (Package) IS-U: Deregulation

Basic Data

Table Category	INTTAB	Structure
Structure	EGRIDRATE_CRM	Table Relationship Diagram
Short Description	Rate Data and Prices for Grid

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	GRID_ID	☐	GRID_ID	GRID_ID	CHAR	10	0	Grid	*
2	GRID_LEVEL	☐	GRID_LEVEL	GRID_LEVEL	CHAR	10	0	Grid Level
3	PODGROUP	☐	E_DEREGPODGROUP	E_DEREGPODGROUP	NUMC	4	0	Point of Delivery Group ID	*
4	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
5	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
6	TARIFTYP	☐	TARIFTYP_DIST	TARIFTYP	CHAR	10	0	Rate Category of Grid Installation	*
7	TARIFART	☐	TARIFART_DIST	TARIFART	CHAR	8	0	Rate Type of Grid Installation	*
8	KONDIGR	☐	KONDIGR_DIST	KONDIGR	CHAR	10	0	Rate Fact Group for Grid Installation	*
9	OPERAND	☐	E_OPERAND	E_OPERAND	CHAR	10	0	Operand	*
10	OPTYP	☐	E_OPTYP	E_OPTYP	CHAR	8	0	Operand category	*
11	.INCLUDE	☐				0	0	Mstr Pricing Table for All Prices
12	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
13	PREIS	☐	E_PREIS	E_PREIS	CHAR	10	0	Price	*
14	PREISTYP	☐	PREISTYP	PREISTYP	CHAR	1	0	Price category
15	PREISTUF	☐	PREISTUF	PREISTUF	CHAR	10	0	Price level	TE471
16	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
17	MASS	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
18	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	EAKLASSE
19	TIMBASIS	☐	TIMBASIS	TIMBASIS	CHAR	3	0	Time Basis
20	TIMTYP	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
21	PREIGKL	☐	PREIGKL	PREIGKL	CHAR	10	0	Price adjustment clause	EPRESCL
22	MITTELPR	☐	MITTELPR	MITTELPR	CHAR	1	0	Calculation of an average price when price change occurs
23	DPREIKZ	☐	DPREIKZ	DPREIKZ	CHAR	1	0	Average Price
24	RUNDART	☐	RUNDART	RUNDART	CHAR	1	0	Rounding Category
25	RUNDUNG	☐	E_RUNDUNG	E_RUNDUNG	CHAR	2	0	Starting Point for Rounding
26	PREISART	☐	E_PREISART	E_PREISART	CHAR	1	0	Price type
27	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
28	.INCLUDE	☐				0	0	Creation and Change Data
29	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
30	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
31	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
32	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
33	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
34	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
35	INDEXP	☐	INDEXP	INDEXP	CHAR	1	0	Index-Based Price
36	NEXTINT	☐	NEXTINT	NEXTINT	CHAR	1	0	Valuate quantity portions already started using full price
37	FRAN_TYPE	☐	FRAN_TYPE	FRAN_TYPE	CHAR	1	0	Franchise Fee Category
38	EXTPRICE	☐	EXTPRICE	EXTPRICE	CHAR	1	0	External Price
39	PRCZONAJ	☐	PRCZONAJ	PRCZONAJ	CHAR	1	0	Type of Price Block Adjustment
40	PRCZOMIN	☐	PRCZOMIN	PRCZOMIN	NUMC	3	0	Lower limit of interval for price block adjustment in days
41	PRCZOMAX	☐	PRCZOMAX	PRCZOMAX	NUMC	3	0	Upper limit of interval for price block adjustment in days
42	KA_GRENZPREIS	☐	KA_GRENZPREIS	KENNZX	CHAR	1	0	Price Limit in Franchise Fee
43	GROSSPRICE	☐	GROSSPRICE	KENNZX	CHAR	1	0	Gross Price
44	PRICEORIGIN	☐	PRICEORIGIN	PRICEORIGIN	CHAR	3	0	Price Origin
45	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	*
46	RABART	☐	RABART	RABART	CHAR	1	0	Discount type
47	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	EGRIDRATE_CRM	AKLASSE	EAKLASSE	AKLASSE	KEY
2	EGRIDRATE_CRM	MANDT	T000	MANDT		1	CN
3	EGRIDRATE_CRM	MASS	T006	MSEHI		1	CN
4	EGRIDRATE_CRM	PREIGKL	EPRESCL	PREIGKL	KEY
5	EGRIDRATE_CRM	PREISTUF	TE471	PREISTUF	KEY
6	EGRIDRATE_CRM	SPARTE	TSPA	SPART	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in	471