I_UtilsContrToBeBlld

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_UtilsContrToBeBlld.
-- 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: IECONTRTBBILLED

CREATE VIEW I_UtilsContrToBeBlld AS
SELECT
  UtilsContrToBeBlldData.UtilitiesContract AS UtilitiesContract,
  UtilsContrToBeBlldData.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsContrToBeBlldData.UtilitiesPortion AS UtilitiesPortion,
  UtilsContrToBeBlldData.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilsContrToBeBlldData.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilsContrToBeBlldData.CompanyCode AS CompanyCode,
  UtilsContrToBeBlldData.Division AS Division,
  UtilsContrToBeBlldData.UtilitiesInstallation AS UtilitiesInstallation,
  ContractAccountPartner.ContractAccount AS ContractAccount,
  ContractAccountPartner.BusinessPartner AS BusinessPartner,
  UtilsContrToBeBlldData.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilsContrToBeBlldData.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilsContrToBeBlldData.MeterReadingUnit AS MeterReadingUnit,
  UtilsContrToBeBlldData.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsContrToBeBlldData.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilsContrToBeBlldData.MeterReadingReason AS MeterReadingReason,
  UtilsContrToBeBlldData.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilsContrToBeBlldData.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilsContrToBeBlldData.UtilsContrJointInvcType AS UtilsContrJointInvcType,
  UtilsContrToBeBlldData.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilsContrToBeBlldData.UtilsPortionScheduleRecordDate AS UtilsPortionScheduleRecordDate,
  UtilsContrToBeBlldData.SchedldUtilsInvcgPrintoutDate AS SchedldUtilsInvcgPrintoutDate,
  cast(1 as e_nrofutilscontr_vdm) AS NmbrOfUtilsContractsToBeBilled,
  UtilsContrToBeBlldData.AuthorizationGroup AS AuthorizationGroup,
  UtilsContrToBeBlldData._UtilitiesPortion AS _UtilitiesPortion,
  UtilsContrToBeBlldData._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilsContrToBeBlldData._CompanyCode AS _CompanyCode,
  UtilsContrToBeBlldData._Division AS _Division,
  UtilsContrToBeBlldData._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsContrToBeBlldData._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilsContrToBeBlldData._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilsContrToBeBlldData._MeterReadingUnit AS _MeterReadingUnit,
  UtilsContrToBeBlldData._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsContrToBeBlldData._UtilsBillingClass AS _UtilsBillingClass,
  UtilsContrToBeBlldData._MeterReadingReason AS _MeterReadingReason,
  UtilsContrToBeBlldData._InvcUtilsContractsJointly AS _InvcUtilsContractsJointly,
  UtilsContrToBeBlldData._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  ContractAccountPartner._ContrAcc AS _ContrAcc,
  ContractAccountPartner._BusinessPartner AS _BusinessPartner
FROM I_UtilsContrToBeBlldData AS UtilsContrToBeBlldData
LEFT OUTER JOIN I_UtilitiesBillingDocument AS UtilitiesBillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesBillingOrder AS UtilitiesBillingOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SuppressedUtilsBillingOrder AS SuppressedUtilsBillingOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_ContractAccountPartner AS ContractAccountPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsInstIntAndExtPtOfDeliv AS _UtilsInstIntAndExtPtOfDeliv ON UtilitiesInstallation = _UtilsInstIntAndExtPtOfDeliv.UtilitiesInstallation AND _UtilsInstIntAndExtPtOfDeliv.UtilsPoDAllocValidityEndDate = '99991231' AND _UtilsInstIntAndExtPtOfDeliv.UtilsPoDAllocValidityEndTime = '235959'  -- association [0..*]
LEFT OUTER JOIN I_UtilsContrToBeBlldType AS _UtilsContrToBeBlldType ON UtilsContrToBeBlldType = _UtilsContrToBeBlldType.UtilsContrToBeBlldType  -- association [1..1]
LEFT OUTER JOIN I_UtilsContrToBeBlldDetsType AS _UtilsContrToBeBlldDetsType ON UtilsContrToBeBlldDetsType = _UtilsContrToBeBlldDetsType.UtilsContrToBeBlldDetsType  -- association [1..1]
;