EWM Reference

/SCWM/T301T

textSemantic key

Storage type descriptions — one row per storage type per language

Identity

Module: Warehouse StructureBronze: scwm_t301t

Notes

Language-filtered like every SAP text table.

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.

Text companion

/SCWM/T301T holds the per-language descriptions for /SCWM/T301 — one row per SPRAS. Filter to one language or rows multiply.

Fields

5 fields · 4 key

5 fields.

Table fields: position, field name, description, data type, and flags. 5 fields.
#	Field	Description	Type	Flags
1	MANDT	Client	CLNT(3)	Key
2	SPRAS	Language key	LANG(1)	Key
3	LGNUM	EWM warehouse number	CHAR(4)	Key
4	LGTYP	Storage type	CHAR(4)	Key
5	LTYPT	Storage type description in the row's language	CHAR(40)

Field provenance: hand-curated. 4 key fields.

Boilerplate SQL

Starting point for reading the replicated copy of /SCWM/T301Ton 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)Warehouse number (LGNUM)Storage type

Include optional filters (2)

5 parameters not filled: <catalog>, <schema>, <client>, <LGNUM>, <LGTYP>

-- ============================================================
-- Table  : /SCWM/T301T — Storage type descriptions — one row per storage type per language
-- Purpose: Column-selected read of /SCWM/T301T — auto-generated from field metadata
-- Grain  : One row per client + SPRAS + LGNUM + LGTYP
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/T301T; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_t301t — adjust to your landing convention (see quirks #namespace-slashes). Timestamps flagged UTC are DEC(15) yyyymmddhhmmss values in UTC, not warehouse local time (#utc-timestamps).
-- ============================================================
SELECT
  t.MANDT AS "Client",
  t.SPRAS AS "Language key",
  t.LGNUM AS "EWM warehouse number",
  t.LGTYP AS "Storage type",
  t.LTYPT AS "Storage type description in the row's language"
FROM <catalog>.<schema>.scwm_t301t t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.LGTYP = '<LGTYP>'
ORDER BY t.SPRAS;

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/T301/SCWM/T301Ttext table · 1:N
ON scwm_t301.MANDT = scwm_t301t.MANDT AND scwm_t301.LGTYP = scwm_t301t.LGTYP AND scwm_t301.LGNUM = scwm_t301t.LGNUM AND scwm_t301t.SPRAS = '<language>'

Browse more Warehouse Structure tables