SAP TXI_AFRU Table in S/4 HANA - Order completion confirmations









TXI_AFRU is a standard SAP Table which is used to store Order completion confirmations data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TXI_AFRU table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: TXI_AFRU


TXI_AFRU table structure field list

Below is the full TXI_AFRU field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) T000MANDT
RUECKCompletion confirmation number for the operationCO_RUECKNUMC10(0) CO_RUECKRCK
RMZHLConfirmation counterCO_RMZHLNUMC8(0) CIM_COUNTRZL
ERSDAEntry Date of ConfirmationRU_ERSDADATS8(0) DATUM
ERNAMUser who Entered the ConfirmationRU_ERNAMCHAR12(0) USNAM
LAEDADate of Last ChangeLAEDADATS8(0) DATUM
AENAMName of person who changed objectAENAMCHAR12(0) USNAM
BUDATPosting DateBUCHDATUMDATS8(0) DATUM
ARBIDObject IDOBJEKTIDNUMC8(0) NUM08PON
WERKSPlantWERKS_DCHAR4(0) T001WWERKSWRKH_T001W_CWERKS
LTXA1Confirmation textCO_RTEXTCHAR40(0) TEXT40
TXTSPLanguage KeySPRASLANG1(0) T002ISOLASPRASSPRH_T002SPRAS
ISERHConfirmed Break TimeISERHQUAN9(3) VGWRT
ZEIERUnit for a Break TimeDZEIERUNIT3(0) T006CUNITMEINS
ILE01Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT3(0) T006CUNITMEINS
ISM01Activity Currently to be ConfirmedRU_ISMNGQUAN13(3) MENGV13
ILE02Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT3(0) T006CUNITMEINS
ISM02Activity Currently to be ConfirmedRU_ISMNGQUAN13(3) MENGV13
ILE03Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT3(0) T006CUNITMEINS
ISM03Activity Currently to be ConfirmedRU_ISMNGQUAN13(3) MENGV13
ILE04Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT3(0) T006CUNITMEINS
ISM04Activity Currently to be ConfirmedRU_ISMNGQUAN13(3) MENGV13
ILE05Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT3(0) T006CUNITMEINS
ISM05Activity Currently to be ConfirmedRU_ISMNGQUAN13(3) MENGV13
ILE06Unit of measure for the activity to be confirmedCO_ISMNGEHUNIT3(0) T006CUNITMEINS
ISM06Activity Currently to be ConfirmedRU_ISMNGQUAN13(3) MENGV13
ABARBConfirmation: Degree of processingCO_ABARBNUMC3(0) CO_ABARB
ISMNWActual workISMNWQUAN7(1) ARBEIT
ISMNEUnit for workARBEITEUNIT3(0) T006CUNITMEINS
LEARRActivity Type for ConfirmationLEARRCHAR6(0) CSLALSTAR
IDAURActual Duration for ConfirmationIDAURQUAN5(1) DAUER_4_1
IDAUEUnit for actual durationIDAUREUNIT3(0) T006CUNITMEINS
ZCODEReference number for standard value codeDZCODECHAR6(0) ZCODE
LOARTWage typeLOHNARTCHAR4(0) LOART
QUALFSuitabilityQUALFCHAR2(0) T423QUALF
ANZMANumber of employeesANZMSDEC5(2) ANZMA
LOGRPWage GroupLOHNGRPCHAR3(0) T421LOHNGRP
GMNGAConfirmed yield quantity in order unit of measureRU_GMNGAQUAN13(3) MENG13
LMNGAYield to be ConfirmedRU_LMNGAQUAN13(3) MENGV13
XMNGAScrap to Be ConfirmedRU_XMNGAQUAN13(3) MENGV13
GMEINBase Unit of MeasureMEINSUNIT3(0) T006CUNITMEINS
MEINHConfirmation Unit of MeasureRU_VORMEUNIT3(0) T006CUNITMEINS
GRUNDReason for VarianceCO_AGRNDCHAR4(0) TRUGCO_AGRND
PERNRPersonnel numberCO_PERNRNUMC8(0) PERNRPER
ISDDConfirmed Start Date of ExecutionRU_ISDDDATS8(0) DATUM
ISDZConfirmed Time for 'Start Execution'RU_ISDZTIMS6(0) ATIME
IERDConfirmed Date for 'Finish Setup'RU_IERDDATS8(0) DATUM
IERZConfirmed Time for 'Finish Setup'RU_IERZTIMS6(0) ATIME
ISBDConfirmed Date for 'Start Processing'RU_ISBDDATS8(0) DATUM
ISBZConfirmed Time for 'Start Processing'RU_ISBZTIMS6(0) ATIME
IEBDConfirmed Date for 'Finish Processing'RU_IEBDDATS8(0) DATUM
IEBZConfirmed Time for 'Finish Processing'RU_IEBZTIMS6(0) ATIME
ISADConfirmed Date for 'Start Teardown'RU_ISADDATS8(0) DATUM
ISAZConfirmed Time for 'Start Teardown'RU_ISAZTIMS6(0) ATIME
IEDDConfirmed Finish Date of ExecutionRU_IEDDDATS8(0) DATUMEDR
IEDZConfirmed Time for 'Finish Execution'RU_IEDZTIMS6(0) ATIMEEZR
PEDDForecast finish date of operation from confirmationCO_PEDDDATS8(0) DATUM
PEDZForecast End Time of Operation from ConfirmationCO_PEDZTIMS6(0) ATIME
WABLNRNumber of Material DocumentMBLNRCHAR10(0) ALPHABELNRMBN
WEBLNRNumber of a document from a goods movement with errorsWEBLNRCHAR10(0) ALPHABELNR
AUERUPartial/Final ConfirmationAUERU_VSCHAR1(0) AUERU_VS
AUSORClear Open ReservationsAUSBUCHAR1(0) XFELD
STNDRIndicator: Standard confirmationSTNDRCHAR1(0) XFELD
MANURIndicator for type of confirmationMANURCHAR1(0) MANUR
MEILRIndicator: Milestone Confirmation Carried OutMEILRCHAR1(0) MEILR
AUFPLRouting number of operations in the orderCO_AUFPLNUMC10(0) AUFPL
APLZLGeneral counter for orderCO_APLZLNUMC8(0) AFVCCO_APLZL
AUFNROrder NumberAUFNRCHAR12(0) AUFKALPHAAUFNRANR
APLFLSequencePLNFOLGECHAR6(0) ALPHAPLNFOLGE
VORNROperation/Activity NumberVORNRCHAR4(0) NUMCVVORNRVGN
SUMNRNode Number of the Superior OperationSUMKNTNRNUMC8(0) KNTNR
OFM01Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN9(3) VGWRT
OFE01Unit of Measurement for Forecast Standard ValueRU_PROGVGEUNIT3(0) T006CUNITMEINS
LEK01Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
OFM02Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN9(3) VGWRT
OFE02Unit of Measurement for Forecast Standard ValueRU_PROGVGEUNIT3(0) T006CUNITMEINS
LEK02Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
OFM03Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN9(3) VGWRT
OFE03Unit of Measurement for Forecast Standard ValueRU_PROGVGEUNIT3(0) T006CUNITMEINS
LEK03Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
OFM04Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN9(3) VGWRT
OFE04Unit of Measurement for Forecast Standard ValueRU_PROGVGEUNIT3(0) T006CUNITMEINS
LEK04Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
OFM05Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN9(3) VGWRT
OFE05Unit of Measurement for Forecast Standard ValueRU_PROGVGEUNIT3(0) T006CUNITMEINS
LEK05Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
OFM06Forecast Value for Updating of Standard ValueCO_SCHAETZQUAN9(3) VGWRT
OFE06Unit of Measurement for Forecast Standard ValueRU_PROGVGEUNIT3(0) T006CUNITMEINS
LEK06Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
OFMNWRemaining workREMNWQUAN7(1) ARBEIT
OFMNEUnit of Measure for Remaining WorkOFMNEUNIT3(0) T006CUNITMEINS
LEKNWIndicator: No Remaining Work ExpectedLEKNWCHAR1(0) XFELD
ODAURRemaining duration of activityODAURQUAN5(1) DAUER_4_1
ODAUEUnit for remaining durationODAUEUNIT3(0) T006CUNITMEINS
STOKZIndicator: Document was reversedCO_STOKZCHAR1(0) FLAG
STZHLConfirmation Counter of Cancelled ConfirmationCO_STZHLNUMC8(0) CIM_COUNT
SMENGOperation Total QuantityMGVRGQUAN13(3) MENG13
RUECK_MSTCompletion confirmation number for the operationCO_RUECKNUMC10(0) CO_RUECKRCK
RMZHL_MSTConfirmation counterCO_RMZHLNUMC8(0) CIM_COUNTRZL
PDSNRSequential number for PDC messagesPDSNR_DNUMC12(0) Assigned to domainPDSNR
KAPIDCapacity IDKAPIDNUMC8(0) KAKOKAPID
SPLITSplit numberCY_SPLITINT13(0) INT1
ZAUSWTime Recording ID NumberDZAUSWNUMC8(0) ZAUSW
ORINDOrigin Indicator of PDC Message (Application)ORINDCHAR1(0) ORIND
ORIGFOrigin Indicator of PDC MessageORIGFCHAR1(0) ORIGF
CANUMCounters for cap. rqmts. records (various caps. + indiv.capsCY_COUNTNUMC4(0) KBEDCY_COUNT
BELNR_ISTDocument NumberCO_BELNRCHAR10(0) Assigned to domainALPHACO_BELNRBLN
BELNR_UMBDocument NumberCO_BELNRCHAR10(0) Assigned to domainALPHACO_BELNRBLN
RMNGACurrent Confirmation Rework QuantityRU_RMNGAQUAN13(3) MENGV13
CATSBELNRDocument no.CATSBELNRCHAR10(0) ALPHABELNR
SATZARecord Type for ConfirmationCO_SATZACHAR3(0) CO_SATZA
ERZETConfirmation Entry TimeRU_ERZETTIMS6(0) UZEIT
CATSPRICEPrice in Transaction CurrencyCATSPRICECURR11(2) WERTV6
CATSTCURRTransaction CurrencyTWAERCUKY5(0) Assigned to domainWAERSFWS
CATSPEINHPrice unitPEINHDEC5(0) PACK3
BEMOTAccounting IndicatorBEMOTCHAR2(0) TBMOTBEMOT
IPRZ1Current Quantity for Business ProcessRU_IPRZSQUAN13(3) MENGV13
IPRE1Unit of Measure for Business Process QuantityRU_IPRZEUNIT3(0) T006CUNITMEINS
IPRK1No Remaining Quantity Expected for Business ProcessRU_IPRZKCHAR1(0) XFELD
EXNAMExternal creator of confirmationRU_EXNAMCHAR12(0) USNAM
EXERDExternal date of entry for confirmationRU_EXERDDATS8(0) DATUM
EXERZExternal time of entry for confirmationRU_EXERZTIMS6(0) UZEIT
PRZ01Business ProcessCO_PRZNRCHAR12(0) Assigned to domainALPHACO_PRZNRKWP
OPRZ1Remaining Quantity for Business ProcessOPRZ1QUAN13(3) MENGV13
OPRE1Unit for Remaining Quantity of Business ProcessOPRE1UNIT3(0) T006CUNITMEINS
SKOKRSControlling AreaKOKRSCHAR4(0) Assigned to domainCACCDCAC
SKOSTLSender Cost CenterSKOSTLCHAR10(0) Assigned to domainALPHAKOSTLKSK
NODATDo not update actual date in the operationNODATCHAR1(0) XFELD
ISMNUUnit for workARBEITEUNIT3(0) T006CUNITMEINS
OFMNUUnit for workARBEITEUNIT3(0) T006CUNITMEINS
PACKNOPackage numberPACKNONUMC10(0) Assigned to domainPACKNO
EXTIDExternal Key for Confirmation (for example, from PDC System)RU_EXTIDRAW16(0) SYSUUID
SCHGRUPGrouping for Shift Definitions and Shift SequencesSCHGRUPCHAR2(0) Assigned to domainSCHGRUP
KAPTPROGShift DefinitionKAPTPROGCHAR4(0) Assigned to domainKAPTPROG
EEW_AFRU_PS_DUMMYDummy function in length 1DUMMYCHAR1(0) DUMMY
OBMATMaterial from Original BatchUCMATCHAR40(0) MATN1MATNRMAT1MATNR
OBCHAOriginal BatchUCCHACHAR10(0) CHARGMCH1CHARG
LICHASupplier Batch NumberLICHNCHAR15(0) LICHN
MYEARMaterial Document YearMJAHRNUMC4(0) GJAHRGJAHRMJA
ME_SFCIDSFC Number from the ME SystemCO_MES_INT_SFCIDCHAR60(0) CHAR60
ME_2ND_CONF_QTYRework Quantity Confirmed from SAP MECO_MES_SECOND_CONF_QTYQUAN13(3) MENGV13
NO_GOODSMOVEMENT_VIA_APIConfirmation: No Goods Movement via APINO_GOODSMOVEMENT_VIA_APICHAR1(0) XFELD
.INCLU--AP0(0)
ROLE_IDRole ID for Confirmation in PortalRMAN_PRSP_ROLEIDCHAR1(0) RMAN_PRSP_ROLEID
.INCLU--AP0(0)
UCMATMill: Material in Process BatchMILL_PCMATCHAR40(0) MATN1MATNRMAT1MATNR
UCCHAMill: Process batchMILL_PCCHACHAR10(0) CHARGMCH1CHARG
.INCLU--AP0(0)
WTY_INDWarranty indicatorWTYSC_WTY_INDICATORCHAR1(0) WTYSC_WTY_INDICATOR
ISERH_QYUnitUNITUNIT3(0) CUNITEINHEIT
ISM01_QYUnitUNITUNIT3(0) CUNITEINHEIT
ISM02_QYUnitUNITUNIT3(0) CUNITEINHEIT
ISM03_QYUnitUNITUNIT3(0) CUNITEINHEIT
ISM04_QYUnitUNITUNIT3(0) CUNITEINHEIT
ISM05_QYUnitUNITUNIT3(0) CUNITEINHEIT
ISM06_QYUnitUNITUNIT3(0) CUNITEINHEIT
ISMNW_QYUnitUNITUNIT3(0) CUNITEINHEIT
IDAUR_QYUnitUNITUNIT3(0) CUNITEINHEIT
GMNGA_QYUnitUNITUNIT3(0) CUNITEINHEIT
LMNGA_QYUnitUNITUNIT3(0) CUNITEINHEIT
XMNGA_QYUnitUNITUNIT3(0) CUNITEINHEIT
OFM01_QYUnitUNITUNIT3(0) CUNITEINHEIT
OFM02_QYUnitUNITUNIT3(0) CUNITEINHEIT
OFM03_QYUnitUNITUNIT3(0) CUNITEINHEIT
OFM04_QYUnitUNITUNIT3(0) CUNITEINHEIT
OFM05_QYUnitUNITUNIT3(0) CUNITEINHEIT
OFM06_QYUnitUNITUNIT3(0) CUNITEINHEIT
OFMNW_QYUnitUNITUNIT3(0) CUNITEINHEIT
ODAUR_QYUnitUNITUNIT3(0) CUNITEINHEIT
SMENG_QYUnitUNITUNIT3(0) CUNITEINHEIT
RMNGA_QYUnitUNITUNIT3(0) CUNITEINHEIT
CATSPRICE_CYCUKY for SYSTSYCUKYCUKY5(0) SYCUKY
IPRZ1_QYUnitUNITUNIT3(0) CUNITEINHEIT
OPRZ1_QYUnitUNITUNIT3(0) CUNITEINHEIT




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!