P_JP_APDOCUMENTITEMLIST3

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_JP_APDOCUMENTITEMLIST3.
-- 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: PJPAPDOCIT3

CREATE VIEW P_JP_APDOCUMENTITEMLIST3 AS
SELECT
  IRHeader.Supplier AS Supplier,
  po_gr.SourceLedger AS SourceLedger,
  po_gr.CompanyCode AS CompanyCode,
  po_gr.FiscalYear AS FiscalYear,
  po_gr.AccountingDocument AS AccountingDocument,
  po_gr.LedgerGLLineItem AS LedgerGLLineItem,
  po_gr.Ledger AS Ledger,
  cast ( IRHeader.AccountingDocument as glo_jp_anx20_leading_acctg_doc preserving type ) AS JP_Annex205APLeadingAcctgDoc,
  po_gr.FiscalPeriod AS FiscalPeriod,
  po_gr.PostingDate AS PostingDate,
  po_gr.DocumentDate AS DocumentDate,
  po_gr.ClearingDate AS ClearingDate,
  po_gr.DocumentItemText AS DocumentItemText,
  po_gr.AccountingDocumentType AS AccountingDocumentType,
  po_gr.FinancialAccountType AS FinancialAccountType,
  po_gr.ChartOfAccounts AS ChartOfAccounts,
  po_gr.GLAccount AS GLAccount,
  po_gr.ReferenceDocument AS ReferenceDocument,
  po_gr.ReferenceDocumentItem AS ReferenceDocumentItem,
  po_gr.PurchasingDocument AS PurchasingDocument,
  po_gr.PurchasingDocumentItem AS PurchasingDocumentItem,
  po_gr.Product AS Product,
  po_gr.DebitCreditCodeName AS DebitCreditCodeName,
  po_gr.DebitCreditCode AS DebitCreditCode,
  po_gr.TransactionCurrency AS TransactionCurrency,
  po_gr.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  po_gr.CompanyCodeCurrency AS CompanyCodeCurrency,
  po_gr.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  po_gr.BaseUnit AS BaseUnit,
  po_gr.Quantity AS Quantity,
  po_gr._SourceLedger AS _SourceLedger,
  po_gr._CompanyCode AS _CompanyCode,
  po_gr._FiscalYear AS _FiscalYear,
  po_gr._JournalEntry AS _JournalEntry,
  po_gr._Ledger AS _Ledger,
  IRHeader._Supplier AS _Supplier,
  po_gr._Product AS _Product,
  po_gr._PurchasingDocument AS _PurchasingDocument,
  po_gr._PurchasingDocumentItem AS _PurchasingDocumentItem,
  po_gr._TransactionCurrency AS _TransactionCurrency,
  po_gr._CompanyCodeCurrency AS _CompanyCodeCurrency,
  po_gr._BaseUnit AS _BaseUnit,
  po_gr._DebitCreditCode AS _DebitCreditCode,
  po_gr._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  po_gr._ChartOfAccounts AS _ChartOfAccounts,
  po_gr._AccountingDocumentType AS _AccountingDocumentType,
  po_gr._AccountingDocumentTypeText AS _AccountingDocumentTypeText
FROM P_JP_GRBASEDACCTGGRLIST AS po_gr
INNER JOIN P_JP_APDOCUMENTHEADERLIST AS IRHeader ON /* join condition not captured in parsed metadata */
;