I_MstrProjPurOrdItemSimple

DDL: I_MSTRPROJPURORDITEMSIMPLE SQL: IMPPOITMSIMPLE Type: view COMPOSITE
10 Fields 3 Data Sources 1 Associations

Simplified PO Items for Master Project

I_MstrProjPurOrdItemSimple is a Composite CDS View that provides data about "Simplified PO Items for Master Project" in SAP S/4HANA. It reads from 3 data sources (I_MstrProjItmProjStrucNode, I_PurchaseOrderItem, I_PurgDocAccountAssignment) and exposes 10 fields with key fields MasterProject, ProjectUUID, PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_MstrProjItmProjStrucNode MasterProject from
I_PurchaseOrderItem PurchaseOrder inner
I_PurgDocAccountAssignment PurchasingDocument inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurgDocScheduleLine _ScheduleLine $projection.PurchaseOrder = _ScheduleLine.PurchasingDocument and $projection.PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem

Annotations (12)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MstrProjItmProjStrucNode MasterProject Project ID
KEY ProjectUUID I_MstrProjItmProjStrucNode ProjectUUID Project UUID
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseRequisition I_PurchaseOrderItem PurchaseRequisition Requisition
PurchaseRequisitionItem I_PurchaseOrderItem PurchaseRequisitionItem Requisn. item
Project I_MstrProjItmProjStrucNode Project WBS Element
ProjectObject I_MstrProjItmProjStrucNode ProjectObject Object number
ControllingObjectExternalID I_MstrProjItmProjStrucNode ControllingObjectExternalID WBS Element
DeliveryDate

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_MstrProjPurOrdItemSimple.
-- 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: IMPPOITMSIMPLE

CREATE VIEW I_MstrProjPurOrdItemSimple AS
SELECT
  MasterProject.MasterProject AS MasterProject,
  MasterProject.ProjectUUID AS ProjectUUID,
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  PurchaseOrder.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrder.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrder.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  MasterProject.Project AS Project,
  MasterProject.ProjectObject AS ProjectObject,
  MasterProject.ControllingObjectExternalID AS ControllingObjectExternalID,
  cast( _ScheduleLine.ScheduleLineDeliveryDate as dats) AS DeliveryDate
FROM I_MstrProjItmProjStrucNode AS MasterProject
INNER JOIN I_PurgDocAccountAssignment AS PurchasingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrderItem AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocScheduleLine AS _ScheduleLine ON PurchaseOrder = _ScheduleLine.PurchasingDocument AND PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem  -- association [0..1]
;

Learn More