P_ContrAcctgBPItmPostdClrdRvsd

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 P_ContrAcctgBPItmPostdClrdRvsd.
-- 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.
-- Parameters: P_fromPostingDate : fis_budat_from, P_toPostingDate : fis_budat_to, P_CompanyCode : bukrs

CREATE VIEW P_ContrAcctgBPItmPostdClrdRvsd AS
SELECT
  fica_bpitems_posted.CADocumentNumber AS CADocumentNumber,
  fica_bpitems_posted.CABPItemNumber AS CABPItemNumber,
  fica_bpitems_posted.CASubItemNumber AS CASubItemNumber,
  fica_bpitems_posted.CARepetitionItemNumber AS CARepetitionItemNumber,
  fica_bpitems_posted.CompanyCode AS CompanyCode,
  fica_bpitems_posted._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  ficadoc.CreatedByUser AS CreatedByUser,
  ficadoc.CreationDate AS CreationDate,
  ficadoc.CreationTime AS CreationTime,
  ficadoc.CAApplicationArea AS CAApplicationArea,
  ficadoc.DocumentDate AS DocumentDate,
  ficadoc.LastChangeDate AS LastChangeDate,
  ficadoc.CAReferenceDocument AS CAReferenceDocument,
  ficadoc.CAClassificationKey AS CAClassificationKey,
  cast( '' as opupk_kk) AS CAGLItemNumber,
  fica_bpitems_posted.CAPostingDate AS CAPostingDate,
  fica_bpitems_posted.CACashDiscountDueDate AS CACashDiscountDueDate,
  fica_bpitems_posted.ChartOfAccounts AS ChartOfAccounts,
  fica_bpitems_posted.CAReconciliationAccount AS GLAccount,
  fica_bpitems_posted.TaxCode AS TaxCode,
  fica_bpitems_posted.CADocumentType AS CADocumentType,
  _CADocumentType._Text[1: Language = $session.system_language]. CADocumentTypeName as CADocumentTypeName AS CADocumentTypeNameasCADocumentTypeName,
  fica_bpitems_posted.TransactionCurrency AS TransactionCurrency,
  fica_bpitems_posted.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  fica_bpitems_posted.CompanyCodeCurrency AS CompanyCodeCurrency,
  fica_bpitems_posted.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  fica_bpitems_posted.CAExchangeRate AS CAExchangeRate,
  fica_bpitems_posted.CAClearingDate AS CAClearingDate,
  fica_bpitems_posted.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  cast( '' as fica_opbel ) AS CAClearedDocument,
  fica_bpitems_posted._CADocument.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  fica_bpitems_posted.BusinessPartner as BusinessPartner AS CADocumentNumberasCADocumentNumber,
  fica_bpitems_clrd.BusinessPartner AS BusinessPartner
FROM I_CADocument AS ficadoc
INNER JOIN I_CADocumentBPItem AS fica_bpitems_posted ON /* join condition not captured in parsed metadata */
INNER JOIN I_CADocumentBPItem AS fica_bpitems_rvsd ON /* join condition not captured in parsed metadata */
INNER JOIN I_CADocumentBPItem AS fica_bpitems_clrd ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CADocument
;