SAP table CSKS_EX (Cost Centers: Maintainable Fields)

SAP table CSKS_EX has 4 primary key fields being KOKRS,KOSTL,DATBI,DATAB.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 KOSTL
DATBI Valid To Date DATS 8 0 DATBI
STATUS Activation Status of Generic Master Record CHAR 1 0 CMDT_STATUS
A Active
D Inactive: Delete
I Inactive: Create
U Inactive: Change
DATAB Valid-From Date DATS 8 0 DATAB
KTEXT General Name CHAR 20 0 KTEXT
LTEXT Description CHAR 40 0 KLTXT
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
ERSDA Entered On DATS 8 0 ERFDT
USNAM Entered By CHAR 12 0 ERFNM
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
ABTEI Department CHAR 12 0 ABTEI
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
KHINR Standard Hierarchy Area CHAR 12 0 KHINR
PRCTR Profit Center CHAR 10 0 PRCTR
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
FUNC_AREA Functional Area CHAR 16 0 TFKB FKBER
WERKS Plant CHAR 4 0 WERKS_D
SPRAS2 Language Key LANG 1 0 SPRAS
BKZKP Lock Indicator for Actual Primary Postings CHAR 1 0 BKZKP
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
PKZKP Lock Indicator for Plan Primary Costs CHAR 1 0 PKZKP
PKZKS Lock Indicator for Plan Secondary Costs CHAR 1 0 PKZKS
PKZER Lock Indicator for Planning Revenues CHAR 1 0 PKZER
MGEFL Indicator for Recording Consumption Quantities CHAR 1 0 MGEFL
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KALSM Costing Sheet CHAR 6 0 T683 AUFKALSM
KOSZSCHL CO-CCA Overhead Key CHAR 6 0 KOSZSCHL
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
SCI_TEMPL Template: Activity-Independent Allocation to Cost Center CHAR 10 0 * CCA_TEMPL_SCI
SCD_TEMPL Template: Activity-Dependent Allocation to Cost Center CHAR 10 0 * CCA_TEMPL_SCD
SKI_TEMPL CCA_TEMPL_SKI CHAR 10 0 * CCA_TEMPL_SKI
SKD_TEMPL Template: Act. Stat. Key Figure - Cost Center/Activity Type CHAR 10 0 * CCA_TEMPL_SKD
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
LAND1 Country/Region Key CHAR 3 0 * 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
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
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
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
EEW_CSKS_PS_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
KOMPL Completion Flag for the Cost Center Master Record CHAR 1 0 KSKOM
MCTXT Search Term for Matchcode Use CHAR 20 0 MCDS3

CSKS_EX foreign key relationships

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