SAP table CSKSB (Cost center master strucure for change documents)
SAP table CSKSB has 5 primary key fields being MANDT,KOKRS,KOSTL,DATBI,DATAB.
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 | KOKRS | ||
| KOSTL | Cost Center | CHAR | 10 | 0 | KOSTL | ||
| DATBI | Valid To Date | DATS | 8 | 0 | DATBI | ||
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||
| ERSDA | Entered On | DATS | 8 | 0 | ERFDT | ||
| USNAM | Entered By | CHAR | 12 | 0 | ERFNM | ||
| 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 | ||
| VMETH | Indicator for Allowed Allocation Methods | CHAR | 2 | 0 | VMETH | ||
| MGEFL | Indicator for Recording Consumption Quantities | CHAR | 1 | 0 | MGEFL | ||
| BUKRS | Company Code | CHAR | 4 | 0 | BUKRS | ||
| GSBER | Business Area | CHAR | 4 | 0 | GSBER | ||
| ABTEI | Department | CHAR | 12 | 0 | ABTEI | ||
| KOSAR | Cost Center Category | CHAR | 1 | 0 | KOSAR | ||
| VERAK | Person Responsible | CHAR | 20 | 0 | VERAK | ||
| VERAK_USER | User Responsible | CHAR | 12 | 0 | USR02 | VERAK_USER | |
| WAERS | Currency Key | CUKY | 5 | 0 | WAERS | ||
| NKOST | Subsequent Cost Center | CHAR | 10 | 0 | NKOST | ||
| KVEWE | Usage of the condition table | CHAR | 1 | 0 | KVEWE | ||
| KAPPL | Application | CHAR | 2 | 0 | KAPPL | ||
| KALSM | Costing Sheet | CHAR | 6 | 0 | AUFKALSM | ||
| KOSZSCHL | CO-CCA Overhead Key | CHAR | 6 | 0 | KOSZSCHL | ||
| 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 | REGIO | ||
| SPRAS | Language Key | LANG | 1 | 0 | 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 | ||
| TXJCD | Tax Jurisdiction | CHAR | 15 | 0 | TTXJ | TXJCD | |
| RECIND | Recovery Indicator | CHAR | 2 | 0 | T8JJ | JV_RECIND | |
| PRCTR | Profit Center | CHAR | 10 | 0 | PRCTR | ||
| EEW_CSKS_PS_DUMMY | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY | ||
| KTEXT | General Name | CHAR | 20 | 0 | KTEXT | ||
| LTEXT | Description | CHAR | 40 | 0 | KLTXT | ||
| 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 | |
| LOGSYSTEM | Logical System | CHAR | 10 | 0 | TBDLS | LOGSYS_CO | |
| CPI_TEMPL | Template for Activity-Independent Formula Planning | CHAR | 10 | 0 | CCA_TEMPL_CPI | ||
| CPD_TEMPL | Template for Activity-Dependent Formula Planning | CHAR | 10 | 0 | CCA_TEMPL_CPD | ||
| FUNC_AREA | Functional Area | CHAR | 16 | 0 | TFKB | FKBER | |
| 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 | ||
| 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 |
CSKSB foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 CSKSB | ETYPE | T8JG | Valid Investment Group | MANDT |
| 0 CSKSB | ETYPE | T8JG | Valid Investment Group | BUKRS |
| 0 CSKSB | ETYPE | T8JG | Valid Investment Group | VNAME |
| 0 CSKSB | ETYPE | T8JG | Valid Investment Group | FDATE |
| 1 CSKSB | FUNC_AREA | TFKB | Functional areas | FKBER |
| 0 CSKSB | JV_JIBCL | T8J6A | JIB/JIBE Class | MANDT |
| 0 CSKSB | JV_JIBCL | T8J6A | JIB/JIBE Class | BUKRS |
| 0 CSKSB | JV_JIBCL | T8J6A | JIB/JIBE Class | CLASS |
| 1 CSKSB | JV_JIBSA | T8J6C | JIB/JIBE Subclass | MANDT |
| 1 CSKSB | JV_JIBSA | T8J6C | JIB/JIBE Subclass | BUKRS |
| 0 CSKSB | LOGSYSTEM | TBDLS | Logical system | LOGSYS |
| 1 CSKSB | OBJNR | ONR00 | General Object Number | MANDT |
| 0 CSKSB | RECID | T8JJ | Recovery Indicator | MANDT |
| 0 CSKSB | RECID | T8JJ | Recovery Indicator | BUKRS |
| 1 CSKSB | RECIND | T8JJ | Recovery Indicator | MANDT |
| 1 CSKSB | RECIND | T8JJ | Recovery Indicator | BUKRS |
| 0 CSKSB | TXJCD | TTXJ | Check Table for Tax Jurisdiction | MANDT |
| 0 CSKSB | TXJCD | TTXJ | Check Table for Tax Jurisdiction | KALSM |
| 1 CSKSB | VERAK_USER | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| 0 CSKSB | VNAME | T8JV | Joint Venture | MANDT |
| 0 CSKSB | VNAME | T8JV | Joint Venture | BUKRS |
| 0 CSKSB | VNAME | T8JV | Joint Venture | VNAME |