EGRID (Grid in the Utilities Industry) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EGRID to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||
|
GRID_ID
Grid
|
GRID_ID |
CHAR
|
10 | 0 | ||||||||||||||||||||
|
SUP_GRID_ID
Higher Level Grid
|
SUP_GRID_ID | EGRID |
CHAR
|
10 | 0 | |||||||||||||||||||
|
SPARTYP
Division category
|
SPARTYP |
NUMC
|
2 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
GRID_LEVEL_TYPE
Grid Level Type
|
GRID_LEVEL_TYPE | EGRIDLT |
CHAR
|
4 | 0 | |||||||||||||||||||
|
EXTERNALID
External ID of Grid
|
E_GRIDEXTERNALID |
CHAR
|
40 | 0 | ||||||||||||||||||||
|
EXT_CODELISTID
External Code List ID
|
E_EDMIDEEXTCODELISTID | EEXTCODELISTID |
CHAR
|
3 | 0 | |||||||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EGRID | EXT_CODELISTID | EGRID | MANDT |
EEXTCODELISTID
ID of External Code List
|
MANDT |
| EGRID | EXT_CODELISTID | EGRID | EXT_CODELISTID |
EEXTCODELISTID
ID of External Code List
|
EXT_CODELISTID |
| EGRID | GRID_LEVEL_TYPE | EGRID | MANDT |
EGRIDLT
Grid Level Types
|
MANDT |
| EGRID | GRID_LEVEL_TYPE | EGRID | GRID_LEVEL_TYPE |
EGRIDLT
Grid Level Types
|
GRID_LEVEL_TYPE |
| EGRID | MANDT | EGRID | MANDT |
T000
Clients
|
MANDT |
| EGRID | SUP_GRID_ID | EGRID | MANDT |
EGRID
Grid in the Utilities Industry
|
MANDT |
| EGRID | SUP_GRID_ID | EGRID | SUP_GRID_ID |
EGRID
Grid in the Utilities Industry
|
GRID_ID |