I_UtilitiesInstallationHist

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_UtilitiesInstallationHist.
-- 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: IEINSTHISTORY

CREATE VIEW I_UtilitiesInstallationHist AS
SELECT
  eanlh.anlage AS UtilitiesInstallation,
  cast(eanlh.bis as e_inst_end_vdm preserving type) AS UtilsInstHistValidityEndDate,
  cast(eanlh.ab as e_inst_start_vdm preserving type) AS UtilsInstHistValidityStartDate,
  eanlh.tariftyp AS UtilitiesRateCategory,
  eanlh.schemanr AS UtilitiesBillingSchema,
  eanlh.aklasse AS UtilitiesBillingClass,
  eanlh.ableinh AS MeterReadingUnit,
  eanlh.temp_area AS UtilitiesTemperatureArea,
  eanlh.konzbefr AS UtilsInstIsExmptFrmFrnchsFee,
  eanlh.pauschal AS UtilsInstDvceAllctnIsNotAllwd,
  eanlh.konzver AS UtilitiesFranchiseContract,
  eanlh.billing_party AS UtilitiesBillingParty,
  eanlh.invoicing_party AS UtilitiesInvoicingParty,
  eanlh.prov_last_res AS ObligatorySupUtilsSrvcProvider,
  eanlh.maininst AS PrimaryUtilitiesInstallation,
  eanlh.instrole AS UtilsInstallationGroupRole,
  eanlh.instgrtype AS UtilsInstallationGroupType,
  eanlh.highlevinst AS HigherLevelUtilsInstallation,
  eanlh.hochart AS UnbilldRevnXtrapltnType,
  eanlh.pruefgr AS UtilsRegDepdntValdtnGroup,
  cast ( eanlh.branche as bu_ind_sector preserving type ) AS IndustrySector
FROM eanlh
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation  -- association [1..1]
LEFT OUTER JOIN I_UtilsDepdntValdtnGroup AS _UtilsDepdntValdtnGroup ON UtilsRegDepdntValdtnGroup = _UtilsDepdntValdtnGroup.UtilsRegDepdntValdtnGroup  -- association [0..1]
LEFT OUTER JOIN I_UtilsUnbilldRevnXtrapltnType AS _UtilsUnbilldRevnXtrapltnType ON UnbilldRevnXtrapltnType = _UtilsUnbilldRevnXtrapltnType.UnbilldRevnXtrapltnType  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstGroupType AS _UtilsInstGroupType ON UtilsInstallationGroupType = _UtilsInstGroupType.UtilsInstallationGroupType  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstGroupRole AS _UtilsInstGroupRole ON UtilsInstallationGroupRole = _UtilsInstGroupRole.UtilsInstallationGroupRole  -- association [0..1]
LEFT OUTER JOIN I_UtilsTemperatureArea AS _UtilsTemperatureArea ON UtilitiesTemperatureArea = _UtilsTemperatureArea.UtilitiesTemperatureArea  -- association [0..1]
LEFT OUTER JOIN I_UtilsBillingClass AS _UtilsBillingClass ON UtilitiesBillingClass = _UtilsBillingClass.UtilitiesBillingClass  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesRateCategory AS _UtilitiesRateCategory ON UtilitiesRateCategory = _UtilitiesRateCategory.UtilitiesRateCategory  -- association [1..1]
LEFT OUTER JOIN I_MeterReadingUnit AS _MeterReadingUnit ON MeterReadingUnit = _MeterReadingUnit.MeterReadingUnit  -- association [1..1]
;