P_MPProcurement

DDL: P_MPPROCUREMENT SQL: PMPPROCUREMENT Type: view COMPOSITE
15 Fields 2 Data Sources

P_MPProcurement is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_MstrProjPurOrdItem, I_MstrProjPurReqItem) and exposes 15 fields.

Data Sources (2)

SourceAliasJoin Type
I_MstrProjPurOrdItem PurchaseOrder union
I_MstrProjPurReqItem PurchaseRequisition from

Annotations (9)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
MasterProject I_MstrProjPurReqItem MasterProject Project ID
ControllingObjectExternalID I_MstrProjPurReqItem ControllingObjectExternalID WBS Element
ControllingObjectDescription I_MstrProjPurReqItem ControllingObjectDescription
Material I_MstrProjPurReqItem Material Vehicle Model
Supplier
ReleaseCode I_MstrProjPurReqItem ReleaseCode Release ind.
PurchaseRequisition I_MstrProjPurReqItem PurchaseRequisition Requisition
MasterProject Project ID
ControllingObjectExternalID I_MstrProjPurOrdItem ControllingObjectExternalID WBS Element
ControllingObjectDescription I_MstrProjPurOrdItem ControllingObjectDescription
Material I_MstrProjPurOrdItem Material Vehicle Model
Supplier
ReleaseCode I_MstrProjPurOrdItem ReleaseCode Release ind.
PurchaseRequisition Requisition
PurchaseOrder I_MstrProjPurOrdItem PurchaseOrder Purchasing Document

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_MPProcurement.
-- 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: PMPPROCUREMENT

CREATE VIEW P_MPProcurement AS
SELECT
  PurchaseRequisition.MasterProject AS MasterProject,
  PurchaseRequisition.ControllingObjectExternalID AS ControllingObjectExternalID,
  PurchaseRequisition.ControllingObjectDescription AS ControllingObjectDescription,
  PurchaseRequisition.Material AS Material,
  cast(PurchaseRequisition.Supplier as md_supplier) AS Supplier,
  PurchaseRequisition.ReleaseCode AS ReleaseCode,
  PurchaseRequisition.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrder.PurchaseOrder AS PurchaseOrder
FROM I_MstrProjPurReqItem AS PurchaseRequisition
-- UNION with additional select branch(es): I_MstrProjPurOrdItem
;

Learn More