C_OutsrtdUtilsBillingDoc

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 C_OutsrtdUtilsBillingDoc.
-- 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: CECOUTSRTDBDOC

CREATE VIEW C_OutsrtdUtilsBillingDoc AS
SELECT
  UtilitiesBillingDocument.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  UtilitiesBillingDocument.UtilitiesContract AS UtilitiesContract,
  UtilitiesBillingDocument.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilitiesBillingDocument.UtilitiesPortion AS UtilitiesPortion,
  UtilitiesBillingDocument.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilitiesBillingDocument.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilitiesBillingDocument.BusinessPartner AS BusinessPartner,
  UtilitiesBillingDocument.ContractAccount AS ContractAccount,
  UtilitiesBillingDocument._UtilitiesContract.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilitiesBillingDocument._UtilitiesContract.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilitiesBillingDocument._UtilitiesContract.CompanyCode AS CompanyCode,
  UtilitiesBillingDocument._UtilitiesContract.UtilitiesDivision AS Division,
  UtilitiesBillingDocument.UtilitiesInstallation AS UtilitiesInstallation,
  UtilitiesBillingDocument.MeterReadingUnit AS MeterReadingUnit,
  UtilitiesInstallationHist.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilitiesInstallationHist.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilitiesBillingDocument.UtilsBillgPeriodEndDate AS UtilsPortionScheduleRecordDate,
  UtilitiesBillingDocument._UtilitiesContract.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  _UtilsBillgDocOutsrtgDataCntr._UtilsBillgDocOutsrtgChkGrp.UtilitiesBillingCheck AS UtilitiesBillingCheck,
  _UtilsBillgDocOutsrtgDataRsn._UtilsBillgDocOutsrtgData.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  _UtilsBillgDocOutsrtgDataRsn._UtilsBillgDocOutsrtgData._UtilsBillgOutsortingGroup._Text[1: Language=$session.system_language].UtilsBillgOutsortingReasonName AS UtilsBillgOutsortingReasonName,
  cast(_CalendarDate.CalendarMonth as e_schdldmnth_vdm preserving type ) AS CalendarMonth,
  _CalendarDate._CalendarMonth._Text[1: Language = $session.system_language].CalendarMonthName AS CalendarMonthName,
  cast(_CalendarDate.CalendarYear as e_schdldyr_vdm preserving type ) AS CalendarYear,
  UtilitiesBillingDocument.AuthorizationGroup AS AuthorizationGroup,
  cast(1 as e_outsrtdbillgdoc_nmbr_vdm) AS NmbrOfOutsortedUtilsBillgDocs,
  UtilitiesBillingDocument._UtilitiesContract AS _UtilitiesContract,
  UtilitiesBillingDocument._UtilitiesPortion AS _UtilitiesPortion,
  UtilitiesBillingDocument._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilitiesBillingDocument._BusinessPartner AS _BusinessPartner,
  UtilitiesBillingDocument._UtilitiesContract._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilitiesBillingDocument._UtilitiesContract._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilitiesBillingDocument._UtilitiesContract._CompanyCode AS _CompanyCode,
  UtilitiesBillingDocument._UtilitiesContract._Division AS _Division,
  UtilitiesBillingDocument._MeterReadingUnit AS _MeterReadingUnit,
  UtilitiesInstallationHist._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilitiesInstallationHist._UtilsBillingClass AS _UtilsBillingClass,
  UtilitiesBillingDocument._UtilitiesContract._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  _UtilsBillgDocOutsrtgDataRsn._UtilsBillgDocOutsrtgData._UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup,
  _CalendarDate._CalendarMonth AS _CalendarMonth,
  _CalendarDate._CalendarYear AS _CalendarYear
FROM I_UtilitiesBillingDocumentTP AS UtilitiesBillingDocument
INNER JOIN I_UtilitiesInstallationHist AS UtilitiesInstallationHist ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_UtilsBillgDocOutsrtgDataCntr AS _UtilsBillgDocOutsrtgDataCntr ON UtilitiesBillingDocument = _UtilsBillgDocOutsrtgDataCntr.UtilitiesBillingDocument  -- association [1..1]
LEFT OUTER JOIN I_UtilsBillgDocOutsrtgDataRsn AS _UtilsBillgDocOutsrtgDataRsn ON UtilitiesBillingDocument = _UtilsBillgDocOutsrtgDataRsn.UtilitiesBillingDocument  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON ScheduledUtilitiesBillingDate = _CalendarDate.CalendarDate  -- association [1..1]
;