EWM Reference
/SCWM/ADGI
CreatePost an unplanned goods issue — take stock out of the warehouse without a delivery behind 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_aqua.MANDT = scwm_quan.MANDT AND scwm_aqua.GUID_STOCK = scwm_quan.GUID_STOCK AND scwm_aqua.GUID_PARENT = scwm_quan.GUID_PARENT -- RAW16 GUID equality — join raw; hex is for display/conformance onlyON lime_nquan.MANDT = scwm_quan.MANDT AND lime_nquan.GUID_STOCK = scwm_quan.GUID_STOCK AND lime_nquan.GUID_PARENT = scwm_quan.GUID_PARENT -- RAW16 GUID equality — join raw; hex is for display/conformance onlyON scwm_aqua.MANDT = scwm_huhdr.MANDT AND scwm_aqua.HUIDENT = scwm_huhdr.HUIDENT AND scwm_aqua.LGNUM = scwm_huhdr.LGNUM
R read · W write · R/W read + write
Primary tables
- /LIME/NQUANThe LIME stock quantities table — the physical quantity of a stock item hanging on one node of the location/handling-unit tree, one row per stock GUID per node per unit of measureWrite accessMixed keytransaction
- /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/write accessGUID keytransaction
Secondary tables
- /SCWM/HUHDRHandling unit header — one row per HU with its external number, packaging material, current storage type and bin, weights, volumes, and the entitled party whose stock it holdsRead accessGUID keytransaction
- /SCWM/QUANQuant attributes — the descriptive side of a stock item (units, weight, volume, goods-receipt time, shelf life, country of origin, and the document reference for special stock), keyed by the stock GUIDRead accessGUID keytransaction
More Stock & Handling Units t-codes
- /SCWM/ADHUCreate an ad-hoc warehouse task for a handling unit — move a whole HU rather than a product quantity
- /SCWM/ADPRODCreate an ad-hoc warehouse task for a product — move stock without a delivery or a wave asking for it
- /SCWM/PACKGeneral packing — build, repack, and unpack handling units at a work center
- /SCWM/POSTPosting change — change a stock attribute in place (stock type, owner, entitled party, batch) without moving the goods