AFRV SAP table for – Confirmation pool

Here we would like to draw your attention to AFRV table in SAP. As we know it is being mainly used with the SAP PP-SFC (Production Orders – PP) component which is coming under PP module (Production Planning). AFRV is a SAP standard transparent table used for storing Confirmation pool related data in SAP. It comes under the package CORU.

SAP AFRV table

Table AFRV technical data

TableAFRV
Data storingConfirmation pool
ModulePP
ComponentPP-SFC
SAP PackageCORU
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFRV Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in AFRV table.

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • INFTY : Infotype
    Its data type is C (Character String) with field length 4
  • LEK04 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • ILE05 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ISM05 : Activity currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OFM05 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFE05 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • LEK05 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • ILE06 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ISM06 : Activity currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OFM06 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFE06 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • SUBTY : Subtype
    Its data type is C (Character String) with field length 4
  • LEK06 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • ISMNW : Actual work
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • ISMNE : Unit for work
    Its data type is C (Character String) with field length 3
  • LEARR : Activity type for confirmation
    Its data type is C (Character String) with field length 6
  • OFMNW : Remaining work
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • OFMNE : Unit of measure for remaining work
    Its data type is C (Character String) with field length 3
  • LEKNW : Indicator: No Remaining Work Expected
    Its data type is C (Character String) with field length 1
  • ABARB : Confirmation: Degree of processing
    Its data type is N (Character String with Digits Only) with field length 3
  • IDAUR : Actual duration for confirmation
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • IDAUE : Unit for actual duration
    Its data type is C (Character String) with field length 3
  • OBJPS : Character field, length 2
    Its data type is C (Character String) with field length 2
  • ODAUR : Remaining duration of activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • ODAUE : Unit for remaining duration
    Its data type is C (Character String) with field length 3
  • LOART : Wage type
    Its data type is C (Character String) with field length 4
  • QUALF : Suitability
    Its data type is C (Character String) with field length 2
  • ANZMA : Number of employees
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • LOGRP : Wage group
    Its data type is C (Character String) with field length 3
  • LMNGA : Yield currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • XMNGA : Scrap currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINH : Confirmation unit of measure
    Its data type is C (Character String) with field length 3
  • GRUND : Reason for Variance
    Its data type is C (Character String) with field length 4
  • SPRPS : Single-Character Flag
    Its data type is C (Character String) with field length 1
  • ISDD : Confirmed date for start of execution
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISDZ : Confirmed time for ‘Execution start’
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • IERD : Confirmed date for ‘Setup finish’
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IERZ : Confirmed time for ‘Setup finish’
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ISBD : Confirmed date for ‘Processing start’
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISBZ : Confirmed time for ‘Processing start’
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • IEBD : Confirmed date for ‘processing finish’
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IEBZ : Confirmed time for ‘processing finish’
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ISAD : Confirmed date for ‘teardown start’
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISAZ : Confirmed time for ‘teardown start’
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ENDDA : End Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IEDD : Confirmed date for execution finish
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IEDZ : Confirmed time for ‘Execution finish’
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • PEDD : Forecast finish date of operation from confirmation
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PEDZ : Forecast finish time of operation from confirmation
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AUERU : Activation of Final Confirmation
    Its data type is C (Character String) with field length 1
  • AUSOR : Post open reservations
    Its data type is C (Character String) with field length 1
  • APLFL : Sequence
    Its data type is C (Character String) with field length 6
  • UVORN : Suboperation
    Its data type is C (Character String) with field length 4
  • AUTYP : Order category
    Its data type is N (Character String with Digits Only) with field length 2
  • PKNUM : Control cycle number
    Its data type is C (Character String) with field length 7
  • BEGDA : Start Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PKPOS : Kanban item number / control cycle item
    Its data type is N (Character String with Digits Only) with field length 3
  • PKBST : Kanban status
    Its data type is C (Character String) with field length 1
  • ABMNG : Reduced quantity in the planned order
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • RMNGA : Total confirmed rework quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PKKEY : Identification Number
    Its data type is N (Character String with Digits Only) with field length 10
  • PKIMG : Actual quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CATSBELNR : Document number
    Its data type is C (Character String) with field length 10
  • CATSPRICE : Price in Transaction Currency
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • CATSTCURR : Transaction Currency
    Its data type is C (Character String) with field length 5
  • CATSPEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • SEQNR : Number of Infotype Record With Same Key
    Its data type is N (Character String with Digits Only) with field length 3
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • PRZ01 : Business Process
    Its data type is C (Character String) with field length 12
  • IPRZ1 : Current quantity to be confirmed for the business process
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • IPRE1 : Unit of measurement for conf. quantity for business process
    Its data type is C (Character String) with field length 3
  • IPRK1 : No remaining quantity expected for business process
    Its data type is C (Character String) with field length 1
  • OPRZ1 : Remaining quantity for business process
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OPRE1 : Unit for remaining quantity of business process
    Its data type is C (Character String) with field length 3
  • EXNAM : External creator of confirmation
    Its data type is C (Character String) with field length 12
  • EXERD : External date of entry for confirmation
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EXERZ : External time of entry for confirmation
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • WEBLNR : Number of a document from a goods movement with errors
    Its data type is C (Character String) with field length 10
  • PKLUZ : Delivery time for a kanban, time of day
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • PKLDT : Delivery time for a kanban, date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PKBMG : Quantity requested
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • SKOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • SKOSTL : Sender Cost Center
    Its data type is C (Character String) with field length 10
  • NODAT : Do not update actual date in the operation
    Its data type is C (Character String) with field length 1
  • ISMNU : Unit for work
    Its data type is C (Character String) with field length 3
  • OFMNU : Unit for work
    Its data type is C (Character String) with field length 3
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • PACKNO : Package number
    Its data type is N (Character String with Digits Only) with field length 10
  • SLK01 : Indicator: Determine target activity
    Its data type is C (Character String) with field length 1
  • SLK02 : Indicator: Determine target activity
    Its data type is C (Character String) with field length 1
  • SLK03 : Indicator: Determine target activity
    Its data type is C (Character String) with field length 1
  • SLK04 : Indicator: Determine target activity
    Its data type is C (Character String) with field length 1
  • SLK05 : Indicator: Determine target activity
    Its data type is C (Character String) with field length 1
  • SLK06 : Indicator: Determine target activity
    Its data type is C (Character String) with field length 1
  • SPRK1 : Indicator: Determine target qty for business transaction
    Its data type is C (Character String) with field length 1
  • EXTID : External Key for Confirmation (for example, from PDC System)
    Its data type is X (Byte string) with field length 16
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • AFORI : Origin Indicator of PDC Message (Application)
    Its a key field. Its data type is C (Character String) with field length 1
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • KSTRG : Cost Object
    Its data type is C (Character String) with field length 12
  • POSNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • NPLNR : Network Number for Account Assignment
    Its data type is C (Character String) with field length 12
  • VORNR : Operation/Activity Number
    Its data type is C (Character String) with field length 4
  • KDAUF : Sales Order Number
    Its data type is C (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is N (Character String with Digits Only) with field length 6
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is N (Character String with Digits Only) with field length 10
  • PRZNR : Business Process
    Its data type is C (Character String) with field length 12
  • AFRUV : Confirmation pool
    Its a key field. Its data type is C (Character String) with field length 20
  • FISTL : Funds Center
    Its data type is C (Character String) with field length 16
  • FIPOS : Commitment Item
    Its data type is C (Character String) with field length 14
  • GEBER : Fund
    Its data type is C (Character String) with field length 10
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is N (Character String with Digits Only) with field length 5
  • LSTNR : Activity Number
    Its data type is C (Character String) with field length 18
  • LTLST : Activity Type
    Its data type is C (Character String) with field length 6
  • SBUKR : Company Code
    Its data type is C (Character String) with field length 4
  • SGSBR : Business Area
    Its data type is C (Character String) with field length 4
  • SKOST : Cost Center
    Its data type is C (Character String) with field length 10
  • COUNTER : Internal counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • LSTAR : Activity Type
    Its data type is C (Character String) with field length 6
  • EXBEL : Field length 18
    Its data type is C (Character String) with field length 18
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 2
  • OTYPE : Object Type
    Its data type is C (Character String) with field length 2
  • STELL : Job
    Its data type is N (Character String with Digits Only) with field length 8
  • POHRS : Number of Hours for Activity Allocation/External Services
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • DART : Character field, length 2
    Its data type is C (Character String) with field length 2
  • UDART : Character field, length 2
    Its data type is C (Character String) with field length 2
  • SGTXT : Item Text
    Its data type is C (Character String) with field length 50
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • VTEXT : Operation short text
    Its data type is C (Character String) with field length 40
  • LDATE : Entry Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LTIME : Time received
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ERDAT : Created on
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERTIM : Created at
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SATZA : Time Event Type
    Its data type is C (Character String) with field length 3
  • TERID : Terminal ID
    Its data type is C (Character String) with field length 4
  • ABWGR : Not More Closely Defined Area, Possibly Used for Patchlevels
    Its data type is C (Character String) with field length 4
  • EXLGA : Not More Closely Defined Area, Possibly Used for Patchlevels
    Its data type is C (Character String) with field length 4
  • ZEINH : 3-Byte field
    Its data type is C (Character String) with field length 3
  • HRAZL : Decimal field of length 7
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • BEAKNZ : Indicator: Entry in pool was confirmed
    Its data type is C (Character String) with field length 1
  • HRBET : Currency amount, field length 9
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ORIGF : Origin Indicator of PDC Message
    Its data type is C (Character String) with field length 1
  • DALLF : Single-Character Flag
    Its data type is C (Character String) with field length 1
  • PDC_OTYPE : Object Type
    Its data type is C (Character String) with field length 2
  • PDC_PLANS : Position
    Its data type is N (Character String with Digits Only) with field length 8
  • PDC_USRUP : Customer-Specific Field
    Its data type is C (Character String) with field length 20
  • REFEX : Single-Character Flag
    Its data type is C (Character String) with field length 1
  • ORDEX : Single-Character Flag
    Its data type is C (Character String) with field length 1
  • ZAUSW : Time Recording ID Number
    Its data type is N (Character String with Digits Only) with field length 8
  • ORIND : Origin Indicator of PDC Message (Application)
    Its data type is C (Character String) with field length 1
  • .INCLUDE : Actual Activites for Confirmation of Operation
    Its include structure/component is is PDCOM
  • INDEU : Insert/delete or update indicator
    Its data type is C (Character String) with field length 1
  • RUECK : Completion confirmation number for the operation
    Its data type is N (Character String with Digits Only) with field length 10
  • SPLIT : Split number
    Its data type is X (Byte string) with field length 1
  • RMZHL : Confirmation counter
    Its data type is N (Character String with Digits Only) with field length 8
  • BUDAT : Posting date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • ARBPL : Work center
    Its data type is C (Character String) with field length 8
  • KAPAR : Capacity category
    Its data type is C (Character String) with field length 3
  • LTXA1 : Confirmation text
    Its data type is C (Character String) with field length 40
  • ISERH : Confirmed break time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • PDSNR : Sequential number for PDC messages
    Its data type is N (Character String with Digits Only) with field length 12
  • ZEIER : Unit for the break time
    Its data type is C (Character String) with field length 3
  • ILE01 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ISM01 : Activity currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OFM01 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFE01 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • LEK01 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • ILE02 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ISM02 : Activity currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OFM02 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFE02 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • PERNR : Personnel Number
    Its data type is N (Character String with Digits Only) with field length 8
  • LEK02 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • ILE03 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ISM03 : Activity currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OFM03 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFE03 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • LEK03 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • ILE04 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ISM04 : Activity currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OFM04 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFE04 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3