I_MstrProjPurReqItem

DDL: I_MSTRPROJPURREQITEM SQL: IMPPRITEM Type: view COMPOSITE
35 Fields 2 Data Sources 3 Associations

Master Project Purchase Requisition Item

I_MstrProjPurReqItem is a Composite CDS View that provides data about "Master Project Purchase Requisition Item" in SAP S/4HANA. It reads from 2 data sources (I_MPProcurementStructure, I_PurReqnAcctAssgmt) and exposes 35 fields with key fields MasterProject, PurchaseRequisition. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MPProcurementStructure I_MPProcurementStructure from
I_PurReqnAcctAssgmt I_PurReqnAcctAssgmt inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Purchaserequisitionitem _PurchaseReqItem $projection.PurchaseRequisition = _PurchaseReqItem.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseReqItem.PurchaseRequisitionItem
[0..*] I_ReleaseCodeText _ReleaseCodeText $projection.releasecode = _ReleaseCodeText.ReleaseCode
[1..1] I_SupplierOrAddressContactCard _SupplierHeadOffice ( _SupplierHeadOffice.ContactCardType = 'Supplier' and _SupplierHeadOffice.ContactCardID = $projection.Supplier and _SupplierHeadOffice.ContactCardRole = 'Supplier' )

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPPRITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED 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 Master Project Purchase Requisition Item view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MPProcurementStructure MasterProject Project ID
KEY PurchaseRequisition I_PurReqnAcctAssgmt PurchaseRequisition Requisition
PurchaseRequisitionItem I_PurReqnAcctAssgmt PurchaseRequisitionItem Requisn. item
PurchasingDocument _PurchaseReqItem PurchasingDocument Purchasing Document
PurchasingDocumentItem _PurchaseReqItem PurchasingDocumentItem Purchasing Doc. Item
MasterProjectName I_MPProcurementStructure MasterProjectName
ControllingObjectExternalID
ControllingObjectDescription I_MPProcurementStructure ControllingObjectDescription
WBSElement I_MPProcurementStructure WBSElement WBS Internal ID
WBSElementInternalID I_MPProcurementStructure WBSElementInternalID WBS Internal ID
WBSDescription I_MPProcurementStructure WBSDescription WBS Element Name
NetworkActivity I_MPProcurementStructure NetworkActivity Operation/Activity
NetworkActivityInternalID I_MPProcurementStructure NetworkActivityInternalID Counter
NetworkActivityDescription I_MPProcurementStructure NetworkActivityDescription
ProjectNetwork I_MPProcurementStructure ProjectNetwork Order
ProjectNetworkInternalID I_MPProcurementStructure ProjectNetworkInternalID Plan No.f.Oper.
ProjectNetworkDescription I_MPProcurementStructure ProjectNetworkDescription Network Name
Material _PurchaseReqItem Material Vehicle Model
MaterialGroup _PurchaseReqItem MaterialGroup Product Group
ProcessingStatus
PurReqnReleaseStatus
Supplier _PurchaseReqItem FixedSupplier Fixed Vendor
ReleaseCode _PurchaseReqItem ReleaseCode Release ind.
PurchaseRequisitionItemText _PurchaseReqItem PurchaseRequisitionItemText Short Text
BaseUnit _PurchaseReqItem BaseUnit Unit of Measure
RequestedQuantity _PurchaseReqItem RequestedQuantity Requested Quantity
OrderedQuantity _PurchaseReqItem OrderedQuantity Quantity
PurchaseRequisitionPrice _PurchaseReqItem PurchaseRequisitionPrice Valuation Price
OpenQuantity
PurReqnNetAmount
PurReqnItemCurrency _PurchaseReqItem PurReqnItemCurrency Currency
DeliveryDate _PurchaseReqItem DeliveryDate Delivery Date
_PurchaseReqItem _PurchaseReqItem
_ReleaseCodeText _ReleaseCodeText
_SupplierHeadOffice _SupplierHeadOffice

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_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: IMPPRITEM

CREATE VIEW I_MstrProjPurReqItem AS
SELECT
  I_MPProcurementStructure.MasterProject AS MasterProject,
  I_PurReqnAcctAssgmt.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseReqItem.PurchasingDocument AS PurchasingDocument,
  _PurchaseReqItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_MPProcurementStructure.MasterProjectName AS MasterProjectName,
  ltrim(I_MPProcurementStructure.ControllingObjectExternalID,'0') AS ControllingObjectExternalID,
  I_MPProcurementStructure.ControllingObjectDescription AS ControllingObjectDescription,
  I_MPProcurementStructure.WBSElement AS WBSElement,
  I_MPProcurementStructure.WBSElementInternalID AS WBSElementInternalID,
  I_MPProcurementStructure.WBSDescription AS WBSDescription,
  I_MPProcurementStructure.NetworkActivity AS NetworkActivity,
  I_MPProcurementStructure.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_MPProcurementStructure.NetworkActivityDescription AS NetworkActivityDescription,
  I_MPProcurementStructure.ProjectNetwork AS ProjectNetwork,
  I_MPProcurementStructure.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_MPProcurementStructure.ProjectNetworkDescription AS ProjectNetworkDescription,
  _PurchaseReqItem.Material AS Material,
  _PurchaseReqItem.MaterialGroup AS MaterialGroup,
  cast(_PurchaseReqItem.ProcessingStatus as banst) AS ProcessingStatus,
  cast(_PurchaseReqItem.PurReqnReleaseStatus as /cpd/cpm_pr_releasestatus) AS PurReqnReleaseStatus,
  _PurchaseReqItem.FixedSupplier AS Supplier,
  _PurchaseReqItem.ReleaseCode AS ReleaseCode,
  _PurchaseReqItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PurchaseReqItem.BaseUnit AS BaseUnit,
  _PurchaseReqItem.RequestedQuantity AS RequestedQuantity,
  _PurchaseReqItem.OrderedQuantity AS OrderedQuantity,
  _PurchaseReqItem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  ( _PurchaseReqItem.RequestedQuantity - _PurchaseReqItem.OrderedQuantity ) AS OpenQuantity,
  ( ( _PurchaseReqItem.RequestedQuantity - _PurchaseReqItem.OrderedQuantity )* _PurchaseReqItem.PurchaseRequisitionPrice ) AS PurReqnNetAmount,
  _PurchaseReqItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  _PurchaseReqItem.DeliveryDate AS DeliveryDate
FROM I_MPProcurementStructure
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]
LEFT OUTER JOIN I_ReleaseCodeText AS _ReleaseCodeText ON releasecode = _ReleaseCodeText.ReleaseCode  -- association [0..*]
LEFT OUTER JOIN I_SupplierOrAddressContactCard AS _SupplierHeadOffice ON ( _SupplierHeadOffice.ContactCardType = 'Supplier' AND _SupplierHeadOffice.ContactCardID = Supplier AND _SupplierHeadOffice.ContactCardRole = 'Supplier' )  -- association [1..1]
;

Learn More