A_CFinRpldBillingDocument

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 A_CFinRpldBillingDocument.
-- 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.

CREATE VIEW A_CFinRpldBillingDocument AS
SELECT
  cfin_avci_doce.sourcesystemlogicalsystem AS SourceSystemLogicalSystem,
  cfin_avci_doce.cfinreplicatedbillingdocument AS CFinReplicatedBillingDocument,
  cfin_avci_doce.soldtoparty AS SoldToParty,
  cfin_avci_doce.sddocumentcategory AS SDDocumentCategory,
  cfin_avci_doce.creationdate AS CreationDate,
  cfin_avci_doce.companycode AS CompanyCode,
  cfin_avci_doce.cancelledbillingdocument AS CancelledBillingDocument,
  cfin_avci_doce.billingdocumentdate AS BillingDocumentDate,
  cfin_avci_doce.transactioncurrency AS TransactionCurrency,
  cast( accountingexchangerate as kurrf_not_converted preserving type ) AS AccountingExchangeRate,
  cfin_avci_doce.payerparty AS PayerParty,
  cfin_avci_doce.taxdeparturecountry AS TaxDepartureCountry,
  cfin_avci_doce.exchangeratedate AS ExchangeRateDate,
  cfin_avci_doce.billingdocumentiscancelled AS BillingDocumentIsCancelled,
  cfin_avci_doce.vatregistrationorigin AS VATRegistrationOrigin,
  cfin_avci_doce.billingdocumentcategory AS BillingDocumentCategory,
  cfin_avci_doce.isdeleted AS IsDeleted,
  cfin_avci_doce.lastchangedatetime AS LastChangeDateTime,
  cfin_avci_doce.billtoparty AS BillToParty
FROM cfin_avci_doce
LEFT OUTER JOIN E_CFinRpldBillingDocument AS _Extension ON CFinReplicatedBillingDocument = _Extension.CFinReplicatedBillingDocument AND SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem  -- association [1..1]
LEFT OUTER JOIN A_CFinRpldBillingDocumentItem AS _CFinRpldBillingDocumentItem ON /* condition not available in parsed metadata */  -- association [0..*]
;