SAP Reference

CR01

Create S/4HANA status: Active

Create Work Center

Module: PP · Production Planning
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

5 parameters not filled: <catalog>, <schema>, <MANDT>, <WERKS>, <ARBPL>

-- ============================================================
-- T-Code : CR01 Create Work Center
-- Purpose: Create work center with capacity and standard-value keys
-- Grain  : One row per work center / plant / valid-period
-- Tables : CRHD, CRTX, CRCA, KAKO, T001W
-- Notes  : CRTX provides the work-center description and must be filtered by SPRAS. CRCA carries capacity assignments (one row per work-center × capacity category); capacity category (KAPAR) lives on KAKO, joined via KAPID. Cost-center assignment lives in CRCO, not CRHD.
-- ============================================================
SELECT
  -- Keys
  wc.MANDT  AS "Client",
  wc.OBJID  AS "Internal Object ID",
  wc.ARBPL  AS "Work Center",
  wc.WERKS  AS "Plant",

  -- Descriptive text
  ct.KTEXT  AS "Work Center Description",

  -- Dates
  wc.BEGDA  AS "Valid From",
  wc.ENDDA  AS "Valid To",

  -- Status / indicators
  wc.LOANZ  AS "Number of People",
  wc.PLANV  AS "Planner Group",
  wc.VGWTS  AS "Standard-Value Key",
  wc.STAND  AS "Standard Value Key",

  -- Org fields
  pt.NAME1  AS "Plant Name",
  wc.VERWE  AS "Work Center Category",

  -- Master data enrichment
  wc.VERAN  AS "Person Responsible",
  ca.KAPID  AS "Capacity ID",
  k.KAPAR   AS "Capacity Category"
FROM <catalog>.<schema>.crhd wc
LEFT JOIN <catalog>.<schema>.crtx ct
  ON  ct.MANDT = wc.MANDT
  AND ct.OBJTY = wc.OBJTY
  AND ct.OBJID = wc.OBJID
  AND ct.SPRAS = 'E'
LEFT JOIN <catalog>.<schema>.crca ca
  ON  ca.MANDT = wc.MANDT
  AND ca.OBJTY = wc.OBJTY
  AND ca.OBJID = wc.OBJID
LEFT JOIN <catalog>.<schema>.kako k
  ON  k.MANDT = ca.MANDT
  AND k.KAPID = ca.KAPID
LEFT JOIN <catalog>.<schema>.t001w pt
  ON  pt.MANDT = wc.MANDT
  AND pt.WERKS = wc.WERKS
WHERE
  wc.MANDT = '<MANDT>'
  AND wc.WERKS = '<WERKS>'
  -- AND wc.ARBPL = '<ARBPL>'
ORDER BY wc.WERKS, wc.ARBPL;

Tables Used by This Transaction

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

More Production Planning t-codes