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.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
}    
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECT",
"P_PROJECTCOSTOBJECT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/