S023 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S023 in SAP.
- Table description : SFIS: Totals Records for Material
- Module : CRM
- Parent Module : CRM
- Package : MCS
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S023 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| WERKS | Plant | WERKS_D | WERKS |
| DISPO | MRP controller for the order | CO_DISPO | DISPO |
| MATNR | Material Number | MATNR | MATNR |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| LMEIN | Base Unit of Measure | LAGME | MEINS |
| DFZEH | Unit of measure for execution time | DFZEH | EINHEIT |
| ANZFA | Number of production orders | MC_ANZFA | MCZAEHLER |
| .INCLUDE | SFIS: Key Figures for Material/Additional Table for S021 | ||
| P_DLZ | Planned lead time | P_DLZ | DAUER_6_1V |
| S_DLZ | Target lead time | S_DLZ | DAUER_6_1V |
| I_DLZ | Actual lead time | I_DLZ | DAUER_6_1V |
| PIDLZ | Planned/actual lead time deviation | PIDLZ | DAUER_6_1V |
| SIDLZ | Target/actual lead time deviation | SIDLZ | DAUER_6_1V |
| S_DFZ | Target execution time | S_DFZ | DAUER_6_1V |
| I_DFZ | Actual execution time | I_DFZ | DAUER_6_1V |
| S_WTZ | Target queue time | S_WTZ | DAUER_6_1V |
| I_WTZ | Actual queue time | I_WTZ | DAUER_6_1V |
| WTZAB | Queue time deviation | WTZAB | DAUER_6_1V |
| PS_FREI | Planned/target deviation in scheduled release date | PS_FREI | DAUER_6_1V |
| PI_FREI | Planned/actual deviation in scheduled release date | PI_FREI | DAUER_6_1V |
| SI_FREI | Target/actual deviation in scheduled release date | DSI_FREI | DAUER_6_1V |
| PS_STAR | Planned/target deviation in start date | PS_STAR | DAUER_6_1V |
| PI_STAR | Planned/actual deviation in scheduled start date | PI_STAR | DAUER_6_1V |
| SI_STAR | Target/actual schedule deviation in start date | DSI_STAR | DAUER_6_1V |
| PS_LIEF | Planned/target deviation in scheduled delivery date | PS_LIEF | DAUER_6_1V |
| PI_LIEF | Planned/actual deviation in scheduled delivery date | PI_LIEF | DAUER_6_1V |
| SI_LIEF | Target/actual deviation in scheduled delivery date | DSI_LIEF | DAUER_6_1V |
| PGMNG | Total planned order quantity | MC_GSMNG | MENGV15_3 |
| PSMNG | Order item quantity | MC_PSMNG | MENGV15_3 |
| WEMNG | Quantity of goods received | MC_WEMNG | MENGV15_3 |
| PS_MENG | Planned/target quantity deviation | PS_MENG | MENGV15_3 |
| PI_MENG | Planned/actual quantity deviation | PI_MENG | MENGV15_3 |
| SI_MENG | Target/actual quantity deviation | DSI_MENG | MENGV15_3 |
| PAMNG | Fixed quantity of scrap from production | MC_AVMNG | MENGV15_3 |
| PSAMG | Scrap quantity in item | MC_PSAMG | MENGV15_3 |
| IAMNG | Actual scrap quantity from an order item | MC_IAMNG | MENGV15_3 |
| PS_AUSS | Planned/target scrap deviation | PS_AUSS | MENGV15_3 |
| PI_AUSS | Planned/actual scrap deviation | PI_AUSS | MENGV15_3 |
| SI_AUSS | Target/actual scrap deviation | DSI_AUSS | MENGV15_3 |
S023 related tables
| Table | Note |
|---|---|
| S023 | SFIS: Totals Records for Material |
| S021 | SFIS: Order Item Data for Material |
| MCSFIS | R/2 SFIS Data: Old |
| S022 | SFIS: Order Operation Data for Work Center |
| S025 | SFIS: Run Schedule |
| CKML1 | Material Ledger Period Totals Records (Release 3.xx) |
| CKMLCR | Material Ledger: Period Totals Records Values |
| CKMLPP | Material Ledger Period Totals Records Quantity |
| BKKI4 | Totals Records from Payment Transactions |
| BKKI5 | Totals Records from Payment Transactions |
| COFIT | Totals Records for Reconciliation Ledger |
| DFKKSUMOLD | Totals Records Without Account Assignment Changes |
| FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records |
| FDSB2 | CMF Totals Records for G/L Accounts (As of Release 604) |
| FDSR2 | CMF Totals Records for Planning Groups (As of Release 604) |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP