I_CurrentCostCenter

DDL: I_CURRENTCOSTCENTER SQL: IFICURCOSTCENTER Type: view BASIC

Current Cost Center

I_CurrentCostCenter is a Basic CDS View (Dimension) that provides data about "Current Cost Center" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 92 fields with key fields ControllingArea, CostCenter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CostCenter I_CostCenter from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostCenterText _Text $projection.ControllingArea = _Text.ControllingArea and $projection.CostCenter = _Text.CostCenter

Annotations (15)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IFICURCOSTCENTER view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey CostCenter view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Current Cost Center view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (92)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea
KEY CostCenter CostCenter
IsBlkdForPrimaryCostsPosting IsBlkdForPrimaryCostsPosting
IsBlockedForPlanPrimaryCosts IsBlockedForPlanPrimaryCosts
CompanyCode CompanyCode
BusinessArea BusinessArea
CostCenterCategory CostCenterCategory
CostCtrResponsiblePersonName CostCtrResponsiblePersonName
CostCtrResponsibleUser CostCtrResponsibleUser
CostCenterCurrency CostCenterCurrency
CostingSheet CostingSheet
TaxJurisdiction TaxJurisdiction
ProfitCenter ProfitCenter
Plant Plant
LogicalSystem LogicalSystem
CostCenterCreationDate CostCenterCreationDate
CostCenterCreatedByUser CostCenterCreatedByUser
IsBlkdForSecondaryCostsPosting IsBlkdForSecondaryCostsPosting
IsBlockedForRevenuePosting IsBlockedForRevenuePosting
IsBlockedForCommitmentPosting IsBlockedForCommitmentPosting
IsBlockedForPlanSecondaryCosts IsBlockedForPlanSecondaryCosts
IsBlockedForPlanRevenues IsBlockedForPlanRevenues
CostCenterAllocationMethod CostCenterAllocationMethod
ConsumptionQtyIsRecorded ConsumptionQtyIsRecorded
Department Department
SubsequentCostCenter SubsequentCostCenter
ConditionUsage ConditionUsage
ConditionApplication ConditionApplication
CostCenterAccountingOverhead CostCenterAccountingOverhead
Country Country
FormOfAddress FormOfAddress
AddressName AddressName
AddressAdditionalName AddressAdditionalName
CostCenterAddrName3 CostCenterAddrName3
CostCenterAddrName4 CostCenterAddrName4
CityName CityName
District District
StreetAddressName StreetAddressName
POBox POBox
PostalCode PostalCode
POBoxPostalCode POBoxPostalCode
Region Region
Language Language
TeleboxNumber TeleboxNumber
PhoneNumber1 PhoneNumber1
PhoneNumber2 PhoneNumber2
FaxNumber FaxNumber
TeletexNumber TeletexNumber
TelexNumber TelexNumber
DataCommunicationPhoneNumber DataCommunicationPhoneNumber
CostCenterPrinterDestination CostCenterPrinterDestination
CostCenterStandardHierArea CostCenterStandardHierArea
CostCollector CostCollector
CostCenterIsComplete CostCenterIsComplete
IsStatisticalCostCenter IsStatisticalCostCenter
ObjectInternalID ObjectInternalID
CostCenterFunction CostCenterFunction
CostCenterAlternativeFunction CostCenterAlternativeFunction
FunctionalArea FunctionalArea
ActyDepdntFormulaPlanningTmpl ActyDepdntFormulaPlanningTmpl
ActyIndependentAllocationTmpl ActyIndependentAllocationTmpl
ActyDependentAllocationTmpl ActyDependentAllocationTmpl
ActlIndepStatisticalKeyFigures ActlIndepStatisticalKeyFigures
JointVenture JointVenture
JointVentureRecoveryCode JointVentureRecoveryCode
JointVentureEquityType JointVentureEquityType
JointVentureObjectType JointVentureObjectType
JointVentureClass JointVentureClass
JointVentureSubClass JointVentureSubClass
BudgetCarryingCostCenter BudgetCarryingCostCenter
AvailabilityControlProfile AvailabilityControlProfile
AvailabilityControlIsActive AvailabilityControlIsActive
_ControllingArea _ControllingArea
_Text _Text
_CostCenterHierarchyNode _CostCenterHierarchyNode
_Currency _Currency
_CompanyCode _CompanyCode
_BusinessArea _BusinessArea
_ProfitCenter _ProfitCenter
_FunctionalArea _FunctionalArea
_CostCenterCategory _CostCenterCategory
_Country _Country
_Region _Region
_CostingSheetProcedure _CostingSheetProcedure
_Language _Language
_AvailabilityCtrlProfile _AvailabilityCtrlProfile
_UserRespContactCard _UserRespContactCard
_UserCrtedContactCard _UserCrtedContactCard
_ActivityBasedCostingTmplCpd _ActivityBasedCostingTmplCpd
_ActivityBasedCostingTmplSci _ActivityBasedCostingTmplSci
_ActivityBasedCostingTmplScd _ActivityBasedCostingTmplScd
_ActivityBasedCostingTmplSki _ActivityBasedCostingTmplSki
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IFICURCOSTCENTER'
@AbapCatalog.compiler.compareFilter: true

@Analytics.dataCategory: #DIMENSION
@ObjectModel.representativeKey: 'CostCenter'

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

@EndUserText.label: 'Current Cost Center'
@VDM.viewType: #BASIC

@ObjectModel.usageType: {
  dataClass: #ORGANIZATIONAL,
  serviceQuality: #A,
  sizeCategory: #L
}
@Metadata.allowExtensions:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_CurrentCostCenter
  as select from I_CostCenter


  association [0..*] to I_CostCenterText as _Text on  $projection.ControllingArea = _Text.ControllingArea
                                                  and $projection.CostCenter      = _Text.CostCenter
{
      @ObjectModel.foreignKey.association: '_ControllingArea'
      //key cast( kokrs as fis_kokrs )  as ControllingArea,

  key ControllingArea,
//      @Search.defaultSearchElement: true

//      @Search.fuzzinessThreshold: 0.8

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

//      ActyIndepFormulaPlanningTmpl,

      @ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplCpd'
      ActyDepdntFormulaPlanningTmpl,
      @ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplSci'
      ActyIndependentAllocationTmpl,
      @ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplScd'
      ActyDependentAllocationTmpl,
      @ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplSki'
      ActlIndepStatisticalKeyFigures,
//      @ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplSkd'

//      ActlDepStatisticalKeyFigures,

      JointVenture,
      JointVentureRecoveryCode,
      JointVentureEquityType,
      JointVentureObjectType,
      JointVentureClass,
      JointVentureSubClass,
      BudgetCarryingCostCenter,
      AvailabilityControlProfile,
      AvailabilityControlIsActive,

      _ControllingArea,
      _Text,
      _CostCenterHierarchyNode,
      _Currency,
      _CompanyCode,
      _BusinessArea,
      @Consumption.filter.businessDate.at: true
      _ProfitCenter,
      _FunctionalArea,
      _CostCenterCategory,
      _Country,
      _Region,
      _CostingSheetProcedure,
      _Language,
      _AvailabilityCtrlProfile,
      _UserRespContactCard,
      _UserCrtedContactCard,
//      _ActivityBasedCostingTmplCpi,

      _ActivityBasedCostingTmplCpd,
      _ActivityBasedCostingTmplSci,
      _ActivityBasedCostingTmplScd,
      _ActivityBasedCostingTmplSki
//      _ActivityBasedCostingTmplSkd

}
where
      ValidityStartDate <= $session.system_date
  and ValidityEndDate   >= $session.system_date

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTER"
],
"ASSOCIATED":
[
"I_ACTIVITYBASEDCOSTINGTMPL",
"I_AVAILABILITYCTRLPROFILE",
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTERCATEGORY",
"I_COSTCENTERHIERARCHYNODE",
"I_COSTCENTERTEXT",
"I_COSTINGSHEETPROCEDURE",
"I_COUNTRY",
"I_CURRENCY",
"I_FUNCTIONALAREA",
"I_LANGUAGE",
"I_PROFITCENTER",
"I_REGION",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_COSTCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/