I_UtilsInstallationExtnEnbld

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_UtilsInstallationExtnEnbld.
-- 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: IEINSTEXTNENBLD

CREATE VIEW I_UtilsInstallationExtnEnbld AS
SELECT
  UtilitiesInstallation,
  UtilitiesInstallationType,
  Division,
  UtilitiesInstVoltageLevel,
  UtilitiesInstGasPrssrLvl,
  UtilsInstTimeZone,
  UtilsInstGuarOfSupReason,
  UtilsInstDeregulationSts,
  UtilsInstDataReleaseStatus,
  UtilitiesSrvcProviderRole,
  UtilsInstIsForEnergyFeedIn,
  UtilsInstCreationDate,
  UtilsInstCreatedByUser,
  UtilsInstLastChangeDate,
  UtilsInstLastChangedByUser,
  MeterReadingBlockingReason,
  MeterReadingBasePeriodCat,
  NmbrOfAllwdMtrRdngsCntrlCode,
  AuthorizationGroup,
  IsMarkedForDeletion,
  UtilitiesPremise
FROM I_UtilitiesInstallation
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..*]
LEFT OUTER JOIN E_UtilitiesInstallation AS _UtilsInstallationExtension ON UtilitiesInstallation = _UtilsInstallationExtension.UtilitiesInstallation  -- association [1..1]
;