SAP Table AFRU

Order Confirmations

AFRU (Order Confirmations) 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 AFRU to other SAP tables.

AFRU 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 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

AFRU foreign key relationships

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