P_MPStructureElement

@AbapCatalog.sqlViewName: 'PMPSTRELM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MPStructureElement as

select from I_MstrProjStrctrElmntWBC as StructureElement1
  left outer join I_SDItemOrganization     as SalesOrg on StructureElement1.ObjectInternalID = SalesOrg.WBSElement
{
  key StructureElement1.MasterProject,
  StructureElement1.MasterProjectUUID,
  StructureElement1.MasterProjectName,
  StructureElement1.MasterProjectType,
  StructureElement1.MasterProjectIsConfidential,
  StructureElement1.MasterProjectOrganization,
  StructureElement1.WBSElementIsBillingElement,
  StructureElement1.UserIsInvolved,
//  SalesOrg.SalesDocumentItemText                                                                          as ControllingObjectDescription,

//  CONCAT(CONCAT(SalesOrg.SalesDocument, '-'), SalesOrg.SalesDocumentItem)                                 as ControllingObject,

//  CONCAT(CONCAT(SalesOrg.SalesDocument, '-'), SalesOrg.SalesDocumentItem)                                 as ControllingObjectExternalID,

//  cast('SOI' as /cpd/pws_ws_mp_rel_obj)                                                                   as ControllingObjectType,


StructureElement1.ControllingObjectDescription,
  cast(StructureElement1.ControllingObject as abap.char(34))                                                                                     as ControllingObject,
  cast(StructureElement1.ControllingObjectExternalID as abap.char(34))                                                                           as ControllingObjectExternalID,
  cast(StructureElement1.ControllingObjectType as /cpd/pws_ws_mp_rel_obj)                                                                        as ControllingObjectType,

  SalesOrg.SalesDocument,
  SalesOrg.SalesDocumentItem,
  SalesOrg.SDDocumentCategory

}
where
      SalesOrg.SalesDocument                       is not null


union select from I_MasterProjectItemList as MPItem
  inner join      I_SDItemOrganization    as SDItem on MPItem.MasterProjectItem = SDItem.SalesDocument
{
  key MPItem.MasterProject,
  MPItem.MasterProjectUUID,
  MPItem.MasterProjectName,
  MPItem.MasterProjectType,
  MPItem.MasterProjectIsConfidential,
  MPItem.MasterProjectOrganization,
  cast('' as ps_fakkz preserving type )                                                                                      as WBSElementIsBillingElement,
  MPItem.UserIsInvolved,
  SDItem.SalesDocumentItemText                                                                                               as ControllingObjectDescription,
  cast(SDItem.SalesDocument  as abap.char(34))                                                                               as ControllingObject,
  cast(SDItem.SalesDocument  as abap.char(34))                                                                               as ControllingObjectExternalID,
  MPItem.MasterProjectItemObjectType                                                                                         as ControllingObjectType,
  SDItem.SalesDocument,
  SDItem.SalesDocumentItem,
  SDItem.SDDocumentCategory


}