SAP AFRD Default values for collective confirmation Table
Overview
AFRD is a standard SAP S/4HANA table that stores Default values for collective confirmation data. There are total 109 fields in the AFRD table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFRD 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 AFRD to other SAP tables and standard CDS views available based on AFRD table in S/4HANA 2020.
Techincal Settings of AFRD
Below are technical details of the table AFRD
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFRD Fields
The following table gives you an overview of the fields available in AFRD
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUTYP | Order category | AUFTYP | NUMC | 2 | |
| UNAME | User Name | UNAME | CHAR | 12 | |
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | |
| 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 | |
| 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 | |
| AUERU | Activation of Final Confirmation | AUERU | 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 | |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| APLFL | Sequence | PLNFOLGE | CHAR | 6 | |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | |
| OFM01 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE01 | Unit of Measurement of Standard Value | VGWRTEH | 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 of Standard Value | VGWRTEH | 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 of Standard Value | VGWRTEH | 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 of Standard Value | VGWRTEH | 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 of Standard Value | VGWRTEH | 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 of Standard Value | VGWRTEH | 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 |
| SMENG | Operation Total Quantity | MGVRG | QUAN | 13 | |
| SPLIT | Split number | CY_SPLIT | INT1 | 3 | |
| ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | |
| KAPAR | Capacity category | KAPART | TC26 | CHAR | 3 |
| UVORN | Suboperation | UVORN | CHAR | 4 | |
| CATSBELNR | Document no. | CATSBELNR | CHAR | 10 | |
| CATSPRICE | Price in Transaction Currency | CATSPRICE | CURR | 11 | |
| CATSTCURR | Transaction Currency | TWAER | * | CUKY | 5 |
| CATSPEINH | Price unit | PEINH | DEC | 5 | |
| RMNGA | Current Confirmation Rework Quantity | RU_RMNGA | QUAN | 13 | |
| BEMOT | Accounting Indicator | BEMOT | TBMOT | CHAR | 2 |
| PRZ01 | Business Process | CO_PRZNR | * | CHAR | 12 |
| IPRZ1 | Current Quantity for Business Process | RU_IPRZS | QUAN | 13 | |
| IPRE1 | Unit of Measure for Business Process Quantity | RU_IPRZE | * | UNIT | 3 |
| IPRK1 | No Remaining Quantity Expected for Business Process | RU_IPRZK | CHAR | 1 | |
| OPRZ1 | Remaining Quantity for Business Process | OPRZ1 | QUAN | 13 | |
| OPRE1 | Unit for Remaining Quantity of Business Process | OPRE1 | * | UNIT | 3 |
| SCRID | ID for collective entry input list | RU_SCRID | CHAR | 1 | |
| NODAT | Do not update actual date in the operation | NODAT | CHAR | 1 | |
| ISMNW_2 | Actual Work | ISMNW_2 | QUAN | 8 | |
| OFMNW_2 | Remaining Work | REMNW_2 | QUAN | 8 | |
| ISMNU | Unit for work | ARBEITE | T006 | UNIT | 3 |
| OFMNU | Unit for work | ARBEITE | T006 | UNIT | 3 |
| PACKNO | Package number | PACKNO | * | NUMC | 10 |
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 AFRD
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFRD | AUFNR | 1: 1 | AUFK |
| AFRD | BEMOT | : | TBMOT |
| AFRD | GMEIN | 1: CN | T006 |
| AFRD | GRUND | 1: CN | TRUG |
| AFRD | IDAUE | : | T006 |
| AFRD | ILE01 | : | T006 |
| AFRD | ILE02 | : | T006 |
| AFRD | ILE03 | : | T006 |
| AFRD | ILE04 | : | T006 |
| AFRD | ILE05 | : | T006 |
| AFRD | ILE06 | : | T006 |
| AFRD | ISMNE | : | T006 |
| AFRD | ISMNU | : | T006 |
| AFRD | KAPAR | : | TC26 |
| AFRD | LEARR | : | CSLA |
| AFRD | LOGRP | 1: CN | T421 |
| AFRD | MANDT | 1: CN | T000 |
| AFRD | MEINH | : | T006 |
| AFRD | ODAUE | : | T006 |
| AFRD | OFE01 | : | T006 |
| AFRD | OFE02 | : | T006 |
| AFRD | OFE03 | : | T006 |
| AFRD | OFE04 | : | T006 |
| AFRD | OFE05 | : | T006 |
| AFRD | OFE06 | : | T006 |
| AFRD | OFMNE | : | T006 |
| AFRD | OFMNU | : | T006 |
| AFRD | QUALF | 1: CN | T423 |
| AFRD | WERKS | 1: CN | T001W |
| AFRD | ZEIER | : | T006 |