F4100

-- ============================================================
-- Table  : F4100 Warehouse location master: one row per storage location within a branch/plant, defining physical attributes plus putaway, pick, and replenishment behavior.
-- Purpose: Column-selected read of F4100 — auto-generated from field metadata
-- Grain  : One row per LMMCU + LMLOCN
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  TRIM(f.LMMCU) AS "Branch/plant (business unit); stored right-justified with leading blanks.",
  f.LMLOCN AS "Storage location within the branch, formatted per the branch location structure.",
  f.LMAISL AS "Aisle segment of the location code.",
  f.LMBIN AS "Bin segment of the location code.",
  f.LMLA03 AS "Location category code 03 (site-defined classification).",
  f.LMLA04 AS "Location category code 04 (site-defined classification).",
  f.LMLA05 AS "Location category code 05 (site-defined classification).",
  f.LMLA06 AS "Location category code 06 (site-defined classification).",
  f.LMLA07 AS "Location category code 07 (site-defined classification).",
  f.LMLA08 AS "Location category code 08 (site-defined classification).",
  f.LMLA09 AS "Location category code 09 (site-defined classification).",
  f.LMLA10 AS "Location category code 10 (site-defined classification).",
  f.LMLLDL AS "Level-of-detail code for location rollups.",
  f.LMSTY1 AS "Location dimension group, used to match item storage requirements to locations.",
  f.LMCGRP AS "Location characteristics group for warehouse movement rules.",
  f.LMLHLD AS "Hold code that blocks activity against this location.",
  f.LMFREZ AS "Freeze rule controlling whether the location accepts putaway/pick during freeze.",
  f.LMNETA AS "Flag: whether stock here counts as nettable/allocatable for planning.",
  f.LMMNUP AS "Minimum fill percentage before putaway is allowed to this location.",
  f.LMMNUK AS "Minimum fill percentage before picking is allowed from this location.",
  f.LMLCOD AS "Location tax status code.",
  f.LMMMTH AS "Move method code for warehouse movement to/from this location.",
  f.LMEQTY AS "Container (equipment) code allowed in this location.",
  f.LMCTNF AS "Flag: location participates in carton recommendation.",
  f.LMMCNT AS "Flag: different container types may be mixed here.",
  f.LMMLOT AS "Flag: different dates/lots may be mixed here.",
  f.LMMITM AS "Maximum number of distinct items allowed in the location.",
  f.LMSTAG AS "Flag: this is a staging location.",
  f.LMLVER AS "Location verification code (bar-code check value).",
  f.LMPCNF AS "Flag: storage (putaway) confirmation is required.",
  f.LMKCNF AS "Flag: retrieval (pick) confirmation is required.",
  f.LMAPUT AS "Flag: putaway allowed to this location.",
  f.LMAPIK AS "Flag: picking allowed from this location.",
  f.LMARPL AS "Flag: replenishment allowed for this location.",
  f.LMPZON AS "Putaway zone the location belongs to.",
  f.LMKZON AS "Picking zone the location belongs to.",
  f.LMZONR AS "Replenishment zone the location belongs to.",
  f.LMSTGP AS "Staging location used for putaway moves.",
  f.LMSTGK AS "Staging location used for picking moves.",
  f.LMSTGR AS "Staging location used for replenishment moves."
  -- … plus 17 more columns — full list in the Fields section above
FROM <catalog>.<schema_data>.f4100 f
WHERE
  f.LMMCU = '<MCU>'
ORDER BY f.LMMCU;