P_MSTRPROJSTRUCTURE

CDS View

Master Project Structure Elements

P_MSTRPROJSTRUCTURE is a CDS View in S/4HANA. Master Project Structure Elements. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MstrProjStructure view inner COMPOSITE Master Project Structure Element

Fields (7)

KeyField CDS FieldsUsed in Views
ControllingObject ControllingObject 1
ControllingObjectCurrency ControllingObjectCurrency 1
ControllingObjectExternalID ControllingObjectExternalID 1
ObjectInternalID ObjectInternalID 1
ObjectName ObjectName 1
WBSElement WBSElement 1
WBSElementObject WBSElementObject 1 
@AbapCatalog.sqlViewName: 'PPROJSTRUCT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_MstrProjStructure
  as select from P_ProjectCostObject as ProjCostObj
{
  ProjCostObj.Project,
  ProjCostObj.ProjectDescription,
  ProjCostObj.BusinessArea,
  ProjCostObj.CompanyCode,
  ProjCostObj.ControllingArea,

  ProjCostObj.ObjectInternalID,
  ProjCostObj.WBSDescription1   as ObjectName,
  ProjCostObj.ControllingObject as ControllingObject,
  ProjCostObj.Object            as ControllingObjectExternalID,
  ProjCostObj.ObjectType        as ControllingObjectType,
  ProjCostObj.ControllingObjectCurrency,
  ProjCostObj.WBSElementObject,
  ProjCostObj.WBSElement

}
union select from I_Project as Project
{
  Project.Project,
  Project.ProjectDescription,
  Project.BusinessArea,
  Project.CompanyCode,
  Project.ControllingArea,
  cast('' as ps_posnr)       as ObjectInternalID,
    Project.ProjectDescription as ObjectName,
  Project.ProjectObject      as ControllingObject,
  Project.Project            as ControllingObjectExternalID,
  'PD'                       as ControllingObjectType,
  Project.Currency  as ControllingObjectCurrency,
  cast('' as ps_s4_objnr)    as WBSElementObject,
  cast('' as ps_posid)       as WBSElement
}

Learn More