SAP AFRV Confirmation pool Table
Overview
AFRV is a standard SAP S/4HANA table that stores Confirmation pool data. There are total 189 fields in the AFRV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFRV 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 AFRV to other SAP tables and standard CDS views available based on AFRV table in S/4HANA 2020.
Techincal Settings of AFRV
Below are technical details of the table AFRV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFRV Fields
The following table gives you an overview of the fields available in AFRV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| AFORI | Origin Indicator of PDC Message (Application) | ORIND | CHAR | 1 | |
| AFRUV | Confirmation pool | AFRUV | AFRH | CHAR | 20 |
| COUNTER | Internal counter | CIM_COUNT | NUMC | 8 | |
| VTEXT | Operation short text | LTXA1 | CHAR | 40 | |
| BEAKNZ | Indicator: Entry in pool was confirmed | BEAKNZ | CHAR | 1 | |
| MPE_CONF | Confirmation generated by Manufacturing Processing Execution | MPE_CONF | CHAR | 1 | |
| PDSNR | Sequential number for PDC messages | PDSNR_D | * | NUMC | 12 |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| INFTY | Infotype | INFOTYP | * | CHAR | 4 |
| SUBTY | Subtype | SUBTY | CHAR | 4 | |
| OBJPS | Character field, length 2 | CHAR_LG_02 | CHAR | 2 | |
| SPRPS | Single-Character Flag | CHAR1 | CHAR | 1 | |
| ENDDA | End Date | ENDDA | DATS | 8 | |
| BEGDA | Start Date | BEGDA | DATS | 8 | |
| SEQNR | Number of Infotype Record With Same Key | SEQNR | NUMC | 3 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| KSTRG | Cost Object | KSTRG | CKPH | CHAR | 12 |
| POSNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| NPLNR | Network Number for Account Assignment | NPLNR | AUFK | CHAR | 12 |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | |
| KDAUF | Sales Order Number | KDAUF | * | CHAR | 10 |
| KDPOS | Item number in Sales Order | KDPOS | NUMC | 6 | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| PRZNR | Business Process | CO_PRZNR | * | CHAR | 12 |
| FISTL | Funds Center | FM_FICTR | * | CHAR | 16 |
| FIPOS | Commitment Item | FIPOS | * | CHAR | 14 |
| GEBER | Fund | BP_GEBER | * | CHAR | 10 |
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 |
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 |
| LSTNR | Activity Number | ASNUM | ASMD | CHAR | 18 |
| LTLST | Activity Type | LSTAR | CSLA | CHAR | 6 |
| SBUKR | Company Code | BUKRS | T001 | CHAR | 4 |
| SGSBR | Business Area | GSBER | TGSB | CHAR | 4 |
| SKOST | Cost Center | KOSTL | CSKS | CHAR | 10 |
| LSTAR | Activity Type | LSTAR | CSLA | CHAR | 6 |
| EXBEL | Field length 18 | CHAR18 | CHAR | 18 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | * | CHAR | 2 |
| OTYPE | Object Type | OTYPE | T778O | CHAR | 2 |
| STELL | Job | STELL | * | NUMC | 8 |
| POHRS | Number of Hours for Activity Allocation/External Services | POHRS | DEC | 7 | |
| DART | Character field, length 2 | CHAR_LG_02 | * | CHAR | 2 |
| UDART | Character field, length 2 | CHAR_LG_02 | * | CHAR | 2 |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| LDATE | Entry Date | BDE_DATE | DATS | 8 | |
| LTIME | Time received | BDE_TIME | TIMS | 6 | |
| ERDAT | Created on | PHDAT | DATS | 8 | |
| ERTIM | Created at | PHTIM | TIMS | 6 | |
| SATZA | Time Event Type | RETYP | CHAR | 3 | |
| TERID | Terminal ID | TERID | CHAR | 4 | |
| ABWGR | Undefined range (can be used for patch levels) | CHAR4 | * | CHAR | 4 |
| EXLGA | Undefined range (can be used for patch levels) | CHAR4 | CHAR | 4 | |
| ZEINH | 3-Byte field | CHAR3 | * | CHAR | 3 |
| HRAZL | Decimal field of length 7 | DEC07 | DEC | 7 | |
| HRBET | Currency amount, field length 9 | CURR09 | CURR | 9 | |
| ORIGF | Origin Indicator of PDC Message | ORIGF | CHAR | 1 | |
| DALLF | Single-Character Flag | CHAR1 | CHAR | 1 | |
| PDC_OTYPE | Object Type | OTYPE | * | CHAR | 2 |
| PDC_PLANS | Position | PLANS | * | NUMC | 8 |
| PDC_USRUP | Customer-Specific Field | PDC_USRUP | CHAR | 20 | |
| REFEX | Single-Character Flag | CHAR1 | CHAR | 1 | |
| ORDEX | Single-Character Flag | CHAR1 | CHAR | 1 | |
| ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | |
| ORIND | Origin Indicator of PDC Message (Application) | ORIND | CHAR | 1 | |
| INDEU | Insert/delete or update indicator | INDEU | CHAR | 1 | |
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | |
| SPLIT | Split number | CY_SPLIT | INT1 | 3 | |
| RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8 | |
| BUDAT | Posting Date | BUCHDATUM | DATS | 8 | |
| WERKS | Plant | WERKS_D | CHAR | 4 | |
| ARBPL | Work center | ARBPL | CHAR | 8 | |
| KAPAR | Capacity category | KAPART | * | CHAR | 3 |
| LTXA1 | Confirmation text | CO_RTEXT | CHAR | 40 | |
| ISERH | Confirmed Break Time | ISERH | QUAN | 9 | |
| ZEIER | Unit for a Break Time | DZEIER | * | UNIT | 3 |
| ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | * | UNIT | 3 |
| ISM01 | Activity Currently to be Confirmed | CO_ISMNG | QUAN | 13 | |
| OFM01 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE01 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| LEK01 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | * | UNIT | 3 |
| ISM02 | Activity Currently to be Confirmed | CO_ISMNG | QUAN | 13 | |
| OFM02 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE02 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| LEK02 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | * | UNIT | 3 |
| ISM03 | Activity Currently to be Confirmed | CO_ISMNG | QUAN | 13 | |
| OFM03 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE03 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| LEK03 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | * | UNIT | 3 |
| ISM04 | Activity Currently to be Confirmed | CO_ISMNG | QUAN | 13 | |
| OFM04 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE04 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| LEK04 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | * | UNIT | 3 |
| ISM05 | Activity Currently to be Confirmed | CO_ISMNG | QUAN | 13 | |
| OFM05 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE05 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| LEK05 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | * | UNIT | 3 |
| ISM06 | Activity Currently to be Confirmed | CO_ISMNG | QUAN | 13 | |
| OFM06 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE06 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| LEK06 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| ISMNW | Actual work | ISMNW | QUAN | 7 | |
| ISMNE | Unit for work | ARBEITE | * | UNIT | 3 |
| LEARR | Activity Type for Confirmation | LEARR | * | CHAR | 6 |
| OFMNW | Remaining work | REMNW | QUAN | 7 | |
| OFMNE | Unit of Measure for Remaining Work | OFMNE | * | UNIT | 3 |
| LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1 | |
| ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | |
| IDAUR | Actual Duration for Confirmation | IDAUR | QUAN | 5 | |
| IDAUE | Unit for actual duration | IDAURE | * | UNIT | 3 |
| ODAUR | Remaining duration of activity | ODAUR | QUAN | 5 | |
| ODAUE | Unit for remaining duration | ODAUE | * | UNIT | 3 |
| LOART | Wage type | LOHNART | CHAR | 4 | |
| QUALF | Suitability | QUALF | * | CHAR | 2 |
| ANZMA | Number of employees | ANZMS | DEC | 5 | |
| LOGRP | Wage Group | LOHNGRP | * | CHAR | 3 |
| LMNGA | Yield to be Confirmed | RU_LMNGA | QUAN | 13 | |
| XMNGA | Scrap to Be Confirmed | RU_XMNGA | QUAN | 13 | |
| MEINH | Confirmation Unit of Measure | RU_VORME | * | UNIT | 3 |
| GRUND | Reason for Variance | CO_AGRND | * | CHAR | 4 |
| 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 | AUSOR | CHAR | 1 | |
| APLFL | Sequence | PLNFOLGE | CHAR | 6 | |
| UVORN | Suboperation | UVORN | CHAR | 4 | |
| AUTYP | Order category | AUFTYP | NUMC | 2 | |
| PKNUM | Control Cycle | PKNUM | PKHD | CHAR | 7 |
| PKPOS | Kanban Control Cycle Item | PKPOS | NUMC | 3 | |
| PKBST | Kanban Status | PKBST | CHAR | 1 | |
| ABMNG | Reduced quantity in the planned order | ABMNG | QUAN | 13 | |
| RMNGA | Total Confirmed Rework Quantity | RMNGA | QUAN | 13 | |
| PKKEY | Kanban Identification Number | PKKEY | * | NUMC | 10 |
| PKIMG | Actual Quantity | PKIMG | QUAN | 13 | |
| 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 | |
| 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 |
| 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 | |
| WEBLNR | Number of a document from a goods movement with errors | WEBLNR | CHAR | 10 | |
| PKLUZ | Delivery time for a kanban, time of day | PKLUZ | TIMS | 6 | |
| PKLDT | Delivery time for a kanban, date | PKLDT | DATS | 8 | |
| PKBMG | Requested Quantity | PKBMG | QUAN | 13 | |
| CHARG | Batch Number | CHARG_D | * | CHAR | 10 |
| 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 | * | UNIT | 3 |
| OFMNU | Unit for work | ARBEITE | * | UNIT | 3 |
| PACKNO | Package number | PACKNO | * | NUMC | 10 |
| SLK01 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | |
| SLK02 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | |
| SLK03 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | |
| SLK04 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | |
| SLK05 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | |
| SLK06 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | |
| SPRK1 | Indicator: Determine target qty for business transaction | RU_TARGET_BUS_PROC | CHAR | 1 | |
| EXTID | External Key for Confirmation (for example, from PDC System) | RU_EXTID | RAW | 16 | |
| CATSCURR | Transaction Currency | TWAER | * | CUKY | 5 |
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 AFRV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFRV | ABWGR | : | * |
| AFRV | AFRUV | 1: N | AFRH |
| AFRV | AUFNR | : | AUFK |
| AFRV | BEMOT | : | TBMOT |
| AFRV | BUKRS | : | T001 |
| AFRV | CLIENT | 1: CN | T000 |
| AFRV | DART | : | * |
| AFRV | EBELN | : | EKKO |
| AFRV | EBELP | : | EKPO |
| AFRV | GSBER | : | TGSB |
| AFRV | INFTY | : | * |
| AFRV | KDAUF | : | * |
| AFRV | KOKRS | : | TKA01 |
| AFRV | KOSTL | : | CSKS |
| AFRV | KSTRG | : | CKPH |
| AFRV | LSTAR | : | CSLA |
| AFRV | LSTNR | : | ASMD |
| AFRV | LTLST | : | CSLA |
| AFRV | NPLNR | : | AUFK |
| AFRV | OTYPE | : | T778O |
| AFRV | PDC_PLANS | : | * |
| AFRV | PKNUM | : | PKHD |
| AFRV | POSNR | : | PRPS |
| AFRV | SBUKR | : | T001 |
| AFRV | SGSBR | : | TGSB |
| AFRV | SKOST | : | CSKS |
| AFRV | STELL | : | * |
| AFRV | UDART | : | * |
| AFRV | ZEINH | : | * |