/SCWM/TAAREA
configSemantic keyActivity area definition — the execution-oriented grouping of bins that warehouse-order creation and pick-path sorting work against
Activity areas cut across storage types: the same bin can belong to different activity areas for picking and for putaway, which is why the bin-to-area assignment lives in /SCWM/LAGPS with the activity as part of its key.
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 —
LGNUMplus 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 theCHAR(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.
Structural facts — how the table is keyed, not a trap by itself
Join & extract hazards — verify before you rely on this
Fields
5 fields · 3 key
5 fields.
| # | Field | Description | Type | Flags |
|---|---|---|---|---|
| 1 | MANDT | Client | CLNT(3) | Key |
| 2 | LGNUM | EWM warehouse number | CHAR(4) | Key |
| 3 | AAREA | Activity area | CHAR(4) | Key |
| 4 | FLGAALOG | Whether warehouse-order creation writes log entries for this activity area | CHAR(1) | |
| 5 | JOINED_AREA | Marks activity areas that have been joined together | CHAR(1) |
Field provenance: hand-curated. 3 key fields.
Boilerplate SQL
Starting point for reading the replicated copy of /SCWM/TAAREAon 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.
5 parameters not filled: <catalog>, <schema>, <client>, <LGNUM>, <AAREA>
-- ============================================================
-- Table : /SCWM/TAAREA — Activity area definition — the execution-oriented grouping of bins that warehouse-order creation and pick-path sorting work against
-- Purpose: Column-selected read of /SCWM/TAAREA — auto-generated from field metadata
-- Grain : One row per client + LGNUM + AAREA
-- Notes : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/TAAREA; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_taarea — 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.LGNUM AS "EWM warehouse number",
t.AAREA AS "Activity area",
t.FLGAALOG AS "Whether warehouse-order creation writes log entries for this activity area",
t.JOINED_AREA AS "Marks activity areas that have been joined together"
FROM <catalog>.<schema>.scwm_taarea t
WHERE
t.MANDT = '<client>' -- client filter — drop on single-client systems
-- AND t.LGNUM = '<LGNUM>'
-- AND t.AAREA = '<AAREA>'
ORDER BY t.LGNUM;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
ON scwm_taarea.MANDT = scwm_t300.MANDT AND scwm_taarea.LGNUM = scwm_t300.LGNUMON scwm_lagps.MANDT = scwm_taarea.MANDT AND scwm_lagps.AAREA = scwm_taarea.AAREA AND scwm_lagps.LGNUM = scwm_taarea.LGNUMON scwm_who.MANDT = scwm_taarea.MANDT AND scwm_who.AREAWHO = scwm_taarea.AAREA AND scwm_who.LGNUM = scwm_taarea.LGNUM
More Warehouse Structure tables
- /SCWM/TDOORDoors — the loading and unloading points of the warehouse, each mapped to a bin, a default staging area, and (where a yard exists) the matching yard bin
- /SCWM/TWORKSTWork centers — the packing, deconsolidation, value-added-service, and counting stations in the warehouse, each modeled as a storage type and bin
- /SCWM/T300The warehouse number definition — one row per EWM warehouse, the four-character key every structure, bin, stock, and task row is striped by
- /SCWM/T300_MDWarehouse-to-party assignment — the supply chain unit the warehouse maps to plus the default entitled-to-dispose and ship-to parties
- /SCWM/T300TWarehouse number descriptions — one row per warehouse per language; the readable name behind LGNUM
- /SCWM/T301Storage type definition — one row per storage type in a warehouse; the first level of structure below the warehouse number