P_JP_IRPurchaseDocumentHeader

DDL: P_JP_IRPURCHASEDOCUMENTHEADER SQL: PJPIRPODOCHD Type: view COMPOSITE
20 Fields 2 Data Sources

P_JP_IRPurchaseDocumentHeader is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_JP_IRDocumentItem, I_PurchasingDocumentItem) and exposes 20 fields with key fields Supplier, SourceLedger, CompanyCode, FiscalYear, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
P_JP_IRDocumentItem IRDocItem from
I_PurchasingDocumentItem PO_Item inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PJPIRPODOCHD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Supplier P_JP_IRDocumentItem Supplier Supplier
KEY SourceLedger P_JP_IRDocumentItem SourceLedger Source Ledger
KEY CompanyCode P_JP_IRDocumentItem CompanyCode Receiver Company Code
KEY FiscalYear P_JP_IRDocumentItem FiscalYear G/L Fiscal Year
KEY AccountingDocument P_JP_IRDocumentItem AccountingDocument Journal Entry
KEY LedgerGLLineItem P_JP_IRDocumentItem LedgerGLLineItem Journal Entry Item
KEY Ledger P_JP_IRDocumentItem Ledger Ledger
ReferenceDocument P_JP_IRDocumentItem ReferenceDocument Reference Document
ReferenceDocumentItem P_JP_IRDocumentItem ReferenceDocumentItem Reference item
PurchasingDocument P_JP_IRDocumentItem PurchasingDocument Purchasing Document
PurchasingDocumentItem P_JP_IRDocumentItem PurchasingDocumentItem Purchasing Doc. Item
InvoiceIsGoodsReceiptBased I_PurchasingDocumentItem InvoiceIsGoodsReceiptBased GR-Based IV
_Supplier P_JP_IRDocumentItem _Supplier
_SourceLedger P_JP_IRDocumentItem _SourceLedger
_CompanyCode P_JP_IRDocumentItem _CompanyCode
_FiscalYear P_JP_IRDocumentItem _FiscalYear
_JournalEntry P_JP_IRDocumentItem _JournalEntry
_Ledger P_JP_IRDocumentItem _Ledger
_PurchasingDocument P_JP_IRDocumentItem _PurchasingDocument
_PurchasingDocumentItem P_JP_IRDocumentItem _PurchasingDocumentItem

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_IRPurchaseDocumentHeader.
-- 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: PJPIRPODOCHD

CREATE VIEW P_JP_IRPurchaseDocumentHeader AS
SELECT
  IRDocItem.Supplier AS Supplier,
  IRDocItem.SourceLedger AS SourceLedger,
  IRDocItem.CompanyCode AS CompanyCode,
  IRDocItem.FiscalYear AS FiscalYear,
  IRDocItem.AccountingDocument AS AccountingDocument,
  IRDocItem.LedgerGLLineItem AS LedgerGLLineItem,
  IRDocItem.Ledger AS Ledger,
  IRDocItem.ReferenceDocument AS ReferenceDocument,
  IRDocItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  IRDocItem.PurchasingDocument AS PurchasingDocument,
  IRDocItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  PO_Item.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  IRDocItem._Supplier AS _Supplier,
  IRDocItem._SourceLedger AS _SourceLedger,
  IRDocItem._CompanyCode AS _CompanyCode,
  IRDocItem._FiscalYear AS _FiscalYear,
  IRDocItem._JournalEntry AS _JournalEntry,
  IRDocItem._Ledger AS _Ledger,
  IRDocItem._PurchasingDocument AS _PurchasingDocument,
  IRDocItem._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_JP_IRDocumentItem AS IRDocItem
INNER JOIN I_PurchasingDocumentItem AS PO_Item ON /* join condition not captured in parsed metadata */
;

Learn More