/SCWM/MAT1
ChangeMaintain the warehouse product — the warehouse and storage-type level settings layered on a product master record
The warehouse product is where putaway and removal control, storage section and bin type indicators, and the min/max/replenishment quantities are set — the parameters slotting and task creation actually read.
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_binmat.MANDT = sapapo_matkey.MANDT AND scwm_binmat.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 sapapo_matlwh.MANDT = sapapo_matkey.MANDT AND sapapo_matlwh.MATID = sapapo_matkey.MATID -- compressed CHAR(22) GUID equality — join as-isON sapapo_matlwhst.MANDT = sapapo_matkey.MANDT AND sapapo_matlwhst.MATID = sapapo_matkey.MATID -- compressed CHAR(22) GUID equality — join as-isON sapapo_matlwhst.MANDT = sapapo_matlwh.MANDT AND sapapo_matlwhst.MATID = sapapo_matlwh.MATID AND sapapo_matlwhst.SCUGUID = sapapo_matlwh.SCUGUID AND sapapo_matlwhst.ENTITLED_ID = sapapo_matlwh.ENTITLED_ID -- compressed CHAR(22) GUID equality — join as-is · the storage-type row hangs off the warehouse-product row — join the full product + supply chain unit + entitled party keythe storage-type row hangs off the warehouse-product row — join the full product + supply chain unit + entitled party key
R read · W write · R/W read + write
Primary tables
- /SAPAPO/MATLWHWarehouse product — the warehouse-level settings for a product: putaway and stock-removal control, storage section and bin type indicators, stock determination, two-step picking relevance, and the slotting demand quantityRead/write accessGUID keymaster
- /SAPAPO/MATLWHSTWarehouse product at storage-type level — the same product's parameters narrowed to one storage type: preferred section and bin type, maximum fixed bins, and the min/max/replenishment quantity setRead/write accessMixed keymaster
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/BINMATFixed bin assignment — the products that live in a named bin for a given entitled party, with the minimum, maximum, and replenishment quantities slotting maintainsRead accessMixed keymaster