P_ProjMatCompPurDocItems

DDL: P_PROJMATCOMPPURDOCITEMS SQL: PPMCPURDOCITM Type: view BASIC
41 Fields 4 Data Sources 3 Associations

P_ProjMatCompPurDocItems is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (rsdb, rsdb, rsdbs, rsdbs) and exposes 41 fields with key fields PurchasingDocument, PurchasingDocumentItem, PurchasingDocumentItem, PurchasingDocumentItem, PurchasingDocumentItem. It has 3 associations to related views.

Data Sources (4)

SourceAliasJoin Type
rsdb rsdb from
rsdb rsdb union_all
rsdbs rsdbs union_all
rsdbs rsdbs union_all

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurchaseRequisitionItemBasic _PurchaseRequisitionItem $projection.PurchasingDocument = _PurchaseRequisitionItem.PurchaseRequisition and $projection.PurchasingDocumentItem = _PurchaseRequisitionItem.PurchaseRequisitionItem
[0..1] I_PurchasingDocumentType _PurchasingDocumentType $projection.PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory and $projection.PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType
[1..1] I_PurchasingDocumentItem _PurchaseOrderItem $projection.PurchasingDocument = _PurchaseOrderItem.PurchasingDocument and $projection.PurchasingDocumentItem = _PurchaseOrderItem.PurchasingDocumentItem

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPMCPURDOCITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument rsdb banfn Requisition
KEY PurchasingDocumentItem rsdb bnfpo Item pur. doc.
Reservation rsdb rsnum Reservation
ReservationItem rsdb rspos Item no.
RecordType rsdb rsart Risk type
PurchasingDocumentType _PurchaseRequisitionItem PurchaseRequisitionType Order Type
PurchasingDocumentCategory _PurchaseRequisitionItem PurchasingDocumentCategory Doc. Category
Plant _PurchaseRequisitionItem Plant Valuation Area
Supplier _PurchaseRequisitionItem Supplier Supplier
PurchasingDocumentItemText _PurchaseRequisitionItem PurchaseRequisitionItemText Short Text
ebelnasPurchasingDocument
KEY PurchasingDocumentItem rsdb ebelp Item pur. doc.
Reservation rsdb rsnum Reservation
ReservationItem rsdb rspos Item no.
RecordType rsdb rsart Risk type
PurchasingDocumentType Order Type
PurchasingDocumentCategory _PurchaseOrderItem PurchasingDocumentCategory Doc. Category
Plant _PurchaseOrderItem Plant Valuation Area
Supplier Supplier
PurchasingDocumentItemText _PurchaseOrderItem PurchasingDocumentItemText Short Text
banfnasPurchasingDocument
KEY PurchasingDocumentItem rsdbs bnfpo Item pur. doc.
Reservation rsdbs rsnum Reservation
ReservationItem rsdbs rspos Item no.
RecordType rsdbs rsart Risk type
PurchasingDocumentType _PurchaseRequisitionItem PurchaseRequisitionType Order Type
PurchasingDocumentCategory _PurchaseRequisitionItem PurchasingDocumentCategory Doc. Category
Plant _PurchaseRequisitionItem Plant Valuation Area
Supplier _PurchaseRequisitionItem Supplier Supplier
PurchasingDocumentItemText _PurchaseRequisitionItem PurchaseRequisitionItemText Short Text
ebelnasPurchasingDocument
KEY PurchasingDocumentItem rsdbs ebelp Item pur. doc.
Reservation rsdbs rsnum Reservation
ReservationItem rsdbs rspos Item no.
RecordType rsdbs rsart Risk type
PurchasingDocumentType Order Type
PurchasingDocumentCategory _PurchaseOrderItem PurchasingDocumentCategory Doc. Category
Plant _PurchaseOrderItem Plant Valuation Area
Supplier Supplier
PurchasingDocumentItemText _PurchaseOrderItem PurchasingDocumentItemText Short Text
_PurchasingDocumentType _PurchasingDocumentType

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_ProjMatCompPurDocItems.
-- 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: PPMCPURDOCITM

CREATE VIEW P_ProjMatCompPurDocItems AS
SELECT
  rsdb.banfn AS PurchasingDocument,
  rsdb.bnfpo AS PurchasingDocumentItem,
  rsdb.rsnum AS Reservation,
  rsdb.rspos AS ReservationItem,
  rsdb.rsart AS RecordType,
  _PurchaseRequisitionItem.PurchaseRequisitionType AS PurchasingDocumentType,
  _PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseRequisitionItem.Plant AS Plant,
  _PurchaseRequisitionItem.Supplier AS Supplier,
  _PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchasingDocumentItemText
FROM rsdb
LEFT OUTER JOIN I_PurchaseRequisitionItemBasic AS _PurchaseRequisitionItem ON PurchasingDocument = _PurchaseRequisitionItem.PurchaseRequisition AND PurchasingDocumentItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchaseOrderItem ON PurchasingDocument = _PurchaseOrderItem.PurchasingDocument AND PurchasingDocumentItem = _PurchaseOrderItem.PurchasingDocumentItem  -- association [1..1]
-- UNION ALL with additional select branch(es): rsdb, rsdbs
;

Learn More