KS01

-- ============================================================
-- T-Code : KS01 Create Cost Center
-- Purpose: Create cost center with validity period and hierarchy assignment
-- 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.
-- ============================================================
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.LOEVM  AS "Deletion Flag",
  cs.BKZKP  AS "Primary Lock - Planning",
  cs.BKZIST 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 csks cs
LEFT JOIN 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 t001 cc
  ON  cc.MANDT = cs.MANDT
  AND cc.BUKRS = cs.BUKRS
WHERE
  cs.MANDT = '100'
  AND cs.KOKRS = '<KOKRS>'
  -- AND cs.KOSTL = '<KOSTL>'
  -- AND cs.DATBI >= '<AS_OF_DATE>'
ORDER BY cs.KOKRS, cs.KOSTL;