SAP ABAP Table S023 (SFIS: Totals Records for Material)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S023   Table Relationship Diagram
Short Description SFIS: Totals Records for Material    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
9 DISPO CO_DISPO DISPO CHAR 3   0   MRP controller for the order T024D
10 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
11 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
12 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
13 LMEIN LAGME MEINS UNIT 3   0   Base Unit of Measure *
14 DFZEH DFZEH EINHEIT UNIT 3   0   Unit of measure for execution time  
15 ANZFA MC_ANZFA MCZAEHLER DEC 9   0   Number of production orders  
16 .INCLUDE       0   0   SFIS: Key Figures for Material/Additional Table for S021  
17 P_DLZ P_DLZ DAUER_6_1V QUAN 7   1   Planned lead time  
18 S_DLZ S_DLZ DAUER_6_1V QUAN 7   1   Target lead time  
19 I_DLZ I_DLZ DAUER_6_1V QUAN 7   1   Actual lead time  
20 PIDLZ PIDLZ DAUER_6_1V QUAN 7   1   Planned/actual lead time deviation  
21 SIDLZ SIDLZ DAUER_6_1V QUAN 7   1   Target/actual lead time deviation  
22 S_DFZ S_DFZ DAUER_6_1V QUAN 7   1   Target execution time  
23 I_DFZ I_DFZ DAUER_6_1V QUAN 7   1   Actual execution time  
24 S_WTZ S_WTZ DAUER_6_1V QUAN 7   1   Target queue time  
25 I_WTZ I_WTZ DAUER_6_1V QUAN 7   1   Actual queue time  
26 WTZAB WTZAB DAUER_6_1V QUAN 7   1   Queue time deviation  
27 PS_FREI PS_FREI DAUER_6_1V QUAN 7   1   Planned/target deviation in scheduled release date  
28 PI_FREI PI_FREI DAUER_6_1V QUAN 7   1   Planned/actual deviation in scheduled release date  
29 SI_FREI DSI_FREI DAUER_6_1V QUAN 7   1   Target/actual deviation in scheduled release date  
30 PS_STAR PS_STAR DAUER_6_1V QUAN 7   1   Planned/target deviation in start date  
31 PI_STAR PI_STAR DAUER_6_1V QUAN 7   1   Planned/actual deviation in scheduled start date  
32 SI_STAR DSI_STAR DAUER_6_1V QUAN 7   1   Target/actual schedule deviation in start date  
33 PS_LIEF PS_LIEF DAUER_6_1V QUAN 7   1   Planned/target deviation in scheduled delivery date  
34 PI_LIEF PI_LIEF DAUER_6_1V QUAN 7   1   Planned/actual deviation in scheduled delivery date  
35 SI_LIEF DSI_LIEF DAUER_6_1V QUAN 7   1   Target/actual deviation in scheduled delivery date  
36 PGMNG MC_GSMNG MENGV15_3 QUAN 15   3   Total planned order quantity  
37 PSMNG MC_PSMNG MENGV15_3 QUAN 15   3   Order item quantity  
38 WEMNG MC_WEMNG MENGV15_3 QUAN 15   3   Quantity of goods received  
39 PS_MENG PS_MENG MENGV15_3 QUAN 15   3   Planned/target quantity deviation  
40 PI_MENG PI_MENG MENGV15_3 QUAN 15   3   Planned/actual quantity deviation  
41 SI_MENG DSI_MENG MENGV15_3 QUAN 15   3   Target/actual quantity deviation  
42 PAMNG MC_AVMNG MENGV15_3 QUAN 15   3   Fixed quantity of scrap from production  
43 PSAMG MC_PSAMG MENGV15_3 QUAN 15   3   Scrap quantity in item  
44 IAMNG MC_IAMNG MENGV15_3 QUAN 15   3   Actual scrap quantity from an order item  
45 PS_AUSS PS_AUSS MENGV15_3 QUAN 15   3   Planned/target scrap deviation  
46 PI_AUSS PI_AUSS MENGV15_3 QUAN 15   3   Planned/actual scrap deviation  
47 SI_AUSS DSI_AUSS MENGV15_3 QUAN 15   3   Target/actual scrap deviation  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S023 DISPO T024D DISPO KEY 1 CN
2 S023 MANDT T000 MANDT KEY 1 CN
3 S023 MATNR MARA MATNR KEY 1 CN
4 S023 PERIV T009 PERIV REF C CN
5 S023 WERKS T001W WERKS KEY 1 CN
History
Last changed by/on SAP  20050411 
SAP Release Created in