SAP AFRU Order Confirmations Table
Overview
AFRU is a standard SAP S/4HANA table that stores Order Confirmations data. There are total 146 fields in the AFRU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFRU belongs to Confirmations (PP-SFC-EXE-CON) module and is located in the package R/3 Application development: PP Confirmations (CORU).
In addition, following links provide an overview of foreign key relationships, if any, that link AFRU to other SAP tables and standard CDS views available based on AFRU table in S/4HANA 2020.
Techincal Settings of AFRU
Below are technical details of the table AFRU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFRU Fields
The following table gives you an overview of the fields available in AFRU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | |
| RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8 | |
| ERSDA | Entry Date of Confirmation | RU_ERSDA | DATS | 8 | |
| ERNAM | User who Entered the Confirmation | RU_ERNAM | CHAR | 12 | |
| LAEDA | Date of Last Change | LAEDA | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| BUDAT | Posting Date | BUCHDATUM | DATS | 8 | |
| ARBID | Object ID | OBJEKTID | NUMC | 8 | |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| LTXA1 | Confirmation text | CO_RTEXT | CHAR | 40 | |
| TXTSP | Language Key | SPRAS | T002 | LANG | 1 |
| ISERH | Confirmed Break Time | ISERH | QUAN | 9 | |
| ZEIER | Unit for a Break Time | DZEIER | T006 | UNIT | 3 |
| ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | T006 | UNIT | 3 |
| ISM01 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13 | |
| ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | T006 | UNIT | 3 |
| ISM02 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13 | |
| ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | T006 | UNIT | 3 |
| ISM03 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13 | |
| ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | T006 | UNIT | 3 |
| ISM04 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13 | |
| ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | T006 | UNIT | 3 |
| ISM05 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13 | |
| ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | T006 | UNIT | 3 |
| ISM06 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13 | |
| ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | |
| ISMNW | Actual work | ISMNW | QUAN | 7 | |
| ISMNE | Unit for work | ARBEITE | T006 | UNIT | 3 |
| LEARR | Activity Type for Confirmation | LEARR | CSLA | CHAR | 6 |
| IDAUR | Actual Duration for Confirmation | IDAUR | QUAN | 5 | |
| IDAUE | Unit for actual duration | IDAURE | T006 | UNIT | 3 |
| ZCODE | Reference number for standard value code | DZCODE | CHAR | 6 | |
| LOART | Wage type | LOHNART | CHAR | 4 | |
| QUALF | Suitability | QUALF | T423 | CHAR | 2 |
| ANZMA | Number of employees | ANZMS | DEC | 5 | |
| LOGRP | Wage Group | LOHNGRP | T421 | CHAR | 3 |
| GMNGA | Confirmed yield quantity in order unit of measure | RU_GMNGA | QUAN | 13 | |
| LMNGA | Yield to be Confirmed | RU_LMNGA | QUAN | 13 | |
| XMNGA | Scrap to Be Confirmed | RU_XMNGA | QUAN | 13 | |
| GMEIN | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| MEINH | Confirmation Unit of Measure | RU_VORME | T006 | UNIT | 3 |
| GRUND | Reason for Variance | CO_AGRND | TRUG | CHAR | 4 |
| PERNR | Personnel number | CO_PERNR | NUMC | 8 | |
| ISDD | Confirmed Start Date of Execution | RU_ISDD | DATS | 8 | |
| ISDZ | Confirmed Time for 'Start Execution' | RU_ISDZ | TIMS | 6 | |
| IERD | Confirmed Date for 'Finish Setup' | RU_IERD | DATS | 8 | |
| IERZ | Confirmed Time for 'Finish Setup' | RU_IERZ | TIMS | 6 | |
| ISBD | Confirmed Date for 'Start Processing' | RU_ISBD | DATS | 8 | |
| ISBZ | Confirmed Time for 'Start Processing' | RU_ISBZ | TIMS | 6 | |
| IEBD | Confirmed Date for 'Finish Processing" | RU_IEBD | DATS | 8 | |
| IEBZ | Confirmed Time for 'Finish Processing' | RU_IEBZ | TIMS | 6 | |
| ISAD | Confirmed Date for 'Start Teardown' | RU_ISAD | DATS | 8 | |
| ISAZ | Confirmed Time for 'Start Teardown' | RU_ISAZ | TIMS | 6 | |
| IEDD | Confirmed Finish Date of Execution | RU_IEDD | DATS | 8 | |
| IEDZ | Confirmed Time for 'Finish Execution' | RU_IEDZ | TIMS | 6 | |
| PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | |
| PEDZ | Forecast End Time of Operation from Confirmation | CO_PEDZ | TIMS | 6 | |
| WABLNR | Number of Material Document | MBLNR | CHAR | 10 | |
| WEBLNR | Number of a document from a goods movement with errors | WEBLNR | CHAR | 10 | |
| AUERU | Partial/Final Confirmation | AUERU_VS | CHAR | 1 | |
| AUSOR | Clear Open Reservations | AUSBU | CHAR | 1 | |
| STNDR | Indicator: Standard confirmation | STNDR | CHAR | 1 | |
| MANUR | Indicator for type of confirmation | MANUR | CHAR | 1 | |
| MEILR | Indicator: Milestone Confirmation Carried Out | MEILR | CHAR | 1 | |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | General counter for order | CO_APLZL | AFVC | NUMC | 8 |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| APLFL | Sequence | PLNFOLGE | CHAR | 6 | |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | |
| SUMNR | Node Number of the Superior Operation | SUMKNTNR | NUMC | 8 | |
| OFM01 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE01 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | T006 | UNIT | 3 |
| LEK01 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| OFM02 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE02 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | T006 | UNIT | 3 |
| LEK02 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| OFM03 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE03 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | T006 | UNIT | 3 |
| LEK03 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| OFM04 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE04 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | T006 | UNIT | 3 |
| LEK04 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| OFM05 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE05 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | T006 | UNIT | 3 |
| LEK05 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| OFM06 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE06 | Unit of Measurement for Forecast Standard Value | RU_PROGVGE | T006 | UNIT | 3 |
| LEK06 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| OFMNW | Remaining work | REMNW | QUAN | 7 | |
| OFMNE | Unit of Measure for Remaining Work | OFMNE | T006 | UNIT | 3 |
| LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1 | |
| ODAUR | Remaining duration of activity | ODAUR | QUAN | 5 | |
| ODAUE | Unit for remaining duration | ODAUE | T006 | UNIT | 3 |
| STOKZ | Indicator: Document was reversed | CO_STOKZ | CHAR | 1 | |
| STZHL | Confirmation Counter of Cancelled Confirmation | CO_STZHL | NUMC | 8 | |
| SMENG | Operation Total Quantity | MGVRG | QUAN | 13 | |
| RUECK_MST | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | |
| RMZHL_MST | Confirmation counter | CO_RMZHL | NUMC | 8 | |
| PDSNR | Sequential number for PDC messages | PDSNR_D | NUMC | 12 | |
| KAPID | Capacity ID | KAPID | KAKO | NUMC | 8 |
| SPLIT | Split number | CY_SPLIT | INT1 | 3 | |
| ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | |
| ORIND | Origin Indicator of PDC Message (Application) | ORIND | CHAR | 1 | |
| ORIGF | Origin Indicator of PDC Message | ORIGF | CHAR | 1 | |
| CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | CY_COUNT | KBED | NUMC | 4 |
| BELNR_IST | Document Number | CO_BELNR | CHAR | 10 | |
| BELNR_UMB | Document Number | CO_BELNR | CHAR | 10 | |
| RMNGA | Current Confirmation Rework Quantity | RU_RMNGA | QUAN | 13 | |
| CATSBELNR | Document no. | CATSBELNR | CHAR | 10 | |
| SATZA | Record Type for Confirmation | CO_SATZA | CHAR | 3 | |
| ERZET | Confirmation Entry Time | RU_ERZET | TIMS | 6 | |
| CATSPRICE | Price in Transaction Currency | CATSPRICE | CURR | 11 | |
| CATSTCURR | Transaction Currency | TWAER | CUKY | 5 | |
| CATSPEINH | Price unit | PEINH | DEC | 5 | |
| BEMOT | Accounting Indicator | BEMOT | TBMOT | CHAR | 2 |
| IPRZ1 | Current Quantity for Business Process | RU_IPRZS | QUAN | 13 | |
| IPRE1 | Unit of Measure for Business Process Quantity | RU_IPRZE | T006 | UNIT | 3 |
| IPRK1 | No Remaining Quantity Expected for Business Process | RU_IPRZK | CHAR | 1 | |
| EXNAM | External creator of confirmation | RU_EXNAM | CHAR | 12 | |
| EXERD | External date of entry for confirmation | RU_EXERD | DATS | 8 | |
| EXERZ | External time of entry for confirmation | RU_EXERZ | TIMS | 6 | |
| PRZ01 | Business Process | CO_PRZNR | CHAR | 12 | |
| OPRZ1 | Remaining Quantity for Business Process | OPRZ1 | QUAN | 13 | |
| OPRE1 | Unit for Remaining Quantity of Business Process | OPRE1 | T006 | UNIT | 3 |
| SKOKRS | Controlling Area | KOKRS | CHAR | 4 | |
| SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10 | |
| NODAT | Do not update actual date in the operation | NODAT | CHAR | 1 | |
| ISMNU | Unit for work | ARBEITE | T006 | UNIT | 3 |
| OFMNU | Unit for work | ARBEITE | T006 | UNIT | 3 |
| PACKNO | Package number | PACKNO | NUMC | 10 | |
| EXTID | External Key for Confirmation (for example, from PDC System) | RU_EXTID | RAW | 16 | |
| SCHGRUP | Grouping for Shift Definitions and Shift Sequences | SCHGRUP | CHAR | 2 | |
| KAPTPROG | Shift Definition | KAPTPROG | CHAR | 4 | |
| EEW_AFRU_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| OBMAT | Material from Original Batch | UCMAT | CHAR | 40 | |
| OBCHA | Original Batch | UCCHA | CHAR | 10 | |
| LICHA | Supplier Batch Number | LICHN | CHAR | 15 | |
| MYEAR | Material Document Year | MJAHR | NUMC | 4 | |
| ME_SFCID | SFC Number from the ME System | CO_MES_INT_SFCID | CHAR | 60 | |
| ME_2ND_CONF_QTY | Rework Quantity Confirmed from SAP ME | CO_MES_SECOND_CONF_QTY | QUAN | 13 | |
| NO_GOODSMOVEMENT_VIA_API | Confirmation: No Goods Movement via API | NO_GOODSMOVEMENT_VIA_API | CHAR | 1 | |
| ROLE_ID | Role ID for Confirmation in Portal | RMAN_PRSP_ROLEID | CHAR | 1 | |
| UCMAT | Mill: Material in Process Batch | MILL_PCMAT | CHAR | 40 | |
| UCCHA | Mill: Process batch | MILL_PCCHA | CHAR | 10 | |
| WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFRU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFRU | APLZL | : | AFVC |
| AFRU | AUFNR | 1: 1 | AUFK |
| AFRU | BEMOT | : | TBMOT |
| AFRU | CANUM | : | KBED |
| AFRU | GMEIN | 1: CN | T006 |
| AFRU | GRUND | 1: CN | TRUG |
| AFRU | IDAUE | : | T006 |
| AFRU | ILE01 | : | T006 |
| AFRU | ILE02 | : | T006 |
| AFRU | ILE03 | : | T006 |
| AFRU | ILE04 | : | T006 |
| AFRU | ILE05 | : | T006 |
| AFRU | ILE06 | : | T006 |
| AFRU | IPRE1 | : | T006 |
| AFRU | ISMNE | : | T006 |
| AFRU | ISMNU | : | T006 |
| AFRU | KAPID | : | KAKO |
| AFRU | LEARR | : | CSLA |
| AFRU | LOGRP | 1: CN | T421 |
| AFRU | MANDT | 1: CN | T000 |
| AFRU | MEINH | : | T006 |
| AFRU | ODAUE | : | T006 |
| AFRU | OFE01 | : | T006 |
| AFRU | OFE02 | : | T006 |
| AFRU | OFE03 | : | T006 |
| AFRU | OFE04 | : | T006 |
| AFRU | OFE05 | : | T006 |
| AFRU | OFE06 | : | T006 |
| AFRU | OFMNE | : | T006 |
| AFRU | OFMNU | : | T006 |
| AFRU | OPRE1 | : | T006 |
| AFRU | QUALF | 1: CN | T423 |
| AFRU | TXTSP | 1: CN | T002 |
| AFRU | WERKS | 1: CN | T001W |
| AFRU | ZEIER | : | T006 |