Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

MANDT

Client

MANDT

T000

CLNT

RUECK

Completion confirmation number for the operation

CO_RUECK

NUMC

RMZHL

Confirmation counter

CO_RMZHL

NUMC

ERSDA

Confirmation entry date

RU_ERSDA

DATS

ERNAM

Name of the person who entered the confirmation

RU_ERNAM

CHAR

LAEDA

Date of Last Change

LAEDA

DATS

AENAM

Name of Person Who Changed Object

AENAM

CHAR

BUDAT

Posting date

BUCHDATUM

DATS

ARBID

Object ID

OBJEKTID

NUMC

WERKS

Plant

WERKS_D

T001W

CHAR

LTXA1

Confirmation text

CO_RTEXT

CHAR

TXTSP

Language Key

SPRAS

T002

LANG

ISERH

Confirmed break time

ISERH

QUAN

ZEIER

Unit for the break time

DZEIER

T006

UNIT

ILE01

Unit of measure for the activity to be confirmed

CO_ISMNGEH

T006

UNIT

ISM01

Activity Currently to be Confirmed

RU_ISMNG

QUAN

ILE02

Unit of measure for the activity to be confirmed

CO_ISMNGEH

T006

UNIT

ISM02

Activity Currently to be Confirmed

RU_ISMNG

QUAN

ILE03

Unit of measure for the activity to be confirmed

CO_ISMNGEH

T006

UNIT

ISM03

Activity Currently to be Confirmed

RU_ISMNG

QUAN

ILE04

Unit of measure for the activity to be confirmed

CO_ISMNGEH

T006

UNIT

ISM04

Activity Currently to be Confirmed

RU_ISMNG

QUAN

ILE05

Unit of measure for the activity to be confirmed

CO_ISMNGEH

T006

UNIT

ISM05

Activity Currently to be Confirmed

RU_ISMNG

QUAN

ILE06

Unit of measure for the activity to be confirmed

CO_ISMNGEH

T006

UNIT

ISM06

Activity Currently to be Confirmed

RU_ISMNG

QUAN

ABARB

Confirmation: Degree of processing

CO_ABARB

NUMC

ISMNW

Actual work

ISMNW

QUAN

ISMNE

Unit for work

ARBEITE

T006

UNIT

LEARR

Activity Type for Confirmation

LEARR

CSLA

CHAR

IDAUR

Actual Duration for Confirmation

IDAUR

QUAN

IDAUE

Unit for actual duration

IDAURE

T006

UNIT

ZCODE

Reference number for standard value code

DZCODE

CHAR

LOART

Wage Type

LOHNART

CHAR

QUALF

Suitability

QUALF

T423

CHAR

ANZMA

Number of employees

ANZMS

DEC

LOGRP

Wage group

LOHNGRP

T421

CHAR

GMNGA

Previously confirmed yield in order unit of measure

RU_GMNGA

QUAN

LMNGA

Yield to Be Confirmed

RU_LMNGA

QUAN

XMNGA

Scrap to Be Confirmed

RU_XMNGA

QUAN

GMEIN

Base Unit of Measure

MEINS

T006

UNIT

MEINH

Confirmation unit of measure

RU_VORME

T006

UNIT

GRUND

Reason for Variance

CO_AGRND

TRUG

CHAR

PERNR

Personnel number

CO_PERNR

NUMC

ISDD

Confirmed date for start of execution

RU_ISDD

DATS

ISDZ

Confirmed time for 'Execution start'

RU_ISDZ

TIMS

IERD

Confirmed date for 'Setup finish'

RU_IERD

DATS

IERZ

Confirmed time for 'Setup finish'

RU_IERZ

TIMS

ISBD

Confirmed date for 'Processing start'

RU_ISBD

DATS

ISBZ

Confirmed time for 'Processing start'

RU_ISBZ

TIMS

IEBD

Confirmed date for 'processing finish'

RU_IEBD

DATS

IEBZ

Confirmed time for 'processing finish'

RU_IEBZ

TIMS

ISAD

Confirmed date for 'teardown start'

RU_ISAD

DATS

ISAZ

Confirmed time for 'teardown start'

RU_ISAZ

TIMS

IEDD

Confirmed date for execution finish

RU_IEDD

DATS

IEDZ

Confirmed time for 'Execution finish'

RU_IEDZ

TIMS

PEDD

Forecast finish date of operation from confirmation

CO_PEDD

DATS

PEDZ

Forecast finish time of operation from confirmation

CO_PEDZ

TIMS

WABLNR

Number of Material Document

MBLNR

CHAR

WEBLNR

Number of a document from a goods movement with errors

WEBLNR

CHAR

AUERU

Partial/Final Confirmation

AUERU_VS

CHAR

Value	Description
NULL	Partial confirmation
X	Final confirmation
1	Automatic final confirmation

AUSOR

Clear Open Reservations

AUSBU

CHAR

Value	Description
X	Yes
NULL	No

STNDR

Indicator: Standard confirmation

STNDR

CHAR

Value	Description
X	Yes
NULL	No

MANUR

Indicator for type of confirmation

MANUR

CHAR

Value	Description
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

Value	Description
X	Milestone
D	Dynamic milestone
NULL	No

AUFPL

Routing number of operations in the order

CO_AUFPL

NUMC

APLZL

General counter for order

CO_APLZL

AFVC

NUMC

AUFNR

Order Number

AUFNR

AUFK

CHAR

APLFL

Sequence

PLNFOLGE

CHAR

VORNR

Operation/Activity Number

VORNR

CHAR

SUMNR

Node number of the superior operation

SUMKNTNR

NUMC

OFM01

Forecast value used to update the standard value

CO_SCHAETZ

QUAN

OFE01

Unit of measurement for the forecast standard value

RU_PROGVGE

T006

UNIT

LEK01

Indicator: No remaining activity expected

CO_LEIKZ

CHAR

Value	Description
X	Yes
NULL	No

OFM02

Forecast value used to update the standard value

CO_SCHAETZ

QUAN

OFE02

Unit of measurement for the forecast standard value

RU_PROGVGE

T006

UNIT

LEK02

Indicator: No remaining activity expected

CO_LEIKZ

CHAR

Value	Description
X	Yes
NULL	No

OFM03

Forecast value used to update the standard value

CO_SCHAETZ

QUAN

OFE03

Unit of measurement for the forecast standard value

RU_PROGVGE

T006

UNIT

LEK03

Indicator: No remaining activity expected

CO_LEIKZ

CHAR

Value	Description
X	Yes
NULL	No

OFM04

Forecast value used to update the standard value

CO_SCHAETZ

QUAN

OFE04

Unit of measurement for the forecast standard value

RU_PROGVGE

T006

UNIT

LEK04

Indicator: No remaining activity expected

CO_LEIKZ

CHAR

Value	Description
X	Yes
NULL	No

OFM05

Forecast value used to update the standard value

CO_SCHAETZ

QUAN

OFE05

Unit of measurement for the forecast standard value

RU_PROGVGE

T006

UNIT

LEK05

Indicator: No remaining activity expected

CO_LEIKZ

CHAR

Value	Description
X	Yes
NULL	No

OFM06

Forecast value used to update the standard value

CO_SCHAETZ

QUAN

OFE06

Unit of measurement for the forecast standard value

RU_PROGVGE

T006

UNIT

LEK06

Indicator: No remaining activity expected

CO_LEIKZ

CHAR

Value	Description
X	Yes
NULL	No

OFMNW

Remaining work

REMNW

QUAN

OFMNE

Unit of measure for remaining work

OFMNE

T006

UNIT

LEKNW

Indicator: No Remaining Work Expected

LEKNW

CHAR

Value	Description
X	Yes
NULL	No

ODAUR

Remaining duration of activity

ODAUR

QUAN

ODAUE

Unit for remaining duration

ODAUE

T006

UNIT

STOKZ

Indicator: Document Has Been Reversed

CO_STOKZ

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

STZHL

Confirmation counter of cancelled confirmation

CO_STZHL

NUMC

SMENG

Operation Quantity

MGVRG

QUAN

RUECK_MST

Completion confirmation number for the operation

CO_RUECK

NUMC

RMZHL_MST

Confirmation counter

CO_RMZHL

NUMC

PDSNR

Sequential number for PDC messages

PDSNR_D

NUMC

KAPID

Capacity ID

KAPID

KAKO

NUMC

SPLIT

Split number

CY_SPLIT

INT1

ZAUSW

Time Recording ID Number

DZAUSW

NUMC

ORIND

Origin Indicator of PDC Message (Application)

ORIND

CHAR

Value	Description
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

Value	Description
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

BELNR_IST

Document Number

CO_BELNR

CHAR

BELNR_UMB

Document Number

CO_BELNR

CHAR

RMNGA

Current rework quantity to be confirmed

RU_RMNGA

QUAN

CATSBELNR

Document Number

CATSBELNR

CHAR

SATZA

Record type for confirmation

CO_SATZA

CHAR

Value	Description
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

CATSPRICE

Price in Transaction Currency

CATSPRICE

CURR

CATSTCURR

Transaction Currency

TWAER

CUKY

CATSPEINH

Price Unit

PEINH

DEC

BEMOT

Accounting Indicator

BEMOT

TBMOT

CHAR

IPRZ1

Current quantity to be confirmed for the business process

RU_IPRZS

QUAN

IPRE1

Unit of measurement for conf. quantity for business process

RU_IPRZE

T006

UNIT

IPRK1

No remaining quantity expected for business process

RU_IPRZK

CHAR

Value	Description
X	Yes
NULL	No

EXNAM

External creator of confirmation

RU_EXNAM

CHAR

EXERD

External date of entry for confirmation

RU_EXERD

DATS

EXERZ

External time of entry for confirmation

RU_EXERZ

TIMS

PRZ01

Business Process

CO_PRZNR

CHAR

OPRZ1

Remaining quantity for business process

OPRZ1

QUAN

OPRE1

Unit for remaining quantity of business process

OPRE1

T006

UNIT

SKOKRS

Controlling Area

KOKRS

CHAR

SKOSTL

Sender Cost Center

SKOSTL

CHAR

NODAT

Do not update actual date in the operation

NODAT

CHAR

Value	Description
X	Yes
NULL	No

ISMNU

Unit for work

ARBEITE

T006

UNIT

OFMNU

Unit for work

ARBEITE

T006

UNIT

PACKNO

Package number

PACKNO

NUMC

EXTID

External Key for Confirmation (for example, from PDC System)

RU_EXTID

RAW

SCHGRUP

Grouping for Shift Definitions and Shift Sequences

SCHGRUP

CHAR

KAPTPROG

Shift definition

KAPTPROG

CHAR

OBMAT

Material from Original Batch

UCMAT

CHAR

OBCHA

Original Batch

UCCHA

CHAR

LICHA

Vendor Batch Number

LICHN

CHAR

MYEAR

Material Document Year

MJAHR

NUMC

ME_SFCID

SFC Number from the ME System

CO_MES_INT_SFCID

CHAR

ME_2ND_CONF_QTY

Rework Quantity Confirmed from SAP ME

CO_MES_SECOND_CONF_QTY

QUAN

ROLE_ID

Role ID for Confirmation in Portal

RMAN_PRSP_ROLEID

CHAR

Value	Description
1	Production Supervisor
2	Quality Inspector
3	Maintenance Technician: Confirmation
4	Maintenance Technician: Overall Completion Confirmation
5	Other
NULL	Production Supervisor PI

UCMAT

Mill: Material in Process Batch

MILL_PCMAT

CHAR

UCCHA

Mill: Process batch

MILL_PCCHA

CHAR

WTY_IND

Warranty indicator

WTYSC_WTY_INDICATOR

CHAR

Value	Description
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	MANDT	AUFK Order master data	MANDT
AFRU	AUFNR	AFRU	AUFNR	AUFK Order master data	AUFNR
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	MANDT	T006 Units of Measurement	MANDT
AFRU	GMEIN	AFRU	GMEIN	T006 Units of Measurement	MSEHI
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	GRUND	AFRU	WERKS	TRUG Reason for variances in completion confirmations	WERKS
AFRU	IDAUE	AFRU	IDAUE	T006 Units of Measurement	MSEHI
AFRU	IDAUE	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	ILE01	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	ILE01	AFRU	ILE01	T006 Units of Measurement	MSEHI
AFRU	ILE02	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	ILE02	AFRU	ILE02	T006 Units of Measurement	MSEHI
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	ILE05	T006 Units of Measurement	MSEHI
AFRU	ILE05	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	ILE06	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	ILE06	AFRU	ILE06	T006 Units of Measurement	MSEHI
AFRU	IPRE1	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	IPRE1	AFRU	IPRE1	T006 Units of Measurement	MSEHI
AFRU	ISMNE	AFRU	ISMNE	T006 Units of Measurement	MSEHI
AFRU	ISMNE	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	ISMNU	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	ISMNU	AFRU	ISMNU	T006 Units of Measurement	MSEHI
AFRU	KAPID	AFRU	MANDT	KAKO Capacity Header Segment	MANDT
AFRU	KAPID	AFRU	KAPID	KAKO Capacity Header Segment	KAPID
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	LEARR	AFRU	MANDT	CSLA Activity master	MANDT
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	MANDT	T006 Units of Measurement	MANDT
AFRU	MEINH	AFRU	MEINH	T006 Units of Measurement	MSEHI
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	OFE02	T006 Units of Measurement	MSEHI
AFRU	OFE02	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	OFE03	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	OFE03	AFRU	OFE03	T006 Units of Measurement	MSEHI
AFRU	OFE04	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	OFE04	AFRU	OFE04	T006 Units of Measurement	MSEHI
AFRU	OFE05	AFRU	OFE05	T006 Units of Measurement	MSEHI
AFRU	OFE05	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	OFE06	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	OFE06	AFRU	OFE06	T006 Units of Measurement	MSEHI
AFRU	OFMNE	AFRU	MANDT	T006 Units of Measurement	MANDT
AFRU	OFMNE	AFRU	OFMNE	T006 Units of Measurement	MSEHI
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	QUALF	T423 Wage group qualification	QUALF
AFRU	QUALF	AFRU	MANDT	T423 Wage group qualification	MANDT
AFRU	QUALF	AFRU	WERKS	T423 Wage group qualification	WERKS
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	ZEIER	T006 Units of Measurement	MSEHI
AFRU	ZEIER	AFRU	MANDT	T006 Units of Measurement	MANDT