ETDZ

Transparent Table Application Table
44 Fields 2 CDS Views

Technical Data for Installed Register

ETDZ is an SAP database table in S/4HANA. Technical Data for Installed Register. It contains 44 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CRMS4_IU_P_DEVREG view inner Registers assigned to Point of Delivery
I_UtilitiesRegister view from BASIC Register

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY equnr EQUNR Equipment
KEY zwnummer E_ZWNUMMER Register
KEY bis BISZEITSCH Valid to
ab ABZEITSCH Valid From
logikzw LOGIKZW Logical reg.no.
spartyp SPARTYP Division cat.
zwkenn E_ZWKENN Register ID
kennziff KENNZIFF Register Code
zwart E_ZWART Register type
zwfakt E_ZWFAKT Register factor
stanzvor STANZVOR Predec. places
stanznac STANZNAC Decimal places
zwtyp E_ZWTYP Register categ.
bliwirk BLIWIRK React./act.reg.
massread E_MASSREAD MeasUnit for MR
anzerg ANZERG No. MR results
kzmessw KZMESSW Nonmetering
ueberver UEBERVER Transform.ratio
steuergrp STEUERGRP Control Group
nablesen E_NABLESEN No MR
pruefkl PRUEFKL Validat. class
temp_area TEMP_AREA Temp. area
pr_area_ai PR_AREA_AI Air press. area
calor_area CALOR_AREA Cal. val. dist.
hoekorr HOEKORR Alt. corr. pr.
thgber THGBER Therm.gas bill.
kzahle KZAHLE GLDF (set)
kzahlt KZAHLT Act. gas law DF
gas_prs_ar GAS_PRS_AR Gas press. area
crgpress CRGPRESS GasCorrPressure
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
massbill E_MASSBILL Billing MUnit
gewkey GEWKEY Weighting key
zspanns E_ZSPANNS Sec. voltage
zstroms E_ZSTROMS Secondary curr.
zspannp E_ZSPANNP Primary voltage
zstromp E_ZSTROMP Primary current
intsizeid INTSIZEID Interval Length
touperiod E_TOUPERIOD TOU type
vee_code E_AMI_VEE_CODE VEE Code

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Technical Data for Installed Register
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ETDZ (
    MANDT,       -- Client [MANDT]
    EQUNR,       -- Equipment [EQUNR]
    ZWNUMMER,    -- Register [E_ZWNUMMER]
    BIS,         -- Valid to [BISZEITSCH]
    AB,          -- Valid From [ABZEITSCH]
    LOGIKZW,     -- Logical reg.no. [LOGIKZW]
    SPARTYP,     -- Division cat. [SPARTYP]
    ZWKENN,      -- Register ID [E_ZWKENN]
    KENNZIFF,    -- Register Code [KENNZIFF]
    ZWART,       -- Register type [E_ZWART]
    ZWFAKT,      -- Register factor [E_ZWFAKT]
    STANZVOR,    -- Predec. places [STANZVOR]
    STANZNAC,    -- Decimal places [STANZNAC]
    ZWTYP,       -- Register categ. [E_ZWTYP]
    BLIWIRK,     -- React./act.reg. [BLIWIRK]
    MASSREAD,    -- MeasUnit for MR [E_MASSREAD]
    ANZERG,      -- No. MR results [ANZERG]
    KZMESSW,     -- Nonmetering [KZMESSW]
    UEBERVER,    -- Transform.ratio [UEBERVER]
    STEUERGRP,   -- Control Group [STEUERGRP]
    NABLESEN,    -- No MR [E_NABLESEN]
    PRUEFKL,     -- Validat. class [PRUEFKL]
    TEMP_AREA,   -- Temp. area [TEMP_AREA]
    PR_AREA_AI,  -- Air press. area [PR_AREA_AI]
    CALOR_AREA,  -- Cal. val. dist. [CALOR_AREA]
    HOEKORR,     -- Alt. corr. pr. [HOEKORR]
    THGBER,      -- Therm.gas bill. [THGBER]
    KZAHLE,      -- GLDF (set) [KZAHLE]
    KZAHLT,      -- Act. gas law DF [KZAHLT]
    GAS_PRS_AR,  -- Gas press. area [GAS_PRS_AR]
    CRGPRESS,    -- GasCorrPressure [CRGPRESS]
    ERDAT,       -- Created On [ERDAT]
    ERNAM,       -- Created By [ERNAM]
    AEDAT,       -- Changed On [AEDAT]
    AENAM,       -- Changed By [AENAM]
    MASSBILL,    -- Billing MUnit [E_MASSBILL]
    GEWKEY,      -- Weighting key [GEWKEY]
    ZSPANNS,     -- Sec. voltage [E_ZSPANNS]
    ZSTROMS,     -- Secondary curr. [E_ZSTROMS]
    ZSPANNP,     -- Primary voltage [E_ZSPANNP]
    ZSTROMP,     -- Primary current [E_ZSTROMP]
    INTSIZEID,   -- Interval Length [INTSIZEID]
    TOUPERIOD,   -- TOU type [E_TOUPERIOD]
    VEE_CODE,    -- VEE Code [E_AMI_VEE_CODE]
    PRIMARY KEY (MANDT, EQUNR, ZWNUMMER, BIS)
);

Learn More