SAP Table S090
WM: Stock placements/removals
S090 (WM: Stock placements/removals) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S090 to other SAP tables.
S090 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | 0 | |||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | 0 | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | 0 | |||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | 0 | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | T300 | CHAR | 3 | 0 | ||
| LGTYP | Stor.type for stock removal, placement, return | MCWM_LGTYP | T301 | CHAR | 3 | 0 | ||
| LGBER | Storage section for stock removal, placement, return | MCWM_LGBER | T302 | CHAR | 3 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| BWLVS | Movement Type for Warehouse Management | BWLVS | T333 | NUMC | 3 | 0 | ||
| LETYP | Storage Unit Type | LVS_LETYP | T307 | CHAR | 3 | 0 | ||
| MG_LAGKL | Storage class | LVS_LAGKL | T646L | CHAR | 5 | 0 | ||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | 0 | |||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| BASME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||
| GEWEI | Weight Unit | GEWEI | T006 | UNIT | 3 | 0 | ||
| TAAMG | Stock Removal Quantity from TO Item | MCWM_TAAMG | QUAN | 15 | 3 | |||
| TAEMG | Putaway quantity for TO item | MCWM_TAEMG | QUAN | 15 | 3 | |||
| TARMG | Return placement quantity from TO item | MCWM_TARMG | QUAN | 15 | 3 | |||
| EXAMG | External removal quantity (GI interface) | MCWM_EXAMG | QUAN | 15 | 3 | |||
| EXEMG | External stock placement quantity (GR interface) | MCWM_EXEMG | QUAN | 15 | 3 | |||
| TAAGW | Weight of stock removal | MCWM_TAAGW | QUAN | 15 | 3 | |||
| TAEGW | Weight of stock placement item | MCWM_TAEGW | QUAN | 15 | 3 | |||
| TARGW | Weight of return transfer | MCWM_TARGW | QUAN | 15 | 3 | |||
| EXAGW | Weight of external stock removal | MCWM_EXAGW | QUAN | 15 | 3 | |||
| EXEGW | Weight of external stock placement | MCWM_EXEGW | QUAN | 15 | 3 | |||
| TAAPC | Number of stock removals | MCWM_TAAPC | DEC | 9 | 0 | |||
| TAEPC | Number of stock placement items | MCWM_TAEPC | DEC | 9 | 0 | |||
| TARPC | Number of TO items with return placement | MCWM_TARPC | DEC | 9 | 0 | |||
| EXAPC | Number of external stock removal items | MCWM_EXAPC | DEC | 9 | 0 | |||
| EXEPC | Number of external stock placement items | MCWM_EXEPC | DEC | 9 | 0 | |||
| RGLAC | Return to stock removal bin | MCWM_RGLAC | DEC | 9 | 0 | |||
S090 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S090 | BASME | S090 | MANDT | T006 | Units of Measurement | MANDT |
| S090 | BASME | S090 | BASME | T006 | Units of Measurement | MSEHI |
| S090 | BWLVS | S090 | MANDT | T333 | WM Movement Types | MANDT |
| S090 | BWLVS | S090 | LGNUM | T333 | WM Movement Types | LGNUM |
| S090 | BWLVS | S090 | BWLVS | T333 | WM Movement Types | BWLVS |
| S090 | GEWEI | S090 | MANDT | T006 | Units of Measurement | MANDT |
| S090 | GEWEI | S090 | GEWEI | T006 | Units of Measurement | MSEHI |
| S090 | LETYP | S090 | LETYP | T307 | Storage Unit Types | LETYP |
| S090 | LETYP | S090 | MANDT | T307 | Storage Unit Types | MANDT |
| S090 | LETYP | S090 | LGNUM | T307 | Storage Unit Types | LGNUM |
| S090 | LGBER | S090 | LGNUM | T302 | WM Storage Sections | LGNUM |
| S090 | LGBER | S090 | LGTYP | T302 | WM Storage Sections | LGTYP |
| S090 | LGBER | S090 | LGBER | T302 | WM Storage Sections | LGBER |
| S090 | LGBER | S090 | MANDT | T302 | WM Storage Sections | MANDT |
| S090 | LGNUM | S090 | MANDT | T300 | WM Warehouse Numbers | MANDT |
| S090 | LGNUM | S090 | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| S090 | LGORT | S090 | MANDT | T001L | Storage Locations | MANDT |
| S090 | LGORT | S090 | WERKS | T001L | Storage Locations | WERKS |
| S090 | LGORT | S090 | LGORT | T001L | Storage Locations | LGORT |
| S090 | LGTYP | S090 | MANDT | T301 | WM Storage Types | MANDT |
| S090 | LGTYP | S090 | LGNUM | T301 | WM Storage Types | LGNUM |
| S090 | LGTYP | S090 | LGTYP | T301 | WM Storage Types | LGTYP |
| S090 | MANDT | S090 | MANDT | T000 | Clients | MANDT |
| S090 | MATNR | S090 | MANDT | MARA | General Material Data | MANDT |
| S090 | MATNR | S090 | MATNR | MARA | General Material Data | MATNR |
| S090 | MG_LAGKL | S090 | MG_LAGKL | T646L | Storage Classes | LAGKL |
| S090 | MG_LAGKL | S090 | MANDT | T646L | Storage Classes | MANDT |
| S090 | WERKS | S090 | WERKS | T001W | Plants/Branches | WERKS |
| S090 | WERKS | S090 | MANDT | T001W | Plants/Branches | MANDT |
