SAP Reference

KS03

Display S/4HANA status: Active

Display Cost Center

Module: CO · Controlling
What the badges mean
S/4HANA status: Active
Active and unchanged in S/4HANA.
S/4HANA status: Deprecated
Still readable today, but no longer SAP's strategic path — plan around it.
S/4HANA status: Replaced
Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
S/4HANA status: Migrating to IBP
Planning scope is moving from APO toward IBP.
S/4HANA status: Active (StRM) · Replaced (EWM)
Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
S/4HANA status: Replaced · Compat View
Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
S/4HANA status: Active · Proxy View
Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
master
Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters

6 parameters not filled: <catalog>, <schema>, <MANDT>, <KOKRS>, <KOSTL>, <AS_OF_DATE>

-- ============================================================
-- T-Code : KS03 Display Cost Center
-- Purpose: Display cost center master
-- Grain  : One row per cost center / validity period
-- Tables : CSKS, CSKT, T001, TKA01
-- Notes  : CSKS is the cost-center master; CSKT carries the description per language and validity period. Filter DATBI + DATAB on both if you want only currently-valid rows. CSKS has no deletion-flag field — a cost center's validity is date-based (DATAB/DATBI), so 'deletion' is expressed as an expired validity period, not a flag.
-- ============================================================
SELECT
  -- Keys
  cs.MANDT  AS "Client",
  cs.KOKRS  AS "Controlling Area",
  cs.KOSTL  AS "Cost Center",

  -- Descriptive text
  ct.KTEXT  AS "Cost Center Name",
  ct.LTEXT  AS "Cost Center Long Text",

  -- Dates
  cs.DATAB  AS "Valid From",
  cs.DATBI  AS "Valid To",
  cs.ERSDA  AS "Created On",

  -- Status / indicators
  cs.PKZKP  AS "Primary Lock - Planning",
  cs.BKZKP  AS "Primary Lock - Actual",

  -- Org fields
  cs.BUKRS  AS "Company Code",
  cc.BUTXT  AS "Company Code Name",
  cs.WERKS  AS "Plant",
  cs.GSBER  AS "Business Area",
  cs.ABTEI  AS "Department",

  -- Master data enrichment
  cs.KOSAR  AS "Cost Center Category",
  cs.VERAK  AS "Person Responsible",
  cs.KHINR  AS "Hierarchy Area",
  cs.PRCTR  AS "Profit Center",
  cs.WAERS  AS "Currency"
FROM <catalog>.<schema>.csks cs
LEFT JOIN <catalog>.<schema>.cskt ct
  ON  ct.MANDT = cs.MANDT
  AND ct.KOKRS = cs.KOKRS
  AND ct.KOSTL = cs.KOSTL
  AND ct.DATBI = cs.DATBI
  AND ct.SPRAS = 'E'
LEFT JOIN <catalog>.<schema>.t001 cc
  ON  cc.MANDT = cs.MANDT
  AND cc.BUKRS = cs.BUKRS
WHERE
  cs.MANDT = '<MANDT>'
  AND cs.KOKRS = '<KOKRS>'
  -- AND cs.KOSTL = '<KOSTL>'
  -- AND cs.DATBI >= '<AS_OF_DATE>'
ORDER BY cs.KOKRS, cs.KOSTL;

Tables Used by This Transaction

How these tables connect — join details in the list below.

Join details

  • CSKSCSKTtext table · 1:N
    ON csks.KOSTL = cskt.KOSTL

R read · W write · R/W read + write

More Controlling t-codes