I_COSTCENTER
Cost Center
I_COSTCENTER is a CDS View in S/4HANA. Cost Center. It contains 97 fields. 46 CDS views read from this table.
CDS Views using this table (46)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_CostCenter | view | from | BASIC | Cost Center |
| C_CmmdtyHdgPlnExpsrCostCtrVH | view | from | CONSUMPTION | Cmmdty Hedge Plan Exposure Cost Center |
| 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_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 | inner | Orgl Change: Fill Runtime for Cost Cntrs | |
| FINOC_RT_CCR_FILL | view | from | 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_CostCenterChangeLog | view | left_outer | COMPOSITE | Cost Center Change Log |
| I_CostCenterForCompanyCode | view | 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 | 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 |
| I_TripCostCenterVH | view | from | BASIC | Material group Value Help |
| P_CostCenter | view | from | COMPOSITE | |
| P_CostCenterBudget | view | inner | COMPOSITE | |
| P_CostCtrChangeLogCostCenter | view | union | CONSUMPTION | |
| P_CostCtrChangeLogCostCenter | view | from | CONSUMPTION | |
| P_EngmntProjIntcoCostCtrVH | view | inner | CONSUMPTION | |
| 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 | from | COMPOSITE | |
| P_PreviousCostCenter | view | from | COMPOSITE | |
| P_WhereUsedCCAccrual | view | inner | COMPOSITE | |
| 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 (97)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 14 |
| KEY | ControllingArea | ControllingArea | 19 |
| KEY | CostCenter | BudgetCarryingCostCenter,CostCenter | 19 |
| KEY | ObjectInternalID | ObjectInternalID,ObjectNumber,REAccountingObject | 4 |
| KEY | ValidityEndDate | ValidityEndDate | 15 |
| KEY | ValidityStartDate | ValidityStartDate | 14 |
| _ActivityBasedCostingTmplCpd | _ActivityBasedCostingTmplCpd | 1 | |
| _ActivityBasedCostingTmplCpi | _ActivityBasedCostingTmplCpi | 1 | |
| _ActivityBasedCostingTmplScd | _ActivityBasedCostingTmplScd | 1 | |
| _ActivityBasedCostingTmplSci | _ActivityBasedCostingTmplSci | 1 | |
| _ActivityBasedCostingTmplSkd | _ActivityBasedCostingTmplSkd | 1 | |
| _ActivityBasedCostingTmplSki | _ActivityBasedCostingTmplSki | 1 | |
| _AvailabilityCtrlProfile | _AvailabilityCtrlProfile | 1 | |
| _BusinessArea | _BusinessArea | 3 | |
| _CompanyCode | _CompanyCode | 4 | |
| _ControllingArea | _ControllingArea | 5 | |
| _CostCenterCategory | _CostCenterCategory | 3 | |
| _CostCenterHierarchyNode | _CostCenterHierarchyNode | 2 | |
| _CostingSheetProcedure | _CostingSheetProcedure | 2 | |
| _Country | _Country | 2 | |
| _Currency | _Currency | 2 | |
| _FunctionalArea | _FunctionalArea | 2 | |
| _Language | _Language | 2 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _Region | _Region | 2 | |
| _Text | _Text | 3 | |
| _UserCrtedContactCard | _UserCrtedContactCard | 3 | |
| _UserRespContactCard | _UserRespContactCard | 3 | |
| AddressAdditionalName | AddressAdditionalName | 2 | |
| AddressName | AddressName | 1 | |
| AvailabilityControlIsActive | AvailabilityControlIsActive | 1 | |
| AvailabilityControlProfile | AvailabilityControlProfile | 3 | |
| BudgetCarryingCostCenter | BudgetCarryingCostCenter | 2 | |
| BusinessArea | BusinessArea | 4 | |
| CityName | CityName | 3 | |
| ConditionApplication | ConditionApplication | 2 | |
| ConditionUsage | ConditionUsage | 2 | |
| ConsumptionQtyIsRecorded | ConsumptionQtyIsRecorded | 2 | |
| CostCenterAccountingOverhead | CostCenterAccountingOverhead | 2 | |
| CostCenterAddrName3 | CostCenterAddrName3 | 2 | |
| CostCenterAddrName4 | CostCenterAddrName4 | 2 | |
| CostCenterAllocationMethod | CostCenterAllocationMethod | 2 | |
| CostCenterAlternativeFunction | CostCenterAlternativeFunction | 2 | |
| CostCenterCategory | CostCenterCategory | 7 | |
| CostCenterCreatedByUser | CostCenterCreatedByUser | 2 | |
| CostCenterCreationDate | CostCenterCreationDate | 2 | |
| CostCenterCurrency | CostCenterCurrency | 3 | |
| CostCenterFunction | CostCenterFunction | 3 | |
| CostCenterIsComplete | CostCenterIsComplete | 2 | |
| CostCenterPrinterDestination | CostCenterPrinterDestination | 1 | |
| CostCenterStandardHierArea | CostCenterStandardHierArea | 1 | |
| CostCollector | CostCollector | 2 | |
| CostCtrResponsiblePersonName | CostCtrResponsiblePersonName | 7 | |
| CostCtrResponsibleUser | CostCtrResponsibleUser | 5 | |
| CostingSheet | CostingSheet | 2 | |
| Country | Country | 2 | |
| DataCommunicationPhoneNumber | DataCommunicationPhoneNumber | 2 | |
| Department | Department | 3 | |
| District | District | 2 | |
| FaxNumber | FaxNumber | 2 | |
| FormOfAddress | FormOfAddress | 2 | |
| FunctionalArea | FunctionalArea | 3 | |
| FunctionalAreaIsFixAssigned | FunctionalAreaIsFixAssigned | 1 | |
| Fund | Fund | 1 | |
| FundIsFixAssigned | FundIsFixAssigned | 1 | |
| GrantID | GrantID | 1 | |
| GrantIDIsFixAssigned | GrantIDIsFixAssigned | 1 | |
| IsBlkdForPrimaryCostsPosting | IsBlkdForPrimaryCostsPosting | 2 | |
| IsBlkdForSecondaryCostsPosting | IsBlkdForSecondaryCostsPosting | 2 | |
| IsBlockedForCommitmentPosting | IsBlockedForCommitmentPosting | 2 | |
| IsBlockedForPlanPrimaryCosts | IsBlockedForPlanPrimaryCosts | 2 | |
| IsBlockedForPlanRevenues | IsBlockedForPlanRevenues | 2 | |
| IsBlockedForPlanSecondaryCosts | IsBlockedForPlanSecondaryCosts | 2 | |
| IsBlockedForRevenuePosting | IsBlockedForRevenuePosting | 2 | |
| IsStatisticalCostCenter | IsStatisticalCostCenter | 2 | |
| JointVenture | JointVenture | 1 | |
| JointVentureClass | JointVentureClass | 1 | |
| JointVentureEquityType | JointVentureEquityType | 1 | |
| JointVentureObjectType | JointVentureObjectType | 1 | |
| JointVentureRecoveryCode | JointVentureRecoveryCode | 1 | |
| JointVentureSubClass | JointVentureSubClass | 1 | |
| Language | Language | 3 | |
| LogicalSystem | LogicalSystem | 2 | |
| PhoneNumber1 | PhoneNumber1 | 1 | |
| PhoneNumber2 | PhoneNumber2 | 2 | |
| Plant | Plant | 2 | |
| POBox | POBox | 2 | |
| POBoxPostalCode | POBoxPostalCode | 2 | |
| PostalCode | PostalCode | 2 | |
| ProfitCenter | ProfitCenter,ProfitCenterBeforeOrglChange,ProfitCenterByOrglChange | 6 | |
| Region | Region | 3 | |
| StreetAddressName | StreetAddressName | 2 | |
| SubsequentCostCenter | SubsequentCostCenter | 2 | |
| TaxJurisdiction | TaxJurisdiction | 2 | |
| TeleboxNumber | TeleboxNumber | 2 | |
| TeletexNumber | TeletexNumber | 2 | |
| TelexNumber | TelexNumber | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Cost Center
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COSTCENTER (
COMPANYCODE,
CONTROLLINGAREA,
COSTCENTER,
OBJECTINTERNALID,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
_ACTIVITYBASEDCOSTINGTMPLCPD,
_ACTIVITYBASEDCOSTINGTMPLCPI,
_ACTIVITYBASEDCOSTINGTMPLSCD,
_ACTIVITYBASEDCOSTINGTMPLSCI,
_ACTIVITYBASEDCOSTINGTMPLSKD,
_ACTIVITYBASEDCOSTINGTMPLSKI,
_AVAILABILITYCTRLPROFILE,
_BUSINESSAREA,
_COMPANYCODE,
_CONTROLLINGAREA,
_COSTCENTERCATEGORY,
_COSTCENTERHIERARCHYNODE,
_COSTINGSHEETPROCEDURE,
_COUNTRY,
_CURRENCY,
_FUNCTIONALAREA,
_LANGUAGE,
_PROFITCENTER,
_REGION,
_TEXT,
_USERCRTEDCONTACTCARD,
_USERRESPCONTACTCARD,
ADDRESSADDITIONALNAME,
ADDRESSNAME,
AVAILABILITYCONTROLISACTIVE,
AVAILABILITYCONTROLPROFILE,
BUDGETCARRYINGCOSTCENTER,
BUSINESSAREA,
CITYNAME,
CONDITIONAPPLICATION,
CONDITIONUSAGE,
CONSUMPTIONQTYISRECORDED,
COSTCENTERACCOUNTINGOVERHEAD,
COSTCENTERADDRNAME3,
COSTCENTERADDRNAME4,
COSTCENTERALLOCATIONMETHOD,
COSTCENTERALTERNATIVEFUNCTION,
COSTCENTERCATEGORY,
COSTCENTERCREATEDBYUSER,
COSTCENTERCREATIONDATE,
COSTCENTERCURRENCY,
COSTCENTERFUNCTION,
COSTCENTERISCOMPLETE,
COSTCENTERPRINTERDESTINATION,
COSTCENTERSTANDARDHIERAREA,
COSTCOLLECTOR,
COSTCTRRESPONSIBLEPERSONNAME,
COSTCTRRESPONSIBLEUSER,
COSTINGSHEET,
COUNTRY,
DATACOMMUNICATIONPHONENUMBER,
DEPARTMENT,
DISTRICT,
FAXNUMBER,
FORMOFADDRESS,
FUNCTIONALAREA,
FUNCTIONALAREAISFIXASSIGNED,
FUND,
FUNDISFIXASSIGNED,
GRANTID,
GRANTIDISFIXASSIGNED,
ISBLKDFORPRIMARYCOSTSPOSTING,
ISBLKDFORSECONDARYCOSTSPOSTING,
ISBLOCKEDFORCOMMITMENTPOSTING,
ISBLOCKEDFORPLANPRIMARYCOSTS,
ISBLOCKEDFORPLANREVENUES,
ISBLOCKEDFORPLANSECONDARYCOSTS,
ISBLOCKEDFORREVENUEPOSTING,
ISSTATISTICALCOSTCENTER,
JOINTVENTURE,
JOINTVENTURECLASS,
JOINTVENTUREEQUITYTYPE,
JOINTVENTUREOBJECTTYPE,
JOINTVENTURERECOVERYCODE,
JOINTVENTURESUBCLASS,
LANGUAGE,
LOGICALSYSTEM,
PHONENUMBER1,
PHONENUMBER2,
PLANT,
POBOX,
POBOXPOSTALCODE,
POSTALCODE,
PROFITCENTER,
REGION,
STREETADDRESSNAME,
SUBSEQUENTCOSTCENTER,
TAXJURISDICTION,
TELEBOXNUMBER,
TELETEXNUMBER,
TELEXNUMBER,
PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, COSTCENTER, OBJECTINTERNALID, VALIDITYENDDATE, VALIDITYSTARTDATE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA