I_CostCenterForCompanyCode

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.sqlViewName: 'IFICCTRBUKRS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost Center For Company Code'

@Analytics.dataCategory: #DIMENSION

@ObjectModel.representativeKey: 'CostCenter'

@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations: [ '_UserRespContactCard', '_UserCrtedContactCard' ]

@Metadata.allowExtensions: true

@VDM.viewType: #BASIC

@ObjectModel.usageType: {
  dataClass: #ORGANIZATIONAL,
  serviceQuality: #A,
  sizeCategory: #L
}

@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Consumption.filter.businessDate.at: true

define view I_CostCenterForCompanyCode as select from I_CostCenter 

association [1..1] to I_CostCenter              as _CostCenter            on  $projection.ControllingArea = _CostCenter.ControllingArea
                                                                          and $projection.CostCenter    = _CostCenter.CostCenter
                                                                          and $projection.ValidityEndDate = _CostCenter.ValidityEndDate
                                                                              
association [1..1] to E_CostCenter               as _Extension            on  $projection.ControllingArea = _Extension.ControllingArea
                                                                          and $projection.CostCenter      = _Extension.CostCenter
                                                                          and $projection.ValidityEndDate = _Extension.ValidityEndDate

{
@ObjectModel.foreignKey.association: '_CompanyCode'
key I_CostCenter.CompanyCode, 

@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #HIGH
@ObjectModel.text.association: '_Text'
@ObjectModel.hierarchy.association: '_CostCenterHierarchyNode'
key I_CostCenter.CostCenter,
 
@Semantics.businessDate.to: true 
key I_CostCenter.ValidityEndDate, 

@ObjectModel.foreignKey.association: '_ControllingArea'
I_CostCenter.ControllingArea, 
@Semantics.businessDate.from: true
I_CostCenter.ValidityStartDate, 
I_CostCenter.IsBlkdForPrimaryCostsPosting, 
I_CostCenter.IsBlockedForPlanPrimaryCosts, 
@ObjectModel.foreignKey.association: '_BusinessArea'
I_CostCenter.BusinessArea, 
@ObjectModel.foreignKey.association: '_CostCenterCategory'
I_CostCenter.CostCenterCategory, 
I_CostCenter.CostCtrResponsiblePersonName, 
@ObjectModel.foreignKey.association: '_UserRespContactCard'
I_CostCenter.CostCtrResponsibleUser, 
@ObjectModel.foreignKey.association: '_Currency'
I_CostCenter.CostCenterCurrency, 
@ObjectModel.foreignKey.association: '_CostingSheetProcedure'
I_CostCenter.CostingSheet, 
I_CostCenter.TaxJurisdiction,
@ObjectModel.foreignKey.association: '_ProfitCenter' 
I_CostCenter.ProfitCenter, 
I_CostCenter.Plant, 
I_CostCenter.LogicalSystem, 
I_CostCenter.CostCenterCreationDate, 
@ObjectModel.foreignKey.association: '_UserCrtedContactCard'
I_CostCenter.CostCenterCreatedByUser, 
I_CostCenter.IsBlkdForSecondaryCostsPosting, 
I_CostCenter.IsBlockedForRevenuePosting, 
I_CostCenter.IsBlockedForCommitmentPosting, 
I_CostCenter.IsBlockedForPlanSecondaryCosts, 
I_CostCenter.IsBlockedForPlanRevenues, 
I_CostCenter.CostCenterAllocationMethod, 
I_CostCenter.ConsumptionQtyIsRecorded, 
I_CostCenter.Department, 
I_CostCenter.SubsequentCostCenter, 
I_CostCenter.ConditionUsage, 
I_CostCenter.ConditionApplication, 
I_CostCenter.CostCenterAccountingOverhead, 
@ObjectModel.foreignKey.association: '_Country'
I_CostCenter.Country, 
I_CostCenter.FormOfAddress, 
I_CostCenter.AddressName, 
I_CostCenter.AddressAdditionalName, 
I_CostCenter.CostCenterAddrName3, 
I_CostCenter.CostCenterAddrName4, 
I_CostCenter.CityName, 
I_CostCenter.District, 
I_CostCenter.StreetAddressName, 
I_CostCenter.POBox, 
I_CostCenter.PostalCode, 
I_CostCenter.POBoxPostalCode, 
@ObjectModel.foreignKey.association: '_Region'
I_CostCenter.Region, 
@ObjectModel.foreignKey.association: '_Language'
I_CostCenter.Language, 
I_CostCenter.TeleboxNumber, 
I_CostCenter.PhoneNumber1, 
I_CostCenter.PhoneNumber2, 
I_CostCenter.FaxNumber, 
I_CostCenter.TeletexNumber, 
I_CostCenter.TelexNumber, 
I_CostCenter.DataCommunicationPhoneNumber, 
I_CostCenter.CostCenterPrinterDestination, 
I_CostCenter.CostCenterStandardHierArea, 
I_CostCenter.CostCollector, 
I_CostCenter.CostCenterIsComplete, 
I_CostCenter.IsStatisticalCostCenter, 
I_CostCenter.ObjectInternalID, 
I_CostCenter.CostCenterFunction, 
I_CostCenter.CostCenterAlternativeFunction, 
@ObjectModel.foreignKey.association: '_FunctionalArea'
I_CostCenter.FunctionalArea, 

I_CostCenter.JointVenture, 
I_CostCenter.JointVentureRecoveryCode, 
I_CostCenter.JointVentureEquityType, 
I_CostCenter.JointVentureObjectType, 
I_CostCenter.JointVentureClass, 
I_CostCenter.JointVentureSubClass, 
I_CostCenter.BudgetCarryingCostCenter, 
I_CostCenter.AvailabilityControlProfile, 
I_CostCenter.AvailabilityControlIsActive, 
I_CostCenter.Fund, 
I_CostCenter.GrantID, 
I_CostCenter.FundIsFixAssigned, 
I_CostCenter.GrantIDIsFixAssigned, 
I_CostCenter.FunctionalAreaIsFixAssigned,
 
_CostCenter,
I_CostCenter._AvailabilityCtrlProfile, 
I_CostCenter._BusinessArea, 
I_CostCenter._CompanyCode, 
I_CostCenter._ControllingArea, 
I_CostCenter._CostCenterCategory, 
I_CostCenter._CostCenterHierarchyNode, 
I_CostCenter._CostingSheetProcedure, 
I_CostCenter._Country, 
I_CostCenter._Currency, 
I_CostCenter._FunctionalArea, 
I_CostCenter._Language, 
@Consumption.filter.businessDate.at: true          // ??????

I_CostCenter._ProfitCenter, 
I_CostCenter._Region, 
I_CostCenter._Text, 
I_CostCenter._UserCrtedContactCard, 
I_CostCenter._UserRespContactCard  
}