C_MisgUtilsBillingOrderWthDets

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_MisgUtilsBillingOrderWthDets.
-- 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: CEMISGBILLGORD

CREATE VIEW C_MisgUtilsBillingOrderWthDets AS
SELECT
  UtilsContrToBeBlld.UtilitiesContract AS UtilitiesContract,
  UtilsContrToBeBlld.UtilitiesPortion AS UtilitiesPortion,
  UtilsContrToBeBlld.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsContrToBeBlld.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilsContrToBeBlld.UtilitiesInstallation AS UtilitiesInstallation,
  UtilsContrToBeBlld.ContractAccount AS ContractAccount,
  UtilsContrToBeBlld.BusinessPartner AS BusinessPartner,
  UtilsContrToBeBlld.Division AS Division,
  UtilsContrToBeBlld.CompanyCode AS CompanyCode,
  UtilsContrToBeBlld.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilsContrToBeBlld.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilsContrToBeBlld.MeterReadingUnit AS MeterReadingUnit,
  UtilsContrToBeBlld.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsContrToBeBlld.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilsContrToBeBlld.MeterReadingReason AS MeterReadingReason,
  _LtstUtilsBillgDateForContr.LatestUtilitiesBillingReason AS LatestUtilitiesBillingReason,
  UtilsContrToBeBlld.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilsContrToBeBlld.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilsContrToBeBlld.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilsContrToBeBlld._UtilsInstIntAndExtPtOfDeliv.UtilsExternalPointOfDelivery AS UtilsExternalPointOfDelivery,
  UtilsContrToBeBlld.AuthorizationGroup AS AuthorizationGroup,
  UtilsContrToBeBlld._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsContrToBeBlld._UtilitiesPortion AS _UtilitiesPortion,
  UtilsContrToBeBlld._CompanyCode AS _CompanyCode,
  UtilsContrToBeBlld._Division AS _Division,
  UtilsContrToBeBlld._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilsContrToBeBlld._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilsContrToBeBlld._MeterReadingUnit AS _MeterReadingUnit,
  UtilsContrToBeBlld._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsContrToBeBlld._UtilsBillingClass AS _UtilsBillingClass,
  UtilsContrToBeBlld._BusinessPartner AS _BusinessPartner,
  UtilsContrToBeBlld._ContrAcc AS _ContrAcc,
  UtilsContrToBeBlld._MeterReadingReason AS _MeterReadingReason,
  UtilsContrToBeBlld._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  _LtstUtilsBillgDateForContr._UtilitiesBillingReason AS _UtilitiesBillingReason
FROM I_UtilsContrToBeBlld AS UtilsContrToBeBlld
LEFT OUTER JOIN I_LtstBillgDocWthNetAmtByContr AS _LtstUtilsBillgDateForContr ON UtilitiesContract = _LtstUtilsBillgDateForContr.UtilitiesContract  -- association [0..1]
;