/SCWM/POST
CreatePosting change — change a stock attribute in place (stock type, owner, entitled party, batch) without moving the goods
Posting changes are the reason a stock balance can move between categories with no physical movement behind it — worth separating from real movements in any throughput measure.
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 lime_nquan.MANDT = lime_ntree.MANDT AND lime_nquan.GUID_PARENT = lime_ntree.GUID -- RAW16 GUID equality — join raw; hex is for display/conformance only · the join that turns a quantity row into a place — resolve the node before summing anythingthe join that turns a quantity row into a place — resolve the node before summing anything
ON lime_ntree1.MANDT = lime_ntree2.MANDT AND lime_ntree1.GUID_PARENT = lime_ntree2.GUID -- RAW16 GUID equality — join raw; hex is for display/conformance only · the tree's own parent link — a recursive walk, not a single join; a node's row can repeat across OVERFLOW valuesthe tree's own parent link — a recursive walk, not a single join; a node's row can repeat across OVERFLOW values
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
- /LIME/NTREEThe LIME tree structure — one row per node of the location and handling-unit hierarchy stock hangs on, with its object type, its parent node, and the nested-set interval bookkeeping the engine walks the tree withRead accessMixed 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/ADGIPost an unplanned goods issue — take stock out of the warehouse without a delivery behind it
- /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