I_UtilitiesRegister

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_UtilitiesRegister.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IEREGISTER

CREATE VIEW I_UtilitiesRegister AS
SELECT
  etdz.zwnummer AS UtilitiesRegister,
  etdz.equnr AS Equipment,
  etdz.bis AS UtilsRegisterValidityEndDate,
  etdz.ab AS UtilsRegisterValidityStartDate,
  etdz.spartyp AS UtilitiesDivisionCategory,
  etdz.logikzw AS UtilitiesLogicalRegisterNumber,
  etdz.zwart AS UtilitiesRegisterType,
  etdz.zwtyp AS UtilitiesRegisterCategory,
  etdz.zwkenn AS UtilsRegMsmtCategory,
  concat(spartyp, zwkenn) AS ActivityUUID,
  etdz.bliwirk AS UtilsRegActvReactvMsmtType,
  etdz.kennziff AS UtilitiesObjectIdnSystemCode,
  etdz.stanzvor AS NmbrOfUtilsRegDigitsPreDcmls,
  etdz.stanznac AS NmbrOfUtilsRegDigitsDcmls,
  etdz.zwfakt AS MeterReadingResultAdjmtFctrVal,
  etdz.massread AS MeterReadingMeasurementUnit,
  etdz.anzerg AS NumberOfResultsPerMeterReading,
  etdz.kzmessw AS UtilitiesRegisterIsNonMetering,
  etdz.nablesen AS UtilsRegIsNotMtrRdngRelevant,
  etdz.steuergrp AS MltplMtrRdngOrdCrtnCntrlGroup,
  etdz.pruefkl AS IndepMtrRdngValdtnClass,
  etdz.temp_area AS UtilitiesTemperatureArea,
  etdz.pr_area_ai AS UtilitiesAirPressureArea,
  etdz.calor_area AS UtilsCalorificValDistrict,
  etdz.hoekorr AS UtilsAltitudeCorrtnPrssrVal,
  etdz.thgber AS GasBillgFctrInclsnType,
  etdz.kzahle AS UtilsGasLawDevtnFctrVal,
  etdz.kzahlt AS ActualUtilsGasLawDvtnFctrVal,
  etdz.gas_prs_ar AS UtilitiesGasPressureArea,
  etdz.crgpress AS UtilitiesGasCorrectionPrssrVal,
  etdz.erdat AS UtilsRegisterCreationDate,
  etdz.ernam AS UtilsRegisterCreatedByUser,
  etdz.aedat AS UtilsRegisterLastChangeDate,
  etdz.aenam AS UtilsRegisterLastChangedByUser,
  etdz.massbill AS BillingMeasurementUnit,
  etdz.gewkey AS UtilitiesWeightingCode,
  etdz.ueberver AS UtilsRegTransformationRatio,
  etdz.zspannp AS RegPrimTrnsfrmerVltgValue,
  etdz.zstromp AS RegPrimTrnsfrmerCurVltgValue,
  etdz.zspanns AS RegSecdryTrnsfrmerVltgValue,
  etdz.zstroms AS RegSecdryTrnsfrmerCurVltgValue,
  etdz.intsizeid AS UtilsProfileValIntvlLength,
  etdz.touperiod AS UtilitiesTimeOfUseCode
FROM etdz
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [1..1]
LEFT OUTER JOIN I_UtilsTemperatureArea AS _UtilitiesTemperatureArea ON UtilitiesTemperatureArea = _UtilitiesTemperatureArea.UtilitiesTemperatureArea  -- association [0..1]
LEFT OUTER JOIN I_UtilsDivisionCategory AS _UtilitiesDivisionCategory ON UtilitiesDivisionCategory = _UtilitiesDivisionCategory.UtilitiesDivisionCategory  -- association [1..1]
LEFT OUTER JOIN I_UtilsRegMsmtCat AS _UtilsRegMsmtCategory ON ActivityUUID = _UtilsRegMsmtCategory.ActivityUUID  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesRegisterType AS _UtilitiesRegisterType ON UtilitiesRegisterType = _UtilitiesRegisterType.UtilitiesRegisterType  -- association [1..1]
LEFT OUTER JOIN I_UtilsRegisterCategory AS _UtilitiesRegisterCategory ON UtilitiesRegisterCategory = _UtilitiesRegisterCategory.UtilitiesRegisterCategory  -- association [1..1]
LEFT OUTER JOIN I_UtilsRegActvReactvMsmtType AS _UtilsRegActvReactvMsmtType ON UtilsRegActvReactvMsmtType = _UtilsRegActvReactvMsmtType.UtilsRegActvReactvMsmtType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MeterReadingMeasurementUnit ON MeterReadingMeasurementUnit = _MeterReadingMeasurementUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_IndepMtrRdngValdtnCl AS _IndepMtrRdngValdtnClass ON IndepMtrRdngValdtnClass = _IndepMtrRdngValdtnClass.IndepMtrRdngValdtnClass  -- association [0..1]
LEFT OUTER JOIN I_UtilsAirPressureArea AS _UtilitiesAirPressureArea ON UtilitiesAirPressureArea = _UtilitiesAirPressureArea.UtilitiesAirPressureArea  -- association [0..1]
LEFT OUTER JOIN I_UtilsCalorificValDstrct AS _UtilsCalorificValDistrict ON UtilsCalorificValDistrict = _UtilsCalorificValDistrict.UtilsCalorificValDistrict  -- association [0..1]
LEFT OUTER JOIN I_UtilsGasBillgFctrInclsnType AS _GasBillgFctrInclsnType ON GasBillgFctrInclsnType = _GasBillgFctrInclsnType.GasBillgFctrInclsnType  -- association [0..1]
LEFT OUTER JOIN I_UtilsGasPressureArea AS _UtilitiesGasPressureArea ON UtilitiesGasPressureArea = _UtilitiesGasPressureArea.UtilitiesGasPressureArea  -- association [0..1]
LEFT OUTER JOIN I_UtilsWeightingCode AS _UtilitiesWeightingCode ON UtilitiesWeightingCode = _UtilitiesWeightingCode.UtilitiesWeightingCode  -- association [0..1]
LEFT OUTER JOIN I_UtilsPrflValIntvlLength AS _UtilsProfileValIntvlLength ON UtilsProfileValIntvlLength = _UtilsProfileValIntvlLength.UtilsProfileValIntvlLength  -- association [0..1]
LEFT OUTER JOIN I_UtilsTimeOfUseCode AS _UtilitiesTimeOfUseCode ON UtilitiesTimeOfUseCode = _UtilitiesTimeOfUseCode.UtilitiesTimeOfUseCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON UtilsRegisterCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON UtilsRegisterLastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;