P_MSTRPROJSTRUCTURE

@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.OrderID,
  ProjCostObj.NetworkActivity,
  ProjCostObj.ControllingObjectCurrency,
  ProjCostObj.WBSElementObject,
  ProjCostObj.WBSElement,
  ProjCostObj.ObjectSource as ObjectSource
}
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,
  cast('' as abap.numc( 10 )) as OrderID,
  cast('' as abap.char( 4 ))  as NetworkActivity,
  //Project.Project           as ControllingObjectExternalID,

  //'PD'                       as ControllingObjectType,

  Project.Currency  as ControllingObjectCurrency,
  cast('' as ps_s4_objnr)    as WBSElementObject,
  cast('' as ps_posid)       as WBSElement,
  cast('PRJ' as abap.char(3))   as ObjectSource
}