I_Mpfilterfields

@AbapCatalog.sqlViewName: 'IMPFILTER'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.dataCategory: #VALUE_HELP
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Master Project Filter Fields'
@VDM.viewType: #COMPOSITE
@Consumption.ranked: true
define view I_Mpfilterfields
  as select from           I_MasterProject     as MP
    left outer to one join I_MasterProjectUser as MstrProjUser on MP.MasterProject = MstrProjUser.MasterProject
  association [0..1] to I_MasterProjectType          as _MasterProjectType         on  $projection.MasterProjectType = _MasterProjectType.MasterProjectType
  association [0..1] to I_EngagementProjectStage     as _MasterProjectStage        on  $projection.MasterProjectStage = _MasterProjectStage.EngagementProjectStage
  association [0..1] to I_Customer                   as _Customer                  on  $projection.Customer = _Customer.Customer
  association [0..1] to I_MstrProjBusPartnerByRoleVH as _BusinessPartner           on  $projection.BusinessPartner           = _BusinessPartner.BusinessPartner
                                                                                   and _BusinessPartner.BusinessPartnerRole = 'BUP003'
  association [0..1] to I_EngagementProjectSrvcOrg   as _MasterProjectOrganization on  $projection.MasterProjectOrganization = _MasterProjectOrganization.EngagementProjectServiceOrg
  association [0..1] to I_Country                    as _Country                   on  $projection.Country = _Country.Country
  association [0..1] to I_Region                     as _Region                    on  $projection.Country = _Region.Country
                                                                                   and $projection.Region  = _Region.Region
  association [0..1] to I_CpdIndustry                as _Industry                  on  $projection.Industry = _Industry.Industry
  //  association [0..1] to I_Cpdprojectrisk           as _ProjectRisk               on  $projection.projectrisk = _ProjectRisk.ProjectRisk

  association [0..1] to I_Cpdfinancialrisk           as _FinancialRisk             on  $projection.FinancialRisk = _FinancialRisk.FinancialRisk
  association [0..1] to I_Cpdtechnicalrisk           as _TechnicalRisk             on  $projection.TechnicalRisk = _TechnicalRisk.TechnicalRisk
  association [0..1] to I_Cpdprojectrisk             as _ProjectRisk               on  $projection.ProjectRisk = _ProjectRisk.ProjectRisk
  //  association [0..1] to I_Cpdprojectrisk           as _OverallRisk               on  $projection.OverallRisk = _OverallRisk.ProjectRisk

  //  association [1..*] to I_MPContactPerson          as _ContactPerson             on  $projection.MasterProjectUUID = _ContactPerson.MasterProjectUUID

  association [0..1] to I_MasterProjectVH            as _MasterProject             on  $projection.MasterProject = _MasterProject.MasterProject
  association [0..1] to I_Cpdworktype                as _WorkType                  on  $projection.WorkType = _WorkType.WorkType
  //association [0..1] to I_UserContactCard            as _User                      on  $projection.CreatedByUser = _User.ContactCardID            //SAP Note 3497295

  association [0..1] to E_MasterProject              as _Extension                 on  $projection.MasterProjectUUID = _Extension.MasterProjectUUID
{


      //  association [0..*] to C_MPStatusItemDetails      as _EngagementProjectStatus   on  $projection.MasterProject = _EngagementProjectStatus.MasterProject

      //--[ GENERATED:012:E6ExH29r7kY4i74kMOlQIW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_MasterProjectStdVH',
                     element: 'MasterProject' }
        }]
      // ]--GENERATED

      @ObjectModel: {foreignKey.association: '_MasterProject'}
      @Search.defaultSearchElement: true
      @UI: { selectionField }
  key MP.MasterProject,

      MP.MasterProjectUUID,
      
      MP.MasterProjectName,                                         //SAP Note 3497295          


      @ObjectModel: {foreignKey.association: '_MasterProjectType'}
      @UI: { selectionField }
      MP.MasterProjectType,

      @UI: { selectionField }
      @UI.lineItem
  //    @Search.defaultSearchElement: true  * ATC Error

      cast(case when MstrProjUser.UserID <> ''
               then 'X'
               end as  /cpd/cpm_isuser_satatus)                                                                                              as  IsUserStatus,

      @ObjectModel: {foreignKey.association: '_MasterProjectStage'}
      @UI: { selectionField }
      MP.MasterProjectStage,

      @UI: { selectionField }
      cast(MP.StartDate as /cpd/cpm_start_date)                                                                                              as  StartDate,

      @UI: { selectionField }
      cast(MP.EndDate as /cpd/cpm_end_date)                                                                                                  as  EndDate,

      //--[ GENERATED:012:E6ExH29r7kY4i74kMOlQIW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]
      // ]--GENERATED

      @ObjectModel: {foreignKey.association: '_Customer'}
      @UI: { selectionField }
      MP.Customer,


      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_MstrProjBusPartnerByRoleVH',
                    element: 'BusinessPartner' }
       }]
      // @ObjectModel.text.element: 'BusinessPartnerFullName'

      // @UI.lineItem

      @ObjectModel: {foreignKey.association: '_BusinessPartner'}
      @UI: { selectionField }
      @Consumption.valueHelp: '_BusinessPartner'
      cast(MP.ProjectManager as /cpd/cpm_proj_manager)                                                                                       as  BusinessPartner,//as  ProjectManager,


      //--[ GENERATED:012:E6ExH29r7kY4i74kMOlQIW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_EngmntProjSrvcOrgStdVH',
                     element: 'EngagementProjectServiceOrg' }
        }]
      // ]--GENERATED

      @ObjectModel: {foreignKey.association: '_MasterProjectOrganization'}
      @UI: { selectionField }
      MP.MasterProjectOrganization,

      @UI: { selectionField }
      cast ( MP.MasterProjectIsConfidential as /cpd/cpm_comlprojcofl )                                                                       as  MasterProjectIsConfidential,

      @ObjectModel: {foreignKey.association: '_Country'}
      @UI: { selectionField }
      MP.Country,

      @ObjectModel: {foreignKey.association: '_Region'}
      @UI: { selectionField }
      MP.Region,

      @ObjectModel: {foreignKey.association: '_WorkType'}
      @UI: { selectionField }
      MP.WorkType,

      @ObjectModel: {foreignKey.association: '_Industry'}
      @UI: { selectionField }
      MP.Industry,

      //MP.ProjectRisk,

      @ObjectModel: {foreignKey.association: '_FinancialRisk'}
      @UI: { selectionField }
      MP.FinancialRisk,

      @ObjectModel: {foreignKey.association: '_TechnicalRisk'}
      @UI: { selectionField }
      MP.TechnicalRisk,

      @ObjectModel: {foreignKey.association: '_ProjectRisk'}
      @UI: { selectionField }
      MP.ProjectRisk,

      //      @ObjectModel: {foreignKey.association: '_OverallRisk'}

      //      @UI: { selectionField }

      //      MP.OverallRisk,

      //

      //      MP.InspectionDate,


      //      @UI: { selectionField }

      //      MP.InternalInspectionDate,

      //

      //

      //      @UI: { selectionField }

      //      MP.ExternalInspectionDate,


      //@ObjectModel: {foreignKey.association: '_User'}

      @UI: { selectionField }
      MP.CreatedByUser,


      _Country,
      //_User,                                                          //SAP Note 3497295

      _Customer,
      _BusinessPartner,
      _WorkType,
      _MasterProject,
      _FinancialRisk,
      _Industry,
      _MasterProjectType,
      _MasterProjectStage,
      _MasterProjectOrganization,
      _ProjectRisk,
      //      _OverallRisk,

      _Region,
      //      _Region._Country,

      //      _Region._RegionText,

      _TechnicalRisk


}