I_COSTCENTER
Cost Center
I_COSTCENTER is a CDS View in S/4HANA. Cost Center. It contains 102 fields. 53 CDS views read from this table.
CDS Views using this table (53)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_CntrlInvcMgmtCostCtrOwnr | view_entity | from | CONSUMPTION | Cost Center Owners |
| A_CostCenter | view | from | BASIC | Cost Center |
| C_CmmdtyHdgPlnExpsrCostCtrVH | view | from | CONSUMPTION | Cmmdty Hedge Plan Exposure Cost Center |
| C_EnPrjPfSrvsPrjCostCtrVH | view_entity | inner | CONSUMPTION | Service Orgnization Cost Centers |
| C_EntProjCostCenterVH | view | from | CONSUMPTION | Cost Center |
| C_FixedAssetOvwCostCenterVH | view | from | CONSUMPTION | Cost Center by Company Code Value Help |
| C_MM_CostCenterValueHelp | view | from | CONSUMPTION | Value Help for Cost Center |
| C_ProjDemandCostCenterVH | view | from | CONSUMPTION | Cost Center Value Help |
| C_ProjSrvcOrgAvailCostCenterVH | view_entity | from | CONSUMPTION | Select Available Cost Center |
| C_ProjSrvcOrgCostCenterVH | view_entity | from | CONSUMPTION | Select Cost Center |
| C_PurOrdAccrsEmlTmplCostCtr | view | from | CONSUMPTION | E-mail Tmpl for PO Accrs of Cost Center |
| C_ReExAssignCostCenter | view | from | CONSUMPTION | Cost Center |
| fac_cds_fh_costcenter | view | from | Cost Center in Flexible Hierarchy | |
| fac_cds_uh_costcenter | view | from | Cost Center in Flexible Hierarchy | |
| FAC_COST_CENTER_VH | view | from | Cost Center (Value help) | |
| FAC_DART_Z3_COSTCENTER | view | from | Cost Center Master Data | |
| FINOC_RT_CCR_FILL | view | from | Orgl Change: Fill Runtime for Cost Cntrs | |
| FINOC_RT_CCR_FILL | view | inner | Orgl Change: Fill Runtime for Cost Cntrs | |
| FINOC_RT_CCR_FILL_TIME_SLICED | view | from | Orgl Change: CCTR with prev. time slice | |
| FINOC_RT_CCR_FILL_TIME_SLICED | view | inner | Orgl Change: CCTR with prev. time slice | |
| I_BudgetCarryingCostCenterVH | view | from | BASIC | Budget-Carrying Cost Center Value Help |
| I_BudgetCostCenterHierDir | view_entity | from | COMPOSITE | Budget Cost Center Directory |
| I_CePuCoCostCenterVH | view_entity | from | COMPOSITE | Central Contract Cost Center |
| I_CostCenterForCompanyCode | view_entity | from | BASIC | Cost Center For Company Code |
| I_CostCenterInCompanyCode | view_entity | from | BASIC | Cost Center In Company Code |
| I_CostCenterStdVH | view | from | COMPOSITE | Cost Center |
| I_CostCenterVH | view | from | BASIC | Cost Center |
| I_CurrentCostCenter | view_entity | from | BASIC | Current Cost Center |
| I_EmployeeOp | view | left_outer | BASIC | Employee CDS view for OP |
| I_JointVentureCostCenter | view | from | BASIC | Joint Venture Cost Center |
| I_MM_CostCenterValueHelp | view | from | BASIC | Purchasing Cost Center Value Help |
| I_PRACostCenter | view | from | COMPOSITE | PRA Cost Center |
| I_QltyMgmtPlantCostCenterVH | view | from | COMPOSITE | Cost Center By Plant |
| I_REControllingObject | view | from | COMPOSITE | Real Estate Accounting Object |
| I_SAFTCostCenter | view | from | BASIC | SAF-T Cost Centers |
| P_CostCenter | view | from | COMPOSITE | Cost Center |
| P_CostCenterBudget | view | inner | COMPOSITE | Cost Center Budget Report |
| P_CostCtrChangeLogCostCenter | view | from | CONSUMPTION | Cost Center in Cost Center Change Log |
| P_CostCtrChangeLogCostCenter | view | union | CONSUMPTION | Cost Center in Cost Center Change Log |
| P_EngmntProjIntcoCostCtrVH | view | inner | CONSUMPTION | Engagement Project Intercompany Company Code |
| P_FuncnlAreaCostCenters | view | from | COMPOSITE | WUFAREA Cost Centers |
| P_FundCostCenters | view | from | COMPOSITE | WUFUND Cost Centers |
| P_GrantCostCenters | view | from | COMPOSITE | WUGRANT Cost Centers |
| P_NextCostCenter | view_entity | from | COMPOSITE | None |
| P_PERSONWORKAGRMTORGLDETAILS1 | view_entity | inner | COMPOSITE | ZI_PersonWorkAgrmtOrglDetails1 |
| P_PreviousCostCenter | view_entity | from | COMPOSITE | None |
| P_WhereUsedCCAccrual | view | inner | COMPOSITE | Where Used Cost Centers - Accrual Object |
| P_WorkAssignmentCostCenterDets | view_entity | inner | COMPOSITE | Work Assignment Details with Cost Center |
| P_WRKASSGMTDETSCOSTCENTER | view_entity | inner | COMPOSITE | P_WRKASSGMTDETSCOSTCENTER |
| R_CostCenterTP | view_entity | from | TRANSACTIONAL | Cost Center |
| R_CostCtrValidityPeriodEvent | view_entity | from | TRANSACTIONAL | Cost Center Validity Period Business Event |
| R_EvtBsdPostgRuleCostCenterVH | view | from | COMPOSITE | Cost Center |
| R_EvtBsdPostingRuleReceiverVH | view | union_all | COMPOSITE | EB Posting Rule Receiver |
Fields (102)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | bukrs,CompanyCode | 18 |
| KEY | ControllingArea | ControllingArea | 24 |
| KEY | CostCenter | BudgetCarryingCostCenter,CostCenter | 21 |
| KEY | ObjectInternalID | ObjectInternalID,ObjectNumber,REAccountingObject | 5 |
| KEY | ValidityEndDate | ValidityEndDate | 16 |
| KEY | ValidityStartDate | ValidityStartDate | 14 |
| _ActivityBasedCostingTmplCpd | _ActivityBasedCostingTmplCpd | 2 | |
| _ActivityBasedCostingTmplCpi | _ActivityBasedCostingTmplCpi | 1 | |
| _ActivityBasedCostingTmplScd | _ActivityBasedCostingTmplScd | 2 | |
| _ActivityBasedCostingTmplSci | _ActivityBasedCostingTmplSci | 2 | |
| _ActivityBasedCostingTmplSkd | _ActivityBasedCostingTmplSkd | 1 | |
| _ActivityBasedCostingTmplSki | _ActivityBasedCostingTmplSki | 2 | |
| _AvailabilityCtrlProfile | _AvailabilityCtrlProfile | 2 | |
| _BusinessArea | _BusinessArea | 3 | |
| _CompanyCode | _CompanyCode | 4 | |
| _ControllingArea | _ControllingArea | 5 | |
| _CostCenterCategory | _CostCenterCategory | 4 | |
| _CostCenterHierarchyNode | _CostCenterHierarchyNode | 1 | |
| _CostingSheetProcedure | _CostingSheetProcedure | 3 | |
| _Country | _Country | 3 | |
| _Currency | _Currency | 3 | |
| _FunctionalArea | _FunctionalArea | 3 | |
| _Language | _Language | 3 | |
| _LastChangedByUserContactCard | _LastChangedByUserContactCard | 1 | |
| _ProfitCenter | _ProfitCenter | 2 | |
| _Region | _Region | 3 | |
| _Text | _Text | 2 | |
| _UserCrtedContactCard | _UserCrtedContactCard | 4 | |
| _UserRespContactCard | _UserRespContactCard | 4 | |
| ActlIndepStatisticalKeyFigures | ActlIndepStatisticalKeyFigures | 1 | |
| ActyDepdntFormulaPlanningTmpl | ActyDepdntFormulaPlanningTmpl | 1 | |
| ActyDependentAllocationTmpl | ActyDependentAllocationTmpl | 1 | |
| ActyIndependentAllocationTmpl | ActyIndependentAllocationTmpl | 1 | |
| AddressAdditionalName | AddressAdditionalName | 3 | |
| AddressName | AddressName | 2 | |
| AvailabilityControlIsActive | AvailabilityControlIsActive | 2 | |
| AvailabilityControlProfile | AvailabilityControlProfile | 4 | |
| BudgetCarryingCostCenter | BudgetCarryingCostCenter | 3 | |
| BusinessArea | BusinessArea | 4 | |
| CityName | CityName | 4 | |
| ConditionApplication | ConditionApplication | 3 | |
| ConditionUsage | ConditionUsage | 3 | |
| ConsumptionQtyIsRecorded | ConsumptionQtyIsRecorded | 3 | |
| CostCenterAccountingOverhead | CostCenterAccountingOverhead | 3 | |
| CostCenterAddrName3 | CostCenterAddrName3 | 3 | |
| CostCenterAddrName4 | CostCenterAddrName4 | 3 | |
| CostCenterAllocationMethod | CostCenterAllocationMethod | 3 | |
| CostCenterAlternativeFunction | CostCenterAlternativeFunction | 3 | |
| CostCenterCategory | CostCenterCategory | 8 | |
| CostCenterCreatedByUser | CostCenterCreatedByUser | 3 | |
| CostCenterCreationDate | CostCenterCreationDate | 3 | |
| CostCenterCurrency | CostCenterCurrency | 4 | |
| CostCenterFunction | CostCenterFunction | 4 | |
| CostCenterIsComplete | CostCenterIsComplete | 3 | |
| CostCenterPrinterDestination | CostCenterPrinterDestination | 2 | |
| CostCenterStandardHierArea | CostCenterStandardHierArea | 2 | |
| CostCollector | CostCollector | 3 | |
| CostCtrResponsiblePersonName | CostCtrResponsiblePersonName | 8 | |
| CostCtrResponsibleUser | CostCtrResponsibleUser,UserID | 7 | |
| CostingSheet | CostingSheet | 3 | |
| Country | Country | 3 | |
| DataCommunicationPhoneNumber | DataCommunicationPhoneNumber | 3 | |
| Department | Department | 4 | |
| District | District | 3 | |
| FaxNumber | FaxNumber | 3 | |
| FormOfAddress | FormOfAddress | 3 | |
| FunctionalArea | FunctionalArea | 4 | |
| FunctionalAreaIsFixAssigned | FunctionalAreaIsFixAssigned | 1 | |
| Fund | Fund | 1 | |
| FundIsFixAssigned | FundIsFixAssigned | 1 | |
| GrantID | GrantID | 1 | |
| GrantIDIsFixAssigned | GrantIDIsFixAssigned | 1 | |
| IsBlkdForPrimaryCostsPosting | IsBlkdForPrimaryCostsPosting | 3 | |
| IsBlkdForSecondaryCostsPosting | IsBlkdForSecondaryCostsPosting | 3 | |
| IsBlockedForCommitmentPosting | IsBlockedForCommitmentPosting | 3 | |
| IsBlockedForPlanPrimaryCosts | IsBlockedForPlanPrimaryCosts | 3 | |
| IsBlockedForPlanRevenues | IsBlockedForPlanRevenues | 3 | |
| IsBlockedForPlanSecondaryCosts | IsBlockedForPlanSecondaryCosts | 3 | |
| IsBlockedForRevenuePosting | IsBlockedForRevenuePosting | 3 | |
| IsStatisticalCostCenter | IsStatisticalCostCenter | 3 | |
| JointVenture | JointVenture | 2 | |
| JointVentureClass | JointVentureClass | 2 | |
| JointVentureEquityType | JointVentureEquityType | 2 | |
| JointVentureObjectType | JointVentureObjectType | 2 | |
| JointVentureRecoveryCode | JointVentureRecoveryCode | 2 | |
| JointVentureSubClass | JointVentureSubClass | 2 | |
| Language | Language | 4 | |
| LogicalSystem | LogicalSystem | 3 | |
| PhoneNumber1 | PhoneNumber1 | 2 | |
| PhoneNumber2 | PhoneNumber2 | 3 | |
| Plant | Plant | 3 | |
| POBox | POBox | 3 | |
| POBoxPostalCode | POBoxPostalCode | 3 | |
| PostalCode | PostalCode | 3 | |
| ProfitCenter | ProfitCenter,ProfitCenterBeforeOrglChange,ProfitCenterByOrglChange | 7 | |
| Region | Region | 4 | |
| StreetAddressName | StreetAddressName | 3 | |
| SubsequentCostCenter | SubsequentCostCenter | 3 | |
| TaxJurisdiction | TaxJurisdiction | 3 | |
| TeleboxNumber | TeleboxNumber | 3 | |
| TeletexNumber | TeletexNumber | 3 | |
| TelexNumber | TelexNumber | 3 |
@AbapCatalog.sqlViewName: 'IFICOSTCENTER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@Analytics:{
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
automatic: true
}
}
}
@ObjectModel.representativeKey: 'CostCenter'
@ObjectModel.sapObjectNodeType.name: 'CostCenter'
@AccessControl.authorizationCheck: #CHECK
//@AccessControl.personalData.blocking: #REQUIRED -> Not needed for user in ADRP because no XBLCK field like in BUT000 or KNA1/LFA1
@AccessControl.privilegedAssociations: [ '_UserRespContactCard', '_UserCrtedContactCard', '_LastChangedByUserContactCard' ]
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Cost Center'
@VDM.viewType: #BASIC
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.usageType: {
dataClass: #ORGANIZATIONAL,
serviceQuality: #A,
sizeCategory: #L
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Consumption.filter.businessDate.at: true
define view I_CostCenter
as select from csks
association [1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..*] to I_CostCenterText as _Text on $projection.ControllingArea = _Text.ControllingArea
and $projection.CostCenter = _Text.CostCenter
and $projection.ValidityEndDate = _Text.ValidityEndDate
association [0..*] to I_CostCenterHierarchyNode as _CostCenterHierarchyNode on $projection.ControllingArea = _CostCenterHierarchyNode.ControllingArea
and $projection.CostCenter = _CostCenterHierarchyNode.CostCenter
association [0..1] to I_Currency as _Currency on $projection.CostCenterCurrency = _Currency.Currency
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ProfitCenter = _ProfitCenter.ProfitCenter
and $projection.ControllingArea = _ProfitCenter.ControllingArea
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association [0..1] to I_CostCenterCategory as _CostCenterCategory on $projection.CostCenterCategory = _CostCenterCategory.CostCenterCategory
association [0..1] to I_Country as _Country on $projection.Country = _Country.Country
association [0..1] to I_Region as _Region on $projection.Region = _Region.Region
and $projection.Country = _Region.Country
association [0..1] to I_CostingSheetProcedure as _CostingSheetProcedure on _CostingSheetProcedure.ConditionUsage = 'A'
and _CostingSheetProcedure.ConditionApplication = 'KA'
and _CostingSheetProcedure.CostingSheetProcedure = $projection.CostingSheet
association [0..1] to I_UserContactCard as _UserRespContactCard on $projection.CostCtrResponsibleUser = _UserRespContactCard.ContactCardID
association [0..1] to I_UserContactCard as _UserCrtedContactCard on $projection.CostCenterCreatedByUser = _UserCrtedContactCard.ContactCardID
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
association [0..1] to I_AvailabilityCtrlProfile as _AvailabilityCtrlProfile on $projection.AvailabilityControlProfile = _AvailabilityCtrlProfile.AvailabilityControlProfile
association [1..1] to E_CostCenter as _Extension on $projection.ControllingArea = _Extension.ControllingArea
and $projection.CostCenter = _Extension.CostCenter
and $projection.ValidityEndDate = _Extension.ValidityEndDate
association [0..1] to I_ActivityBasedCostingTmpl as _ActivityBasedCostingTmplCpi on _ActivityBasedCostingTmplCpi.ControllingArea = $projection.ControllingArea
and _ActivityBasedCostingTmplCpi.ActivityBasedCostingEnvrmt = 'CPI'
and _ActivityBasedCostingTmplCpi.ActivityBasedCostingTemplate = $projection.ActyIndepFormulaPlanningTmpl
association [0..1] to I_ActivityBasedCostingTmpl as _ActivityBasedCostingTmplCpd on _ActivityBasedCostingTmplCpd.ControllingArea = $projection.ControllingArea
and _ActivityBasedCostingTmplCpd.ActivityBasedCostingEnvrmt = 'CPD'
and _ActivityBasedCostingTmplCpd.ActivityBasedCostingTemplate = $projection.ActyDepdntFormulaPlanningTmpl
association [0..1] to I_ActivityBasedCostingTmpl as _ActivityBasedCostingTmplSci on _ActivityBasedCostingTmplSci.ControllingArea = $projection.ControllingArea
and _ActivityBasedCostingTmplSci.ActivityBasedCostingEnvrmt = 'SCI'
and _ActivityBasedCostingTmplSci.ActivityBasedCostingTemplate = $projection.ActyIndependentAllocationTmpl
association [0..1] to I_ActivityBasedCostingTmpl as _ActivityBasedCostingTmplScd on _ActivityBasedCostingTmplScd.ControllingArea = $projection.ControllingArea
and _ActivityBasedCostingTmplScd.ActivityBasedCostingEnvrmt = 'SCD'
and _ActivityBasedCostingTmplScd.ActivityBasedCostingTemplate = $projection.ActyDependentAllocationTmpl
association [0..1] to I_ActivityBasedCostingTmpl as _ActivityBasedCostingTmplSki on _ActivityBasedCostingTmplSki.ControllingArea = $projection.ControllingArea
and _ActivityBasedCostingTmplSki.ActivityBasedCostingEnvrmt = 'SKI'
and _ActivityBasedCostingTmplSki.ActivityBasedCostingTemplate = $projection.ActlIndepStatisticalKeyFigures
association [0..1] to I_ActivityBasedCostingTmpl as _ActivityBasedCostingTmplSkd on _ActivityBasedCostingTmplSkd.ControllingArea = $projection.ControllingArea
and _ActivityBasedCostingTmplSkd.ActivityBasedCostingEnvrmt = 'SKD'
and _ActivityBasedCostingTmplSkd.ActivityBasedCostingTemplate = $projection.ActlDepStatisticalKeyFigures
association [0..1] to I_UserContactCard as _LastChangedByUserContactCard on $projection.CostCenterLastChangedByUser = _LastChangedByUserContactCard.ContactCardID
association [0..1] to I_JointVenture as _JointVenture on $projection.CompanyCode = _JointVenture.CompanyCode
and $projection.JointVenture = _JointVenture.JointVenture
association [0..1] to I_JointVentureRecovery as _JointVentureRecovery on $projection.CompanyCode = _JointVentureRecovery.CompanyCode
and $projection.JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode
association [0..1] to I_JointVentureEquityType as _JointVentureEquityType on $projection.CompanyCode = _JointVentureEquityType.CompanyCode
and $projection.JointVentureEquityType = _JointVentureEquityType.JointVentureEquityType
association [0..1] to I_JntVntrCostCtrType as _JointVentureObjectType on $projection.CompanyCode = _JointVentureObjectType.CompanyCode
and $projection.JointVentureObjectType = _JointVentureObjectType.JntVntrCostCtrType
association [0..1] to I_JntIntrstBillgClass as _JointVentureClass on $projection.CompanyCode = _JointVentureClass.CompanyCode
and $projection.JointVentureClass = _JointVentureClass.JntIntrstBillgClass
association [0..1] to I_JntIntrstBillgSubclass as _JointVentureSubClass on $projection.CompanyCode = _JointVentureSubClass.CompanyCode
and $projection.JointVentureClass = _JointVentureSubClass.JntIntrstBillgClass
and $projection.JointVentureSubClass = _JointVentureSubClass.JntIntrstBillgSubClass
association [0..*] to I_Fund as _Fund on $projection.Fund = _Fund.Fund
association [0..1] to I_Grant as _Grant on $projection.GrantID = _Grant.GrantID
association [0..*] to I_CostCenter as _BudgetCarryingCostCenter on _BudgetCarryingCostCenter.ControllingArea = $projection.ControllingArea
and _BudgetCarryingCostCenter.CostCenter = $projection.BudgetCarryingCostCenter
// and _BudgetCarryingCostCenter.ValidityStartDate <= $session.system_date
// and _BudgetCarryingCostCenter.ValidityEndDate >= $session.system_date
association [0..*] to I_BudgetCostCenterHierarchy as _BudgetCostCenterHier on _BudgetCostCenterHier.ControllingArea = $projection.ControllingArea
and _BudgetCostCenterHier.CostCenter = $projection.CostCenter
// and _BudgetCostCenterHier.ValidityStartDate <= $session.system_date
// and _BudgetCostCenterHier.ValidityEndDate >= $session.system_date
{
@ObjectModel.foreignKey.association: '_ControllingArea'
//key cast( kokrs as fis_kokrs ) as ControllingArea,
key kokrs as ControllingArea,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@ObjectModel.text.association: '_Text'
@ObjectModel.hierarchy.association: '_CostCenterHierarchyNode'
key kostl as CostCenter,
@Semantics.businessDate.to: true
key datbi as ValidityEndDate,
@Semantics.businessDate.from: true
datab as ValidityStartDate,
bkzkp as IsBlkdForPrimaryCostsPosting,
pkzkp as IsBlockedForPlanPrimaryCosts,
@ObjectModel.foreignKey.association: '_CompanyCode'
bukrs as CompanyCode,
@ObjectModel.foreignKey.association: '_BusinessArea'
gsber as BusinessArea,
@ObjectModel.foreignKey.association: '_CostCenterCategory'
kosar as CostCenterCategory,
verak as CostCtrResponsiblePersonName,
@ObjectModel.foreignKey.association: '_UserRespContactCard'
verak_user as CostCtrResponsibleUser,
@Semantics.currencyCode: true
@ObjectModel.foreignKey.association: '_Currency'
waers as CostCenterCurrency,
@ObjectModel.foreignKey.association: '_CostingSheetProcedure'
kalsm as CostingSheet,
txjcd as TaxJurisdiction,
@ObjectModel.foreignKey.association: '_ProfitCenter'
prctr as ProfitCenter,
werks as Plant,
logsystem as LogicalSystem,
@Semantics.systemDate.createdAt: true
ersda as CostCenterCreationDate,
@Semantics.user.createdBy: true
@ObjectModel.foreignKey.association: '_UserCrtedContactCard'
usnam as CostCenterCreatedByUser,
bkzks as IsBlkdForSecondaryCostsPosting,
bkzer as IsBlockedForRevenuePosting,
bkzob as IsBlockedForCommitmentPosting,
cast(pkzks as fis_pkzks preserving type) as IsBlockedForPlanSecondaryCosts,
cast(pkzer as fis_pkzer preserving type) as IsBlockedForPlanRevenues,
vmeth as CostCenterAllocationMethod,
mgefl as ConsumptionQtyIsRecorded,
abtei as Department,
nkost as SubsequentCostCenter,
kvewe as ConditionUsage,
kappl as ConditionApplication,
koszschl as CostCenterAccountingOverhead,
@ObjectModel.foreignKey.association: '_Country'
land1 as Country,
anred as FormOfAddress,
name1 as AddressName,
name2 as AddressAdditionalName,
name3 as CostCenterAddrName3,
name4 as CostCenterAddrName4,
ort01 as CityName,
ort02 as District,
stras as StreetAddressName,
pfach as POBox,
pstlz as PostalCode,
pstl2 as POBoxPostalCode,
@ObjectModel.foreignKey.association: '_Region'
regio as Region,
@ObjectModel.foreignKey.association: '_Language'
spras as Language,
telbx as TeleboxNumber,
telf1 as PhoneNumber1,
telf2 as PhoneNumber2,
telfx as FaxNumber,
teltx as TeletexNumber,
telx1 as TelexNumber,
datlt as DataCommunicationPhoneNumber,
drnam as CostCenterPrinterDestination,
khinr as CostCenterStandardHierArea,
cckey as CostCollector,
kompl as CostCenterIsComplete,
cast(stakz as fins_xkostl_stat preserving type) as IsStatisticalCostCenter,
objnr as ObjectInternalID,
funkt as CostCenterFunction,
afunk as CostCenterAlternativeFunction,
@ObjectModel.foreignKey.association: '_FunctionalArea'
func_area as FunctionalArea,
@ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplCpi'
cpi_templ as ActyIndepFormulaPlanningTmpl,
@ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplCpd'
cpd_templ as ActyDepdntFormulaPlanningTmpl,
@ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplSci'
sci_templ as ActyIndependentAllocationTmpl,
@ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplScd'
scd_templ as ActyDependentAllocationTmpl,
@ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplSki'
ski_templ as ActlIndepStatisticalKeyFigures,
@ObjectModel.foreignKey.association: '_ActivityBasedCostingTmplSkd'
skd_templ as ActlDepStatisticalKeyFigures,
vname as JointVenture,
recid as JointVentureRecoveryCode,
etype as JointVentureEquityType,
jv_otype as JointVentureObjectType,
jv_jibcl as JointVentureClass,
jv_jibsa as JointVentureSubClass,
budget_carrying_cost_ctr as BudgetCarryingCostCenter,
avc_profile as AvailabilityControlProfile,
avc_active as AvailabilityControlIsActive,
fund as Fund,
grant_id as GrantID,
fund_fix_assigned as FundIsFixAssigned,
grant_fix_assigned as GrantIDIsFixAssigned,
func_area_fix_assigned as FunctionalAreaIsFixAssigned,
@Semantics.systemTime.createdAt: true
created_at as CostCenterCreationTime,
@ObjectModel.foreignKey.association: '_LastChangedByUserContactCard'
@Semantics.user.lastChangedBy
last_changed_by as CostCenterLastChangedByUser,
@Semantics.systemDate.lastChangedAt: true
last_changed_on as CostCenterLastChangedOnDate,
@Semantics.systemTime.lastChangedAt: true
last_changed_at as CostCenterLastChangedAtTime,
_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,
_LastChangedByUserContactCard,
_JointVenture,
_JointVentureRecovery,
_JointVentureEquityType,
_JointVentureObjectType,
_JointVentureClass,
_JointVentureSubClass,
_Fund,
_Grant,
@ObjectModel.association.toHierarchy: true
_BudgetCostCenterHier,
_BudgetCarryingCostCenter
}