S023 SAP (SFIS: Totals Records for Material) Table details
Dictionary Type: Table
Description: SFIS: Totals Records for Material
Description: SFIS: Totals Records for Material
Table field list including key, data, relationships and ABAP select examples
S023 is a standard SAP Table which is used to store SFIS: Totals Records for Material data and is available within R/3 SAP systems depending on the version and release level.
The S023 table consists of various fields, each holding specific information or linking keys about SFIS: Totals Records for Material data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP S023 table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| DISPO | MRP controller for the order | CO_DISPO | CHAR | 3 | T024D | DISPO | DGR | ||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
| LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| DFZEH | Unit of measure for execution time | DFZEH | UNIT | 3 | CUNIT | EINHEIT | |||
| ANZFA | Number of production orders | MC_ANZFA | DEC | 9 | MCZAEHLER | ||||
| P_DLZ | Planned lead time | P_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
| S_DLZ | Target lead time | S_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
| I_DLZ | Actual lead time | I_DLZ | QUAN | 7(1) | DAUER_6_1V | ||||
| PIDLZ | Planned/actual lead time deviation | PIDLZ | QUAN | 7(1) | DAUER_6_1V | ||||
| SIDLZ | Target/actual lead time deviation | SIDLZ | QUAN | 7(1) | DAUER_6_1V | ||||
| S_DFZ | Target execution time | S_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
| I_DFZ | Actual execution time | I_DFZ | QUAN | 7(1) | DAUER_6_1V | ||||
| S_WTZ | Target queue time | S_WTZ | QUAN | 7(1) | DAUER_6_1V | ||||
| I_WTZ | Actual queue time | I_WTZ | QUAN | 7(1) | DAUER_6_1V | ||||
| WTZAB | Queue time deviation | WTZAB | QUAN | 7(1) | DAUER_6_1V | ||||
| PS_FREI | Planned/target deviation in scheduled release date | PS_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
| PI_FREI | Planned/actual deviation in scheduled release date | PI_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
| SI_FREI | Target/actual deviation in scheduled release date | DSI_FREI | QUAN | 7(1) | DAUER_6_1V | ||||
| PS_STAR | Planned/target deviation in start date | PS_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
| PI_STAR | Planned/actual deviation in scheduled start date | PI_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
| SI_STAR | Target/actual schedule deviation in start date | DSI_STAR | QUAN | 7(1) | DAUER_6_1V | ||||
| PS_LIEF | Planned/target deviation in scheduled delivery date | PS_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
| PI_LIEF | Planned/actual deviation in scheduled delivery date | PI_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
| SI_LIEF | Target/actual deviation in scheduled delivery date | DSI_LIEF | QUAN | 7(1) | DAUER_6_1V | ||||
| PGMNG | Total planned order quantity | MC_GSMNG | QUAN | 15(3) | MENGV15_3 | ||||
| PSMNG | Order item quantity | MC_PSMNG | QUAN | 15(3) | MENGV15_3 | ||||
| WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 15(3) | MENGV15_3 | ||||
| PS_MENG | Planned/target quantity deviation | PS_MENG | QUAN | 15(3) | MENGV15_3 | ||||
| PI_MENG | Planned/actual quantity deviation | PI_MENG | QUAN | 15(3) | MENGV15_3 | ||||
| SI_MENG | Target/actual quantity deviation | DSI_MENG | QUAN | 15(3) | MENGV15_3 | ||||
| PAMNG | Fixed quantity of scrap from production | MC_AVMNG | QUAN | 15(3) | MENGV15_3 | ||||
| PSAMG | Scrap quantity in item | MC_PSAMG | QUAN | 15(3) | MENGV15_3 | ||||
| IAMNG | Actual scrap quantity from an order item | MC_IAMNG | QUAN | 15(3) | MENGV15_3 | ||||
| PS_AUSS | Planned/target scrap deviation | PS_AUSS | QUAN | 15(3) | MENGV15_3 | ||||
| PI_AUSS | Planned/actual scrap deviation | PI_AUSS | QUAN | 15(3) | MENGV15_3 | ||||
| SI_AUSS | Target/actual scrap deviation | DSI_AUSS | QUAN | 15(3) | MENGV15_3 |
| Key field | Non-key field |
How do I retrieve data from SAP table S023 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S023 to SELECT all data from the tableDATA: WA_S023 TYPE S023.
SELECT SINGLE *
FROM S023
INTO CORRESPONDING FIELDS OF WA_S023
WHERE...
How to access SAP table S023
Within an ECC or HANA version of SAP you can also view further information about S023 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects