SAP Table S034
INVCO: Movements (Batches)
S034 (INVCO: Movements (Batches)) 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 S034 to other SAP tables.
S034 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 | |||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| CHARG | Batch Number | CHARG_D | MCHA | CHAR | 10 | 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 | ||
| CMZUBB | Valuated stock receipts quantity | MZUBB | QUAN | 15 | 3 | |||
| CWZUBB | Valuated stock receipts value | WZUBB | CURR | 15 | 2 | |||
| CAZUBB | Number of times that valuated stock has been received | AZUBB | DEC | 9 | 0 | |||
| CMZUKB | Consignment stock receipts quantity | MZUKB | QUAN | 15 | 3 | |||
| CAZUKB | Number of times that consignment stock has been received | AZUKB | DEC | 9 | 0 | |||
| CMAGBB | Quantity of valuated stock issues | MAGBB | QUAN | 15 | 3 | |||
| CWAGBB | Value of valuated stock that has been issued | WAGBB | CURR | 15 | 2 | |||
| CAAGBB | Number of times valuated stock has been issued | AAGBB | DEC | 9 | 0 | |||
| CMAGKB | Quantity of consignment stock that has been issued | MAGKB | QUAN | 15 | 3 | |||
| CAAGKB | Number of times consignment stock has been issued | AAGKB | DEC | 9 | 0 | |||
| CAMBWG | Number of material movements | AMBWG | DEC | 9 | 0 | |||
| CMGVBR | Total usage quantity | GVBRM | QUAN | 15 | 3 | |||
| CWGVBR | Total usage value | WGVBR | CURR | 15 | 2 | |||
| CAGVBR | Number of times that total usage has been updated | AGVBR | DEC | 9 | 0 | |||
| CMUVBR | Unplanned usage quantity | UVBRM | QUAN | 15 | 3 | |||
| CWUVBR | Unplanned usage value | WUVBR | CURR | 15 | 2 | |||
| CAUVBR | Number of times an unplanned usage has been recorded | AUVBR | DEC | 9 | 0 | |||
| CASTOR | Number of cancelation documents to date | ASTOR | DEC | 9 | 0 | |||
S034 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S034 | BASME | S034 | MANDT | T006 | Units of Measurement | MANDT |
| S034 | BASME | S034 | BASME | T006 | Units of Measurement | MSEHI |
| S034 | CHARG | S034 | WERKS | MCHA | Batches | WERKS |
| S034 | CHARG | S034 | CHARG | MCHA | Batches | CHARG |
| S034 | CHARG | S034 | MANDT | MCHA | Batches | MANDT |
| S034 | CHARG | S034 | MATNR | MCHA | Batches | MATNR |
| S034 | HWAER | S034 | HWAER | TCURC | Currency Codes | WAERS |
| S034 | HWAER | S034 | MANDT | TCURC | Currency Codes | MANDT |
| S034 | LGORT | S034 | MANDT | T001L | Storage Locations | MANDT |
| S034 | LGORT | S034 | WERKS | T001L | Storage Locations | WERKS |
| S034 | LGORT | S034 | LGORT | T001L | Storage Locations | LGORT |
| S034 | MANDT | S034 | MANDT | T000 | Clients | MANDT |
| S034 | MATNR | S034 | MANDT | MARA | General Material Data | MANDT |
| S034 | MATNR | S034 | MATNR | MARA | General Material Data | MATNR |
| S034 | WERKS | S034 | MANDT | T001W | Plants/Branches | MANDT |
| S034 | WERKS | S034 | WERKS | T001W | Plants/Branches | WERKS |
