SAP Table EGRID
Grid in the Utilities Industry
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.
EGRID table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||||||||
| 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 | ||||||||||||||||||
EGRID foreign key relationships
| 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 |
