/SCWM/T331

-- ============================================================
-- Table  : /SCWM/T331 — Storage type control — the behavior of a storage type: its role, whether handling units are mandatory, the capacity check method and availability group, the putaway and stock-removal rules, replenishment level and tolerance, and the mixing rules that decide what may share a bin
-- Purpose: Column-selected read of /SCWM/T331 — auto-generated from field metadata
-- Grain  : One row per client + 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/T331; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_t331 — 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.LGTYP AS "Storage type whose behavior this row controls",
  t.ST_ROLE AS "Storage type role — what the storage type is used for (standard storage, staging, work centre, and so on)",
  t.HUOBL AS "Whether stock in this storage type must sit in a handling unit",
  t.KAPAP AS "Capacity check method used when putting stock away here",
  t.AVLGRP AS "Availability group — the stock-availability bucket the storage type reports into",
  t.AVLGRP_MAND AS "Whether an availability group is mandatory for the storage type",
  t.AVQLVL AS "Level at which available quantity is determined for the storage type",
  t.REM_RULE AS "Stock removal rule applied when picking from the storage type",
  t.PUT_RULE AS "Putaway rule applied when placing stock into the storage type",
  t.QUEIN AS "Whether putaway tasks into this storage type require confirmation",
  t.QUAUS AS "Whether stock removal tasks out of this storage type require confirmation",
  t.NEGAT AS "Whether negative stock is permitted in the storage type",
  t.FIXBIN AS "Whether the storage type works with fixed storage bins",
  t.MAXFIXBIN AS "Maximum number of fixed bins a product may hold in the storage type",
  t.REPL_LVL AS "Replenishment level the storage type is replenished at",
  t.REPL_TOL AS "Tolerance applied to the replenishment quantity",
  t.CHKSMAQ AS "Whether the maximum storage type quantity is checked",
  t.MIXBIN AS "Whether mixed stock is allowed in a bin or handling unit of the storage type",
  t.MIXHU AS "Whether mixed stock is allowed inside one handling unit",
  t.MIXBBD AS "Whether quants with different expiration dates may be added to the same bin or handling unit",
  t.BEHAV AS "Storage behavior of the storage type (standard, handling-unit managed, and so on)",
  t.STGTYP_LVL AS "Level of the storage type, used where storage types are layered",
  t.CAT_ROLE AS "Stock type role of the storage type",
  t.PROCS AS "External storage process step the storage type takes part in",
  t.AAREA_PLAN AS "Activity area used for planning in the storage type",
  t.DISTANCE_DEF AS "Default travel distance assumed for the storage type"
FROM <catalog>.<schema>.scwm_t331 t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.LGTYP = '<LGTYP>'
ORDER BY t.LGNUM;