P_ENTSIMILARPROJBSCDATAUNION

@AbapCatalog.sqlViewName: 'PEPSMRPROJUN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@UI.presentationVariant.sortOrder.by: 'ObjectIndicator'
@UI.presentationVariant.sortOrder.direction: #ASC
@UI.headerInfo: {
  typeName:         'Similar Project',
  typeNamePlural:   'Similar Projects',
  title:            { type: #STANDARD, value: 'SimilarProject' },
  description:      { type: #STANDARD, value: 'SimilarProjectDescription' }
}
@ObjectModel: {
    usageType: {
       serviceQuality:  #D,
       dataClass:       #MIXED,
       sizeCategory:    #XL
   }
}
define view P_EntSimilarProjBscDataUnion
 as select from I_EntProjSimilarProjData as _ProjBscData
  association [0..1] to I_EnterpriseProject as _TargetProject  on _ProjBscData.ProjectUUID = _TargetProject.ProjectUUID
  association [0..1] to I_EnterpriseProject as _SimilarProject on _ProjBscData.SimilarProjectUUID = _SimilarProject.ProjectUUID
{
      @UI.hidden:true
  key _ProjBscData.ProjectUUID,
      @UI.hidden:true
  key _ProjBscData.SimilarProjectUUID,
      @UI.hidden:true
      cast(_TargetProject.ProjectInternalID as ps_intnr)                                                             as  ProjectInternalID,
      @UI.hidden:true
      cast(_SimilarProject.ProjectInternalID as ps_intnr)                                                            as  SimilarProjectInternalID,
      @UI.hidden:true
      cast('' as ps_pspid)                                                                               as  Project,
      @UI.hidden:true
      @ObjectModel.text.element: ['SimilarProjectDescription']
      @UI.textArrangement: #TEXT_FIRST
      cast('' as ps_pspid)                                                                               as  SimilarProject,
      @UI.hidden:true
      _ProjBscData.ProjPredictedSimilarityValue*100                                                      as  ProjPredictedSimilarityValue,
      @UI.hidden:true
      _ProjBscData.ProjectPredictedFactor,
      @UI.lineItem: {position: 70}
      @EndUserText: { label: 'Planned Start', quickInfo: 'Planned Start Date' }
      cast( '19000101' as /s4ppm/tv_startdate )                                                          as  PlannedStartDate,
      @UI.lineItem: {position: 80}
      @EndUserText: { label: 'Planned End', quickInfo: 'Planned End Date' }
      cast( '19000101' as /s4ppm/tv_enddate )                                                            as  PlannedEndDate,
      @UI.hidden:true
      cast( '' as ps_s4_proj_post1_v1 )                                                                  as  SimilarProjectDescription,
      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      @UI.lineItem: {position: 60}
      @EndUserText: { label: 'Actual Costs in Global Currency', quickInfo: 'Actual Costs in Global Currency' }
      cast(0  as fis_ksl)                                                                                as  ActualAmountInGlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      @UI.lineItem: {position: 60}
      @EndUserText: { label: 'Planning Category Costs in Global Currency', quickInfo: 'Planning Category Costs in Global Currency' }
      cast(0  as fis_ksl)                                                                                as  PlanAmountInGlobalCurrency,
      @Semantics.currencyCode: true
      @UI.hidden:true
      cast('' as fis_rkcur )                                                                             as  GlobalCurrency,
      @EndUserText: { label: 'Responsible Cost Center', quickInfo: 'Responsible Cost Center' }
      cast('' as ps_fkstl)                                                                               as  ResponsibleCostCenter,
      cast('' as fis_bukrs)                                                                              as  CompanyCode,
      cast('' as kokrs )                                                                                 as  ControllingArea,
      cast('' as prctr)                                                                                  as  ProfitCenter,
      cast('' as fkber )                                                                                 as  FunctionalArea,
      @EndUserText: { label: 'Project Duration(Days)', quickInfo: 'Project Planned Duration' }
      cast(0 as numberofdays)                                                                            as  PlannedDuration,
      @EndUserText: { label: 'Team Member Count', quickInfo: 'Team Member Count' }
      0                                                                                                  as  TeamMemberCount,
      @UI.hidden:true
      cast( 'None' as abap.char(11) )                                                                    as  ObjectIndicator,
      @UI.hidden:true
      cast(_ProjBscData.ProjectUUID as bu_partner_guid)                                                  as  BusinessPartnerUUID,
      @UI.hidden:true
      @EndUserText: { label: 'Project Manager', quickInfo: 'Project Manager' }
      cast('' as ad_namtext)                                                                             as  BusinessPartnerFullName




}
union select from I_EntProjSimilarProjData as _ProjBscData
association [0..1] to I_EnterpriseProject as _TargetProject on _ProjBscData.ProjectUUID = _TargetProject.ProjectUUID
{
      @UI.hidden:true
  key _ProjBscData.ProjectUUID,
      @UI.hidden:true
  key _ProjBscData.ProjectUUID                                                                                                                                          as  SimilarProjectUUID,
      @UI.hidden:true
      cast(_TargetProject.ProjectInternalID as ps_intnr)                                                                                                                            as  ProjectInternalID,
      @UI.hidden:true
      cast(_TargetProject.ProjectInternalID as ps_intnr)                                                                                                                            as  SimilarProjectInternalID,
      @UI.hidden:true
      cast('' as ps_pspid)                                                                                                                                              as  Project,
      @UI.hidden:true
      @ObjectModel.text.element: ['SimilarProjectDescription']
      @UI.textArrangement: #TEXT_FIRST
      cast('' as ps_pspid)                                                                                                                                              as  SimilarProject,
      @UI.hidden:true
      100                                                                                                                                                               as  ProjPredictedSimilarityValue,
      @UI.hidden:true
      0                                                                                                                                                                 as  ProjectPredictedFactor,
      @UI.lineItem: {position: 70}
      @EndUserText: { label: 'Planned Start', quickInfo: 'Planned Start Date' }
      cast( '19000101' as /s4ppm/tv_startdate )                                                                                                                         as  PlannedStartDate,
      @UI.lineItem: {position: 80}
      @EndUserText: { label: 'Planned End', quickInfo: 'Planned End Date' }
      cast( '19000101' as /s4ppm/tv_enddate )                                                                                                                           as  PlannedEndDate,
      @UI.hidden:true
      cast( '' as ps_s4_proj_post1_v1 )                                                                                                                                 as  SimilarProjectDescription,
      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      @UI.lineItem: {position: 60}
      @EndUserText: { label: 'Actual Costs in Global Currency', quickInfo: 'Actual Costs in Global Currency' }
      cast(0  as fis_ksl)                                                                                                                                               as  ActualAmountInGlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      @UI.lineItem: {position: 60}
      @EndUserText: { label: 'Planning Category Costs in Global Currency', quickInfo: 'Planning Category Costs in Global Currency' }
      cast(0  as fis_ksl)                                                                                                                                               as  PlanAmountInGlobalCurrency,
      @Semantics.currencyCode: true
      @UI.hidden:true
      cast('' as fis_rkcur )                                                                                                                                            as  GlobalCurrency,
      @EndUserText: { label: 'Responsible Cost Center', quickInfo: 'Responsible Cost Center' }
      cast('' as ps_fkstl)                                                                                                                                              as  ResponsibleCostCenter,
      cast('' as fis_bukrs)                                                                                                                                             as  CompanyCode,
      cast('' as kokrs )                                                                                                                                                as  ControllingArea,
      cast('' as prctr)                                                                                                                                                 as  ProfitCenter,
      cast('' as fkber )                                                                                                                                                as  FunctionalArea,
      @EndUserText: { label: 'Project Duration(Days)', quickInfo: 'Project Planned Duration' }
      cast(0 as numberofdays)                                                                                                                                           as  PlannedDuration,
      @EndUserText: { label: 'Team Member Count', quickInfo: 'Team Member Count' }
      0                                                                                                                                                                 as  TeamMemberCount,
      @UI.hidden:true
      cast( 'Information' as abap.char(11) )                                                                                                                            as  ObjectIndicator,
      @UI.hidden:true
      cast(_ProjBscData.ProjectUUID as bu_partner_guid)                                                                                                                 as  BusinessPartnerUUID,
      @UI.hidden:true
      @EndUserText: { label: 'Project Manager', quickInfo: 'Project Manager' }
      cast('' as ad_namtext)                                                                                                                                            as  BusinessPartnerFullName


}