The ETDZ table in SAP ERP or S/4HANA stores Technical Data for Installed Register data. There are total 44 fields in ETDZ table. The Technical Data for Installed Register table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ETDZ table. It is in IS-U: Installation, Removal and Replacement of Devices (EE07) ABAP package and is part of the Device installation (IS-U-DM-DI) module.
SAP ETDZ Table Fields
Following is the list of fields that are available in SAP ETDZ table. The primary key fields of the table are MANDT (Client), EQUNR (Equipment Number), ZWNUMMER (Register), BIS (Date at Which a Time Slice Expires).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR (18) |
| ZWNUMMER | Register | E_ZWNUMMER | NUMC (3) | |
| BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS (8) | |
| AB | Date from which time slice is valid | ABZEITSCH | DATS (8) | |
| LOGIKZW | Logical register number | LOGIKZW | NUMC (18) | |
| SPARTYP | Division category | SPARTYP | NUMC (2) | |
| ZWKENN | Register identification | E_ZWKENN | TE065 | CHAR (2) |
| KENNZIFF | Code for Identifying a Register | KENNZIFF | CHAR (15) | |
| ZWART | Register type | E_ZWART | TE523 | CHAR (2) |
| ZWFAKT | Register factor | E_ZWFAKT | DEC (12) | |
| STANZVOR | Places before the decimal point in a register | STANZVOR | NUMC (2) | |
| STANZNAC | Places after the decimal in a register | STANZNAC | NUMC (2) | |
| ZWTYP | Register category | E_ZWTYP | NUMC (2) | |
| BLIWIRK | Reactive, apparent, or active registers | BLIWIRK | NUMC (2) | |
| MASSREAD | Unit of measurement for meter reading | E_MASSREAD | * | UNIT (3) |
| ANZERG | Number of meter reading results per meter reading | ANZERG | DEC (2) | |
| KZMESSW | Nonmetering register | KZMESSW | CHAR (1) | |
| UEBERVER | Transformation ratio | UEBERVER | DEC (10) | |
| STEUERGRP | Control group for multiple meter reading order creation | STEUERGRP | * | CHAR (4) |
| NABLESEN | Do Not Read Register | E_NABLESEN | CHAR (1) | |
| PRUEFKL | Validation class for independent validations | PRUEFKL | * | CHAR (4) |
| TEMP_AREA | Temperature area | TEMP_AREA | TE307 | CHAR (8) |
| PR_AREA_AI | Air pressure area | PR_AREA_AI | TE309 | CHAR (8) |
| CALOR_AREA | Calorific value district | CALOR_AREA | TE453 | CHAR (8) |
| HOEKORR | Altitude correction pressure | HOEKORR | DEC (7) | |
| THGBER | Inclusion of factors in thermal gas billing | THGBER | CHAR (2) | |
| KZAHLE | Gas law deviation factor (set) | KZAHLE | DEC (7) | |
| KZAHLT | Actual gas law deviation factor | KZAHLT | DEC (7) | |
| GAS_PRS_AR | Gas Pressure Area | GAS_PRS_AR | TE343 | CHAR (8) |
| CRGPRESS | Gas correction pressure | CRGPRESS | DEC (7) | |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| MASSBILL | Unit of measurement for billing | E_MASSBILL | * | UNIT (3) |
| GEWKEY | Weighting key | GEWKEY | * | CHAR (8) |
| ZSPANNS | Register factor: secondary transformer voltage | E_ZSPANNS | DEC (4) | |
| ZSTROMS | Register factor: secondary transformer current | E_ZSTROMS | DEC (5) | |
| ZSPANNP | Register factor: primary transformer voltage | E_ZSPANNP | DEC (6) | |
| ZSTROMP | Register factor: primary transformer current | E_ZSTROMP | DEC (5) | |
| INTSIZEID | Interval Length ID | INTSIZEID | * | CHAR (4) |
| TOUPERIOD | Time-of-use type | E_TOUPERIOD | * | CHAR (10) |
| VEE_CODE | External VEE Code | E_AMI_VEE_CODE | * | NUMC (4) |
