AFRV SAP (Confirmation pool) Table details
Dictionary Type: Table
Description: Confirmation pool
Description: Confirmation pool
Table field list including key, data, relationships and ABAP select examples
AFRV is a standard SAP Table which is used to store Confirmation pool data and is available within R/3 SAP systems depending on the version and release level.
The AFRV table consists of various fields, each holding specific information or linking keys about Confirmation pool data available in SAP. These include AFORI (Origin Indicator of PDC Message (Application)), AFRUV (Confirmation pool), COUNTER (Internal counter), VTEXT (Operation short text).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AFRV table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AFORI | Origin Indicator of PDC Message (Application) | ORIND | CHAR | 1 | ORIND | ||||
AFRUV | Confirmation pool | AFRUV | CHAR | 20 | AFRH | AFRUV | |||
COUNTER | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
VTEXT | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
BEAKNZ | Indicator: Entry in pool was confirmed | BEAKNZ | CHAR | 1 | XFELD | ||||
PDSNR | Sequential number for PDC messages | PDSNR_D | NUMC | 12 | Assigned to domain | PDSNR | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
INFTY | Infotype | INFOTYP | CHAR | 4 | Assigned to domain | INFOTYP | HRBAS00INFTY | ||
SUBTY | Subtype | SUBTY | CHAR | 4 | SUBTY | SUB | |||
OBJPS | Character field, length 2 | CHAR_LG_02 | CHAR | 2 | CHAR_LG_02 | ||||
SPRPS | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | NUM03 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
KSTRG | Cost Object | KSTRG | CHAR | 12 | CKPH | KSTRG | KTR | ||
POSNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | AUFK | ALPHA | AUFNR | NET | |
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
FISTL | Funds Center | FM_FICTR | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
LSTNR | Activity Number | ASNUM | CHAR | 18 | ASMD | ALPHA | ASNUM | ASN | |
LTLST | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
SBUKR | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SGSBR | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SKOST | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
EXBEL | Field length 18 | CHAR18 | CHAR | 18 | CHAR18 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
STELL | Job | STELL | NUMC | 8 | Assigned to domain | STELL | |||
POHRS | Number of Hours for Activity Allocation/External Services | POHRS | DEC | 7(2) | PTM_DEC5_2S | ||||
DART | Character field, length 2 | CHAR_LG_02 | CHAR | 2 | Assigned to domain | CHAR_LG_02 | |||
UDART | Character field, length 2 | CHAR_LG_02 | CHAR | 2 | Assigned to domain | CHAR_LG_02 | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
LDATE | Entry Date | BDE_DATE | DATS | 8 | DATUM | ||||
LTIME | Time received | BDE_TIME | TIMS | 6 | UZEIT | ||||
ERDAT | Created on | PHDAT | DATS | 8 | DATUM | ||||
ERTIM | Created at | PHTIM | TIMS | 6 | UZEIT | ||||
SATZA | Time Event Type | RETYP | CHAR | 3 | RETYP | ||||
TERID | Terminal ID | TERID | CHAR | 4 | TERID | ||||
ABWGR | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | Assigned to domain | CHAR4 | |||
EXLGA | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | CHAR4 | ||||
ZEINH | 3-Byte field | CHAR3 | CHAR | 3 | Assigned to domain | CHAR3 | |||
HRAZL | Decimal field of length 7 | DEC07 | DEC | 7(2) | CO_ANZHL | ||||
HRBET | Currency amount, field length 9 | CURR09 | CURR | 9(2) | WERT5 | ||||
ORIGF | Origin Indicator of PDC Message | ORIGF | CHAR | 1 | ORIGF | ||||
DALLF | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PDC_OTYPE | Object Type | OTYPE | CHAR | 2 | Assigned to domain | OTYPE | POT | ||
PDC_PLANS | Position | PLANS | NUMC | 8 | Assigned to domain | PLANS | |||
PDC_USRUP | Customer-Specific Field | PDC_USRUP | CHAR | 20 | CHAR20 | ||||
REFEX | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ORDEX | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | ZAUSW | ||||
ORIND | Origin Indicator of PDC Message (Application) | ORIND | CHAR | 1 | ORIND | ||||
INDEU | Insert/delete or update indicator | INDEU | CHAR | 1 | INDEU | ||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8 | CIM_COUNT | RZL | |||
BUDAT | Posting date | BUCHDATUM | DATS | 8 | DATUM | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
LTXA1 | Confirmation text | CO_RTEXT | CHAR | 40 | TEXT40 | ||||
ISERH | Confirmed break time | ISERH | QUAN | 9(3) | VGWRT | ||||
ZEIER | Unit for the break time | DZEIER | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM01 | Activity currently to be confirmed | CO_ISMNG | QUAN | 13(3) | MENG13 | ||||
OFM01 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE01 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEK01 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM02 | Activity currently to be confirmed | CO_ISMNG | QUAN | 13(3) | MENG13 | ||||
OFM02 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE02 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEK02 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM03 | Activity currently to be confirmed | CO_ISMNG | QUAN | 13(3) | MENG13 | ||||
OFM03 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE03 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEK03 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM04 | Activity currently to be confirmed | CO_ISMNG | QUAN | 13(3) | MENG13 | ||||
OFM04 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE04 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEK04 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM05 | Activity currently to be confirmed | CO_ISMNG | QUAN | 13(3) | MENG13 | ||||
OFM05 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE05 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEK05 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM06 | Activity currently to be confirmed | CO_ISMNG | QUAN | 13(3) | MENG13 | ||||
OFM06 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE06 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEK06 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ISMNW | Actual work | ISMNW | QUAN | 7(1) | ARBEIT | ||||
ISMNE | Unit for work | ARBEITE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEARR | Activity Type for Confirmation | LEARR | CHAR | 6 | Assigned to domain | LSTAR | |||
OFMNW | Remaining work | REMNW | QUAN | 7(1) | ARBEIT | ||||
OFMNE | Unit of measure for remaining work | OFMNE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1 | XFELD | ||||
ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | CO_ABARB | ||||
IDAUR | Actual Duration for Confirmation | IDAUR | QUAN | 5(1) | DAUER_4_1 | ||||
IDAUE | Unit for actual duration | IDAURE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ODAUR | Remaining duration of activity | ODAUR | QUAN | 5(1) | DAUER_4_1 | ||||
ODAUE | Unit for remaining duration | ODAUE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LOART | Wage Type | LOHNART | CHAR | 4 | LOART | ||||
QUALF | Suitability | QUALF | CHAR | 2 | Assigned to domain | QUALF | |||
ANZMA | Number of employees | ANZMS | DEC | 5(2) | ANZMA | ||||
LOGRP | Wage group | LOHNGRP | CHAR | 3 | Assigned to domain | LOHNGRP | |||
LMNGA | Yield to Be Confirmed | RU_LMNGA | QUAN | 13(3) | MENGV13 | ||||
XMNGA | Scrap to Be Confirmed | RU_XMNGA | QUAN | 13(3) | MENGV13 | ||||
MEINH | Confirmation unit of measure | RU_VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GRUND | Reason for Variance | CO_AGRND | CHAR | 4 | Assigned to domain | CO_AGRND | |||
ISDD | Confirmed date for start of execution | RU_ISDD | DATS | 8 | DATUM | ||||
ISDZ | Confirmed time for 'Execution start' | RU_ISDZ | TIMS | 6 | ATIME | ||||
IERD | Confirmed date for 'Setup finish' | RU_IERD | DATS | 8 | DATUM | ||||
IERZ | Confirmed time for 'Setup finish' | RU_IERZ | TIMS | 6 | ATIME | ||||
ISBD | Confirmed date for 'Processing start' | RU_ISBD | DATS | 8 | DATUM | ||||
ISBZ | Confirmed time for 'Processing start' | RU_ISBZ | TIMS | 6 | ATIME | ||||
IEBD | Confirmed date for 'processing finish' | RU_IEBD | DATS | 8 | DATUM | ||||
IEBZ | Confirmed time for 'processing finish' | RU_IEBZ | TIMS | 6 | ATIME | ||||
ISAD | Confirmed date for 'teardown start' | RU_ISAD | DATS | 8 | DATUM | ||||
ISAZ | Confirmed time for 'teardown start' | RU_ISAZ | TIMS | 6 | ATIME | ||||
IEDD | Confirmed date for execution finish | RU_IEDD | DATS | 8 | DATUM | EDR | |||
IEDZ | Confirmed time for 'Execution finish' | RU_IEDZ | TIMS | 6 | ATIME | EZR | |||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
PEDZ | Forecast finish time of operation from confirmation | CO_PEDZ | TIMS | 6 | ATIME | ||||
AUERU | Activation of Final Confirmation | AUERU | CHAR | 1 | AUERU_VS | ||||
AUSOR | Post open reservations | AUSOR | CHAR | 1 | XFELD | ||||
APLFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
PKNUM | Control cycle number | PKNUM | CHAR | 7 | PKHD | ALPHA | PKNUM | PKNUM | |
PKPOS | Kanban item number / control cycle item | PKPOS | NUMC | 3 | PKPOS | ||||
PKBST | Kanban status | PKBST | CHAR | 1 | PKBST | ||||
ABMNG | Reduced quantity in the planned order | ABMNG | QUAN | 13(3) | MENGE | ||||
RMNGA | Total confirmed rework quantity | RMNGA | QUAN | 13(3) | MENGV13 | ||||
PKKEY | Identification Number | PKKEY | NUMC | 10 | Assigned to domain | PKKEY | |||
PKIMG | Actual quantity | PKIMG | QUAN | 13(3) | MENG13 | ||||
CATSBELNR | Document Number | CATSBELNR | CHAR | 10 | ALPHA | BELNR | |||
CATSPRICE | Price in Transaction Currency | CATSPRICE | CURR | 11(2) | WERTV6 | ||||
CATSTCURR | Transaction Currency | TWAER | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CATSPEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
PRZ01 | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
IPRZ1 | Current quantity to be confirmed for the business process | RU_IPRZS | QUAN | 13(3) | MENGV13 | ||||
IPRE1 | Unit of measurement for conf. quantity for business process | RU_IPRZE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IPRK1 | No remaining quantity expected for business process | RU_IPRZK | CHAR | 1 | XFELD | ||||
OPRZ1 | Remaining quantity for business process | OPRZ1 | QUAN | 13(3) | MENGV13 | ||||
OPRE1 | Unit for remaining quantity of business process | OPRE1 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EXNAM | External creator of confirmation | RU_EXNAM | CHAR | 12 | USNAM | ||||
EXERD | External date of entry for confirmation | RU_EXERD | DATS | 8 | DATUM | ||||
EXERZ | External time of entry for confirmation | RU_EXERZ | TIMS | 6 | UZEIT | ||||
WEBLNR | Number of a document from a goods movement with errors | WEBLNR | CHAR | 10 | ALPHA | BELNR | |||
PKLUZ | Delivery time for a kanban, time of day | PKLUZ | TIMS | 6 | UZEIT | ||||
PKLDT | Delivery time for a kanban, date | PKLDT | DATS | 8 | DATUM | ||||
PKBMG | Quantity requested | PKBMG | QUAN | 13(3) | MENG13 | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
SKOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
NODAT | Do not update actual date in the operation | NODAT | CHAR | 1 | XFELD | ||||
ISMNU | Unit for work | ARBEITE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFMNU | Unit for work | ARBEITE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PACKNO | Package number | PACKNO | NUMC | 10 | Assigned to domain | PACKNO | |||
SLK01 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK02 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK03 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK04 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK05 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK06 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SPRK1 | Indicator: Determine target qty for business transaction | RU_TARGET_BUS_PROC | CHAR | 1 | XFELD | ||||
EXTID | External Key for Confirmation (for example, from PDC System) | RU_EXTID | RAW | 16 | SYSUUID | ||||
.INCLU--AP | 0 | ||||||||
CATSCURR | Transaction Currency | TWAER | CUKY | 5 | Assigned to domain | WAERS | FWS |
Key field | Non-key field |
How do I retrieve data from SAP table AFRV using ABAP code
The following ABAP code Example will allow you to do a basic selection on AFRV to SELECT all data from the tableDATA: WA_AFRV TYPE AFRV.
SELECT SINGLE *
FROM AFRV
INTO CORRESPONDING FIELDS OF WA_AFRV
WHERE...
How to access SAP table AFRV
Within an ECC or HANA version of SAP you can also view further information about AFRV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects