C_UtilsInvcgDocBillingData

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_UtilsInvcgDocBillingData.
-- 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: CEOUTINVDOCBLLGD

CREATE VIEW C_UtilsInvcgDocBillingData AS
SELECT
  UtilsInvcgDocBillingData.UtilitiesInvoicingDocument AS UtilitiesInvoicingDocument,
  UtilsInvcgDocBillingData.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  _OutsrtdInvcgDocBillgNetAmt.UtilsBillgDocTotalNetAmt AS UtilsBillgDocTotalNetAmt,
  _OutsrtdInvcgDocBillgNetAmt.UtilsBillgDocTransactionCrcy AS UtilsBillgDocTransactionCrcy,
  UtilsInvcgDocBillingData.BusinessPartner AS BusinessPartner,
  UtilsInvcgDocBillingData.ContractAccount AS ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  UtilsInvcgDocBillingData.UtilitiesContract AS UtilitiesContract,
  UtilsInvcgDocBillingData.CompanyCode AS CompanyCode,
  UtilsInvcgDocBillingData.Division AS Division,
  UtilsInvcgDocBillingData.UtilitiesInstallation AS UtilitiesInstallation,
  UtilsInvcgDocBillingData.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilsInvcgDocBillingData.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilsInvcgDocBillingData.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilsInvcgDocBillingData.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  UtilsInvcgDocBillingData.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilsInvcgDocBillingData.UtilsBillgPeriodStartDate AS UtilsBillgPeriodStartDate,
  UtilsInvcgDocBillingData.UtilsBillgPeriodEndDate AS UtilsBillgPeriodEndDate,
  UtilsInvcgDocBillingData.UtilitiesPortion AS UtilitiesPortion,
  UtilsInvcgDocBillingData.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsInvcgDocBillingData._UtilitiesPortionScheduleRecd.SchedldUtilsInvcgPrintoutDate AS SchedldUtilsInvcgPrintoutDate,
  UtilsInvcgDocBillingData.MeterReadingUnit AS MeterReadingUnit,
  UtilsInvcgDocBillingData.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilsInvcgDocBillingData.UtilsBillgDocCreationDate AS UtilsBillgDocCreationDate,
  UtilsInvcgDocBillingData.UtilitiesAccountClass AS UtilitiesAccountClass,
  UtilsInvcgDocBillingData.UtilsContrSpcfcBdgtBillgCycle AS UtilsContrSpcfcBdgtBillgCycle,
  UtilsInvcgDocBillingData.UtilsDefaultBdgtBillgCycle AS UtilsDefaultBdgtBillgCycle,
  UtilsInvcgDocBillingData.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsInvcgDocBillingData.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilsInvcgDocBillingData._UtilsBillgDocIntAndExtPoD.UtilsExternalPointOfDelivery AS UtilsExternalPointOfDelivery,
  UtilsInvcgDocBillingData._UtilitiesInstallation._UtilitiesPremise._UtilsTechObjLocationAddr.AddressID AS AddressID,
  cast('' as abap.sstring( 256 )) AS UtilsPostalAddressFormatted,
  UtilsInvcgDocBillingData.AuthorizationGroup AS AuthorizationGroup,
  _UtilitiesInstallation._UtilitiesPremise.UtilitiesPremise AS UtilitiesPremise,
  UtilsInvcgDocBillingData._UtilitiesBillingDocument AS _UtilitiesBillingDocument,
  UtilsInvcgDocBillingData._BusinessPartner AS _BusinessPartner,
  UtilsInvcgDocBillingData._UtilitiesContract AS _UtilitiesContract,
  UtilsInvcgDocBillingData._CompanyCode AS _CompanyCode,
  UtilsInvcgDocBillingData._Division AS _Division,
  UtilsInvcgDocBillingData._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsInvcgDocBillingData._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  UtilsInvcgDocBillingData._UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup,
  UtilsInvcgDocBillingData._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilsInvcgDocBillingData._UtilitiesPortion AS _UtilitiesPortion,
  UtilsInvcgDocBillingData._MeterReadingUnit AS _MeterReadingUnit,
  UtilsInvcgDocBillingData._UtilsAccountClass AS _UtilsAccountClass,
  UtilsInvcgDocBillingData._UtilsContrSpcfcBdgtBillgCyc AS _UtilsContrSpcfcBdgtBillgCyc,
  UtilsInvcgDocBillingData._UtilitiesBdgtBillgCyc AS _UtilitiesBdgtBillgCyc,
  UtilsInvcgDocBillingData._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsInvcgDocBillingData._UtilsBillingClass AS _UtilsBillingClass
FROM I_UtilsInvcgDocBillingData AS UtilsInvcgDocBillingData
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_OutsrtdInvcgDocBillgNetAmt AS _OutsrtdInvcgDocBillgNetAmt ON UtilitiesInvoicingDocument = _OutsrtdInvcgDocBillgNetAmt.UtilitiesInvoicingDocument AND UtilitiesBillingDocument = _OutsrtdInvcgDocBillgNetAmt.UtilitiesBillingDocument  -- association [0..1]
LEFT OUTER JOIN C_UtilsBillgDocMeteringData AS _UtilsBillgDocMeteringData ON UtilitiesBillingDocument = _UtilsBillgDocMeteringData.UtilitiesBillingDocument  -- association [0..*]
;