EWM Reference

/SCWM/ORDIM_C

transactionMixed key

Confirmed warehouse tasks — the same movement after execution, carrying the actual quantity, the confirmation timestamp, and (with the creation stamp) the task cycle time

Identity

Module: Warehouse Tasks & OrdersBronze: scwm_ordim_cOther half: /SCWM/ORDIM_O

Classic WM

In the SAP reference: LTAK In the SAP reference: LTAP WM → EWM crosswalk

Grain note

One key column more than the open table (TAPOS, the task item) — a UNION of the two must account for the asymmetry rather than assuming identical keys

Notes

The confirmation side of the split. Exception codes, the processor, the start stamp, and actual alternate-unit quantities are all on the DDIC page and are strong swap-in candidates for a labor or exception analysis.

What the badges mean

master: Data class: what the table holds — master data, transaction documents, configuration, an organizational object, or a language-striped text companion.
Semantic key: Every non-client key column is readable business data — LGNUM plus a bin, task, or order number. Joins run on the columns you can see (see the quirks guide).
GUID key: Every non-client key column is a GUID — RAW(16) on the /SCWM, /SCDL, /LIME, and /SCMB tables, and the CHAR(22) compressed form on the product master. Join the raw column; a hex rendering is for reading only, and the two encodings need converting between (see the quirks guide).
Mixed key: The key mixes readable and GUID columns in either direction — a product GUID inside an otherwise-readable bin key, or a readable status type inside an otherwise-GUID key. Check which side of a join you are on (see the quirks guide).
DOCCAT: PDO: A /SCDL delivery table holds several document categories in one table — inbound and outbound requests, the inbound delivery, the outbound delivery order, and the final outbound delivery — discriminated by DOCCAT. The chips list the categories this table carries; anchor the one you mean or documents of every kind come back together (see the quirks guide).
Embedded S/4HANA only: Deployment: shown only when a table does not exist in both embedded S/4HANA EWM and decentralized EWM. No table in this wave is deployment-specific, so the badge stays absent until one is.

Used in the library

Cross-ERP guides

GuideSource History & Ingestion Path

GuideMedallion Layer Contracts for ERP Data

GuideERP Data Quality Checklist

Open & confirmed

/SCWM/ORDIM_C is one half of the warehouse-task split: confirming a task deletes the row from the open table and writes it to /SCWM/ORDIM_O, so neither table alone is the history. The boilerplate SQL below reads both with UNION ALL — see the quirks guide.

Fields

18 fields · 4 key

18 fields.

Table fields: position, field name, description, data type, and flags. 18 fields.
#	Field	Description	Type	Flags
1	MANDT	Client	CLNT(3)	Key
2	LGNUM	Warehouse number	CHAR(4)	Key
3	TANUM	Warehouse task number	NUMC(12)	Key
4	TAPOS	Warehouse task item — the extra key column that exists only on the confirmed table	NUMC(4)	Key
5	WHO	Warehouse order the task belonged to	NUMC(10)
6	PROCTY	Warehouse process type	CHAR(4)
7	QUEUE	Execution queue	CHAR(10)
8	MATID	Product GUID (RAW16 form)	RAW(16)
9	CAT	Stock type moved	CHAR(2)
10	VLPLA	Source storage bin	CHAR(18)
11	NLPLA	Destination storage bin	CHAR(18)
12	NISTM	Actual confirmed quantity in the base unit	QUAN(31,14)
13	MEINS	Base unit of measure	UNIT(3)
14	RDOCCAT	Reference document category — routes the reference GUIDs to the inbound or outbound delivery item table	CHAR(3)
15	RDOCID	GUID of the reference delivery document	RAW(16)
16	RITMID	GUID of the reference delivery item	RAW(16)
17	CREATED_AT	Task creation time	DEC(15)	UTC
18	CONFIRMED_AT	Task confirmation time — with the creation stamp, this gives the task cycle time	DEC(15)	UTCFilter date

Field provenance: hand-curated. 4 key fields.

Boilerplate SQL

Starting point for reading the replicated copy of /SCWM/ORDIM_Con Databricks — the client anchor is already in place, the namespaced name is rendered as the underscore bronze name replication targets conventionally land it under, and any RAW16 GUID column selects a hex rendering alongside the raw value. Set your Unity Catalog location, schema, and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaClient (MANDT)From timestamp (yyyymmddhhmmss, UTC)To timestamp (yyyymmddhhmmss, UTC)

Include optional filters (4)

5 parameters not filled: <catalog>, <schema>, <client>, <TS_FROM>, <TS_TO>

-- ============================================================
-- Table  : /SCWM/ORDIM_C + /SCWM/ORDIM_O — open and confirmed warehouse tasks
-- Purpose: Task history across the open/confirmed split — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + TANUM + TAPOS (open) or client + LGNUM + TANUM (confirmed)
-- Caution: Confirming a warehouse task DELETES the row from /SCWM/ORDIM_C and writes it to /SCWM/ORDIM_O — neither table alone is task history; /SCWM/ORDIM_O carries one extra key column the open table does not. See quirks guide #ordim-union.
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/ORDIM_C / /SCWM/ORDIM_O; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_ordim_c / scwm_ordim_o — adjust to your landing convention (see quirks #namespace-slashes). RAW16 GUID columns are joined raw; the hex aliases are for display only (#guid-keys). Timestamps flagged UTC are DEC(15) yyyymmddhhmmss values in UTC, not warehouse local time (#utc-timestamps).
-- ============================================================
SELECT
  t.MANDT AS "Client",
  t.LGNUM AS "Warehouse number",
  t.TANUM AS "Warehouse task number",
  t.TAPOS AS "Warehouse task item — the extra key column that exists only on the confirmed table",
  t.WHO AS "Warehouse order the task belonged to",
  t.PROCTY AS "Warehouse process type",
  t.QUEUE AS "Execution queue",
  t.MATID AS "Product GUID (RAW16 form)",
  lower(hex(t.MATID)) AS "Product GUID (RAW16 form) (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.CAT AS "Stock type moved",
  t.VLPLA AS "Source storage bin",
  t.NLPLA AS "Destination storage bin",
  t.NISTM AS "Actual confirmed quantity in the base unit",
  t.MEINS AS "Base unit of measure",
  t.RDOCCAT AS "Reference document category — routes the reference GUIDs to the inbound or outbound delivery item table",
  t.RDOCID AS "GUID of the reference delivery document",
  lower(hex(t.RDOCID)) AS "GUID of the reference delivery document (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.RITMID AS "GUID of the reference delivery item",
  lower(hex(t.RITMID)) AS "GUID of the reference delivery item (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.CREATED_AT AS "Task creation time",  -- UTC
  t.CONFIRMED_AT AS "Task confirmation time — with the creation stamp, this gives the task cycle time",  -- UTC
  NULL AS "Source storage type",  -- not on /SCWM/ORDIM_C
  NULL AS "Destination storage type",  -- not on /SCWM/ORDIM_C
  NULL AS "Target quantity in the base unit of measure",  -- not on /SCWM/ORDIM_C
  'OPEN' AS "Task state"
FROM <catalog>.<schema>.scwm_ordim_c t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- range below applies to /SCWM/ORDIM_C's own CONFIRMED_AT, not to the other branch's timestamp
  -- AND t.CONFIRMED_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CONFIRMED_AT <= <TS_TO>
UNION ALL
SELECT
  t.MANDT AS "Client",
  t.LGNUM AS "Warehouse number",
  t.TANUM AS "Warehouse task number",
  NULL AS "Warehouse task item — the extra key column that exists only on the confirmed table",  -- not on /SCWM/ORDIM_O
  t.WHO AS "Warehouse order the task belonged to",
  t.PROCTY AS "Warehouse process type",
  t.QUEUE AS "Execution queue",
  t.MATID AS "Product GUID (RAW16 form)",
  lower(hex(t.MATID)) AS "Product GUID (RAW16 form) (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.CAT AS "Stock type moved",
  t.VLPLA AS "Source storage bin",
  t.NLPLA AS "Destination storage bin",
  NULL AS "Actual confirmed quantity in the base unit",  -- not on /SCWM/ORDIM_O
  t.MEINS AS "Base unit of measure",
  t.RDOCCAT AS "Reference document category — routes the reference GUIDs to the inbound or outbound delivery item table",
  t.RDOCID AS "GUID of the reference delivery document",
  lower(hex(t.RDOCID)) AS "GUID of the reference delivery document (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.RITMID AS "GUID of the reference delivery item",
  lower(hex(t.RITMID)) AS "GUID of the reference delivery item (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.CREATED_AT AS "Task creation time",  -- UTC
  NULL AS "Task confirmation time — with the creation stamp, this gives the task cycle time",  -- not on /SCWM/ORDIM_O · UTC
  t.VLTYP AS "Source storage type",
  t.NLTYP AS "Destination storage type",
  t.VSOLM AS "Target quantity in the base unit of measure",
  'CONFIRMED' AS "Task state"
FROM <catalog>.<schema>.scwm_ordim_o t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- range below applies to /SCWM/ORDIM_O's own CREATED_AT, not to the other branch's timestamp
  -- AND t.CREATED_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CREATED_AT <= <TS_TO>
;

Verified August 2026

Landing conventions differ — see namespaced names in a lakehouse.

Relationships

Diagram of 1-hop neighbors — join details below. GUID joins and text-table joins are highlighted; they’re the joins newcomers most often get wrong.

Join details

/SCWM/ORDIM_C/SCWM/WHOforeign key · N:1
ON scwm_ordim_c.MANDT = scwm_who.MANDT AND scwm_ordim_c.WHO = scwm_who.WHO AND scwm_ordim_c.LGNUM = scwm_who.LGNUM
/SCWM/ORDIM_C/SCWM/LAGPforeign key · N:1
ON scwm_ordim_c.MANDT = scwm_lagp.MANDT AND scwm_ordim_c.VLPLA = scwm_lagp.LGPLA AND scwm_ordim_c.LGNUM = scwm_lagp.LGNUM
/SCWM/ORDIM_C/SCWM/LAGPforeign key · N:1
ON scwm_ordim_c.MANDT = scwm_lagp.MANDT AND scwm_ordim_c.NLPLA = scwm_lagp.LGPLA AND scwm_ordim_c.LGNUM = scwm_lagp.LGNUM
/SCWM/ORDIM_C/SAPAPO/MATKEYGUID join · N:1
ON scwm_ordim_c.MANDT = sapapo_matkey.MANDT AND scwm_ordim_c.MATID = sapapo_matkey.MATID -- the /SCWM side is RAW(16) and MATKEY keys the CHAR 22 compressed form — convert before comparing; this is not a raw equality
the /SCWM side is RAW(16) and MATKEY keys the CHAR 22 compressed form — convert before comparing; this is not a raw equality
/SCWM/ORDIM_C/SCDL/DB_PROCI_IGUID join · N:1
ON scwm_ordim_c.MANDT = scdl_db_proci_i.MANDT AND scwm_ordim_c.RDOCID = scdl_db_proci_i.DOCID AND scwm_ordim_c.RITMID = scdl_db_proci_i.ITEMID -- RAW16 GUID equality — join raw; hex is for display/conformance only · applies when RDOCCAT identifies an inbound delivery
applies when RDOCCAT identifies an inbound delivery
/SCWM/ORDIM_C/SCDL/DB_PROCI_OGUID join · N:1
ON scwm_ordim_c.MANDT = scdl_db_proci_o.MANDT AND scwm_ordim_c.RDOCID = scdl_db_proci_o.DOCID AND scwm_ordim_c.RITMID = scdl_db_proci_o.ITEMID -- RAW16 GUID equality — join raw; hex is for display/conformance only · applies when RDOCCAT identifies an outbound delivery order
applies when RDOCCAT identifies an outbound delivery order
/SCWM/ORDIM_C/SCWM/T346foreign key · N:1
ON scwm_ordim_c.MANDT = scwm_t346.MANDT AND scwm_ordim_c.QUEUE = scwm_t346.QUEUE AND scwm_ordim_c.LGNUM = scwm_t346.LGNUM

Transaction codes that touch this table

Curated: the EWM transactions an analyst would trace back to these rows, and how each one touches them.

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

Browse more Warehouse Tasks & Orders tables