P_JP_GRLeadingAcctgDocItem

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_GRLeadingAcctgDocItem.
-- 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: PJPGRLDACCDOCIT

CREATE VIEW P_JP_GRLeadingAcctgDocItem AS
SELECT
  GRM_Item.Supplier AS Supplier,
  GRM_Item.SourceLedger AS SourceLedger,
  GRM_Item.CompanyCode AS CompanyCode,
  GRM_Item.FiscalYear AS FiscalYear,
  GRM_Item.AccountingDocument AS AccountingDocument,
  GRM_Item.LedgerGLLineItem AS LedgerGLLineItem,
  GRM_Item.Ledger AS Ledger,
  GRM_Item.JP_Annex205APLeadingAcctgDoc AS JP_Annex205APLeadingAcctgDoc,
  GRM_Item.FiscalPeriod AS FiscalPeriod,
  GRM_Item.PostingDate AS PostingDate,
  GRM_Item.DocumentDate AS DocumentDate,
  GRM_Item.ClearingDate AS ClearingDate,
  GRM_Item.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  GRM_Item.DocumentItemText AS DocumentItemText,
  GRM_Item.AccountingDocumentType AS AccountingDocumentType,
  GRM_Item.FinancialAccountType AS FinancialAccountType,
  GRM_Item.ChartOfAccounts AS ChartOfAccounts,
  GRM_Item.GLAccount AS GLAccount,
  GRM_Item.ReferenceDocument AS ReferenceDocument,
  GRM_Item.ReferenceDocumentItem AS ReferenceDocumentItem,
  GRM_Item.PurchasingDocument AS PurchasingDocument,
  GRM_Item.PurchasingDocumentItem AS PurchasingDocumentItem,
  GRM_Item.Product AS Product,
  GRM_Item.DebitCreditCode AS DebitCreditCode,
  GRM_Item.TransactionCurrency AS TransactionCurrency,
  GRM_Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  GRM_Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  GRM_Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  GRM_Item.BaseUnit AS BaseUnit,
  GRM_Item.Quantity AS Quantity,
  GRM_Item.OrderPriceUnit AS OrderPriceUnit,
  GRM_Item.NetPriceQuantity AS NetPriceQuantity,
  GRM_Item.NetPriceAmount AS NetPriceAmount,
  GRM_Item.DocumentCurrency AS DocumentCurrency,
  GRM_Item._SourceLedger AS _SourceLedger,
  GRM_Item._CompanyCode AS _CompanyCode,
  GRM_Item._FiscalYear AS _FiscalYear,
  GRM_Item._JournalEntry AS _JournalEntry,
  GRM_Item._Ledger AS _Ledger,
  GRM_Item._FinancialAccountType AS _FinancialAccountType,
  GRM_Item._Supplier AS _Supplier,
  GRM_Item._Product AS _Product,
  GRM_Item._PurchasingDocument AS _PurchasingDocument,
  GRM_Item._PurchasingDocumentItem AS _PurchasingDocumentItem,
  GRM_Item._TransactionCurrency AS _TransactionCurrency,
  GRM_Item._CompanyCodeCurrency AS _CompanyCodeCurrency,
  GRM_Item._BaseUnit AS _BaseUnit,
  GRM_Item._DebitCreditCode AS _DebitCreditCode,
  GRM_Item._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  GRM_Item._ChartOfAccounts AS _ChartOfAccounts,
  GRM_Item._AccountingDocumentType AS _AccountingDocumentType,
  GRM_Item._AccountingDocumentTypeText AS _AccountingDocumentTypeText
FROM P_JP_GRMaterialDocumentItem AS GRM_Item
INNER JOIN I_PurchasingDocHistory AS PO_History ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_JP_GRMaterialDocumentItem
;