I_MstrProjPurReqItemSimple

DDL: I_MSTRPROJPURREQITEMSIMPLE SQL: IMPPRITEMSIMPLE Type: view COMPOSITE
8 Fields 2 Data Sources 1 Associations

Simplified PR Items for Master Project

I_MstrProjPurReqItemSimple is a Composite CDS View that provides data about "Simplified PR Items for Master Project" in SAP S/4HANA. It reads from 2 data sources (I_MstrProjItmProjStrucNode, I_PurReqnAcctAssgmt) and exposes 8 fields with key fields MasterProject, PurchaseRequisition, PurchaseRequisitionItem. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_MstrProjItmProjStrucNode I_MstrProjItmProjStrucNode from
I_PurReqnAcctAssgmt I_PurReqnAcctAssgmt inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Purchaserequisitionitem _PurchaseReqItem $projection.PurchaseRequisition = _PurchaseReqItem.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseReqItem.PurchaseRequisitionItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPPRITEMSIMPLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Simplified PR Items for Master Project view
AccessControl.personalData.blocking #REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MstrProjItmProjStrucNode MasterProject Project ID
KEY PurchaseRequisition I_PurReqnAcctAssgmt PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_PurReqnAcctAssgmt PurchaseRequisitionItem Requisn. item
ProjectUUID I_MstrProjItmProjStrucNode ProjectUUID Project UUID
Project I_MstrProjItmProjStrucNode Project WBS Element
ProjectObject I_MstrProjItmProjStrucNode ProjectObject Object number
OpenQuantity
_PurchaseReqItem _PurchaseReqItem

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 I_MstrProjPurReqItemSimple.
-- 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: IMPPRITEMSIMPLE

CREATE VIEW I_MstrProjPurReqItemSimple AS
SELECT
  I_MstrProjItmProjStrucNode.MasterProject AS MasterProject,
  I_PurReqnAcctAssgmt.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_MstrProjItmProjStrucNode.ProjectUUID AS ProjectUUID,
  I_MstrProjItmProjStrucNode.Project AS Project,
  I_MstrProjItmProjStrucNode.ProjectObject AS ProjectObject,
  ( _PurchaseReqItem.RequestedQuantity - _PurchaseReqItem.OrderedQuantity ) AS OpenQuantity
FROM I_MstrProjItmProjStrucNode
INNER JOIN I_PurReqnAcctAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseReqItem ON PurchaseRequisition = _PurchaseReqItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseReqItem.PurchaseRequisitionItem  -- association [0..1]
;

Learn More