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 |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10(0) | CO_RUECK | RCK | ||||
RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8(0) | CIM_COUNT | RZL | ||||
ERSDA | Entry Date of Confirmation | RU_ERSDA | DATS | 8(0) | DATUM | |||||
ERNAM | User who Entered the Confirmation | RU_ERNAM | CHAR | 12(0) | USNAM | |||||
LAEDA | Date of Last Change | LAEDA | DATS | 8(0) | DATUM | |||||
AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
BUDAT | Posting Date | BUCHDATUM | DATS | 8(0) | DATUM | |||||
ARBID | Object ID | OBJEKTID | NUMC | 8(0) | NUM08 | PON | ||||
WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
LTXA1 | Confirmation text | CO_RTEXT | CHAR | 40(0) | TEXT40 | |||||
TXTSP | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
ISERH | Confirmed Break Time | ISERH | QUAN | 9(3) | VGWRT | |||||
ZEIER | Unit for a Break Time | DZEIER | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ISM01 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | |||||
ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ISM02 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | |||||
ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ISM03 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | |||||
ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ISM04 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | |||||
ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ISM05 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | |||||
ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ISM06 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | |||||
ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3(0) | CO_ABARB | |||||
ISMNW | Actual work | ISMNW | QUAN | 7(1) | ARBEIT | |||||
ISMNE | Unit for work | ARBEITE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEARR | Activity Type for Confirmation | LEARR | CHAR | 6(0) | CSLA | LSTAR | ||||
IDAUR | Actual Duration for Confirmation | IDAUR | QUAN | 5(1) | DAUER_4_1 | |||||
IDAUE | Unit for actual duration | IDAURE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ZCODE | Reference number for standard value code | DZCODE | CHAR | 6(0) | ZCODE | |||||
LOART | Wage type | LOHNART | CHAR | 4(0) | LOART | |||||
QUALF | Suitability | QUALF | CHAR | 2(0) | T423 | QUALF | ||||
ANZMA | Number of employees | ANZMS | DEC | 5(2) | ANZMA | |||||
LOGRP | Wage Group | LOHNGRP | CHAR | 3(0) | T421 | LOHNGRP | ||||
GMNGA | Confirmed yield quantity in order unit of measure | RU_GMNGA | QUAN | 13(3) | MENG13 | |||||
LMNGA | Yield to be Confirmed | RU_LMNGA | QUAN | 13(3) | MENGV13 | |||||
XMNGA | Scrap to Be Confirmed | RU_XMNGA | QUAN | 13(3) | MENGV13 | |||||
GMEIN | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
MEINH | Confirmation Unit of Measure | RU_VORME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
GRUND | Reason for Variance | CO_AGRND | CHAR | 4(0) | TRUG | CO_AGRND | ||||
PERNR | Personnel number | CO_PERNR | NUMC | 8(0) | PERNR | PER | ||||
ISDD | Confirmed Start Date of Execution | RU_ISDD | DATS | 8(0) | DATUM | |||||
ISDZ | Confirmed Time for 'Start Execution' | RU_ISDZ | TIMS | 6(0) | ATIME | |||||
IERD | Confirmed Date for 'Finish Setup' | RU_IERD | DATS | 8(0) | DATUM | |||||
IERZ | Confirmed Time for 'Finish Setup' | RU_IERZ | TIMS | 6(0) | ATIME | |||||
ISBD | Confirmed Date for 'Start Processing' | RU_ISBD | DATS | 8(0) | DATUM | |||||
ISBZ | Confirmed Time for 'Start Processing' | RU_ISBZ | TIMS | 6(0) | ATIME | |||||
IEBD | Confirmed Date for 'Finish Processing' | RU_IEBD | DATS | 8(0) | DATUM | |||||
IEBZ | Confirmed Time for 'Finish Processing' | RU_IEBZ | TIMS | 6(0) | ATIME | |||||
ISAD | Confirmed Date for 'Start Teardown' | RU_ISAD | DATS | 8(0) | DATUM | |||||
ISAZ | Confirmed Time for 'Start Teardown' | RU_ISAZ | TIMS | 6(0) | ATIME | |||||
IEDD | Confirmed Finish Date of Execution | RU_IEDD | DATS | 8(0) | DATUM | EDR | ||||
IEDZ | Confirmed Time for 'Finish Execution' | RU_IEDZ | TIMS | 6(0) | ATIME | EZR | ||||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8(0) | DATUM | |||||
PEDZ | Forecast End Time of Operation from Confirmation | CO_PEDZ | TIMS | 6(0) | ATIME | |||||
WABLNR | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
WEBLNR | Number of a document from a goods movement with errors | WEBLNR | CHAR | 10(0) | ALPHA | BELNR | ||||
AUERU | Partial/Final Confirmation | AUERU_VS | CHAR | 1(0) | AUERU_VS | |||||
AUSOR | Clear Open Reservations | AUSBU | CHAR | 1(0) | XFELD | |||||
STNDR | Indicator: Standard confirmation | STNDR | CHAR | 1(0) | XFELD | |||||
MANUR | Indicator for type of confirmation | MANUR | CHAR | 1(0) | MANUR | |||||
MEILR | Indicator: Milestone Confirmation Carried Out | MEILR | CHAR | 1(0) | MEILR | |||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10(0) | AUFPL | |||||
APLZL | General counter for order | CO_APLZL | NUMC | 8(0) | AFVC | CO_APLZL | ||||
AUFNR | Order Number | AUFNR | CHAR | 12(0) | AUFK | ALPHA | AUFNR | ANR | ||
APLFL | Sequence | PLNFOLGE | CHAR | 6(0) | ALPHA | PLNFOLGE | ||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4(0) | NUMCV | VORNR | VGN | |||
SUMNR | Node Number of the Superior Operation | SUMKNTNR | NUMC | 8(0) | KNTNR | |||||
OFM01 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | |||||
OFE01 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEK01 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
OFM02 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | |||||
OFE02 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEK02 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
OFM03 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | |||||
OFE03 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEK03 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
OFM04 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | |||||
OFE04 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEK04 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
OFM05 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | |||||
OFE05 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEK05 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
OFM06 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | |||||
OFE06 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEK06 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
OFMNW | Remaining work | REMNW | QUAN | 7(1) | ARBEIT | |||||
OFMNE | Unit of Measure for Remaining Work | OFMNE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1(0) | XFELD | |||||
ODAUR | Remaining duration of activity | ODAUR | QUAN | 5(1) | DAUER_4_1 | |||||
ODAUE | Unit for remaining duration | ODAUE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
STOKZ | Indicator: Document was reversed | CO_STOKZ | CHAR | 1(0) | FLAG | |||||
STZHL | Confirmation Counter of Cancelled Confirmation | CO_STZHL | NUMC | 8(0) | CIM_COUNT | |||||
SMENG | Operation Total Quantity | MGVRG | QUAN | 13(3) | MENG13 | |||||
RUECK_MST | Completion confirmation number for the operation | CO_RUECK | NUMC | 10(0) | CO_RUECK | RCK | ||||
RMZHL_MST | Confirmation counter | CO_RMZHL | NUMC | 8(0) | CIM_COUNT | RZL | ||||
PDSNR | Sequential number for PDC messages | PDSNR_D | NUMC | 12(0) | Assigned to domain | PDSNR | ||||
KAPID | Capacity ID | KAPID | NUMC | 8(0) | KAKO | KAPID | ||||
SPLIT | Split number | CY_SPLIT | INT1 | 3(0) | INT1 | |||||
ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8(0) | ZAUSW | |||||
ORIND | Origin Indicator of PDC Message (Application) | ORIND | CHAR | 1(0) | ORIND | |||||
ORIGF | Origin Indicator of PDC Message | ORIGF | CHAR | 1(0) | ORIGF | |||||
CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | CY_COUNT | NUMC | 4(0) | KBED | CY_COUNT | ||||
BELNR_IST | Document Number | CO_BELNR | CHAR | 10(0) | Assigned to domain | ALPHA | CO_BELNR | BLN | ||
BELNR_UMB | Document Number | CO_BELNR | CHAR | 10(0) | Assigned to domain | ALPHA | CO_BELNR | BLN | ||
RMNGA | Current Confirmation Rework Quantity | RU_RMNGA | QUAN | 13(3) | MENGV13 | |||||
CATSBELNR | Document no. | CATSBELNR | CHAR | 10(0) | ALPHA | BELNR | ||||
SATZA | Record Type for Confirmation | CO_SATZA | CHAR | 3(0) | CO_SATZA | |||||
ERZET | Confirmation Entry Time | RU_ERZET | TIMS | 6(0) | UZEIT | |||||
CATSPRICE | Price in Transaction Currency | CATSPRICE | CURR | 11(2) | WERTV6 | |||||
CATSTCURR | Transaction Currency | TWAER | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
CATSPEINH | Price unit | PEINH | DEC | 5(0) | PACK3 | |||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2(0) | TBMOT | BEMOT | ||||
IPRZ1 | Current Quantity for Business Process | RU_IPRZS | QUAN | 13(3) | MENGV13 | |||||
IPRE1 | Unit of Measure for Business Process Quantity | RU_IPRZE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
IPRK1 | No Remaining Quantity Expected for Business Process | RU_IPRZK | CHAR | 1(0) | XFELD | |||||
EXNAM | External creator of confirmation | RU_EXNAM | CHAR | 12(0) | USNAM | |||||
EXERD | External date of entry for confirmation | RU_EXERD | DATS | 8(0) | DATUM | |||||
EXERZ | External time of entry for confirmation | RU_EXERZ | TIMS | 6(0) | UZEIT | |||||
PRZ01 | Business Process | CO_PRZNR | CHAR | 12(0) | Assigned to domain | ALPHA | CO_PRZNR | KWP | ||
OPRZ1 | Remaining Quantity for Business Process | OPRZ1 | QUAN | 13(3) | MENGV13 | |||||
OPRE1 | Unit for Remaining Quantity of Business Process | OPRE1 | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
SKOKRS | Controlling Area | KOKRS | CHAR | 4(0) | Assigned to domain | CACCD | CAC | |||
SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10(0) | Assigned to domain | ALPHA | KOSTL | KSK | ||
NODAT | Do not update actual date in the operation | NODAT | CHAR | 1(0) | XFELD | |||||
ISMNU | Unit for work | ARBEITE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
OFMNU | Unit for work | ARBEITE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PACKNO | Package number | PACKNO | NUMC | 10(0) | Assigned to domain | PACKNO | ||||
EXTID | External Key for Confirmation (for example, from PDC System) | RU_EXTID | RAW | 16(0) | SYSUUID | |||||
SCHGRUP | Grouping for Shift Definitions and Shift Sequences | SCHGRUP | CHAR | 2(0) | Assigned to domain | SCHGRUP | ||||
KAPTPROG | Shift Definition | KAPTPROG | CHAR | 4(0) | Assigned to domain | KAPTPROG | ||||
EEW_AFRU_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY | |||||
OBMAT | Material from Original Batch | UCMAT | CHAR | 40(0) | MATN1 | MATNR | MAT1 | MATNR | ||
OBCHA | Original Batch | UCCHA | CHAR | 10(0) | CHARG | MCH1 | CHARG | |||
LICHA | Supplier Batch Number | LICHN | CHAR | 15(0) | LICHN | |||||
MYEAR | Material Document Year | MJAHR | NUMC | 4(0) | GJAHR | GJAHR | MJA | |||
ME_SFCID | SFC Number from the ME System | CO_MES_INT_SFCID | CHAR | 60(0) | CHAR60 | |||||
ME_2ND_CONF_QTY | Rework Quantity Confirmed from SAP ME | CO_MES_SECOND_CONF_QTY | QUAN | 13(3) | MENGV13 | |||||
NO_GOODSMOVEMENT_VIA_API | Confirmation: No Goods Movement via API | NO_GOODSMOVEMENT_VIA_API | CHAR | 1(0) | XFELD | |||||
.INCLU--AP | 0(0) | |||||||||
ROLE_ID | Role ID for Confirmation in Portal | RMAN_PRSP_ROLEID | CHAR | 1(0) | RMAN_PRSP_ROLEID | |||||
.INCLU--AP | 0(0) | |||||||||
UCMAT | Mill: Material in Process Batch | MILL_PCMAT | CHAR | 40(0) | MATN1 | MATNR | MAT1 | MATNR | ||
UCCHA | Mill: Process batch | MILL_PCCHA | CHAR | 10(0) | CHARG | MCH1 | CHARG | |||
.INCLU--AP | 0(0) | |||||||||
WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1(0) | WTYSC_WTY_INDICATOR | |||||
ISERH_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ISM01_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ISM02_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ISM03_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ISM04_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ISM05_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ISM06_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ISMNW_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
IDAUR_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
GMNGA_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
LMNGA_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
XMNGA_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OFM01_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OFM02_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OFM03_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OFM04_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OFM05_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OFM06_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OFMNW_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
ODAUR_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
SMENG_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
RMNGA_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
CATSPRICE_CY | CUKY for SYST | SYCUKY | CUKY | 5(0) | SYCUKY | |||||
IPRZ1_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT | ||||
OPRZ1_QY | Unit | UNIT | UNIT | 3(0) | CUNIT | EINHEIT |
Search for further information about these or an SAP related objects