I_UtilitiesInstallation

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_UtilitiesInstallation.
-- 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: IEINSTALLATION

CREATE VIEW I_UtilitiesInstallation AS
SELECT
  eanl.anlage AS UtilitiesInstallation,
  eanl.anlart AS UtilitiesInstallationType,
  eanl.sparte AS Division,
  eanl.spebene AS UtilitiesInstVoltageLevel,
  eanl.drckstuf AS UtilitiesInstGasPrssrLvl,
  eanl.etimezone AS UtilsInstTimeZone,
  eanl.nodisconct AS UtilsInstGuarOfSupReason,
  eanl.deregstat AS UtilsInstDeregulationSts,
  eanl.inforel AS UtilsInstDataReleaseStatus,
  eanl.service AS UtilitiesSrvcProviderRole,
  eanl.bezug AS UtilsInstIsForEnergyFeedIn,
  eanl.erdat AS UtilsInstCreationDate,
  eanl.ernam AS UtilsInstCreatedByUser,
  eanl.aedat AS UtilsInstLastChangeDate,
  eanl.aenam AS UtilsInstLastChangedByUser,
  eanl.ablsperr AS MeterReadingBlockingReason,
  eanl.bapertyp AS MeterReadingBasePeriodCat,
  eanl.ablesartst AS NmbrOfAllwdMtrRdngsCntrlCode,
  eanl.begru AS AuthorizationGroup,
  eanl.loevm AS IsMarkedForDeletion,
  eanl.vstelle AS UtilitiesPremise,
  eanl.altitude AS UtilitiesGeoLocAltitudeValue
FROM eanl
LEFT OUTER JOIN I_UtilitiesInstallationHist AS _UtilitiesInstallationHist ON UtilitiesInstallation = _UtilitiesInstallationHist.UtilitiesInstallation  -- association [1..*]
LEFT OUTER JOIN I_UtilsNmbrOfAllwdMRCtrlCode AS _UtilsNmbrOfAllwdMRCtrlCode ON NmbrOfAllwdMtrRdngsCntrlCode = _UtilsNmbrOfAllwdMRCtrlCode.NmbrOfAllwdMtrRdngsCntrlCode  -- association [0..1]
LEFT OUTER JOIN I_UtilsMtrRdngBasePerdCat AS _UtilsMtrRdngBasePerdCat ON MeterReadingBasePeriodCat = _UtilsMtrRdngBasePerdCat.MeterReadingBasePeriodCat  -- association [0..1]
LEFT OUTER JOIN I_UtilsMtrRdngBlockReason AS _UtilsMtrRdngBlockReason ON MeterReadingBlockingReason = _UtilsMtrRdngBlockReason.MeterReadingBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_UtilsServiceProviderRole AS _UtilsServiceProviderRole ON UtilitiesSrvcProviderRole = _UtilsServiceProviderRole.UtilitiesSrvcProviderRole  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstDataReleaseSts AS _UtilsInstDataReleaseSts ON UtilsInstDataReleaseStatus = _UtilsInstDataReleaseSts.UtilsInstDataReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstDeregulationSts AS _UtilsInstDeregulationSts ON UtilsInstDeregulationSts = _UtilsInstDeregulationSts.UtilsInstDeregulationSts  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstGuarOfSupRsn AS _UtilsInstGuarOfSupRsn ON UtilsInstGuarOfSupReason = _UtilsInstGuarOfSupRsn.UtilsInstGuarOfSupReason  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstGasPressureLvl AS _UtilsInstGasPressureLvl ON UtilitiesInstGasPrssrLvl = _UtilsInstGasPressureLvl.UtilitiesInstGasPrssrLvl  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstVltgLevel AS _UtilsInstVltgLevel ON UtilitiesInstVoltageLevel = _UtilsInstVltgLevel.UtilitiesInstVoltageLevel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstallationType AS _UtilsInstallationType ON UtilitiesInstallationType = _UtilsInstallationType.UtilitiesInstallationType  -- association [0..1]
LEFT OUTER JOIN I_User AS _UtilsInstCreatedByUser ON UtilsInstCreatedByUser = _UtilsInstCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _UtilsInstLastChangedByUser ON UtilsInstLastChangedByUser = _UtilsInstLastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPremise AS _UtilitiesPremise ON UtilitiesPremise = _UtilitiesPremise.UtilitiesPremise  -- association [0..1]
LEFT OUTER JOIN I_UtilsAllocOfInstToPoD AS _UtilsAllocOfInstToPoD ON UtilitiesInstallation = _UtilsAllocOfInstToPoD.UtilitiesInstallation  -- association [0..*]
;