P_NO_CADocumentBPItem

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_NO_CADocumentBPItem.
-- 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 P_NO_CADocumentBPItem AS
SELECT
  CAItem.BusinessPartner AS BusinessPartner,
  CAItem.CADocumentNumber AS CADocumentNumber,
  CAItem.CABPItemNumber AS CABPItemNumber,
  CAItem.CASubItemNumber AS CASubItemNumber,
  CAItem.CompanyCode AS CompanyCode,
  cast(lpad(substring(cast(CAItem.CAPostingDate as abap.char(8)), 5, 2),3, '0') as abap.numc(3)) AS FiscalPeriod,
  CAItem.CAPostingDate AS CAPostingDate,
  CAItem.CADocumentType AS CADocumentType,
  FIDoc.AccountingDocument AS AccountingDocument,
  cast(CAItem.CAAmountInTransactionCurrency as abap.dec(13,2) ) AS CAAmountInTransactionCurrency,
  CAItem.TransactionCurrency AS TransactionCurrency,
  cast(CAItem.CAAmountInLocalCurrency as abap.dec(13,2) ) AS CAAmountInLocalCurrency,
  ficaitem.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_CADocumentBPItem AS CAItem
INNER JOIN I_CADocument AS CADoc ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CADocumentBPItem
;