I_UtilsContrToBeBlldData

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_UtilsContrToBeBlldData.
-- 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: IECONTRTBBILLEDD

CREATE VIEW I_UtilsContrToBeBlldData AS
SELECT
  UtilitiesContract.UtilitiesContract AS UtilitiesContract,
  UtilitiesPortionScheduleRecd.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilitiesPortionScheduleRecd.UtilitiesPortion AS UtilitiesPortion,
  MtrRdngUnitScheduleRecord.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilitiesPortionScheduleRecd.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilitiesContract.CompanyCode AS CompanyCode,
  UtilitiesContract.UtilitiesDivision AS Division,
  UtilitiesContract.UtilitiesInstallation AS UtilitiesInstallation,
  UtilitiesContract.ContractAccount AS ContractAccount,
  UtilitiesContract.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilitiesContract.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilitiesInstallationHist.MeterReadingUnit AS MeterReadingUnit,
  UtilitiesInstallationHist.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilitiesInstallationHist.UtilitiesBillingClass AS UtilitiesBillingClass,
  MtrRsnCorrespgToBillgRsn.MeterReadingReason AS MeterReadingReason,
  UtilitiesContract.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilitiesContract.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilitiesContract.UtilsContrJointInvcType AS UtilsContrJointInvcType,
  UtilitiesContract.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilitiesPortionScheduleRecd.UtilsPortionScheduleRecordDate AS UtilsPortionScheduleRecordDate,
  UtilitiesPortionScheduleRecd.SchedldUtilsInvcgPrintoutDate AS SchedldUtilsInvcgPrintoutDate,
  dats_add_days(UtilitiesPortionScheduleRecd.ScheduledUtilitiesBillingDate, cast( MtrRdngUnitScheduleRecord._MeterReadingUnit.UtilsMtrRdngIntervalInDays as abap.int4) , 'INITIAL' ) AS UtilitiesBillingHighDate,
  dats_add_days(UtilitiesPortionScheduleRecd.ScheduledUtilitiesBillingDate, cast( MtrRdngUnitScheduleRecord._MeterReadingUnit.UtilsMtrRdngIntervalInDays as abap.int4) * -1 , 'INITIAL' ) AS UtilitiesBillingLowDate,
  UtilitiesContract.AuthorizationGroup AS AuthorizationGroup,
  UtilitiesPortionScheduleRecd._UtilitiesPortion AS _UtilitiesPortion,
  UtilitiesPortionScheduleRecd._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilitiesContract._CompanyCode AS _CompanyCode,
  UtilitiesContract._Division AS _Division,
  UtilitiesContract._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilitiesContract._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilitiesContract._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilitiesInstallationHist._MeterReadingUnit AS _MeterReadingUnit,
  UtilitiesInstallationHist._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilitiesInstallationHist._UtilsBillingClass AS _UtilsBillingClass,
  MtrRsnCorrespgToBillgRsn._MeterReadingReason AS _MeterReadingReason,
  UtilitiesContract._InvcUtilsContractsJointly AS _InvcUtilsContractsJointly,
  UtilitiesContract._UtilsAccountDetnCode AS _UtilsAccountDetnCode
FROM I_UtilitiesContract AS UtilitiesContract
INNER JOIN I_UtilitiesPortionScheduleRecd AS UtilitiesPortionScheduleRecd ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesInstallationHist AS UtilitiesInstallationHist ON /* join condition not captured in parsed metadata */
INNER JOIN I_MtrRsnCorrespgToBillgRsn AS MtrRsnCorrespgToBillgRsn ON /* join condition not captured in parsed metadata */
INNER JOIN I_MtrRdngUnitScheduleRecord AS MtrRdngUnitScheduleRecord ON /* join condition not captured in parsed metadata */
INNER JOIN I_MeterReadingUnit AS MeterReadingUnit ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_UtilitiesContract
;