C_ProjectFinCtrlrOvw

@AbapCatalog: {
  sqlViewName: 'CPROJFINCTRLROVW',
  compiler.compareFilter: true,
  preserveKey:true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Project Financial Controller Overview'
@ObjectModel.usageType: {
  serviceQuality: #D,
  sizeCategory : #L,
  dataClass: #MASTER
}
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Search.searchable: false
@VDM: {
  lifecycle.contract.type: #NONE,
  viewType: #CONSUMPTION
}
@UI.headerInfo: {
  typeName: 'Project',
  typeNamePlural: 'Projects',
  title: {
    value: 'Project',
    type: #STANDARD
  }
}
define view C_ProjectFinCtrlrOvw
as select from I_ProjectBasicData as _ProjectBasicData
  left outer join I_PPM_ProjectSummaryTask as _PST on _ProjectBasicData.ProjectInternalID = _PST.ProjectInternalID
  association [1..1] to E_PPM_Project as _ProjectHeaderExtension on $projection.ProjectUUID = _ProjectHeaderExtension.ProjectUUID 
  {
@UI.selectionField.position: 10
@Consumption.valueHelpDefinition.entity: {
  name: 'C_EnterpriseProjectVH',
  element: 'Project'
}
@EndUserText.label: 'Project'
@EndUserText.quickInfo: ''
@Search: {
  defaultSearchElement: true,
  ranking: #HIGH,
  fuzzinessThreshold: 0.85
}
key _ProjectBasicData.Project,

@UI.hidden:true
@EndUserText.quickInfo: ''
_PST.ProjectUUID,

@Consumption.valueHelpDefinition.entity: {
  name: 'C_CompanyCodeValueHelpProj',
  element: 'CompanyCode'
}
@EndUserText.label: 'Company Code'
@EndUserText.quickInfo: ''
@UI.fieldGroup: {
  qualifier: 'moreFilters',
  groupLabel: 'Others'
}
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.85
}
_ProjectBasicData.CompanyCode,

@UI.hidden:true
@EndUserText.quickInfo: ''
cast('0' as fins_ledger) as Ledger,

@Consumption.valueHelpDefinition.entity: {
  name: 'C_ProjectManagerVH',
  element: 'BusinessPartner'
}
@EndUserText.label: 'Project Manager'
@EndUserText.quickInfo: ''
@UI: {
  fieldGroup: {
    qualifier: 'moreFilters',
    groupLabel: 'Others'
  },
  selectionField.position: 20
}
@Search: {
  defaultSearchElement: true,
  ranking: #HIGH,
  fuzzinessThreshold: 0.85
}
cast('0' as bu_partner) as BusinessPartner,

@Consumption.valueHelpDefinition.entity: {
  name: 'C_PrftCtrValHelp',
  element: 'ProfitCenter'
} 
@EndUserText.label: 'Profit Center'
@EndUserText.quickInfo: ''
@UI.fieldGroup: {
  qualifier: 'moreFilters',
  groupLabel: 'Others'
}
@Search: {
  defaultSearchElement: true,
  ranking: #HIGH,
  fuzzinessThreshold: 0.85
}
_ProjectBasicData.ProfitCenter,

@Consumption.valueHelpDefinition.entity: {
  name: 'C_ControllingAreaVH',
  element: 'ControllingArea'
}
@EndUserText.label: 'Controlling Area'
@EndUserText.quickInfo: ''
@UI.fieldGroup: {
  qualifier: 'moreFilters',
  groupLabel: 'Others'
}
@Search: {
  defaultSearchElement: true,
  ranking: #HIGH,
  fuzzinessThreshold: 0.85
}
_ProjectBasicData.ControllingArea,

//CE2005 Projecttype as a filter 

@Consumption.valueHelpDefinition.entity: {
  name: 'C_ProjectTypeVH',
  element: 'ProjectType'
}
@EndUserText.label: 'Project Type'
@EndUserText.quickInfo: ''
@UI.fieldGroup: {
  qualifier: 'moreFilters',
  groupLabel: 'Others'
}
@Search: {
  defaultSearchElement: true,
  ranking: #HIGH,
  fuzzinessThreshold: 0.85
}

cast('0' as ps_prart) as ProjectType,


@Consumption.valueHelpDefinition.entity: {
  name: 'C_CostCategoryVH',
  element: 'PlanningCategory'
}
@EndUserText.label: 'Planning Category'
@EndUserText.quickInfo: ''
@Search: {
  defaultSearchElement: true,
  ranking: #HIGH,
  fuzzinessThreshold: 0.85
}
cast('0' as fcom_category) as PlanningCategory

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTSUMMARYTASK",
"I_PROJECTBASICDATA"
],
"ASSOCIATED":
[
"E_PPM_PROJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/