SAP table S225 (Goods receipts: repetitive manufacturing)
SAP table S225 has 16 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,WERKS,DISPO,MATNR,VERID,MDV01,MDV02,KDAUF,KDPOS,PSPNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SSOUR | Statistic(s) origin | CHAR | 4 | 0 | SSOUR | ||
| VRSIO | Version number in the information structure | CHAR | 3 | 0 | VRSIO | ||
| SPMON | Period to analyze - month | NUMC | 6 | 0 | SPMON | ||
| SPTAG | Period to analyze - current date | DATS | 8 | 0 | SPTAG | ||
| SPWOC | Period to analyze - week | NUMC | 6 | 0 | SPWOC | ||
| SPBUP | Period to analyze - posting period | NUMC | 6 | 0 | SPBUP | ||
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| DISPO | MRP controller for the order | CHAR | 3 | 0 | T024D | CO_DISPO | |
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| VERID | Production Version | CHAR | 4 | 0 | MKAL | VERID | |
| MDV01 | Production line | CHAR | 8 | 0 | T437P | MDV01 | |
| MDV02 | Planning identification 2 | CHAR | 8 | 0 | T437P | MDV02 | |
| KDAUF | Sales Order | CHAR | 10 | 0 | VBUK | CO_KDAUF | |
| KDPOS | Sales Order Item | NUMC | 6 | 0 | VBUP | CO_KDPOS | |
| PSPNR | Production Lot (WBS Element) | NUMC | 8 | 0 | PRPS | REM_PSPNR | |
| PERIV | Fiscal Year Variant | CHAR | 2 | 0 | PERIV | ||
| VWDAT | Pointer to administrative data | NUMC | 10 | 0 | VWDAT | ||
| AMEIN | Unit of measure for in-house production | UNIT | 3 | 0 | T006 | CO_AUFME | |
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | T006 | LAGME | |
| WEMNG | Quantity of goods received | QUAN | 15 | 3 | MC_WEMNG | ||
| IAMNG | Actual scrap quantity from an order item | QUAN | 15 | 3 | MC_IAMNG | ||
| PGMNG | Total planned order quantity | QUAN | 15 | 3 | MC_GSMNG | ||
| PAMNG | Fixed quantity of scrap from production | QUAN | 15 | 3 | MC_AVMNG |
S225 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 S225 | AMEIN | T006 | Units of Measurement | MANDT |
| 0 S225 | AMEIN | T006 | Units of Measurement | MSEHI |
| 1 S225 | DISPO | T024D | MRP Controllers | MANDT |
| 1 S225 | DISPO | T024D | MRP Controllers | WERKS |
| 1 S225 | DISPO | T024D | MRP Controllers | DISPO |
| 0 S225 | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| 0 S225 | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| 1 S225 | KDPOS | VBUP | Sales Document: Item Status | MANDT |
| 1 S225 | KDPOS | VBUP | Sales Document: Item Status | VBELN |
| 1 S225 | KDPOS | VBUP | Sales Document: Item Status | POSNR |
| 0 S225 | MATNR | MARA | General Material Data | MANDT |
| 0 S225 | MATNR | MARA | General Material Data | MATNR |
| 1 S225 | MDV01 | T437P | Planning IDs for Repetitive Manufacturing | MANDT |
| 1 S225 | MDV01 | T437P | Planning IDs for Repetitive Manufacturing | PLAN_ID |
| 0 S225 | MDV02 | T437P | Planning IDs for Repetitive Manufacturing | MANDT |
| 0 S225 | MDV02 | T437P | Planning IDs for Repetitive Manufacturing | PLAN_ID |
| 1 S225 | MEINS | T006 | Units of Measurement | MANDT |
| 1 S225 | MEINS | T006 | Units of Measurement | MSEHI |
| 0 S225 | PSPNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| 0 S225 | PSPNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| 1 S225 | VERID | MKAL | Production Versions of Material | WERKS |
| 1 S225 | VERID | MKAL | Production Versions of Material | VERID |
| 0 S225 | WERKS | T001W | Plants/Branches | WERKS |