EWM Reference
/SCWM/ADPROD
CreateCreate an ad-hoc warehouse task for a product — move stock without a delivery or a wave asking for 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_lagp.MANDT AND scwm_aqua.LGPLA = scwm_lagp.LGPLA AND scwm_aqua.LGNUM = scwm_lagp.LGNUMON scwm_aqua.MANDT = sapapo_matkey.MANDT AND scwm_aqua.MATID = sapapo_matkey.MATID -- the /SCWM side is RAW(16) and MATKEY keys the CHAR 22 compressed form — convert before comparing; this is not a raw equalitythe /SCWM side is RAW(16) and MATKEY keys the CHAR 22 compressed form — convert before comparing; this is not a raw equality
ON scwm_ordim_o.MANDT = scwm_who.MANDT AND scwm_ordim_o.WHO = scwm_who.WHO AND scwm_ordim_o.LGNUM = scwm_who.LGNUMON scwm_ordim_o.MANDT = scwm_lagp.MANDT AND scwm_ordim_o.VLPLA = scwm_lagp.LGPLA AND scwm_ordim_o.LGNUM = scwm_lagp.LGNUMON scwm_ordim_o.MANDT = scwm_lagp.MANDT AND scwm_ordim_o.NLPLA = scwm_lagp.LGPLA AND scwm_ordim_o.LGNUM = scwm_lagp.LGNUMON scwm_ordim_o.MANDT = sapapo_matkey.MANDT AND scwm_ordim_o.MATID = sapapo_matkey.MATID -- the /SCWM side is RAW(16) and MATKEY keys the CHAR 22 compressed form — convert before comparing; this is not a raw equalitythe /SCWM side is RAW(16) and MATKEY keys the CHAR 22 compressed form — convert before comparing; this is not a raw equality
R read · W write · R/W read + write
Primary 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/ORDIM_OOpen warehouse tasks — the work still to be done: source and destination bin, product, target quantity, process type, queue, and the delivery item the move was created forWrite accessMixed keytransaction
Secondary tables
- /SAPAPO/MATKEYThe product master key table — the bridge between the internal product GUID every EWM table carries and the readable material number, with the base unit, weights, volumes, and shelf-life controlRead accessGUID keymaster
- /SCWM/LAGPThe storage bin master — one row per bin in a warehouse, with its storage type and section, the three block indicators, capacity limits, empty/full flags, and the layout coordinates the pick path is built fromRead accessSemantic keymaster
- /SCWM/WHOWarehouse order header — the bundle of tasks one operator executes as a unit, with the creation rule that produced it, the wave it came from, its queue, activity area, assigned resource, and the timestamps that bound executionWrite accessMixed keytransaction
More Stock & Handling Units t-codes
- /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
- /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