P_Projmatcomponent

DDL: P_PROJMATCOMPONENT SQL: PPROJMATCOMP Type: view BASIC
15 Fields 4 Data Sources

P_Projmatcomponent is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (resb, resb, rsdb, rsdbs) and exposes 15 fields with key fields Reservation, ReservationItem, RecordType, IndexCounter, ReservationItem.

Data Sources (4)

SourceAliasJoin Type
resb resb inner
resb resb inner
rsdb rsdb from
rsdbs rsdbs union_all

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROJMATCOMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Reservation rsdb rsnum Reservation
KEY ReservationItem rsdb rspos Item no.
KEY RecordType rsdb rsart Risk type
KEY IndexCounter rsdb rsinz Index counter
PurchaseRequisition rsdb banfn Requisition
PurchaseRequisitionItem rsdb bnfpo Requisn. item
PurchaseOrder rsdb ebeln Source PurchDoc
rsnumasReservation
KEY ReservationItem rsdbs rspos Item no.
KEY RecordType rsdbs rsart Risk type
KEY IndexCounter rsdbs rsinz Index counter
PurchaseRequisition rsdbs banfn Requisition
PurchaseRequisitionItem rsdbs bnfpo Requisn. item
PurchaseOrder rsdbs ebeln Source PurchDoc
PurchaseOrderItem rsdbs ebelp Item pur. doc.

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_Projmatcomponent.
-- 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: PPROJMATCOMP

CREATE VIEW P_Projmatcomponent AS
SELECT
  rsdb.rsnum AS Reservation,
  rsdb.rspos AS ReservationItem,
  rsdb.rsart AS RecordType,
  rsdb.rsinz AS IndexCounter,
  rsdb.banfn AS PurchaseRequisition,
  rsdb.bnfpo AS PurchaseRequisitionItem,
  rsdb.ebeln AS PurchaseOrder,
  rsdb.ebelp as PurchaseOrderItem AS rsnumasReservation,
  rsdbs.ebelp AS PurchaseOrderItem
FROM rsdb
INNER JOIN resb ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): rsdbs
;

Learn More