1. Home
  2. Resources
  3. SAP Tables
  4. ETDZ - Technical Data for Installed Register

SAP Table ETDZ

Technical Data for Installed Register

ETDZ (Technical Data for Installed Register) 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 ETDZ to other SAP tables.

ETDZ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
ZWNUMMER Register E_ZWNUMMER NUMC 3 0
BIS Date at Which a Time Slice Expires BISZEITSCH DATS 8 0
AB Date from which time slice is valid ABZEITSCH DATS 8 0
LOGIKZW Logical register number LOGIKZW NUMC 18 0
SPARTYP Division category SPARTYP NUMC 2 0
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors
ZWKENN Register identification E_ZWKENN TE065 CHAR 2 0
KENNZIFF Code for Identifying a Register KENNZIFF CHAR 15 0
ZWART Register type E_ZWART TE523 CHAR 2 0
ZWFAKT Register factor E_ZWFAKT DEC 12 5
STANZVOR Places before the decimal point in a register STANZVOR NUMC 2 0
STANZNAC Places after the decimal in a register STANZNAC NUMC 2 0
ZWTYP Register category E_ZWTYP NUMC 2 0
01 Cumulating demand meter
02 Balancing demand meter
03 Resetting register
04 Balancing consumption register
05 Cumulating consumption register
06 Other register
BLIWIRK Reactive, apparent, or active registers BLIWIRK NUMC 2 0
01 Reactive register
02 Active register
03 Apparent current register
MASSREAD Unit of measurement for meter reading E_MASSREAD UNIT 3 0
ANZERG Number of meter reading results per meter reading ANZERG DEC 2 0
KZMESSW Nonmetering register KZMESSW CHAR 1 0
NULL Field inactive
X Field active
UEBERVER Transformation ratio UEBERVER DEC 10 3
STEUERGRP Control group for multiple meter reading order creation STEUERGRP CHAR 4 0
NABLESEN Do Not Read Register E_NABLESEN CHAR 1 0
NULL Field inactive
X Field active
PRUEFKL Validation class for independent validations PRUEFKL CHAR 4 0
TEMP_AREA Temperature area TEMP_AREA TE307 CHAR 8 0
PR_AREA_AI Air pressure area PR_AREA_AI TE309 CHAR 8 0
CALOR_AREA Calorific value district CALOR_AREA TE453 CHAR 8 0
HOEKORR Altitude correction pressure HOEKORR DEC 7 5
THGBER Inclusion of factors in thermal gas billing THGBER CHAR 2 0
00 Register includes no thermal gas factors
01 Register includes temperature
02 Register includes temperature and pressure
03 Register includes temperature, pressure and compressibility
KZAHLE Gas law deviation factor (set) KZAHLE DEC 7 5
KZAHLT Actual gas law deviation factor KZAHLT DEC 7 5
GAS_PRS_AR Gas Pressure Area GAS_PRS_AR TE343 CHAR 8 0
CRGPRESS Gas correction pressure CRGPRESS DEC 7 4
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
MASSBILL Unit of measurement for billing E_MASSBILL UNIT 3 0
GEWKEY Weighting key GEWKEY CHAR 8 0
ZSPANNS Register factor: secondary transformer voltage E_ZSPANNS DEC 4 1
ZSTROMS Register factor: secondary transformer current E_ZSTROMS DEC 5 2
ZSPANNP Register factor: primary transformer voltage E_ZSPANNP DEC 6 0
ZSTROMP Register factor: primary transformer current E_ZSTROMP DEC 5 1
INTSIZEID Interval Length ID INTSIZEID CHAR 4 0
TOUPERIOD Time-of-use type E_TOUPERIOD CHAR 10 0
VEE_CODE External VEE Code E_AMI_VEE_CODE NUMC 4 0

ETDZ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ETDZ CALOR_AREA * TE453 Calorific Value Districts MANDT
ETDZ CALOR_AREA ETDZ CALOR_AREA TE453 Calorific Value Districts CALOR_AREA
ETDZ EQUNR ETDZ MANDT EQUI Equipment master data MANDT
ETDZ EQUNR ETDZ EQUNR EQUI Equipment master data EQUNR
ETDZ GAS_PRS_AR * TE343 Gas Press. Areas MANDT
ETDZ GAS_PRS_AR ETDZ GAS_PRS_AR TE343 Gas Press. Areas GAS_PRS_AR
ETDZ MANDT ETDZ MANDT T000 Clients MANDT
ETDZ PR_AREA_AI * TE309 Air Press. Area MANDT
ETDZ PR_AREA_AI ETDZ PR_AREA_AI TE309 Air Press. Area PR_AREA_AI
ETDZ TEMP_AREA ETDZ TEMP_AREA TE307 Temperature Areas TEMP_AREA
ETDZ TEMP_AREA * TE307 Temperature Areas MANDT
ETDZ ZWART ETDZ MANDT TE523 Register Types MANDT
ETDZ ZWART ETDZ ZWART TE523 Register Types ZWART
ETDZ ZWKENN ETDZ MANDT TE065 Register Identif. MANDT
ETDZ ZWKENN ETDZ SPARTYP TE065 Register Identif. SPARTYP
ETDZ ZWKENN ETDZ ZWKENN TE065 Register Identif. ZWKENN