S021

SFIS: Order Item Data for Material | #itemdata | 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
MATNR FK Material Number
AUFNR Order Number
POSNR Order item number
Column Name Description
Column Name Description
📏 Base Unit of Measure (LMEIN):
PGMNG Planned Total Order Quantity
PSMNG Order Item Planned Total Quantity
WEMNG Quantity of Goods Received for the Order Item
PAMNG Planned Scrap Quantity
PSAMG Order Item Planned Scrap Quantity
IAMNG Expected Surplus/Deficit For Goods Receipt
📏 Unit of measure for execution time (DFZEH):
S_DFZ Target execution time
I_DFZ Actual execution time
📏 Unit of Measure for Capacity Requirements (KEINH):
KSUMS Total target capacity requirements
Column Name Description
SPTAG Period to analyze - current date
ERDAT Created On
FTRMP Planned Release Date
FTRMS Scheduled release date
FTRMI Actual release date
GSTRP Basic start date
GSTRS Scheduled start
GSTRI Actual start date
GLTRP Basic finish date
GLTRS Scheduled finish
GLTRI Actual finish date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Unit of Measure for Capacity Requirements
  • S021.MANDT == T006.MANDT
  • S021.KEINH == T006.MSEHI
Client S021.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S021.MATNR == MARA.MATNR
  • S021.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S021.PERIV == T009.PERIV
  • S021.MANDT == T009.MANDT
Plant
  • S021.MANDT == T001W.MANDT
  • S021.WERKS == T001W.WERKS