SAP Table TXW_AFRU

Order Confirmations

TXW_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 TXW_AFRU to other SAP tables.

TXW_AFRU table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
DLINR Number of the Dynamic Item AD01DLINR NUMC 20 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 CHAR 4 0
LTXA1 Confirmation text CO_RTEXT CHAR 40 0
TXTSP Language Key SPRAS LANG 1 0
ISERH Confirmed break time TXW_ISERH CHAR 16 0
ZEIER Unit for the break time DZEIER UNIT 3 0
ILE01 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM01 Activity Currently to be Confirmed TXW_ISMNG CHAR 18 0
ILE02 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM02 Activity Currently to be Confirmed TXW_ISMNG CHAR 18 0
ILE03 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM03 Activity Currently to be Confirmed TXW_ISMNG CHAR 18 0
ILE04 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM04 Activity Currently to be Confirmed TXW_ISMNG CHAR 18 0
ILE05 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM05 Activity Currently to be Confirmed TXW_ISMNG CHAR 18 0
ILE06 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM06 Activity Currently to be Confirmed TXW_ISMNG CHAR 18 0
ABARB Confirmation: Degree of processing CO_ABARB NUMC 3 0
ISMNW Actual work TXW_ISMNW CHAR 12 0
ISMNE Unit for work ARBEITE UNIT 3 0
LEARR Activity Type for Confirmation LEARR CHAR 6 0
IDAUR Actual Duration for Confirmation TXW_IDAUR CHAR 10 0
IDAUE Unit for actual duration IDAURE UNIT 3 0
LOART Wage Type LOHNART CHAR 4 0
LOGRP Wage group LOHNGRP CHAR 3 0
GMNGA Previously confirmed yield in order unit of measure TXW_GMNGA CHAR 18 0
LMNGA Yield to Be Confirmed TXW_LMNGA CHAR 18 0
XMNGA Scrap to Be Confirmed TXW_XMNGA CHAR 18 0
GMEIN Base Unit of Measure MEINS UNIT 3 0
MEINH Confirmation unit of measure RU_VORME UNIT 3 0
GRUND Reason for Variance CO_AGRND 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
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 NUMC 8 0
AUFNR Order Number AUFNR 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
OFMNW Remaining work TXW_REMNW CHAR 12 0
OFMNE Unit of measure for remaining work OFMNE UNIT 3 0
LEKNW Indicator: No Remaining Work Expected LEKNW CHAR 1 0
X Yes
NULL No
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 TXW_MGVRG CHAR 18 0
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
SPLIT Split number TXW_CY_SPLIT CHAR 3 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 NUMC 4 0
BELNR_IST Document Number CO_BELNR CHAR 10 0
BELNR_UMB Document Number CO_BELNR CHAR 10 0
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
CATSPRICE Price in Transaction Currency TXW_CATSPRICE CHAR 16 0
CATSTCURR Transaction Currency TWAER CUKY 5 0
CATSPEINH Price Unit TXW_PEINH CHAR 6 0
BEMOT Accounting Indicator BEMOT CHAR 2 0
SKOKRS Controlling Area KOKRS CHAR 4 0
SKOSTL Sender Cost Center SKOSTL CHAR 10 0