SAP ETDZ Technical Data for Installed Register Table data and field list

ETDZ is a standard SAP Table which is used to store Technical Data for Installed Register data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ETDZ table consists of various fields, each holding specific information or linking keys about Technical Data for Installed Register data available in SAP. These include EQUNR (Equipment Number), ZWNUMMER (Register), BIS (Date at Which a Time Slice Expires), AB (Date from which time slice is valid)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ETDZ table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ETDZ table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ETDZ table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
ZWNUMMERRegister E_ZWNUMMERNUMC3LFDNR3EZN
BISDate at Which a Time Slice Expires BISZEITSCHDATS8DATUM
ABDate from which time slice is valid ABZEITSCHDATS8DATUM
LOGIKZWLogical register number LOGIKZWNUMC18LOGIKZW
SPARTYPDivision category SPARTYPNUMC2SPARTYPSPT
ZWKENNRegister identification E_ZWKENNCHAR2TE065E_ZWKENN
KENNZIFFCode for Identifying a Register KENNZIFFCHAR15CHAR15
ZWARTRegister type E_ZWARTCHAR2TE523E_ZWART
ZWFAKTRegister factor E_ZWFAKTDEC12(5) E_ZWFAKT
STANZVORPlaces before the decimal point in a register STANZVORNUMC2STANZVOR
STANZNACPlaces after the decimal in a register STANZNACNUMC2STANZNAC
ZWTYPRegister category E_ZWTYPNUMC2E_ZWTYP
BLIWIRKReactive, apparent, or active registers BLIWIRKNUMC2BLIWIRK
MASSREADUnit of measurement for meter reading E_MASSREADUNIT3Assigned to domainCUNITMEINS
ANZERGNumber of meter reading results per meter reading ANZERGDEC2ANZAHLENT
KZMESSWNonmetering register KZMESSWCHAR1KENNZX
UEBERVERTransformation ratio UEBERVERDEC10(3) UEBERV
STEUERGRPControl group for multiple meter reading order creation STEUERGRPCHAR4Assigned to domainSTEUERGRP
NABLESENDo Not Read Register E_NABLESENCHAR1KENNZX
PRUEFKLValidation class for independent validations PRUEFKLCHAR4Assigned to domainPRUEFKL
TEMP_AREATemperature area TEMP_AREACHAR8TE307TEMP_AREA
PR_AREA_AIAir pressure area PR_AREA_AICHAR8TE309PR_AREA_AI
CALOR_AREACalorific value district CALOR_AREACHAR8TE453CALOR_AREABWZ
HOEKORRAltitude correction pressure HOEKORRDEC7(5) HOEKORR
THGBERInclusion of factors in thermal gas billing THGBERCHAR2THGBER
KZAHLEGas law deviation factor (set) KZAHLEDEC7(5) KZAHL
KZAHLTActual gas law deviation factor KZAHLTDEC7(5) KZAHL
GAS_PRS_ARGas Pressure Area GAS_PRS_ARCHAR8TE343GAS_PRS_ARGDG
CRGPRESSGas correction pressure CRGPRESSDEC7(4) CRGPRESS
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
MASSBILLUnit of measurement for billing E_MASSBILLUNIT3Assigned to domainCUNITMEINS
GEWKEYWeighting key GEWKEYCHAR8Assigned to domainGEWKEY
ZSPANNSRegister factor: secondary transformer voltage E_ZSPANNSDEC4(1) SPANNUNG
ZSTROMSRegister factor: secondary transformer current E_ZSTROMSDEC5(2) E_ZSTROMS
ZSPANNPRegister factor: primary transformer voltage E_ZSPANNPDEC6WSPANNP
ZSTROMPRegister factor: primary transformer current E_ZSTROMPDEC5(1) E_ZSTROMP
INTSIZEIDInterval Length ID INTSIZEIDCHAR4Assigned to domainINTSIZEID
TOUPERIODTime-of-use type E_TOUPERIODCHAR10Assigned to domainE_TOUPERIOD
VEE_CODEExternal VEE Code E_AMI_VEE_CODENUMC4Assigned to domainE_AMI_VEE_CODE

Key field Non-key field



How do I retrieve data from SAP table ETDZ using ABAP code

The following ABAP code Example will allow you to do a basic selection on ETDZ to SELECT all data from the table
DATA: WA_ETDZ TYPE ETDZ.

SELECT SINGLE *
FROM ETDZ
INTO CORRESPONDING FIELDS OF WA_ETDZ
WHERE...

How to access SAP table ETDZ

Within an ECC or HANA version of SAP you can also view further information about ETDZ and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).