SAP table CSKS (Cost Center Master Record)

SAP table CSKS (Cost Center Master Record) is a crucial component within the SAP ERP and S/4HANA systems, storing essential data related to cost centers. This table is part of the Controlling (CO) module and is implemented as a Column Store table within the SAP HANA database. The CSKS table is used to manage and maintain cost center master data, which is vital for overhead cost controlling and effective management of customer interactions

A cost center in SAP is a specific area or department within a company where costs are tracked. Think of it as a way to keep an eye on expenses in different parts of the organization. For example, a cost center could be a marketing department, a production unit, or even a specific project. By using cost centers, companies can see where money is being spent, control their budgets better, and make informed decisions about their finances. In SAP, cost centers help in organizing and managing costs efficiently, ensuring that every expense is accounted for and analyzed. This way, businesses can improve their financial planning and overall performance.

SAP table CSKS has 4 primary key fields being MANDT,KOKRS,KOSTL,DATBI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 KOSTL
DATBI Valid To Date DATS 8 0 DATBI
DATAB Valid-From Date DATS 8 0 DATAB
BKZKP Lock Indicator for Actual Primary Postings CHAR 1 0 BKZKP
PKZKP Lock Indicator for Plan Primary Costs CHAR 1 0 PKZKP
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
KOSAR Cost Center Category CHAR 1 0 TKA05 KOSAR
VERAK Person Responsible CHAR 20 0 VERAK
VERAK_USER User Responsible CHAR 12 0 USR02 VERAK_USER
WAERS Currency Key CUKY 5 0 TCURC WAERS
KALSM Costing Sheet CHAR 6 0 T683 AUFKALSM
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
PRCTR Profit Center CHAR 10 0 PRCTR
WERKS Plant CHAR 4 0 T001W WERKS_D
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
ERSDA Entered On DATS 8 0 ERFDT
USNAM Entered By CHAR 12 0 ERFNM
BKZKS Lock Indicator for Actual Secondary Costs CHAR 1 0 BKZKS
BKZER Lock Indicator for Actual Revenue Postings CHAR 1 0 BKZER
BKZOB Lock Indicator for Commitment Update CHAR 1 0 BKZOB
PKZKS Lock Indicator for Plan Secondary Costs CHAR 1 0 PKZKS
PKZER Lock Indicator for Planning Revenues CHAR 1 0 PKZER
VMETH Indicator for Allowed Allocation Methods CHAR 2 0 VMETH
MGEFL Indicator for Recording Consumption Quantities CHAR 1 0 MGEFL
ABTEI Department CHAR 12 0 ABTEI
NKOST Subsequent Cost Center CHAR 10 0 NKOST
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KOSZSCHL CO-CCA Overhead Key CHAR 6 0 KOSZSCHL
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
ANRED Title CHAR 15 0 ANRED
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
PSTLZ Postal Code CHAR 10 0 PSTLZ
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
SPRAS Language Key LANG 1 0 T002 SPRAS
TELBX Telebox number CHAR 15 0 TELBX
TELF1 First telephone number CHAR 16 0 TELF1
TELF2 Second telephone number CHAR 16 0 TELF2
TELFX Fax Number CHAR 31 0 TELFX
TELTX Teletex number CHAR 30 0 TELTX
TELX1 Telex number CHAR 30 0 TELX1
DATLT Data communication line no. CHAR 14 0 DATLT
DRNAM Printer Destination for CCtr Report CHAR 4 0 KDNAM
KHINR Standard Hierarchy Area CHAR 12 0 KHINR
CCKEY Cost Collector Key CHAR 23 0 CCKEY
KOMPL Completion Flag for the Cost Center Master Record CHAR 1 0 KSKOM
STAKZ Indicator. Object Is Statistical CHAR 1 0 STAKZ
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
FUNKT Function of Cost Center CHAR 3 0 FUNKT_DLK
AFUNK Alternative Function of Cost Center CHAR 3 0 AFUNK_DLK
CPI_TEMPL Template for Activity-Independent Formula Planning CHAR 10 0 COTPL CCA_TEMPL_CPI
CPD_TEMPL Template for Activity-Dependent Formula Planning CHAR 10 0 COTPL CCA_TEMPL_CPD
FUNC_AREA Functional Area CHAR 16 0 TFKB FKBER
SCI_TEMPL Template: Activity-Independent Allocation to Cost Center CHAR 10 0 COTPL CCA_TEMPL_SCI
SCD_TEMPL Template: Activity-Dependent Allocation to Cost Center CHAR 10 0 COTPL CCA_TEMPL_SCD
SKI_TEMPL CCA_TEMPL_SKI CHAR 10 0 COTPL CCA_TEMPL_SKI
SKD_TEMPL Template: Act. Stat. Key Figure - Cost Center/Activity Type CHAR 10 0 COTPL CCA_TEMPL_SKD
EEW_CSKS_PS_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
ETYPE Equity type CHAR 3 0 T8JG JV_ETYPE
JV_OTYPE Joint Venture Object Type CHAR 4 0 JV_OTYPE
JV_JIBCL JIB/JIBE Class CHAR 3 0 T8J6A JV_JIBCL
JV_JIBSA JIB/JIBE Subclass A CHAR 5 0 T8J6C JV_JIBSA
BUDGET_CARRYING_COST_CTR Budget-Carrying Cost Center CHAR 10 0 FCO_BUDGET_CARRYING_COST_CTR
AVC_PROFILE Budget Availability Control: Profile CHAR 6 0 * FCO_AVC_PROFILE
AVC_ACTIVE Budget Availability Control for Cost Centers is Active CHAR 1 0 FCO_AVC_FOR_COST_CENTER_ACTIVE
FUND Fund CHAR 10 0 * BP_GEBER
GRANT_ID Grant CHAR 20 0 GM_GRANT_NBR
FUND_FIX_ASSIGNED Indicator for Fund with Fixed Assignment CHAR 1 0 PSM_FUND_FIX_ASSIGNED
GRANT_FIX_ASSIGNED Indicator for Grant with Fixed Assignment CHAR 1 0 PSM_GRANT_FIX_ASSIGNED
FUNC_AREA_FIX_ASSIGNED Indicator for Functional Area with Fixed Assignment CHAR 1 0 PSM_FUNC_AREA_FIX_ASSIGNED
FERC_IND Regulatory indicator CHAR 4 0 FERC_C7 FE_IND

CSKS foreign key relationships

Table Field Check Table Check Field
0 CSKS BUKRS T001 Company Codes BUKRS
1 CSKS CPD_TEMPL COTPL CO-ABC Template Master Data MANDT
1 CSKS CPD_TEMPL COTPL CO-ABC Template Master Data KOKRS
1 CSKS CPD_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
0 CSKS CPI_TEMPL COTPL CO-ABC Template Master Data MANDT
0 CSKS CPI_TEMPL COTPL CO-ABC Template Master Data KOKRS
0 CSKS CPI_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
1 CSKS ETYPE T8JG Valid Investment Group MANDT
1 CSKS ETYPE T8JG Valid Investment Group BUKRS
1 CSKS ETYPE T8JG Valid Investment Group VNAME
1 CSKS ETYPE T8JG Valid Investment Group FDATE
0 CSKS FERC_IND FERC_C7 Regulatory indicators MANDT
0 CSKS FERC_IND FERC_C7 Regulatory indicators IND
1 CSKS FUNC_AREA TFKB Functional areas FKBER
0 CSKS GSBER TGSB Business Areas MANDT
0 CSKS GSBER TGSB Business Areas GSBER
1 CSKS JV_JIBCL T8J6A JIB/JIBE Class MANDT
1 CSKS JV_JIBCL T8J6A JIB/JIBE Class BUKRS
1 CSKS JV_JIBCL T8J6A JIB/JIBE Class CLASS
0 CSKS JV_JIBSA T8J6C JIB/JIBE Subclass MANDT
0 CSKS JV_JIBSA T8J6C JIB/JIBE Subclass BUKRS
1 CSKS KALSM T683 Pricing procedures KAPPL
1 CSKS KALSM T683 Pricing procedures KALSM
0 CSKS KAPPL T681A Conditions: Applications KAPPL
1 CSKS KOKRS TKA01 Controlling Areas MANDT
0 CSKS KOSAR TKA05 Cost Center Types KOSAR
1 CSKS KVEWE T681V Conditions: Usages KVEWE
0 CSKS LAND1 T005 Countries MANDT
0 CSKS LAND1 T005 Countries LAND1
1 CSKS LOGSYSTEM TBDLS Logical system LOGSYS
0 CSKS OBJNR ONR00 General Object Number MANDT
1 CSKS RECID T8JJ Recovery Indicator MANDT
1 CSKS RECID T8JJ Recovery Indicator BUKRS
0 CSKS REGIO T005S Taxes: Region (Province) Key LAND1
1 CSKS SCD_TEMPL COTPL CO-ABC Template Master Data MANDT
1 CSKS SCD_TEMPL COTPL CO-ABC Template Master Data KOKRS
1 CSKS SCD_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
0 CSKS SCI_TEMPL COTPL CO-ABC Template Master Data MANDT
0 CSKS SCI_TEMPL COTPL CO-ABC Template Master Data KOKRS
0 CSKS SCI_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
1 CSKS SKD_TEMPL COTPL CO-ABC Template Master Data MANDT
1 CSKS SKD_TEMPL COTPL CO-ABC Template Master Data KOKRS
1 CSKS SKD_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
0 CSKS SKI_TEMPL COTPL CO-ABC Template Master Data MANDT
0 CSKS SKI_TEMPL COTPL CO-ABC Template Master Data KOKRS
0 CSKS SKI_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
1 CSKS SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 CSKS TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 CSKS TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 CSKS VERAK_USER USR02 Logon Data (Kernel-Side Use) BNAME
0 CSKS VNAME T8JV Joint Venture MANDT
0 CSKS VNAME T8JV Joint Venture BUKRS
0 CSKS VNAME T8JV Joint Venture VNAME
1 CSKS WAERS TCURC Currency Codes MANDT
1 CSKS WAERS TCURC Currency Codes WAERS
0 CSKS WERKS T001W Plants/Branches MANDT
0 CSKS WERKS T001W Plants/Branches WERKS