SAP Table S023
SFIS: Totals Records for Material
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table S023 (SFIS: Totals Records for Material) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S023 |
| Short Text | SFIS: Totals Records for Material |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S023
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| DISPO | ✔ | MRP controller for the order | CO_DISPO | CHAR | 3 | T024D |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | * | |
| DFZEH | Unit of measure for execution time | DFZEH | UNIT | 3 | ||
| ANZFA | Number of production orders | MC_ANZFA | DEC | 9 | ||
| P_DLZ | Planned lead time | P_DLZ | QUAN | 7 | ||
| S_DLZ | Target lead time | S_DLZ | QUAN | 7 | ||
| I_DLZ | Actual lead time | I_DLZ | QUAN | 7 | ||
| PIDLZ | Planned/actual lead time deviation | PIDLZ | QUAN | 7 | ||
| SIDLZ | Target/actual lead time deviation | SIDLZ | QUAN | 7 | ||
| S_DFZ | Target execution time | S_DFZ | QUAN | 7 | ||
| I_DFZ | Actual execution time | I_DFZ | QUAN | 7 | ||
| S_WTZ | Target queue time | S_WTZ | QUAN | 7 | ||
| I_WTZ | Actual queue time | I_WTZ | QUAN | 7 | ||
| WTZAB | Queue time deviation | WTZAB | QUAN | 7 | ||
| PS_FREI | Planned/target deviation in scheduled release date | PS_FREI | QUAN | 7 | ||
| PI_FREI | Planned/actual deviation in scheduled release date | PI_FREI | QUAN | 7 | ||
| SI_FREI | Target/actual deviation in scheduled release date | DSI_FREI | QUAN | 7 | ||
| PS_STAR | Planned/target deviation in start date | PS_STAR | QUAN | 7 | ||
| PI_STAR | Planned/actual deviation in scheduled start date | PI_STAR | QUAN | 7 | ||
| SI_STAR | Target/actual schedule deviation in start date | DSI_STAR | QUAN | 7 | ||
| PS_LIEF | Planned/target deviation in scheduled delivery date | PS_LIEF | QUAN | 7 | ||
| PI_LIEF | Planned/actual deviation in scheduled delivery date | PI_LIEF | QUAN | 7 | ||
| SI_LIEF | Target/actual deviation in scheduled delivery date | DSI_LIEF | QUAN | 7 | ||
| PGMNG | Total planned order quantity | MC_GSMNG | QUAN | 15 | ||
| PSMNG | Order item quantity | MC_PSMNG | QUAN | 15 | ||
| WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 15 | ||
| PS_MENG | Planned/target quantity deviation | PS_MENG | QUAN | 15 | ||
| PI_MENG | Planned/actual quantity deviation | PI_MENG | QUAN | 15 | ||
| SI_MENG | Target/actual quantity deviation | DSI_MENG | QUAN | 15 | ||
| PAMNG | Fixed quantity of scrap from production | MC_AVMNG | QUAN | 15 | ||
| PSAMG | Scrap quantity in item | MC_PSAMG | QUAN | 15 | ||
| IAMNG | Actual scrap quantity from an order item | MC_IAMNG | QUAN | 15 | ||
| PS_AUSS | Planned/target scrap deviation | PS_AUSS | QUAN | 15 | ||
| PI_AUSS | Planned/actual scrap deviation | PI_AUSS | QUAN | 15 | ||
| SI_AUSS | Target/actual scrap deviation | DSI_AUSS | QUAN | 15 |