SAP Table CSKS_EX
Cost Centers: Maintainable Fields
CSKS_EX (Cost Centers: Maintainable Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link CSKS_EX to other SAP tables.
CSKS_EX table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||||||
DATBI | Valid To Date | DATBI | DATS | 8 | 0 | |||||||||||
STATUS | Activation Status of Generic Master Record | CMDT_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||||
DATAB | Valid-From Date | DATAB | DATS | 8 | 0 | |||||||||||
KTEXT | General Name | KTEXT | CHAR | 20 | 0 | |||||||||||
LTEXT | Description | KLTXT | CHAR | 40 | 0 | |||||||||||
OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||||
ERSDA | Created on | ERFDT | DATS | 8 | 0 | |||||||||||
USNAM | Entered by | ERFNM | CHAR | 12 | 0 | |||||||||||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||
GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||
ABTEI | Department | ABTEI | CHAR | 12 | 0 | |||||||||||
KOSAR | Cost Center Category | KOSAR | TKA05 | CHAR | 1 | 0 | ||||||||||
VERAK | Person Responsible | VERAK | CHAR | 20 | 0 | |||||||||||
VERAK_USER | User Responsible | VERAK_USER | USR02 | CHAR | 12 | 0 | ||||||||||
WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||
KHINR | Standard Hierarchy Area | KHINR | CHAR | 12 | 0 | |||||||||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | 0 | |||||||||||
LOGSYSTEM | Logical System | LOGSYSTEM | TBDLS | CHAR | 10 | 0 | ||||||||||
FUNC_AREA | Functional Area | FKBER | TFKB | CHAR | 16 | 0 | ||||||||||
WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||||
SPRAS2 | Language Key | SPRAS | LANG | 1 | 0 | |||||||||||
BKZKP | Lock Indicator for Actual Primary Postings | BKZKP | CHAR | 1 | 0 |
Possible values
|
||||||||||
BKZKS | Lock Indicator for Actual Secondary Costs | BKZKS | CHAR | 1 | 0 |
Possible values
|
||||||||||
BKZER | Lock Indicator for Actual Revenue Postings | BKZER | CHAR | 1 | 0 |
Possible values
|
||||||||||
BKZOB | Lock Indicator for Commitment Update | BKZOB | CHAR | 1 | 0 |
Possible values
|
||||||||||
PKZKP | Lock Indicator for Plan Primary Costs | PKZKP | CHAR | 1 | 0 |
Possible values
|
||||||||||
PKZKS | Lock Indicator for Plan Secondary Costs | PKZKS | CHAR | 1 | 0 |
Possible values
|
||||||||||
PKZER | Lock Indicator for Planning Revenues | PKZER | CHAR | 1 | 0 |
Possible values
|
||||||||||
MGEFL | Indicator for Recording Consumption Quantities | MGEFL | CHAR | 1 | 0 |
Possible values
|
||||||||||
KVEWE | Usage of the condition table | KVEWE | T681V | CHAR | 1 | 0 | ||||||||||
KAPPL | Application | KAPPL | T681A | CHAR | 2 | 0 | ||||||||||
KALSM | Costing Sheet | AUFKALSM | T683 | CHAR | 6 | 0 | ||||||||||
KOSZSCHL | CO-CCA Overhead Key | KOSZSCHL | CHAR | 6 | 0 | |||||||||||
CPI_TEMPL | Template for Activity-Independent Formula Planning | CCA_TEMPL_CPI | COTPL | CHAR | 10 | 0 | ||||||||||
CPD_TEMPL | Template for Activity-Dependent Formula Planning | CCA_TEMPL_CPD | COTPL | CHAR | 10 | 0 | ||||||||||
SCI_TEMPL | Template: Activity-Independent Allocation to Cost Center | CCA_TEMPL_SCI | CHAR | 10 | 0 | |||||||||||
SCD_TEMPL | Template: Activity-Dependent Allocation to Cost Center | CCA_TEMPL_SCD | CHAR | 10 | 0 | |||||||||||
LAND1 | Country Key | LAND1 | CHAR | 3 | 0 | |||||||||||
ANRED | Title | ANRED | CHAR | 15 | 0 | |||||||||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | 0 | |||||||||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | 0 | |||||||||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | 0 | |||||||||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | 0 | |||||||||||
ORT01 | City | ORT01_GP | CHAR | 35 | 0 | |||||||||||
ORT02 | District | ORT02_GP | CHAR | 35 | 0 | |||||||||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | 0 | |||||||||||
PFACH | PO Box | PFACH | CHAR | 10 | 0 | |||||||||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||||||||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | 0 | |||||||||||
REGIO | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | 0 | |||||||||||
SPRAS | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||||
TELBX | Telebox number | TELBX | CHAR | 15 | 0 | |||||||||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | 0 | |||||||||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | 0 | |||||||||||
TELFX | Fax Number | TELFX | CHAR | 31 | 0 | |||||||||||
TELTX | Teletex number | TELTX | CHAR | 30 | 0 | |||||||||||
TELX1 | Telex number | TELX1 | CHAR | 30 | 0 | |||||||||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | 0 | |||||||||||
DRNAM | Printer destination for CCtr report | KDNAM | CHAR | 4 | 0 | |||||||||||
VNAME | Joint Venture | JV_NAME | T8JV | CHAR | 6 | 0 | ||||||||||
RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR | 2 | 0 | ||||||||||
ETYPE | Equity type | JV_ETYPE | T8JG | CHAR | 3 | 0 | ||||||||||
JV_OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | 0 | |||||||||||
JV_JIBCL | JIB/JIBE Class | JV_JIBCL | T8J6A | CHAR | 3 | 0 | ||||||||||
JV_JIBSA | JIB/JIBE Subclass A | JV_JIBSA | T8J6C | CHAR | 5 | 0 | ||||||||||
KOMPL | Completion flag for the cost center master record | KSKOM | CHAR | 1 | 0 |
Possible values
|
||||||||||
MCTXT | Search term for matchcode use | MCDS3 | CHAR | 20 | 0 |
CSKS_EX foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
CSKS_EX | BUKRS | SY | MANDT | T001 | Company Codes | MANDT |
CSKS_EX | BUKRS | CSKS_EX | BUKRS | T001 | Company Codes | BUKRS |
CSKS_EX | CPD_TEMPL | SY | MANDT | COTPL | CO-ABC Template Master Data | MANDT |
CSKS_EX | CPD_TEMPL | * | COTPL | CO-ABC Template Master Data | KOKRS | |
CSKS_EX | CPD_TEMPL | 'CPD' | COTPL | CO-ABC Template Master Data | CLASS | |
CSKS_EX | CPD_TEMPL | CSKS_EX | CPD_TEMPL | COTPL | CO-ABC Template Master Data | TEMPLATE |
CSKS_EX | CPI_TEMPL | 'CPI' | COTPL | CO-ABC Template Master Data | CLASS | |
CSKS_EX | CPI_TEMPL | CSKS_EX | CPI_TEMPL | COTPL | CO-ABC Template Master Data | TEMPLATE |
CSKS_EX | CPI_TEMPL | SY | MANDT | COTPL | CO-ABC Template Master Data | MANDT |
CSKS_EX | CPI_TEMPL | * | COTPL | CO-ABC Template Master Data | KOKRS | |
CSKS_EX | ETYPE | CSKS_EX | VNAME | T8JG | Valid Investment Group | VNAME |
CSKS_EX | ETYPE | CSKS_EX | ETYPE | T8JG | Valid Investment Group | ETYPE |
CSKS_EX | ETYPE | * | T8JG | Valid Investment Group | FDATE | |
CSKS_EX | ETYPE | SYST | MANDT | T8JG | Valid Investment Group | MANDT |
CSKS_EX | ETYPE | GJV_OBJDAT | BUKRS | T8JG | Valid Investment Group | BUKRS |
CSKS_EX | FUNC_AREA | SY | MANDT | TFKB | Functional areas | MANDT |
CSKS_EX | FUNC_AREA | CSKS_EX | FUNC_AREA | TFKB | Functional areas | FKBER |
CSKS_EX | GSBER | SY | MANDT | TGSB | Business Areas | MANDT |
CSKS_EX | GSBER | CSKS_EX | GSBER | TGSB | Business Areas | GSBER |
CSKS_EX | JV_JIBCL | SYST | MANDT | T8J6A | JIB/JIBE Class | MANDT |
CSKS_EX | JV_JIBCL | GJV_OBJDAT | BUKRS | T8J6A | JIB/JIBE Class | BUKRS |
CSKS_EX | JV_JIBCL | CSKS_EX | JV_JIBCL | T8J6A | JIB/JIBE Class | CLASS |
CSKS_EX | JV_JIBSA | GJV_OBJDAT | BUKRS | T8J6C | JIB/JIBE Subclass | BUKRS |
CSKS_EX | JV_JIBSA | CSKS_EX | JV_JIBCL | T8J6C | JIB/JIBE Subclass | CLASS |
CSKS_EX | JV_JIBSA | CSKS_EX | JV_JIBSA | T8J6C | JIB/JIBE Subclass | SUBCLASS |
CSKS_EX | JV_JIBSA | SYST | MANDT | T8J6C | JIB/JIBE Subclass | MANDT |
CSKS_EX | KALSM | CSKS_EX | KALSM | T683 | Pricing procedures | KALSM |
CSKS_EX | KALSM | SY | MANDT | T683 | Pricing procedures | MANDT |
CSKS_EX | KALSM | CSKS_EX | KVEWE | T683 | Pricing procedures | KVEWE |
CSKS_EX | KALSM | CSKS_EX | KAPPL | T683 | Pricing procedures | KAPPL |
CSKS_EX | KAPPL | CSKS_EX | KAPPL | T681A | Conditions: Applications | KAPPL |
CSKS_EX | KOKRS | CSKS_EX | MANDT | TKA01 | Controlling Areas | MANDT |
CSKS_EX | KOKRS | CSKS_EX | KOKRS | TKA01 | Controlling Areas | KOKRS |
CSKS_EX | KOSAR | SY | MANDT | TKA05 | Cost Center Types | MANDT |
CSKS_EX | KOSAR | CSKS_EX | KOSAR | TKA05 | Cost Center Types | KOSAR |
CSKS_EX | KVEWE | CSKS_EX | KVEWE | T681V | Conditions: Usages | KVEWE |
CSKS_EX | LOGSYSTEM | CSKS_EX | LOGSYSTEM | TBDLS | Logical system | LOGSYS |
CSKS_EX | MANDT | CSKS_EX | MANDT | T000 | Clients | MANDT |
CSKS_EX | OBJNR | CSKS_EX | MANDT | ONR00 | General Object Number | MANDT |
CSKS_EX | OBJNR | CSKS_EX | OBJNR | ONR00 | General Object Number | OBJNR |
CSKS_EX | RECID | SYST | MANDT | T8JJ | Recovery Indicator | MANDT |
CSKS_EX | RECID | GJV_OBJDAT | BUKRS | T8JJ | Recovery Indicator | BUKRS |
CSKS_EX | RECID | CSKS_EX | RECID | T8JJ | Recovery Indicator | RECID |
CSKS_EX | REGIO | CSKS_EX | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
CSKS_EX | REGIO | SY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
CSKS_EX | REGIO | CSKS_EX | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
CSKS_EX | SPRAS | CSKS_EX | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
CSKS_EX | VERAK_USER | * | USR02 | Logon Data (Kernel-Side Use) | MANDT | |
CSKS_EX | VERAK_USER | CSKS_EX | VERAK_USER | USR02 | Logon Data (Kernel-Side Use) | BNAME |
CSKS_EX | VNAME | SYST | MANDT | T8JV | Joint Venture | MANDT |
CSKS_EX | VNAME | GJV_OBJDAT | BUKRS | T8JV | Joint Venture | BUKRS |
CSKS_EX | VNAME | CSKS_EX | VNAME | T8JV | Joint Venture | VNAME |
CSKS_EX | WAERS | CSKS_EX | WAERS | TCURC | Currency Codes | WAERS |
CSKS_EX | WAERS | SY | MANDT | TCURC | Currency Codes | MANDT |