P_MstrProjChklstReferenceDoc

DDL: P_MSTRPROJCHKLSTREFERENCEDOC SQL: PMPCHKLSTREFDOC Type: view COMPOSITE

P_MstrProjChklstReferenceDoc is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_OdOp, I_Project, I_WBSElement, I_OrderHeader, I_OrdMstrData) and exposes 9 fields with key field ControllingObject.

5 data source(s) 9 fields

Data Sources (5)

SourceAliasJoin Type
I_OdOp _OdOp union
I_Project _Project union
I_WBSElement _WBSElement from
I_OrderHeader OrderHeader left_outer
I_OrdMstrData OrdMstrData union

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PMPCHKLSTREFDOC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject I_WBSElement WBSElementObject
ObjectName I_WBSElement WBSDescription
ControllingObjectasControllingObject
ObjectName I_OrdMstrData OrderDescription
ProjectObjectasControllingObject
ObjectName I_Project ProjectDescription
NetworkActivityObjectasControllingObject
ObjectName I_OdOp NetworkActivityDescription
ControllingObjectExternalID 
@AbapCatalog.sqlViewName: 'PMPCHKLSTREFDOC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_MstrProjChklstReferenceDoc
  as select from I_WBSElement as _WBSElement
{
  key  _WBSElement.WBSElementObject as ControllingObject,
       _WBSElement.WBSDescription   as ObjectName,

       _WBSElement.WBSElement       as ControllingObjectExternalID
}

union select from I_OrdMstrData as OrdMstrData
{
  key OrdMstrData.ControllingObject               as ControllingObject,
      OrdMstrData.OrderDescription                as ObjectName,
      OrdMstrData.OrderID                         as ControllingObjectExternalID

}

union select from I_Project as _Project
{
  key  _Project.ProjectObject                as ControllingObject,
       _Project.ProjectDescription
                                             as ObjectName,
       _Project.Project                      as ControllingObjectExternalID
}

union select from I_OdOp        as _OdOp
  left outer join I_OrderHeader as OrderHeader on _OdOp.ProjectNetworkInternalID = OrderHeader.ProjectNetworkInternalID
{
  key _OdOp.NetworkActivityObject                                       as ControllingObject,
      _OdOp.NetworkActivityDescription                                  as ObjectName,


      concat(OrderHeader.OrderID, concat('-', _OdOp.NetworkActivity))   as ControllingObjectExternalID
      // OrderHeader.OrderID               as ControllingObjectExternalID

}

Learn More