SAP Table S226
Material usage: repetitive manufacturing
S226 (Material usage: repetitive manufacturing) 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 S226 to other SAP tables.
S226 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 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| MCOMP | BOM component | IDNRK | MARA | CHAR | 18 | 0 | ||
| VERID | Production Version | VERID | MKAL | CHAR | 4 | 0 | ||
| KDAUF | Sales order number | CO_KDAUF | VBUK | CHAR | 10 | 0 | ||
| KDPOS | Sales order item | CO_KDPOS | VBUP | NUMC | 6 | 0 | ||
| PSPNR | Production lot (WBS element) | REM_PSPNR | PRPS | NUMC | 8 | 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 | ||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| BDMNG | Requirement Quantity | MC_BDMNG | QUAN | 15 | 3 | |||
| ENMNG | Quantity withdrawn | MC_ENMNG | QUAN | 15 | 3 | |||
| ENWRT | Issued Value | MC_ENWRT | CURR | 19 | 2 | |||
S226 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S226 | BASME | S226 | BASME | T006 | Units of Measurement | MSEHI |
| S226 | BASME | S226 | MANDT | T006 | Units of Measurement | MANDT |
| S226 | KDAUF | S226 | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| S226 | KDAUF | S226 | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| S226 | KDPOS | S226 | MANDT | VBUP | Sales Document: Item Status | MANDT |
| S226 | KDPOS | S226 | KDAUF | VBUP | Sales Document: Item Status | VBELN |
| S226 | KDPOS | S226 | KDPOS | VBUP | Sales Document: Item Status | POSNR |
| S226 | MANDT | S226 | MANDT | T000 | Clients | MANDT |
| S226 | MATNR | S226 | MANDT | MARA | General Material Data | MANDT |
| S226 | MATNR | S226 | MATNR | MARA | General Material Data | MATNR |
| S226 | MCOMP | S226 | MCOMP | MARA | General Material Data | MATNR |
| S226 | MCOMP | S226 | MANDT | MARA | General Material Data | MANDT |
| S226 | PSPNR | S226 | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| S226 | PSPNR | S226 | PSPNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| S226 | VERID | S226 | MANDT | MKAL | Production Versions of Material | MANDT |
| S226 | VERID | S226 | MCOMP | MKAL | Production Versions of Material | MATNR |
| S226 | VERID | S226 | WERKS | MKAL | Production Versions of Material | WERKS |
| S226 | VERID | S226 | VERID | MKAL | Production Versions of Material | VERID |
| S226 | WAERS | S226 | MANDT | TCURC | Currency Codes | MANDT |
| S226 | WAERS | S226 | WAERS | TCURC | Currency Codes | WAERS |
| S226 | WERKS | S226 | MANDT | T001W | Plants/Branches | MANDT |
| S226 | WERKS | S226 | WERKS | T001W | Plants/Branches | WERKS |
