I_OpenUtilsBillgDocAndOrdData

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_OpenUtilsBillgDocAndOrdData.
-- 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: IEOPENBILLGSU

CREATE VIEW I_OpenUtilsBillgDocAndOrdData AS
SELECT
  UtilitiesBillingOrder.UtilitiesContract AS UtilitiesContract,
  UtilitiesBillingOrder.UtilitiesInstallation AS UtilitiesInstallation,
  UtilitiesBillingOrder.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilitiesBillingOrder.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilitiesBillingOrder.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  UtilitiesBillingOrder.ContractAccount AS ContractAccount,
  UtilitiesBillingOrder.UtilitiesPortion AS UtilitiesPortion,
  UtilitiesBillingOrder.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilitiesBillingOrder.CompanyCode AS CompanyCode,
  UtilitiesBillingOrder.Division AS Division,
  UtilitiesBillingOrder.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilitiesBillingOrder.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilitiesBillingOrder.MeterReadingUnit AS MeterReadingUnit,
  UtilitiesBillingOrder.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilitiesBillingOrder.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilitiesBillingOrder.UtilsPortionScheduleRecordDate AS UtilsPortionScheduleRecordDate,
  UtilitiesBillingOrder.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilitiesBillingOrder.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilitiesBillingOrder.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilitiesBillingOrder.UtilitiesContractIsActive AS UtilitiesContractIsActive,
  UtilitiesBillingOrder.UtilsInstTimeSliceIsValid AS UtilsInstTimeSliceIsValid,
  UtilitiesBillingOrder.AuthorizationGroup AS AuthorizationGroup,
  UtilitiesBillingOrder._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilitiesBillingOrder._UtilitiesPortion AS _UtilitiesPortion,
  UtilitiesBillingOrder._CompanyCode AS _CompanyCode,
  UtilitiesBillingOrder._Division AS _Division,
  UtilitiesBillingOrder._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilitiesBillingOrder._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilitiesBillingOrder._MeterReadingUnit AS _MeterReadingUnit,
  UtilitiesBillingOrder._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilitiesBillingOrder._UtilsBillingClass AS _UtilsBillingClass,
  UtilitiesBillingOrder._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  '04' AS OpnUtilsBillgDocAndOrdType,
  UtilitiesBillingDocumentTP._UtilitiesBillingReason AS _UtilitiesBillingReason
FROM I_UtilsBillingOrder AS UtilitiesBillingOrder
INNER JOIN I_UtilitiesContract AS UtilitiesContract ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesInstallationHist AS UtilitiesInstallationHist ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesBillingReason AS _UtilitiesBillingReason ON UtilitiesBillingReason = _UtilitiesBillingReason.UtilitiesBillingReason  -- association [1..1]
LEFT OUTER JOIN I_OpnUtilsBillgDocAndOrdType AS _OpnUtilsBillgDocAndOrdType ON OpnUtilsBillgDocAndOrdType = _OpnUtilsBillgDocAndOrdType.OpnUtilsBillgDocAndOrdType  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation  -- 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]
-- UNION ALL with additional select branch(es): I_UtilitiesBillingDocumentTP
;