EWM Reference
/SCWM/LS03
DisplayDisplay a storage bin — the bin's type, section, capacity, block indicators, and the stock currently sitting in it
Tables behind this transaction
Curated: these are the tables an analyst reads to see what this transaction did, and how it touches each of them. Every table page carries its own field list and Databricks SQL.
How these tables connect — join details in the list below. GUID joins and text-table joins are highlighted.
Join details
ON scwm_lagp.MANDT = scwm_t303.MANDT AND scwm_lagp.LPTYP = scwm_t303.LPTYP AND scwm_lagp.LGNUM = scwm_t303.LGNUMON scwm_lagps.MANDT = scwm_lagp.MANDT AND scwm_lagps.LGPLA = scwm_lagp.LGPLA AND scwm_lagps.LGNUM = scwm_lagp.LGNUMON scwm_aqua.MANDT = scwm_lagp.MANDT AND scwm_aqua.LGPLA = scwm_lagp.LGPLA AND scwm_aqua.LGNUM = scwm_lagp.LGNUM
R read · W write · R/W read + write
Secondary tables
- /SCWM/AQUAAvailable quants — the stock that warehouse task creation can actually consume, with the bin, handling unit, product, stock type, batch, owner, and entitled party all resolved onto one rowRead accessGUID keytransaction
- /SCWM/LAGPSBin assignments to activity areas — one row per bin per activity, carrying the sort sequence that determines the order an operator walks the binsRead accessSemantic keyconfig
- /SCWM/T303Storage bin types — the weight, volume, capacity, and packing-dimension limits a bin of each type acceptsRead accessSemantic keyconfig