SAP Table IOCONF

Database structure for confirmations at order header level

IOCONF (Database structure for confirmations at order header level) 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 IOCONF to other SAP tables.

Source: IOCONF (Database structure for confirmations at order header level)

IOCONF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Confirmation counter CO_RMZHL NUMC 8 0
ERSDA Confirmation entry date RU_ERSDA DATS 8 0
ERNAM Name of the person who entered the confirmation RU_ERNAM CHAR 12 0
LAEDA Date of Last Change LAEDA DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BUDAT Posting date BUCHDATUM DATS 8 0
ARBID Object ID OBJEKTID NUMC 8 0
WERKS Plant WERKS_D T001W CHAR 4 0
LTXA1 Confirmation text CO_RTEXT CHAR 40 0
TXTSP Language Key SPRAS T002 LANG 1 0
ISERH Confirmed break time ISERH QUAN 9 3
ZEIER Unit for the break time DZEIER T006 UNIT 3 0
ILE01 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM01 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE02 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM02 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE03 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM03 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE04 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM04 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE05 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM05 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE06 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM06 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ABARB Confirmation: Degree of processing CO_ABARB NUMC 3 0
ISMNW Actual work ISMNW QUAN 7 1
ISMNE Unit for work ARBEITE T006 UNIT 3 0
LEARR Activity Type for Confirmation LEARR CSLA CHAR 6 0
IDAUR Actual Duration for Confirmation IDAUR QUAN 5 1
IDAUE Unit for actual duration IDAURE T006 UNIT 3 0
ZCODE Reference number for standard value code DZCODE CHAR 6 0
LOART Wage Type LOHNART CHAR 4 0
QUALF Suitability QUALF T423 CHAR 2 0
ANZMA Number of employees ANZMS DEC 5 2
LOGRP Wage group LOHNGRP T421 CHAR 3 0
GMNGA Previously confirmed yield in order unit of measure RU_GMNGA QUAN 13 3
LMNGA Yield to Be Confirmed RU_LMNGA QUAN 13 3
XMNGA Scrap to Be Confirmed RU_XMNGA QUAN 13 3
GMEIN Base Unit of Measure MEINS T006 UNIT 3 0
MEINH Confirmation unit of measure RU_VORME T006 UNIT 3 0
GRUND Reason for Variance CO_AGRND TRUG CHAR 4 0
PERNR Personnel number CO_PERNR NUMC 8 0
ISDD Confirmed date for start of execution RU_ISDD DATS 8 0
ISDZ Confirmed time for 'Execution start' RU_ISDZ TIMS 6 0
IERD Confirmed date for 'Setup finish' RU_IERD DATS 8 0
IERZ Confirmed time for 'Setup finish' RU_IERZ TIMS 6 0
ISBD Confirmed date for 'Processing start' RU_ISBD DATS 8 0
ISBZ Confirmed time for 'Processing start' RU_ISBZ TIMS 6 0
IEBD Confirmed date for 'processing finish' RU_IEBD DATS 8 0
IEBZ Confirmed time for 'processing finish' RU_IEBZ TIMS 6 0
ISAD Confirmed date for 'teardown start' RU_ISAD DATS 8 0
ISAZ Confirmed time for 'teardown start' RU_ISAZ TIMS 6 0
IEDD Confirmed date for execution finish RU_IEDD DATS 8 0
IEDZ Confirmed time for 'Execution finish' RU_IEDZ TIMS 6 0
PEDD Forecast finish date of operation from confirmation CO_PEDD DATS 8 0
PEDZ Forecast finish time of operation from confirmation CO_PEDZ TIMS 6 0
WABLNR Number of Material Document MBLNR CHAR 10 0
WEBLNR Number of a document from a goods movement with errors WEBLNR CHAR 10 0
AUERU Partial/Final Confirmation AUERU_VS CHAR 1 0
NULL Partial confirmation
X Final confirmation
1 Automatic final confirmation
AUSOR Clear Open Reservations AUSBU CHAR 1 0
X Yes
NULL No
STNDR Indicator: Standard confirmation STNDR CHAR 1 0
X Yes
NULL No
MANUR Indicator for type of confirmation MANUR CHAR 1 0
1 Confirmation was entered manually
2 Automatic confirmation due to milestone confirmation
3 Automatic conf. due to sub-operation degree of processing
4 Autom.confirmation from cumulative confirmation
MEILR Indicator: Milestone confirmation carried out MEILR CHAR 1 0
X Milestone
D Dynamic milestone
NULL No
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL General counter for order CO_APLZL AFVC NUMC 8 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
APLFL Sequence PLNFOLGE CHAR 6 0
VORNR Operation/Activity Number VORNR CHAR 4 0
SUMNR Node number of the superior operation SUMKNTNR NUMC 8 0
OFM01 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE01 Unit of measurement for the forecast standard value RU_PROGVGE T006 UNIT 3 0
LEK01 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM02 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE02 Unit of measurement for the forecast standard value RU_PROGVGE T006 UNIT 3 0
LEK02 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM03 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE03 Unit of measurement for the forecast standard value RU_PROGVGE T006 UNIT 3 0
LEK03 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM04 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE04 Unit of measurement for the forecast standard value RU_PROGVGE T006 UNIT 3 0
LEK04 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM05 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE05 Unit of measurement for the forecast standard value RU_PROGVGE T006 UNIT 3 0
LEK05 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM06 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE06 Unit of measurement for the forecast standard value RU_PROGVGE T006 UNIT 3 0
LEK06 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFMNW Remaining work REMNW QUAN 7 1
OFMNE Unit of measure for remaining work OFMNE T006 UNIT 3 0
LEKNW Indicator: No Remaining Work Expected LEKNW CHAR 1 0
X Yes
NULL No
ODAUR Remaining duration of activity ODAUR QUAN 5 1
ODAUE Unit for remaining duration ODAUE T006 UNIT 3 0
STOKZ Indicator: Document Has Been Reversed CO_STOKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STZHL Confirmation counter of cancelled confirmation CO_STZHL NUMC 8 0
SMENG Operation Quantity MGVRG QUAN 13 3
RUECK_MST Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL_MST Confirmation counter CO_RMZHL NUMC 8 0
PDSNR Sequential number for PDC messages PDSNR_D PDSNR NUMC 12 0
KAPID Capacity ID KAPID KAKO NUMC 8 0
SPLIT Split number CY_SPLIT INT1 3 0
ZAUSW Time Recording ID Number DZAUSW NUMC 8 0
ORIND Origin Indicator of PDC Message (Application) ORIND CHAR 1 0
1 Data from HR (Human Resources Management)
2 Data from PP (production orders)
3 Data from PM (maintenance work orders)
4 Data from PS (network orders)
5 Data from PP-PK (kanban)
6 Data from PP-PI (process orders)
7 Data originate from QM (QM orders)
8 Data originate from QM (results recording)
S Error records which cannot be reposted
ORIGF Origin Indicator of PDC Message ORIGF CHAR 1 0
NULL Was entered in a subsystem
M Was entered or changed by Time Administrator
G Not currently in use
E Was entered by employee in ESS
S Was entered in a subsystem and processed in ESS
CANUM Counters for cap. rqmts. records (various caps. + indiv.caps CY_COUNT KBED NUMC 4 0
BELNR_IST Document Number CO_BELNR CHAR 10 0
BELNR_UMB Document Number CO_BELNR CHAR 10 0
RMNGA Current rework quantity to be confirmed RU_RMNGA QUAN 13 3
CATSBELNR Document Number CATSBELNR CHAR 10 0
SATZA Record type for confirmation CO_SATZA CHAR 3 0
A10 Start teardown PP
A20 Partial teardown PP
A30 Interrupt teardown PP
A40 Finish teardown PP
B10 Start processing PP
B20 Partial processing PP
B30 Interrupt processing PP
B40 Finish processing PP
I20 Time ticket PM partial confirmation
I40 Time ticket PM final confirmation
L00 Time ticket PP automatic final confirmation
L20 Time ticket PP partial confirmation
L40 Time ticket PP final confirmation
R10 Begin setup PP
R20 Partial setup PP
R30 Interrupt setup PP
R40 Finish setup PP
T20 Time ticket PS partial confirmation
T40 Time ticket PS final confirmation
V00 Activity confirmation PP
V20 Partial variable activity PP
V40 Finish variable activity PP
ERZET Confirmation entry time RU_ERZET TIMS 6 0
CATSPRICE Price in Transaction Currency CATSPRICE CURR 11 2
CATSTCURR Transaction Currency TWAER CUKY 5 0
CATSPEINH Price Unit PEINH DEC 5 0
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
IPRZ1 Current quantity to be confirmed for the business process RU_IPRZS QUAN 13 3
IPRE1 Unit of measurement for conf. quantity for business process RU_IPRZE T006 UNIT 3 0
IPRK1 No remaining quantity expected for business process RU_IPRZK CHAR 1 0
X Yes
NULL No
EXNAM External creator of confirmation RU_EXNAM CHAR 12 0
EXERD External date of entry for confirmation RU_EXERD DATS 8 0
EXERZ External time of entry for confirmation RU_EXERZ TIMS 6 0
PRZ01 Business Process CO_PRZNR CHAR 12 0
OPRZ1 Remaining quantity for business process OPRZ1 QUAN 13 3
OPRE1 Unit for remaining quantity of business process OPRE1 T006 UNIT 3 0
SKOKRS Controlling Area KOKRS CHAR 4 0
SKOSTL Sender Cost Center SKOSTL CHAR 10 0
NODAT Do not update actual date in the operation NODAT CHAR 1 0
X Yes
NULL No
ISMNU Unit for work ARBEITE T006 UNIT 3 0
OFMNU Unit for work ARBEITE T006 UNIT 3 0
PACKNO Package number PACKNO NUMC 10 0
EXTID External Key for Confirmation (for example, from PDC System) RU_EXTID RAW 16 0
SCHGRUP Grouping for Shift Definitions and Shift Sequences SCHGRUP CHAR 2 0
KAPTPROG Shift definition KAPTPROG CHAR 4 0
OBMAT Material from Original Batch UCMAT CHAR 18 0
OBCHA Original Batch UCCHA CHAR 10 0
LICHA Vendor Batch Number LICHN CHAR 15 0
MYEAR Material Document Year MJAHR NUMC 4 0
ME_SFCID SFC Number from the ME System CO_MES_INT_SFCID CHAR 60 0
ME_2ND_CONF_QTY Rework Quantity Confirmed from SAP ME CO_MES_SECOND_CONF_QTY QUAN 13 3
ROLE_ID Role ID for Confirmation in Portal RMAN_PRSP_ROLEID CHAR 1 0
1 Production Supervisor
2 Quality Inspector
3 Maintenance Technician: Confirmation
4 Maintenance Technician: Overall Completion Confirmation
5 Other
0 Production Supervisor PI
UCMAT Mill: Material in Process Batch MILL_PCMAT CHAR 18 0
UCCHA Mill: Process batch MILL_PCCHA CHAR 10 0
WTY_IND Warranty indicator WTYSC_WTY_INDICATOR CHAR 1 0
X TRUE
NULL FALSE
ARBPL Work Center RU_ARBPLI CHAR 8 0
NAME Name of employee RU_NAME CHAR 40 0
PERSA Personnel Area PERSA CHAR 4 0
UVORN Suboperation UVORN CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
KOKRS Controlling Area KOKRS CHAR 4 0
INDBT Field defined as in SY-TABIX TABIX_D INT4 10 0
KAPAR Capacity category KAPART TC26 CHAR 3 0
ABARBMAX Deviation (in %) permitted for work in confirmation DELTAARB NUMC 3 0
ABARBIST Deviation (in %) permitted for work in confirmation DELTAARB NUMC 3 0
ABDAUMAX Permitted deviation (in %) for duration in confirmation DELTADAU NUMC 3 0
ABDAUIST Permitted deviation (in %) for duration in confirmation DELTADAU NUMC 3 0
DEFSET Default values set in collective confirmation DEFSET CHAR 1 0
X Yes
NULL No
VSDAT Indicator: Actual data already proposed VSDAT CHAR 1 0
X Yes
NULL No
VSWBN Indicator: Goods movements are already determined VSWBN CHAR 1 0
X Yes
NULL No
LDATE Logical Date LDATE DATS 8 0
LTIME Logical time LTIME TIMS 6 0
GRDTX Text describing the reason for a variance in a confirmation CO_GRDTX CHAR 30 0
ISMNW_2 Actual Work ISMNW_2 QUAN 8 2
OFMNW_2 Remaining Work REMNW_2 QUAN 8 2
SLK01 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK02 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK03 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK04 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK05 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK06 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SPRK1 Indicator: Determine target qty for business transaction RU_TARGET_BUS_PROC CHAR 1 0
X Yes
NULL No
EAML_TABIX Field defined as in SY-TABIX TABIX_D INT4 10 0
PHFLG Indicator: Phase PHFLG CHAR 1 0
X Yes
NULL No
KZ_MARK Single-Character Indicator CHAR1 CHAR 1 0
INDEX_NODE Field defined as in SY-TABIX TABIX_D INT4 10 0
MATNR Material Number for Order CO_MATNR CHAR 18 0
MATXT Material description CO_MATXT CHAR 40 0

IOCONF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IOCONF APLZL IOCONF APLZL AFVC Operation within an order APLZL
IOCONF APLZL IOCONF AUFPL AFVC Operation within an order AUFPL
IOCONF APLZL IOCONF MANDT AFVC Operation within an order MANDT
IOCONF AUFNR IOCONF MANDT AUFK Order master data MANDT
IOCONF AUFNR IOCONF AUFNR AUFK Order master data AUFNR
IOCONF BEMOT IOCONF MANDT TBMOT Accounting indicators MANDT
IOCONF BEMOT IOCONF BEMOT TBMOT Accounting indicators BEMOT
IOCONF CANUM IOCONF MANDT KBED Capacity Requirements Records MANDT
IOCONF CANUM IOCONF CANUM KBED Capacity Requirements Records CANUM
IOCONF CANUM AFVC BEDZL KBED Capacity Requirements Records BEDZL
IOCONF CANUM AFVC BEDID KBED Capacity Requirements Records BEDID
IOCONF GMEIN IOCONF GMEIN T006 Units of Measurement MSEHI
IOCONF GMEIN IOCONF MANDT T006 Units of Measurement MANDT
IOCONF GRUND IOCONF GRUND TRUG Reason for variances in completion confirmations GRUND
IOCONF GRUND IOCONF WERKS TRUG Reason for variances in completion confirmations WERKS
IOCONF GRUND IOCONF MANDT TRUG Reason for variances in completion confirmations MANDT
IOCONF IDAUE IOCONF IDAUE T006 Units of Measurement MSEHI
IOCONF IDAUE IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ILE01 IOCONF ILE01 T006 Units of Measurement MSEHI
IOCONF ILE01 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ILE02 IOCONF ILE02 T006 Units of Measurement MSEHI
IOCONF ILE02 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ILE03 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ILE03 IOCONF ILE03 T006 Units of Measurement MSEHI
IOCONF ILE04 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ILE04 IOCONF ILE04 T006 Units of Measurement MSEHI
IOCONF ILE05 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ILE05 IOCONF ILE05 T006 Units of Measurement MSEHI
IOCONF ILE06 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ILE06 IOCONF ILE06 T006 Units of Measurement MSEHI
IOCONF IPRE1 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF IPRE1 IOCONF IPRE1 T006 Units of Measurement MSEHI
IOCONF ISMNE IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ISMNE IOCONF ISMNE T006 Units of Measurement MSEHI
IOCONF ISMNU IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ISMNU IOCONF ISMNU T006 Units of Measurement MSEHI
IOCONF KAPAR IOCONF KAPAR TC26 Capacity category KAPAR
IOCONF KAPAR AFRU MANDT TC26 Capacity category MANDT
IOCONF KAPID IOCONF KAPID KAKO Capacity Header Segment KAPID
IOCONF KAPID IOCONF MANDT KAKO Capacity Header Segment MANDT
IOCONF LEARR IOCONF MANDT CSLA Activity master MANDT
IOCONF LEARR AFVGD KOKRS CSLA Activity master KOKRS
IOCONF LEARR IOCONF LEARR CSLA Activity master LSTAR
IOCONF LEARR IOCONF BUDAT CSLA Activity master DATBI
IOCONF LOGRP IOCONF LOGRP T421 Wage groups LOGRP
IOCONF LOGRP IOCONF WERKS T421 Wage groups WERKS
IOCONF LOGRP IOCONF MANDT T421 Wage groups MANDT
IOCONF MANDT IOCONF MANDT T000 Clients MANDT
IOCONF MEINH IOCONF MEINH T006 Units of Measurement MSEHI
IOCONF MEINH IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ODAUE IOCONF ODAUE T006 Units of Measurement MSEHI
IOCONF ODAUE IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFE01 IOCONF OFE01 T006 Units of Measurement MSEHI
IOCONF OFE01 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFE02 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFE02 IOCONF OFE02 T006 Units of Measurement MSEHI
IOCONF OFE03 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFE03 IOCONF OFE03 T006 Units of Measurement MSEHI
IOCONF OFE04 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFE04 IOCONF OFE04 T006 Units of Measurement MSEHI
IOCONF OFE05 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFE05 IOCONF OFE05 T006 Units of Measurement MSEHI
IOCONF OFE06 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFE06 IOCONF OFE06 T006 Units of Measurement MSEHI
IOCONF OFMNE IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFMNE IOCONF OFMNE T006 Units of Measurement MSEHI
IOCONF OFMNU IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OFMNU IOCONF OFMNU T006 Units of Measurement MSEHI
IOCONF OPRE1 IOCONF MANDT T006 Units of Measurement MANDT
IOCONF OPRE1 IOCONF OPRE1 T006 Units of Measurement MSEHI
IOCONF PDSNR IOCONF PDSNR PDSNR Sequential Number for PDC Messages PDSNR
IOCONF PDSNR IOCONF MANDT PDSNR Sequential Number for PDC Messages MANDT
IOCONF QUALF IOCONF QUALF T423 Wage group qualification QUALF
IOCONF QUALF IOCONF WERKS T423 Wage group qualification WERKS
IOCONF QUALF IOCONF MANDT T423 Wage group qualification MANDT
IOCONF TXTSP IOCONF TXTSP T002 Language Keys (Component BC-I18) SPRAS
IOCONF WERKS IOCONF WERKS T001W Plants/Branches WERKS
IOCONF WERKS IOCONF MANDT T001W Plants/Branches MANDT
IOCONF ZEIER IOCONF MANDT T006 Units of Measurement MANDT
IOCONF ZEIER IOCONF ZEIER T006 Units of Measurement MSEHI