SAP Table S105
Season: Movements
S105 (Season: Movements) 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 S105 to other SAP tables.
S105 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 | |||
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||
| SATNR | Cross-Plant Configurable Material | SATNR | MARA | CHAR | 18 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| SAISJ | Season Year | SAISJ | CHAR | 4 | 0 | |||
| SAISO | Season Category | SAISO | T6WSP | CHAR | 4 | 0 | ||
| PLGTP | Price Band Category | PLGTP | TWPT | CHAR | 2 | 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 | ||
| HWAER | Local Currency | HWAER | TCURC | CUKY | 5 | 0 | ||
| UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 15 | 3 | |||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 19 | 2 | |||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 19 | 2 | |||
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 19 | 2 | |||
| PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 19 | 2 | |||
| AUMMNG | Promotion sales quantity in BUn | MCW_AUMMNG | QUAN | 15 | 3 | |||
| AUMGEO | Promotion sales at cost | MCW_AUMGEO | CURR | 19 | 2 | |||
| AUMGVO | Promotion sales at retail | MCW_AUMGVO | CURR | 19 | 2 | |||
| AUMGVP | Promotion sales at retail with tax | MCW_AUMGVP | CURR | 19 | 2 | |||
| UBPVPM | Revaluation at retail, plus, quantity | MCW_UBPVPM | QUAN | 15 | 3 | |||
| UBPGVO | Revaluation at retail, plus | MCW_UBPGVO | CURR | 19 | 2 | |||
| UBPGVP | Revaluation at retail, plus, at retail with tax | MCW_UBPGVP | CURR | 19 | 2 | |||
| UBPVAZ | Revaluation at retail, plus, no. of transactions | MCW_UBPVAZ | INT4 | 10 | 0 | |||
| UBMVPM | Revaluation at retail, minus, quantity | MCW_UBMVPM | QUAN | 15 | 3 | |||
| UBMGVO | Revaluation at retail, minus | MCW_UBMGVO | CURR | 19 | 2 | |||
| UBMGVP | Revaluation at retail, minus, at retail with tax | MCW_UBMGVP | CURR | 19 | 2 | |||
| UBMVAZ | Revaluation at retail, minus, no. of transactions | MCW_UBMVAZ | INT4 | 10 | 0 | |||
| ZUGMNG | Receipts quantity in BUn | MCW_ZUGMNG | QUAN | 15 | 3 | |||
| ZUGGEO | Receipts at cost | MCW_ZUGGEO | CURR | 19 | 2 | |||
| ZUGGVO | Receipts at retail | MCW_ZUGGVO | CURR | 19 | 2 | |||
| ZUGGVP | Receipts at retail with tax | MCW_ZUGGVP | CURR | 19 | 2 | |||
| ABGMNG | Issues quantity in BUn | MCW_ABGMNG | QUAN | 15 | 3 | |||
| ABGGEO | Issues at cost | MCW_ABGGEO | CURR | 19 | 2 | |||
| ABGGVO | Issues at retail | MCW_ABGGVO | CURR | 19 | 2 | |||
| ABGGVP | Issues at retail with tax | MCW_ABGGVP | CURR | 19 | 2 | |||
| BBZMNG | Order stock receipts quantity in BUn | MCW_BBZMNG | QUAN | 15 | 3 | |||
| BBZGEO | Order stock receipts at cost | MCW_BBZGEO | CURR | 19 | 2 | |||
| BBZGVO | Order stock receipts at retail | MCW_BBZGVO | CURR | 19 | 2 | |||
| BBZGVP | Order stock receipts at retail with tax | MCW_BBZGVP | CURR | 19 | 2 | |||
| BBAMNG | Order stock issues quantity in BUn | MCW_BBAMNG | QUAN | 15 | 3 | |||
| BBAGEO | Order stock issues at cost | MCW_BBAGEO | CURR | 19 | 2 | |||
| BBAGVO | Order stock issues at retail | MCW_BBAGVO | CURR | 19 | 2 | |||
| BBAGVP | Order stock issues at retail with tax | MCW_BBAGVP | CURR | 19 | 2 | |||
| KMAMNG | Goods issue (distribution center) quantity in BUn | MCW_KMAMNG | QUAN | 15 | 3 | |||
| KMAGEO | Goods issue (DC) at cost | MCW_KMAGEO | CURR | 19 | 2 | |||
| KMAGVO | Goods issue (DC) at retail | MCW_KMAGVO | CURR | 19 | 2 | |||
| KMAGVP | Goods issue (dist. center) at retail with tax | MCW_KMAGVP | CURR | 19 | 2 | |||
| KMAANZ | Goods issue (distribution center), no. of transactions | MCW_KMAANZ | INT4 | 10 | 0 | |||
| ULEMNG | Goods clearing: receipts quantity in BUn | MCW_ULEMNG | QUAN | 15 | 3 | |||
| ULEGEO | Goods clearing: receipts at cost | MCW_ULEGEO | CURR | 19 | 2 | |||
| ULEGVO | Goods clearing: receipts at retail | MCW_ULEGVO | CURR | 19 | 2 | |||
| ULEGVP | Goods clearing: receipts at retail with tax | MCW_ULEGVP | CURR | 19 | 2 | |||
| ULEANZ | Goods clearing: receipts, no. of transactions | MCW_ULEANZ | INT4 | 10 | 0 | |||
| ULAMNG | Goods clearing: issues quantity in BUn | MCW_ULAMNG | QUAN | 15 | 3 | |||
| ULAGEO | Goods clearing: issues at cost | MCW_ULAGEO | CURR | 19 | 2 | |||
| ULAGVO | Goods clearing: issues at retail | MCW_ULAGVO | CURR | 19 | 2 | |||
| ULAGVP | Goods clearing: issues at retail with tax | MCW_ULAGVP | CURR | 19 | 2 | |||
| ULAANZ | Goods clearing: issues, no. of transactions | MCW_ULAANZ | INT4 | 10 | 0 | |||
| MERK1 | Characteristic 1 | MCW_MERK1 | CHAR | 30 | 0 | |||
| MERK2 | Characteristic 2 | MCW_MERK2 | CHAR | 30 | 0 | |||
| MERK3 | Characteristic 3 | MCW_MERK3 | CHAR | 30 | 0 | |||
| WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | 0 | |||
| WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | 0 | |||
| ATINM1 | Internal characteristic number, characteristic 1 | MCW_ATINM1 | NUMC | 10 | 0 | |||
| ATINM2 | Internal characteristic number, characteristic 2 | MCW_ATINM2 | NUMC | 10 | 0 | |||
| ATINM3 | Internal characteristic number, characteristic 3 | MCW_ATINM3 | NUMC | 10 | 0 | |||
S105 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S105 | BASME | S105 | BASME | T006 | Units of Measurement | MSEHI |
| S105 | BASME | S105 | MANDT | T006 | Units of Measurement | MANDT |
| S105 | EKGRP | S105 | MANDT | T024 | Purchasing Groups | MANDT |
| S105 | EKGRP | S105 | EKGRP | T024 | Purchasing Groups | EKGRP |
| S105 | HWAER | S105 | MANDT | TCURC | Currency Codes | MANDT |
| S105 | HWAER | S105 | HWAER | TCURC | Currency Codes | WAERS |
| S105 | LIFNR | S105 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| S105 | LIFNR | S105 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| S105 | MANDT | S105 | MANDT | T000 | Clients | MANDT |
| S105 | MATKL | S105 | MANDT | T023 | Material Groups | MANDT |
| S105 | MATKL | S105 | MATKL | T023 | Material Groups | MATKL |
| S105 | MATNR | S105 | MANDT | MARA | General Material Data | MANDT |
| S105 | MATNR | S105 | MATNR | MARA | General Material Data | MATNR |
| S105 | PLGTP | S105 | PLGTP | TWPT | Price band categories | PLGTP |
| S105 | PLGTP | S105 | MANDT | TWPT | Price band categories | MANDT |
| S105 | SAISO | S105 | MANDT | T6WSP | Check Table for Season Indicator | MANDT |
| S105 | SAISO | S105 | SAISO | T6WSP | Check Table for Season Indicator | SAISO |
| S105 | SATNR | S105 | MANDT | MARA | General Material Data | MANDT |
| S105 | SATNR | S105 | SATNR | MARA | General Material Data | MATNR |
| S105 | WERKS | S105 | MANDT | T001W | Plants/Branches | MANDT |
| S105 | WERKS | S105 | WERKS | T001W | Plants/Branches | WERKS |
