AFRV_DEL SAP table for – Backup Copy for Confirmation Pool

Here we would like to draw your attention to AFRV_DEL 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_DEL is a SAP standard transparent table used for storing Backup Copy for Confirmation Pool related data in SAP. It comes under the package CORU.

SAP AFRV_DEL table

Table AFRV_DEL technical data

TableAFRV_DEL
Data storingBackup Copy for Confirmation Pool
ModulePP
ComponentPP-SFC
SAP PackageCORU
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFRV_DEL 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_DEL 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