What is C_MstrProjPurReqItem in SAP S/4HANA?

C_MstrProjPurReqItem is a consumption CDS view in SAP S/4HANA. Master Project Purchase Requisition Item It contains 35 fields.

Which tables does C_MstrProjPurReqItem read from?

C_MstrProjPurReqItem reads data from: I_MstrProjPurReqItem.

What VDM layer is C_MstrProjPurReqItem?

C_MstrProjPurReqItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MstrProjPurReqItem

DDL: C_MSTRPROJPURREQITEM SQL: CMPPRITEM Type: view CONSUMPTION

35 Fields 1 Data Sources 9 Associations

Master Project Purchase Requisition Item

C_MstrProjPurReqItem is a Consumption CDS View that provides data about "Master Project Purchase Requisition Item" in SAP S/4HANA. It reads from 1 data source (I_MstrProjPurReqItem) and exposes 35 fields with key fields MasterProject, PurchaseRequisition, PurchaseRequisitionItem. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_MstrProjPurReqItem	Requisition	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	I_MasterProjectVH	_MasterProject	`$projection.MasterProject = _MasterProject.MasterProject`
[0..1]	I_Purchaserequisitionitem	_PurchaseRequisition	`$projection.PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseRequisition.PurchaseRequisitionItem`
[0..*]	C_MpPurReqHistory	_PurchaseRequisitionHistory	`$projection.PurchaseRequisition = _PurchaseRequisitionHistory.PurchaseRequisition`
[0..1]	I_Material	_Material	`$projection.Material = _Material.Material`
[0..1]	I_PRReleaseIndicatorDesc	_ReleaseIndicatorDesc	`_ReleaseIndicatorDesc.PurchasingReleaseStatus = Requisition.ReleaseCode and _ReleaseIndicatorDesc.Language = $session.system_language`
[0..1]	I_Processingstatustext	_ProcessingStatusText	`$projection.ProcessingStatus = _ProcessingStatusText.ProcessingStatus and _ProcessingStatusText.Language = $session.system_language`
[0..1]	I_CPDPRProcessingStatus	_PRProcessingStatusText	`$projection.PurReqnReleaseStatus = _PRProcessingStatusText.PurReqnReleaseStatus`
[0..1]	E_Purchaserequisitionitem	_Extension	`Requisition.PurchaseRequisition = _Extension.PurchaseRequisition and $projection.PurchaseRequisitionItem = _Extension.PurchaseRequisitionItem`
[1..1]	C_MstrProjSuplrCntctCard	_Supplier	`$projection.Supplier = _Supplier.Supplier`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CMPPRITEM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Master Project Purchase Requisition Item	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (35)

Key	Field	Source Table	Source Field	Description
KEY	MasterProject	I_MstrProjPurReqItem	MasterProject	Project ID
KEY	PurchaseRequisition
KEY	PurchaseRequisitionItem	I_MstrProjPurReqItem	PurchaseRequisitionItem	Requisn. item
	PurchaseRequisitionItemText	I_MstrProjPurReqItem	PurchaseRequisitionItemText	Short Text
	FormattedPurRequisitionItem
	MasterProjectName	I_MstrProjPurReqItem	MasterProjectName
	ControllingObjectExternalID
	ControllingObjectDescription	I_MstrProjPurReqItem	ControllingObjectDescription
	WBSElement	I_MstrProjPurReqItem	WBSElement	WBS Internal ID
	WBSDescription	I_MstrProjPurReqItem	WBSDescription	WBS Element Name
	NetworkActivity	I_MstrProjPurReqItem	NetworkActivity	Operation/Activity
	NetworkActivityDescription	I_MstrProjPurReqItem	NetworkActivityDescription
	ProjectNetwork	I_MstrProjPurReqItem	ProjectNetwork	Order
	ProjectNetworkDescription	I_MstrProjPurReqItem	ProjectNetworkDescription	Network Name
	Material	I_MstrProjPurReqItem	Material	Vehicle Model
	MaterialName
	Supplier
	SupplierName
	ReleaseCode
	PurchasingReleaseIndicatorDesc	_ReleaseIndicatorDesc	PurchasingReleaseIndicatorDesc
	ProcessingStatus	I_MstrProjPurReqItem	ProcessingStatus	Worklist Status
	ProcessingStatusName
	PurReqnReleaseStatus	I_MstrProjPurReqItem	PurReqnReleaseStatus	Proc.state
	PurchasingDocumentStatusName
	PurReqnNetAmount
	PurReqnItemCurrency	I_MstrProjPurReqItem	PurReqnItemCurrency	Currency
	OpenQuantity
	OrderedQuantity
	RequestedQuantity
	BaseUnit	I_MstrProjPurReqItem	BaseUnit	Unit of Measure
	DeliveryDate	I_MstrProjPurReqItem	DeliveryDate	Delivery Date
	_MasterProject		_MasterProject
	_PurchaseRequisition		_PurchaseRequisition
	_PurchaseRequisitionHistory		_PurchaseRequisitionHistory
	_Supplier		_Supplier

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 C_MstrProjPurReqItem.
-- 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: CMPPRITEM

CREATE VIEW C_MstrProjPurReqItem AS
SELECT
  Requisition.MasterProject AS MasterProject,
  cast(Requisition.PurchaseRequisition as vdm_purchaserequisition) AS PurchaseRequisition,
  Requisition.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Requisition.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  concat(concat(ltrim(Requisition.PurchaseRequisition,'0'),'-'),(Requisition.PurchaseRequisitionItem)) AS FormattedPurRequisitionItem,
  Requisition.MasterProjectName AS MasterProjectName,
  cast(Requisition.ControllingObjectExternalID as /cpd/cpm_struct_elm) AS ControllingObjectExternalID,
  Requisition.ControllingObjectDescription AS ControllingObjectDescription,
  Requisition.WBSElement AS WBSElement,
  Requisition.WBSDescription AS WBSDescription,
  Requisition.NetworkActivity AS NetworkActivity,
  Requisition.NetworkActivityDescription AS NetworkActivityDescription,
  Requisition.ProjectNetwork AS ProjectNetwork,
  Requisition.ProjectNetworkDescription AS ProjectNetworkDescription,
  Requisition.Material AS Material,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  cast( Requisition.Supplier as md_supplier) AS Supplier,
  Requisition._SupplierHeadOffice.FullName AS SupplierName,
  cast(Requisition.ReleaseCode as frgkz) AS ReleaseCode,
  _ReleaseIndicatorDesc.PurchasingReleaseIndicatorDesc AS PurchasingReleaseIndicatorDesc,
  Requisition.ProcessingStatus AS ProcessingStatus,
  cast(_ProcessingStatusText.ProcessingStatusName as /cpd/pws_ws_requi_procsts) AS ProcessingStatusName,
  Requisition.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  cast(_PRProcessingStatusText._Text[1:Language = $session.system_language].PurchasingDocumentStatusName as /cpd/pws_ws_requi_procphase) AS PurchasingDocumentStatusName,
  cast(Requisition.PurReqnNetAmount as netpr) AS PurReqnNetAmount,
  Requisition.PurReqnItemCurrency AS PurReqnItemCurrency,
  cast( Requisition.OpenQuantity as /cpd/pws_ws_open_qty) AS OpenQuantity,
  cast(Requisition.OrderedQuantity as /cpd/pws_ws_ord_qty) AS OrderedQuantity,
  cast(Requisition.RequestedQuantity as bamng) AS RequestedQuantity,
  Requisition.BaseUnit AS BaseUnit,
  Requisition.DeliveryDate AS DeliveryDate
FROM I_MstrProjPurReqItem AS Requisition
LEFT OUTER JOIN I_MasterProjectVH AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisition.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN C_MpPurReqHistory AS _PurchaseRequisitionHistory ON PurchaseRequisition = _PurchaseRequisitionHistory.PurchaseRequisition  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_PRReleaseIndicatorDesc AS _ReleaseIndicatorDesc ON _ReleaseIndicatorDesc.PurchasingReleaseStatus = Requisition.ReleaseCode AND _ReleaseIndicatorDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Processingstatustext AS _ProcessingStatusText ON ProcessingStatus = _ProcessingStatusText.ProcessingStatus AND _ProcessingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CPDPRProcessingStatus AS _PRProcessingStatusText ON PurReqnReleaseStatus = _PRProcessingStatusText.PurReqnReleaseStatus  -- association [0..1]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _Extension ON Requisition.PurchaseRequisition = _Extension.PurchaseRequisition AND PurchaseRequisitionItem = _Extension.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN C_MstrProjSuplrCntctCard AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Depth:

C_MstrProjPurReqItem view

I_MstrProjPurReqItem view