C_MasterProject

@AbapCatalog.sqlViewName: 'CMASTERPROJECT'
@AbapCatalog.compiler.compareFilter: true 
@VDM.viewType: #CONSUMPTION
//@OData.publish: true

@Search.searchable: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory:#XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.dbHints: [{dbSystem: #HDB,
                        hint:     'NO_RECOMPILE_WITH_SQL_PARAMETERS'}]
define view C_MasterProject
  with parameters
    @Consumption.hidden : true
    @Environment.systemField : #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from           I_MasterProject     as MPList
    left outer to one join I_MasterProjectUser as MstrProjUser on MPList.MasterProject = MstrProjUser.MasterProject
    left outer join        I_FinancialPlanDates                on MPList.ProjectUUID = I_FinancialPlanDates.ProjectUUID
  association [1..1] to I_MstrProjUsrAuthList      as _MpAuthList on $projection.MasterProject = _MpAuthList.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..*] to I_Mpstagenexttext          as _MasterProjectStages       on  $projection.masterprojectstageprofile = _MasterProjectStages.MasterProjectStageProfile
                                                                                 and $projection.MasterProjectStage        = _MasterProjectStages.EngagementProjectStage
  association [0..1] to I_Customer                 as _Customer                  on  $projection.Customer = _Customer.Customer
  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 _OverallRisk               on  $projection.OverallRisk = _OverallRisk.ProjectRisk
  association [0..*] 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..*] to I_Mpattachment             as _Attachments               on  $projection.MasterProjectUUID = _Attachments.MasterProjectUUID

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

  association [0..1] to I_MstrProjManager          as _Manager                   on  $projection.MasterProjectUUID = _Manager.MasterProjectUUID
  association [0..*] to C_MPStatusItemDetails      as _MasterProjectStatus       on  $projection.MasterProjectUUID = _MasterProjectStatus.MasterProjectUUID
  association [0..1] to I_User                     as _User                      on  $projection.CreatedByUser = _User.UserID
  association [0..1] to C_MasterProjectBasicData   as _BasicData                 on  $projection.MasterProject = _BasicData.MasterProject
  association [0..*] to C_MstrProjKeyMember as _MstrProjTeamMemberID   on $projection.MasterProject = _MstrProjTeamMemberID.MasterProject
  association [0..*] to C_MPInvoiceWOSO as _CustomerInvoice on $projection.MasterProject = _CustomerInvoice.MasterProject
  association [0..*] to I_MPUnbilledRevenu as _UnbilledRevnInCtrlArCrcy on $projection.MasterProject = _UnbilledRevnInCtrlArCrcy.MasterProject
  association [1..*] to I_MstrProjWBSElement as _StructureElements on $projection.MasterProject = _StructureElements.MasterProject
  association [0..1] to I_WorkforcePerson as _EmployeeInternalID on $projection.ProjectManager = _EmployeeInternalID.Person           //HR Decoupling

  association [0..*] to C_MasterProjectActivity          as _ProjectActivity             on  $projection.MasterProjectUUID = _ProjectActivity.MasterProjectUUID
{

      //--[ GENERATED:012:E6ExH29r7kY4i74kMOlQIW

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

      @ObjectModel.text.element: 'MasterProjectName'
      @ObjectModel: {foreignKey.association: '_MasterProject'}
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
  key MPList.MasterProject                                                                                                                                                                                               as  MasterProject,
      MPList.MasterProjectUUID,
    //  MPList.MasterProjectUUID_E,

      MPList.ProjectUUID,

      @Semantics.text: true
      @Search.defaultSearchElement: true
      @UI.lineItem
      MPList.MasterProjectName                                                                                                                                                                                           as  MasterProjectName,

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

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

      @ObjectModel: {foreignKey.association: '_MasterProjectType'}
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
      MPList.MasterProjectType,
      cast(_MasterProjectType._Text[1:Language = $parameters.P_Language].MasterProjectTypeName as /cpd/cpm_mp_type_desc)                                                                                                 as  MasterProjectTypeName,

      @ObjectModel: {foreignKey.association: '_MasterProjectStage'}
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
      MPList.MasterProjectStage,
      cast(_MasterProjectStage._Text[1:Language = $parameters.P_Language].EngagementProjectStageText as /cpd/cpm_mpstage_desc)                                                                                           as  MasterProjectStageName,

      @UI: { selectionField }
      @UI.lineItem
      @Semantics.businessDate.from
      MPList.StartDate,

      @UI: { selectionField }
      @UI.lineItem
      @Semantics.businessDate.to
      MPList.EndDate,

      //--[ GENERATED:012:E6ExH29r7kY4i74kMOlQIW

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

      @ObjectModel: {foreignKey.association: '_Customer'}
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
      MPList.Customer,
      cast(_Customer.CustomerName as /cpd/cpm_customer)                                                                                                                                                                  as CustomerName,
      @Semantics.eMail.address
      _Customer._StandardAddress._DefaultEmailAddress.EmailAddress,
      @Semantics.telephone.type: [#CELL]
      cast(_Customer._StandardAddress._DefaultMobilePhoneNumber.PhoneNumber as /cpd/cpm_custmobno)                                                                                                                       as  MobilePhoneNumber,
      @Semantics.telephone.type: [#WORK, #PREF]
      cast(_Customer._StandardAddress._DefaultPhoneNumber.PhoneNumber as /cpd/cpm_custcontactno)                                                                                                                         as  PhoneNumber,

      //--[ GENERATED:012:E6ExH29r7kY4i74kMOlQIW

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

      @ObjectModel: {foreignKey.association: '_MasterProjectOrganization'}
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
      MPList.MasterProjectOrganization                                                                                                                                                                                   as  MasterProjectOrganization,
      cast(_MasterProjectOrganization._Text[1:Language = $parameters.P_Language].EngmtProjectServiceOrgName as /cpd/cpm_comlprojorgname)                                                                                 as  MasterProjectOrganizationName,
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
      MPList.MasterProjectIsConfidential                                                                                                                                                                                 as  MasterProjectIsConfidential,

      @ObjectModel: {foreignKey.association: '_Country'}
      @UI: { selectionField }
      @UI.lineItem
      @UI.textArrangement: #TEXT_ONLY
      @Search.defaultSearchElement: true
      MPList.Country,

      @ObjectModel: {foreignKey.association: '_Region'}
      @UI: { selectionField }
      @UI.lineItem
      @UI.textArrangement: #TEXT_ONLY
      @Search.defaultSearchElement: true
      MPList.Region,

      @ObjectModel: {foreignKey.association: '_WorkType'}
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
      MPList.WorkType,

      @ObjectModel: {foreignKey.association: '_Industry'}
      @UI: { selectionField }
      @UI.lineItem
      @Search.defaultSearchElement: true
      MPList.Industry,

      @ObjectModel: {foreignKey.association: '_ProjectRisk'}
      @UI: { selectionField }
      @UI.lineItem
      @UI.textArrangement: #TEXT_ONLY
      @Search.defaultSearchElement: true
      MPList.ProjectRisk,

      @ObjectModel: {foreignKey.association: '_FinancialRisk'}
      @UI: { selectionField }
      @UI.lineItem
      @UI.textArrangement: #TEXT_ONLY
      @Search.defaultSearchElement: true
      MPList.FinancialRisk,

      @ObjectModel: {foreignKey.association: '_TechnicalRisk'}
      @UI: { selectionField }
      @UI.lineItem
      @UI.textArrangement: #TEXT_ONLY
      @Search.defaultSearchElement: true
      MPList.TechnicalRisk,

      @ObjectModel: {foreignKey.association: '_OverallRisk'}
      @UI: { selectionField }
      @UI.lineItem
      @UI.textArrangement: #TEXT_ONLY
      @Search.defaultSearchElement: true
      MPList.OverallRisk                                                                                                                                                                                                 as  OverallRisk,

      @UI: { selectionField }
      @UI.lineItem
      MPList.InternalInspectionDate                                                                                                                                                                                      as  InternalInspectionDate,
      @UI: { selectionField }
      @UI.lineItem
      MPList.ExternalInspectionDate                                                                                                                                                                                      as  ExternalInspectionDate,
      @UI: { selectionField }
      @UI.lineItem
      MPList.CreatedByUser,
      //      @UI: { selectionField }

      //      @UI.lineItem

      //      MPList.CreatedBy,

      @UI.lineItem
      cast(MPList.ProjectLastChangedDateTime as abap.dec( 15, 0 ))                                                                                                                                                       as  ProjectLastChangedDateTime,
      //      cast(MPList.ProjectLastChangedDateTime as abap.dec( 15, 0 ))                                                                                                                                                       as  ChangedOn,


      MPList.ChangedBy                                                                                                                                                                                                   as  ChangedBy,
      @UI.hidden: true
      @Consumption.hidden: true
      MPList.CreationDateTime,
      cast(_MasterProjectType.CntctPersnIsManuallyCreated as /cpd/cpm_isuser_satatus)                                                                                                                                    as  CntctPersnIsManuallyCreated,
      _MasterProjectType.MasterProjectStageProfile,

      ltrim(MPList.ProjectManager,'0') as BusinessPartner,

      @UI.hidden: true
      @Consumption.hidden: true
      MPList.ProjectManager as ProjectManagerName, //Not Used in UI


      cast(MPList._ProjectManager.BusinessPartnerFullName as /cpd/cpm_proj_manager) as ProjectManager,
      //      @Consumption.hidden : true

      I_FinancialPlanDates.MstrProjFinancialPlanUUID,
      I_FinancialPlanDates.FinancialPlanScenario,

      @UI: { selectionField }
      @UI.lineItem
      @Semantics.businessDate.from
      cast (I_FinancialPlanDates.FinancialPlanStartDate as /cpd/financial_start_date )                                                                                                                                   as  FinancialPlanStartDate,

      @UI: { selectionField }
      @UI.lineItem
      @Semantics.businessDate.to
      cast (I_FinancialPlanDates.FinancialPlanEndDate as /cpd/financial_end_date )                                                                                                                                       as  FinancialPlanEndDate,

       MPList._Employee,
      _MpAuthList,
      _MasterProjectType,
      _MasterProjectStage,
      _Customer,
      _MasterProjectOrganization,
      _Country,
      _Region,
      _Industry,
      _ProjectRisk,
      _FinancialRisk,
      _TechnicalRisk,
      _OverallRisk,
      _ContactPerson,
      _MasterProject,
      _WorkType,
      _Attachments,
      _Manager,
      _MasterProjectStatus,
      _MasterProjectStages,
      _BasicData,
      _MstrProjTeamMemberID,
      _CustomerInvoice,
      _UnbilledRevnInCtrlArCrcy,
      _StructureElements,
      _EmployeeInternalID,
      _ProjectActivity


}