/SCWM/T301G

-- ============================================================
-- Table  : /SCWM/T301G — Storage type groups — the grouping of storage types that share one stock-removal rule, putaway rule, and maximum-quantity check
-- Purpose: Column-selected read of /SCWM/T301G — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + LGTYPGRP
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/T301G; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_t301g — 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.LGTYPGRP AS "Storage type group",
  t.REM_RULE AS "Stock removal rule the group applies",
  t.PUT_RULE AS "Putaway rules the group applies",
  t.CHKSMAQ AS "Whether the maximum quantity is checked at group level",
  t.SMAQ_TYPE AS "How the group's maximum quantity is defined"
FROM <catalog>.<schema>.scwm_t301g t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
ORDER BY t.LGNUM;