I_MstrProjPurOrdItemSimple

DDL: I_MSTRPROJPURORDITEMSIMPLE SQL: IMPPOITMSIMPLE Type: view COMPOSITE

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.

3 data source(s) 10 fields

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
KEY ProjectUUID I_MstrProjItmProjStrucNode ProjectUUID
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem
PurchaseRequisition I_PurchaseOrderItem PurchaseRequisition
PurchaseRequisitionItem I_PurchaseOrderItem PurchaseRequisitionItem
Project I_MstrProjItmProjStrucNode Project
ProjectObject I_MstrProjItmProjStrucNode ProjectObject
ControllingObjectExternalID I_MstrProjItmProjStrucNode ControllingObjectExternalID
DeliveryDate 
@AbapCatalog.sqlViewName: 'IMPPOITMSIMPLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Simplified PO Items for Master Project'
@AccessControl.personalData.blocking: #REQUIRED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_MstrProjPurOrdItemSimple as select from I_MstrProjItmProjStrucNode as MasterProject
    inner join  I_PurgDocAccountAssignment as PurchasingDocument on PurchasingDocument.WBSElementInternalID          =  MasterProject.WBSElementInternalID
                                                                            or (
                                                                               PurchasingDocument.ProjectNetworkInternalID      =  MasterProject.ProjectNetworkInternalID
                                                                               and PurchasingDocument.NetworkActivityInternalID =  MasterProject.NetworkActivityInternalID
                                                                             )
                                                                            or (
                                                                               MasterProject.ProjectNetwork                     =  PurchasingDocument.ProjectNetwork
                                                                               and PurchasingDocument.ProjectNetwork            <> ''
                                                                               and MasterProject.NetworkActivity                =  ''
                                                                               and PurchasingDocument.NetworkActivityInternalID =  '00000000'
                                                                               and PurchasingDocument.WBSElementInternalID      =  '00000000'
                                                                             )


    inner join             I_PurchaseOrderItem        as PurchaseOrder      on  PurchasingDocument.PurchasingDocument     = PurchaseOrder.PurchaseOrder
                                                                            and PurchasingDocument.PurchasingDocumentItem = PurchaseOrder.PurchaseOrderItem
    association [0..1] to I_PurgDocScheduleLine          as _ScheduleLine   on  $projection.PurchaseOrder     = _ScheduleLine.PurchasingDocument  
                                                                            and $projection.PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem
                                                                            
  {
   key MasterProject.MasterProject,
   key MasterProject.ProjectUUID,
   key PurchaseOrder.PurchaseOrder,
   key PurchaseOrder.PurchaseOrderItem,
       PurchaseOrder.PurchaseRequisition,
       PurchaseOrder.PurchaseRequisitionItem,
       MasterProject.Project,
       MasterProject.ProjectObject,
       MasterProject.ControllingObjectExternalID,
       cast( _ScheduleLine.ScheduleLineDeliveryDate as dats) as  DeliveryDate


} where PurchaseOrder.IsCompletelyDelivered <> 'X' and PurchaseOrder.PurchasingDocumentDeletionCode <> 'L' and PurchaseOrder.OrderQuantity > 0 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MSTRPROJITMPROJSTRUCNODE",
"I_PURCHASEORDERITEM",
"I_PURGDOCACCOUNTASSIGNMENT",
"I_PURGDOCSCHEDULELINE"
],
"ASSOCIATED":
[
"I_PURGDOCSCHEDULELINE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More