I_PrelimBillgDocEnhancedFields

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_PrelimBillgDocEnhancedFields.
-- 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: ISDPBDENHFLD

CREATE VIEW I_PrelimBillgDocEnhancedFields AS
SELECT
  PrelimBillingDocument.PrelimBillingDocument AS PrelimBillingDocument,
  PrelimBillingDocument.TransactionCurrency AS TransactionCurrency,
  cast( PrelimBillingDocument.TotalTaxAmount + PrelimBillingDocument.TotalNetAmount as sdci_odata_total_amount ) AS TotalGrossAmount,
  _BillToDocPartner.Customer AS BillToParty
FROM I_PrelimBillingDocument AS PrelimBillingDocument
LEFT OUTER JOIN I_PrelimBillingDocument AS _PrelimBillingDocument ON PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_PrelimBillingDocPartner AS _BillToDocPartner ON PrelimBillingDocument = _BillToDocPartner.PrelimBillingDocument AND PartnerFunction = 'RE'  -- association [0..1]
;