I_UtilitiesContractHistory

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_UtilitiesContractHistory.
-- 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: IEUTILSCONTHIST

CREATE VIEW I_UtilitiesContractHistory AS
SELECT
  everh.vertrag AS UtilitiesContract,
  everh.bis AS UtilsContractValidityEndDate,
  everh.num AS UtilitiesFourDigitNumber,
  everh.ab AS UtilsContractValidityStartDate,
  everh.anlage AS UtilitiesInstallation,
  everh.crm_product AS UtilitiesProduct,
  everh.crm_object_id AS UtilsTransNumberInCRMDocument,
  everh.crm_object_pos AS UtilsItemNumberInCRMDocument,
  everh.campaign_to_date AS UtilsMarketingCampaignEndDate,
  everh.loevm AS DeletionIndicator,
  everh.oucontract AS UtilsMstrAgrmtForIndivContract,
  everh.crm_item_descr AS UtilitiesContractDescription
FROM everh
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesContract AS _UtilsMstrAgrmtForIndivContr ON UtilsMstrAgrmtForIndivContract = _UtilsMstrAgrmtForIndivContr.UtilitiesContract  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesContract AS _UtilitiesContract ON UtilitiesContract = _UtilitiesContract.UtilitiesContract  -- association [1..1]
LEFT OUTER JOIN I_UtilsContrHistFourDigitNmbr AS _UtilsContrHistFourDigitNmbr ON UtilitiesFourDigitNumber = _UtilsContrHistFourDigitNmbr.UtilitiesFourDigitNumber  -- association [1..1]
;