I_UtilitiesBillingOrder

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_UtilitiesBillingOrder.
-- 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: IEBILLGORDER

CREATE VIEW I_UtilitiesBillingOrder AS
SELECT
  etrg.anlage AS UtilitiesInstallation,
  cast(etrg.abrdats as e_schedld_billg_dte_vdm preserving type) AS ScheduledUtilitiesBillingDate,
  cast( etrg.abrvorg as e_abrvorg_vdm preserving type) AS UtilitiesBillingReason,
  etrg.bukrs AS CompanyCode,
  etrg.sparte AS Division,
  etrg.trigstat AS UtilsBillingOrderStatus,
  etrg.portion AS UtilitiesPortion,
  cast(etrg.ableinh as ableinheit preserving type) AS MeterReadingUnit,
  cast(etrg.adatsoll as e_schedld_mtrrdng_dte_vdm preserving type) AS ScheduledMeterReadingDate,
  etrg.zuorddat AS UtilsBillgPeriodAllocationDate,
  etrg.erdat AS UtilsBillgOrderCreationDate,
  etrg.ernam AS UtilsBillgOrderCreatedByUser,
  etrg.aedat AS UtilsBillgOrderLastChangeDate,
  etrg.aenam AS UtilsBillgOrdLastChangedByUser,
  cast( etrg.abrdatsu as e_abrdatsu_vdm preserving type) AS SuppressedUtilsSchedldBillgDte,
  cast( etrg.adatsollu as e_adatsollu_vdm preserving type) AS SuppressedSchedldMtrRdngDte,
  cast( etrg.abrvorgu as e_abrvorgu_vdm preserving type) AS SuppressedUtilsBillgReason,
  cast( etrg.billg_err as e_billgordind_vdm preserving type) AS UtilsBillingOrderIndicator
FROM etrg
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesBillingReason AS _UtilitiesBillingReason ON UtilitiesBillingReason = _UtilitiesBillingReason.UtilitiesBillingReason  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MeterReadingUnit AS _MeterReadingUnit ON MeterReadingUnit = _MeterReadingUnit.MeterReadingUnit  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesPortion AS _UtilitiesPortion ON UtilitiesPortion = _UtilitiesPortion.UtilitiesPortion  -- association [1..1]
LEFT OUTER JOIN I_UtilsBillingOrderStatus AS _UtilsBillingOrderStatus ON UtilsBillingOrderStatus = _UtilsBillingOrderStatus.UtilsBillingOrderStatus  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON UtilsBillgOrderCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON UtilsBillgOrdLastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesBillingReason AS _SuppressedUtilsBillgReason ON SuppressedUtilsBillgReason = _SuppressedUtilsBillgReason.UtilitiesBillingReason  -- association [1..1]
LEFT OUTER JOIN I_UtilsBillingOrderIndicator AS _UtilsBillingOrderIndicator ON UtilsBillingOrderIndicator = _UtilsBillingOrderIndicator.UtilsBillingOrderIndicator  -- association [1..1]
;