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 |