S023

SFIS: Totals Records for Material | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
WERKS FK Plant
DISPO FK MRP controller for the order
MATNR FK Material Number
Column Name Description
Column Name Description
📏 Unit of measure for execution time (S021.DFZEH):
P_DLZ Planned lead time
S_DLZ Target lead time
I_DLZ Actual lead time
PIDLZ Planned/actual lead time deviation
SIDLZ Target/actual lead time deviation
S_DFZ Target execution time
I_DFZ Actual execution time
S_WTZ Target queue time
I_WTZ Actual queue time
WTZAB Queue time deviation
PS_FREI Planned/target deviation in scheduled release date
PI_FREI Planned/actual deviation in scheduled release date
SI_FREI Target/actual deviation in scheduled release date
PS_STAR Planned/target deviation in start date
PI_STAR Planned/actual deviation in scheduled start date
SI_STAR Target/actual schedule deviation in start date
PS_LIEF Planned/target deviation in scheduled delivery date
PI_LIEF Planned/actual deviation in scheduled delivery date
SI_LIEF Target/actual deviation in scheduled delivery date
📏 Base Unit of Measure (S021.LMEIN):
PGMNG Total planned order quantity
PSMNG Order Item Quantity
WEMNG Quantity of goods received
PS_MENG Planned/target quantity deviation
PI_MENG Planned/actual quantity deviation
SI_MENG Target/actual quantity deviation
PAMNG Fixed quantity of scrap from production
PSAMG Scrap quantity in item
IAMNG Actual scrap quantity from an order item
PS_AUSS Planned/target scrap deviation
PI_AUSS Planned/actual scrap deviation
SI_AUSS Target/actual scrap deviation
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
ANZFA Number of production orders MCZAEHLER
Master Data Relations Join Conditions
MRP controller for the order
  • Plant
  • MRP controller for the order
  • Client
  • S023.WERKS == T024D.WERKS
  • S023.DISPO == T024D.DISPO
  • S023.MANDT == T024D.MANDT
Client S023.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S023.MATNR == MARA.MATNR
  • S023.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S023.PERIV == T009.PERIV
  • S023.MANDT == T009.MANDT
Plant
  • S023.MANDT == T001W.MANDT
  • S023.WERKS == T001W.WERKS