SAP Table S022
SFIS: Order Operation Data for Work Center
S022 (SFIS: Order Operation Data for Work Center) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S022 to other SAP tables.
S022 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
SSOUR
Statistic(s) origin
|
SSOUR |
CHAR
|
4 | 0 | ||||||||
|
VRSIO
Version number in the information structure
|
VRSIO |
CHAR
|
3 | 0 | ||||||||
|
SPMON
Period to analyze - month
|
SPMON |
NUMC
|
6 | 0 | ||||||||
|
SPTAG
Period to analyze - current date
|
SPTAG |
DATS
|
8 | 0 | ||||||||
|
SPWOC
Period to analyze - week
|
SPWOC |
NUMC
|
6 | 0 | ||||||||
|
SPBUP
Period to analyze - posting period
|
SPBUP |
NUMC
|
6 | 0 | ||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||
|
ARBPL
Work center
|
ARBPL |
CHAR
|
8 | 0 | ||||||||
|
KAPAR
Capacity category
|
KAPART | TC26 |
CHAR
|
3 | 0 | |||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||
|
AUFNR
Order Number
|
AUFNR |
CHAR
|
12 | 0 | ||||||||
|
PLNUM
Planned order number
|
PLNUM |
CHAR
|
10 | 0 | ||||||||
|
POSNR
Order Item Number
|
CO_POSNR |
NUMC
|
4 | 0 | ||||||||
|
PLNFL
Sequence
|
PLNFOLGE |
CHAR
|
6 | 0 | ||||||||
|
VORNR
Operation/Activity Number
|
VORNR |
CHAR
|
4 | 0 | ||||||||
|
PERIV
Fiscal Year Variant
|
PERIV | T009 |
CHAR
|
2 | 0 | |||||||
|
VWDAT
Pointer to administrative data
|
VWDAT |
NUMC
|
10 | 0 | ||||||||
|
MEINH
Unit of Measure for Activity/Operation
|
VORME |
UNIT
|
3 | 0 | ||||||||
|
DFZEH
Unit of measure for execution time
|
DFZEH |
UNIT
|
3 | 0 | ||||||||
|
LIGZE
Unit of measure for wait time
|
LIGZE |
UNIT
|
3 | 0 | ||||||||
|
WRTZE
Unit of measure for queue time
|
WTRZE |
UNIT
|
3 | 0 | ||||||||
|
RSTZE
Unit of measure for setup time
|
RSTZE |
UNIT
|
3 | 0 | ||||||||
|
BEAZE
Unit of measure for processing time
|
BEAZE |
UNIT
|
3 | 0 | ||||||||
|
ARUZE
Unit of measure for teardown
|
ARUZE |
UNIT
|
3 | 0 | ||||||||
|
TRAZE
Unit of measure for move time
|
TRAZE |
UNIT
|
3 | 0 | ||||||||
|
KEINH
Unit of of measure for displaying capacity requirements
|
CY_KEINH | T006 |
UNIT
|
3 | 0 | |||||||
|
KAPID
Capacity ID
|
KAPID |
NUMC
|
8 | 0 | ||||||||
|
KALID
Factory Calendar
|
WFCID |
CHAR
|
2 | 0 | ||||||||
|
OBJNR
Object number
|
J_OBJNR |
CHAR
|
22 | 0 | ||||||||
|
VERTL
Distribution function for capacity requirements
|
VERTEILUNG |
CHAR
|
2 | 0 | ||||||||
|
ERDAT
Created on
|
AUFERFDAT |
DATS
|
8 | 0 | ||||||||
|
FTRMP
Planned release date
|
CO_FTRMP |
DATS
|
8 | 0 | ||||||||
|
FTRMS
Scheduled release date
|
CO_FTRMS |
DATS
|
8 | 0 | ||||||||
|
FTRMI
Actual release date
|
CO_FTRMI |
DATS
|
8 | 0 | ||||||||
|
GSTRP
Basic start date
|
CO_GSTRP |
DATS
|
8 | 0 | ||||||||
|
GSTRS
Scheduled start
|
CO_GSTRS |
DATS
|
8 | 0 | ||||||||
|
GSTRI
Actual start date
|
CO_GSTRI |
DATS
|
8 | 0 | ||||||||
|
SSADD
Latest target input date
|
SSADD |
DATS
|
8 | 0 | ||||||||
|
IADD
Actual input date
|
IADD |
DATS
|
8 | 0 | ||||||||
|
FSAVD
Earliest scheduled start: Execution (date)
|
FSAVD |
DATS
|
8 | 0 | ||||||||
|
SSAVD
Latest scheduled start: Execution (date)
|
SSAVD |
DATS
|
8 | 0 | ||||||||
|
ISDD
Actual start: Execution (date)
|
ISDD |
DATS
|
8 | 0 | ||||||||
|
ISAVD
Actual operation start (date)
|
ISAVD |
DATS
|
8 | 0 | ||||||||
|
FSEDD
Earliest scheduled finish: Execution (date)
|
FSEDD |
DATS
|
8 | 0 | ||||||||
|
SSEDD
Latest scheduled finish: Execution (date)
|
SSEDD |
DATS
|
8 | 0 | ||||||||
|
IEDD
Actual finish: Execution (date)
|
IEDD |
DATS
|
8 | 0 | ||||||||
|
IEAVD
Actual finish of operation (date)
|
IEAVD |
DATS
|
8 | 0 | ||||||||
|
GLTRP
Basic finish date
|
CO_GLTRP |
DATS
|
8 | 0 | ||||||||
|
GLTRS
Scheduled finish
|
CO_GLTRS |
DATS
|
8 | 0 | ||||||||
|
GLTRI
Actual finish date
|
CO_GLTRI |
DATS
|
8 | 0 | ||||||||
|
GMNGA
Confirmed yield in order unit of measure
|
GMNGA |
QUAN
|
13 | 3 | ||||||||
|
MGVRG
Operation Quantity
|
MGVRG |
QUAN
|
13 | 3 | ||||||||
|
LMNGA
Total Yield Confirmed
|
LMNGA |
QUAN
|
13 | 3 | ||||||||
|
ASVRG
Operation scrap
|
ASVRG |
QUAN
|
13 | 3 | ||||||||
|
XMNGA
Total scrap quantity confirmed
|
XMNGA |
QUAN
|
13 | 3 | ||||||||
|
S_DFZ
Target execution time
|
S_DFZ |
QUAN
|
7 | 1 | ||||||||
|
I_DFZ
Actual execution time
|
I_DFZ |
QUAN
|
7 | 1 | ||||||||
|
LIEGZ
Wait time used for scheduling
|
MC_LIEGZ |
QUAN
|
7 | 1 | ||||||||
|
WARTZ
Queue time used for scheduling
|
MC_WARTZ |
QUAN
|
7 | 1 | ||||||||
|
RUEST
Scheduled setup time
|
MC_RUEST |
QUAN
|
7 | 1 | ||||||||
|
BEARZ
Scheduled processing time
|
MC_BEARZ |
QUAN
|
7 | 1 | ||||||||
|
ABRUE
Scheduled teardown time
|
MC_ABRUE |
QUAN
|
7 | 1 | ||||||||
|
TRANZ
Move time used for scheduling
|
MC_TRANZ |
QUAN
|
7 | 1 | ||||||||
|
KRUES
Scheduled cap. requirements for the op. segment "setup"
|
MC_KRUES |
QUAN
|
7 | 1 | ||||||||
|
KBEAS
Scheduled cap. requirements for the op. segment "processing"
|
MC_KBEAS |
QUAN
|
7 | 1 | ||||||||
|
KABRS
Scheduled cap. requirements for the op. segment teardown
|
MC_KABRS |
QUAN
|
7 | 1 | ||||||||
|
LIEGV
Wait time used for scheduling
|
MC_LIEGZ |
QUAN
|
7 | 1 | ||||||||
|
KAPKZ
SFIS indicator for cumulative updating of capacity data
|
KAPKZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
S022 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| S022 | KAPAR | S022 | MANDT |
TC26
Capacity category
|
MANDT |
| S022 | KAPAR | S022 | KAPAR |
TC26
Capacity category
|
KAPAR |
| S022 | KEINH | S022 | KEINH |
T006
Units of Measurement
|
MSEHI |
| S022 | KEINH | S022 | MANDT |
T006
Units of Measurement
|
MANDT |
| S022 | MANDT | S022 | MANDT |
T000
Clients
|
MANDT |
| S022 | MATNR | S022 | MANDT |
MARA
General Material Data
|
MANDT |
| S022 | MATNR | S022 | MATNR |
MARA
General Material Data
|
MATNR |
| S022 | PERIV | S022 | MANDT |
T009
Fiscal Year Variants
|
MANDT |
| S022 | PERIV | S022 | PERIV |
T009
Fiscal Year Variants
|
PERIV |
| S022 | WERKS | S022 | MANDT |
T001W
Plants/Branches
|
MANDT |
| S022 | WERKS | S022 | WERKS |
T001W
Plants/Branches
|
WERKS |