I_MasterProjectSalesOrder

@AbapCatalog.sqlViewName: 'IMPSALESODR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Get MasterProject Sales Order'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
define view I_MasterProjectSalesOrder
  as select from I_MasterProjectItemList as MPItem
    inner join   I_SDItemOrganization    as SDItem on MPItem.MasterProjectItem = SDItem.SalesDocument
{
  @Search.defaultSearchElement: true
  SDItem.SalesDocument,
  SDItem.SalesDocumentItem,
  SDItem.WBSElement,
  SDItem.CompanyCode,
  SDItem.BusinessArea,
  SDItem.ControllingArea,
  SDItem.ControllingObject,
  SDItem.FiscalYear,
  MPItem.MasterProjectUUID,
  MPItem.MasterProject,
  MPItem.MasterProjectName,
  MPItem.MasterProjectType,
  MPItem.MasterProjectStage,
  MPItem.StartDate,
  MPItem.EndDate,
  MPItem.Customer,
  MPItem.MasterProjectOrganization,
  MPItem.MasterProjectIsConfidential,
  MPItem.Country,
  MPItem.Region,
  MPItem.WorkType,
  MPItem.Industry,
  MPItem.ProjectRisk,
  MPItem.FinancialRisk,
  MPItem.TechnicalRisk,
  MPItem.OverallRisk,
  // MPItem.UserID,

  //MPItem.Currency,

  MPItem.MasterProjectItemUUID,
  //MPItem.MstrProjParentkeyOfItem,

  MPItem.MasterProjectItemObjectType,
  MPItem.MasterProjectItem,
  MPItem.CreatedByUser,
  MPItem.CreationDateTime,
  MPItem.LastChangedByUser,
  MPItem.LastChangeDateTime,


  cast (' ' as abap.cuky( 5 ))                   as ControllingAreaCurrency,
  cast (' ' as abap.numc( 8 ))                   as WBSElementInternalID,
//  cast (' ' as abap.numc( 8 ))                   as ControllingObjectInternalID,

  cast (' ' as abap.numc( 8 ))                   as AccountAssignment,

  cast(' ' as abap.char( 22 ))                   as WBSElementObject,

  cast(' ' as abap.char( 34 ))                   as ExternalId
}