SAP table EGRID (Grid in the Utilities Industry)

SAP table EGRID has 2 primary key fields being MANDT,GRID_ID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
GRID_ID Grid CHAR 10 0 GRID_ID
SUP_GRID_ID Higher Level Grid CHAR 10 0 EGRID SUP_GRID_ID
SPARTYP Division category NUMC 2 0 SPARTYP
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors
GRID_LEVEL_TYPE Grid Level Type CHAR 4 0 EGRIDLT GRID_LEVEL_TYPE
EXTERNALID External ID of Grid CHAR 40 0 E_GRIDEXTERNALID
EXT_CODELISTID External Code List ID CHAR 3 0 EEXTCODELISTID E_EDMIDEEXTCODELISTID

EGRID foreign key relationships

Table Field Check Table Check Field
0 EGRID EXT_CODELISTID EEXTCODELISTID ID of External Code List MANDT
1 EGRID GRID_LEVEL_TYPE EGRIDLT Grid Level Types MANDT
1 EGRID GRID_LEVEL_TYPE EGRIDLT Grid Level Types GRID_LEVEL_TYPE
0 EGRID MANDT T000 Clients MANDT
1 EGRID SUP_GRID_ID EGRID Grid in the Utilities Industry GRID_ID