C_UtilsBillgOrdRdyBillgWthDets

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_UtilsBillgOrdRdyBillgWthDets.
-- 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: CEBLLGORDRDYDET

CREATE VIEW C_UtilsBillgOrdRdyBillgWthDets AS
SELECT
  UtilsBillingOrder.UtilitiesContract AS UtilitiesContract,
  UtilsBillingOrder.UtilitiesInstallation AS UtilitiesInstallation,
  UtilsBillingOrder.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsBillingOrder.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilsBillingOrder.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  UtilsBillingOrder.UtilitiesPortion AS UtilitiesPortion,
  UtilsBillingOrder.CompanyCode AS CompanyCode,
  UtilsBillingOrder.Division AS Division,
  UtilsBillingOrder.ContractAccount AS ContractAccount,
  UtilsBillingOrder.BusinessPartner AS BusinessPartner,
  UtilsBillingOrder.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilsBillingOrder.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilsBillingOrder.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilsBillingOrder.MeterReadingUnit AS MeterReadingUnit,
  UtilsBillingOrder.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsBillingOrder.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilsBillingOrder.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilsBillingOrder.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilsBillingOrder._UtilitiesPortion.UtilsDefaultBdgtBillgCycle AS UtilsDefaultBdgtBillgCycle,
  UtilsBillingOrder.UtilsContrSpcfcBdgtBillgCycle AS UtilsContrSpcfcBdgtBillgCycle,
  UtilsBillingOrder.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilsBillingOrder.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  UtilsBillingOrder.UtilsExternalPointOfDelivery AS UtilsExternalPointOfDelivery,
  UtilsBillingOrder.UtilsBillgOrdChkBfrBilling AS UtilsBillgOrdChkBfrBilling,
  case when UtilsBillingOrder.UtilsBillgOrdChkBfrBilling is not null then 1 end AS StatusCriticality,
  cast('' as abap.sstring( 256 )) AS UtilsPostalAddressFormatted,
  UtilsBillingOrder._UtilitiesInstallation._UtilitiesPremise._UtilsTechObjLocationAddr.AddressID AS AddressID,
  UtilsBillingOrder._UtilitiesInstallation._UtilitiesPremise._UtilsTechObjLocationAddr._Address2 AS _Address2,
  UtilsBillingOrder._UtilitiesInstallation.UtilitiesPremise AS UtilitiesPremise,
  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,
  UtilsBillingOrder.UtilsContrIsBilledManually AS UtilsContrIsBilledManually,
  UtilsBillingOrder.AuthorizationGroup AS AuthorizationGroup,
  UtilsBillingOrder._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsBillingOrder._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilsBillingOrder._UtilitiesPortion AS _UtilitiesPortion,
  UtilsBillingOrder._CompanyCode AS _CompanyCode,
  UtilsBillingOrder._Division AS _Division,
  UtilsBillingOrder._ContrAcc AS _ContrAcc,
  UtilsBillingOrder._BusinessPartner AS _BusinessPartner,
  UtilsBillingOrder._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilsBillingOrder._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilsBillingOrder._MeterReadingUnit AS _MeterReadingUnit,
  UtilsBillingOrder._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsBillingOrder._UtilsBillingClass AS _UtilsBillingClass,
  UtilsBillingOrder._UtilitiesPortion._UtilitiesBdgtBillgCyc AS _UtilitiesBdgtBillgCyc,
  UtilsBillingOrder._UtilsContrSpcfcBdgtBillgCyc AS _UtilsContrSpcfcBdgtBillgCyc,
  UtilsBillingOrder._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  UtilsBillingOrder._UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup,
  UtilsBillingOrder._UtilsBillgOrdChkBfrBilling AS _UtilsBillgOrdChkBfrBilling,
  UtilsBillingOrder._UtilitiesInstallation._UtilitiesPremise AS _UtilitiesPremise,
  _CalendarDate._CalendarMonth AS _CalendarMonth,
  _CalendarDate._CalendarYear AS _CalendarYear
FROM I_UtilsBillingOrder AS UtilsBillingOrder
LEFT OUTER JOIN C_UtilitiesBillingOrderHistory AS _UtilitiesBillingOrderHistory ON UtilitiesContract = _UtilitiesBillingOrderHistory.UtilitiesContract  -- association [0..*]
LEFT OUTER JOIN C_UtilsBillingDocumentHistory AS _UtilsBillingDocumentHistory ON UtilitiesContract = _UtilsBillingDocumentHistory.UtilitiesContract  -- association [0..*]
LEFT OUTER JOIN C_MeterReadingHistoryDetails AS _MeterReadingHistoryDetails ON UtilitiesInstallation = _MeterReadingHistoryDetails.UtilitiesInstallation  -- association [0..*]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON ScheduledUtilitiesBillingDate = _CalendarDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [1..1]
;