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 are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

CSKS columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 MANDT
KeyKOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KeyKOSTL Cost Center CHAR 10 0 KOSTL
KeyDATBI 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
/ Relationships

CSKS foreign keys.

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