I_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 I_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: IEINVDOCBILLDATA

CREATE VIEW I_UtilsInvcgDocBillingData AS
SELECT
  UtilitiesInvoicingDocument.UtilitiesInvoicingDocument AS UtilitiesInvoicingDocument,
  UtilsBillgDocInvcgHistory.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  UtilitiesInvoicingDocument.BusinessPartner AS BusinessPartner,
  UtilitiesInvoicingDocument.ContractAccount AS ContractAccount,
  UtilitiesBillingDocument.UtilitiesContract AS UtilitiesContract,
  UtilitiesContract.CompanyCode AS CompanyCode,
  UtilitiesContract.UtilitiesDivision AS Division,
  UtilitiesContract.UtilitiesInstallation AS UtilitiesInstallation,
  UtilitiesContract.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilitiesContract.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilitiesContract.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilitiesContract.UtilsContrJointInvcType AS UtilsContrJointInvcType,
  UtilitiesContract.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  UtilitiesBillingDocument.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilitiesBillingDocument.UtilsBillgPeriodStartDate AS UtilsBillgPeriodStartDate,
  UtilitiesBillingDocument.UtilsBillgPeriodEndDate AS UtilsBillgPeriodEndDate,
  UtilitiesBillingDocument.UtilitiesPortion AS UtilitiesPortion,
  UtilitiesBillingDocument.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilitiesBillingDocument.UtilsPortionScheduleRecordDate AS UtilsPortionScheduleRecordDate,
  UtilitiesBillingDocument.MeterReadingUnit AS MeterReadingUnit,
  UtilitiesBillingDocument.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilitiesBillingDocument.UtilsBillgDocCreationDate AS UtilsBillgDocCreationDate,
  UtilitiesBillingDocument.UtilitiesAccountClass AS UtilitiesAccountClass,
  UtilitiesContract.UtilsContrSpcfcBdgtBillgCycle AS UtilsContrSpcfcBdgtBillgCycle,
  UtilitiesBillingDocument._UtilitiesPortion.UtilsDefaultBdgtBillgCycle AS UtilsDefaultBdgtBillgCycle,
  UtilitiesInstallationHist.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilitiesInstallationHist.UtilitiesBillingClass AS UtilitiesBillingClass,
  cast(ContractAccountPartner.AltvContractAcctForCollvBills as e_collvbillacct_vdm preserving type) AS AltvContractAcctForCollvBills,
  UtilitiesInvoicingDocument.UtilsInvcgDocIsNotReleased AS UtilsInvcgDocIsNotReleased,
  UtilitiesInvoicingDocument.UtilsInvcgDocIsSimulated AS UtilsInvcgDocIsSimulated,
  UtilitiesInvoicingDocument.UtilsInvcgDocIsReversed AS UtilsInvcgDocIsReversed,
  UtilitiesInvoicingDocument.AuthorizationGroup AS AuthorizationGroup,
  cast(1 as e_invoicingdoc_vdm) AS NmbrOfUtilsInvoicingDocuments,
  cast(1 as e_nrofutilscontr_vdm) AS NumberOfUtilitiesContracts,
  UtilsBillgDocInvcgHistory._UtilitiesBillingDocument AS _UtilitiesBillingDocument,
  UtilitiesInvoicingDocument._BusinessPartner AS _BusinessPartner,
  UtilitiesBillingDocument._UtilitiesContract AS _UtilitiesContract,
  UtilitiesContract._CompanyCode AS _CompanyCode,
  UtilitiesContract._Division AS _Division,
  UtilitiesContract._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilitiesContract._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  UtilitiesContract._InvcUtilsContractsJointly AS _InvcUtilsContractsJointly,
  UtilitiesContract._UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup,
  UtilitiesBillingDocument._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilitiesBillingDocument._UtilitiesPortion AS _UtilitiesPortion,
  UtilitiesBillingDocument._MeterReadingUnit AS _MeterReadingUnit,
  UtilitiesBillingDocument._UtilsAccountClass AS _UtilsAccountClass,
  UtilitiesContract._UtilsContrSpcfcBdgtBillgCyc AS _UtilsContrSpcfcBdgtBillgCyc,
  UtilitiesBillingDocument._UtilitiesPortion._UtilitiesBdgtBillgCyc AS _UtilitiesBdgtBillgCyc,
  UtilitiesInstallationHist._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilitiesInstallationHist._UtilsBillingClass AS _UtilsBillingClass,
  ContractAccountPartner._AltvContrAcc AS _AltvContrAcc
FROM I_UtilitiesInvoicingDocument AS UtilitiesInvoicingDocument
INNER JOIN I_UtilsBillgDocInvcgHistory AS UtilsBillgDocInvcgHistory ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesBillingDocument AS UtilitiesBillingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilitiesContract AS UtilitiesContract 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_ContractAccountPartner AS ContractAccountPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ActvUtilsCAInvcgLockRsn AS ActvUtilsCAInvcgLockRsn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ActvUtilsContrInvcgLockRsn AS ActvUtilsContrInvcgLockRsn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsInvcgDocOutsrtgDataCntr AS UtilsInvcgDocOutsrtgDataCntr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesPortionScheduleRecd AS _UtilitiesPortionScheduleRecd ON UtilitiesPortion = _UtilitiesPortionScheduleRecd.UtilitiesPortion AND UtilsPortionScheduleRecordDate = _UtilitiesPortionScheduleRecd.UtilsPortionScheduleRecordDate  -- association [0..1]
LEFT OUTER JOIN I_UtilsBillgDocIntAndExtPoD AS _UtilsBillgDocIntAndExtPoD ON UtilitiesBillingDocument = _UtilsBillgDocIntAndExtPoD.UtilitiesBillingDocument  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgLockReason AS _CAInvcgLockReason ON CABusinessLockReason = _CAInvcgLockReason.CAInvcgLockReason  -- association [0..1]
;