S023 - SFIS: Totals Records for Material
SFIS: Totals Records for Material information is stored in SAP table S023.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S023
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| DISPO | MRP controller for the order | X | CO_DISPO | CHAR | 6 | T024D |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | T009 | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| LMEIN | Base Unit of Measure | LAGME | UNIT | 6 | * | |
| DFZEH | Unit of measure for execution time | DFZEH | UNIT | 6 | ||
| ANZFA | Number of production orders | MC_ANZFA | DEC | 5 | ||
| .INCLUDE | S021Z | 0 | ||||
| P_DLZ | Planned lead time | P_DLZ | QUAN | 4 | ||
| S_DLZ | Target lead time | S_DLZ | QUAN | 4 | ||
| I_DLZ | Actual lead time | I_DLZ | QUAN | 4 | ||
| PIDLZ | Planned/actual lead time deviation | PIDLZ | QUAN | 4 | ||
| SIDLZ | Target/actual lead time deviation | SIDLZ | QUAN | 4 | ||
| S_DFZ | Target execution time | S_DFZ | QUAN | 4 | ||
| I_DFZ | Actual execution time | I_DFZ | QUAN | 4 | ||
| S_WTZ | Target queue time | S_WTZ | QUAN | 4 | ||
| I_WTZ | Actual queue time | I_WTZ | QUAN | 4 | ||
| WTZAB | Queue time deviation | WTZAB | QUAN | 4 | ||
| PS_FREI | Planned/target deviation in scheduled release date | PS_FREI | QUAN | 4 | ||
| PI_FREI | Planned/actual deviation in scheduled release date | PI_FREI | QUAN | 4 | ||
| SI_FREI | Target/actual deviation in scheduled release date | DSI_FREI | QUAN | 4 | ||
| PS_STAR | Planned/target deviation in start date | PS_STAR | QUAN | 4 | ||
| PI_STAR | Planned/actual deviation in scheduled start date | PI_STAR | QUAN | 4 | ||
| SI_STAR | Target/actual schedule deviation in start date | DSI_STAR | QUAN | 4 | ||
| PS_LIEF | Planned/target deviation in scheduled delivery date | PS_LIEF | QUAN | 4 | ||
| PI_LIEF | Planned/actual deviation in scheduled delivery date | PI_LIEF | QUAN | 4 | ||
| SI_LIEF | Target/actual deviation in scheduled delivery date | DSI_LIEF | QUAN | 4 | ||
| PGMNG | Total planned order quantity | MC_GSMNG | QUAN | 8 | ||
| PSMNG | Order Item Quantity | MC_PSMNG | QUAN | 8 | ||
| WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 8 | ||
| PS_MENG | Planned/target quantity deviation | PS_MENG | QUAN | 8 | ||
| PI_MENG | Planned/actual quantity deviation | PI_MENG | QUAN | 8 | ||
| SI_MENG | Target/actual quantity deviation | DSI_MENG | QUAN | 8 | ||
| PAMNG | Fixed quantity of scrap from production | MC_AVMNG | QUAN | 8 | ||
| PSAMG | Scrap quantity in item | MC_PSAMG | QUAN | 8 | ||
| IAMNG | Actual scrap quantity from an order item | MC_IAMNG | QUAN | 8 | ||
| PS_AUSS | Planned/target scrap deviation | PS_AUSS | QUAN | 8 | ||
| PI_AUSS | Planned/actual scrap deviation | PI_AUSS | QUAN | 8 | ||
| SI_AUSS | Target/actual scrap deviation | DSI_AUSS | QUAN | 8 |