AFRU SAP table for – Order Confirmations

Here we would like to draw your attention to AFRU 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). AFRU is a SAP standard transparent table used for storing Order Confirmations related data in SAP. It comes under the package CORU.

SAP AFRU table

Table AFRU technical data

TableAFRU
Data storingOrder Confirmations
ModulePP
ComponentPP-SFC
SAP PackageCORU
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFRU 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 AFRU table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • PDSNR : Sequential number for PDC messages
    Its data type is N (Character String with Digits Only) with field length 12
  • KAPID : Capacity ID
    Its data type is N (Character String with Digits Only) with field length 8
  • SPLIT : Split number
    Its data type is X (Byte 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
  • ORIGF : Origin Indicator of PDC Message
    Its data type is C (Character String) with field length 1
  • CANUM : Counters for cap. rqmts. records (various caps. + indiv.caps
    Its data type is N (Character String with Digits Only) with field length 4
  • BELNR_IST : Document Number
    Its data type is C (Character String) with field length 10
  • BELNR_UMB : Document Number
    Its data type is C (Character String) with field length 10
  • RMNGA : Current rework quantity to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LTXA1 : Confirmation text
    Its data type is C (Character String) with field length 40
  • CATSBELNR : Document number
    Its data type is C (Character String) with field length 10
  • SATZA : Record type for confirmation
    Its data type is C (Character String) with field length 3
  • ERZET : Confirmation entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • 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
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • 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
  • TXTSP : Language Key
    Its data type is C (Character String) with field length 1
  • 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
  • PRZ01 : Business Process
    Its data type is C (Character String) with field length 12
  • 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
  • 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
  • ISERH : Confirmed break time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFMNU : Unit for work
    Its data type is C (Character String) with field length 3
  • PACKNO : Package number
    Its data type is N (Character String with Digits Only) with field length 10
  • EXTID : External Key for Confirmation (for example, from PDC System)
    Its data type is X (Byte string) with field length 16
  • SCHGRUP : Grouping for Shift Definitions and Shift Sequences
    Its data type is C (Character String) with field length 2
  • KAPTPROG : Shift definition
    Its data type is C (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_AFRU
  • OBMAT : Material from Original Batch
    Its data type is C (Character String) with field length 18
  • OBCHA : Original Batch
    Its data type is C (Character String) with field length 10
  • LICHA : Vendor Batch Number
    Its data type is C (Character String) with field length 15
  • MYEAR : Year of material document
    Its data type is N (Character String with Digits Only) with field length 4
  • ZEIER : Unit for the break time
    Its data type is C (Character String) with field length 3
  • ME_SFCID : SFC Number from the ME System
    Its data type is C (Character String) with field length 60
  • ME_2ND_CONF_QTY : Rework Quantity Confirmed from SAP ME
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • .INCLU–AP : Additional Fields for Confirmation
    Its include structure/component is is COCF_S_AFRU_ADD
  • ROLE_ID : Role ID for Confirmation in Portal
    Its data type is C (Character String) with field length 1
  • 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
  • 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
  • ILE03 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • RUECK : Completion confirmation number for the operation
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • ISM03 : Activity currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • 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
  • 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
  • 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
  • ABARB : Confirmation: Degree of processing
    Its data type is N (Character String with Digits Only) with field length 3
  • 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
  • RMZHL : Confirmation counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • LEARR : Activity type for confirmation
    Its data type is C (Character String) with field length 6
  • 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
  • ZCODE : Reference number for standard value code
    Its data type is C (Character String) with field length 6
  • 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
  • GMNGA : Previously confirmed yield in order unit of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMNGA : Yield currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ERSDA : Confirmation entry date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • XMNGA : Scrap currently to be confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GMEIN : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • 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
  • PERNR : Personnel number
    Its data type is N (Character String with Digits Only) with field length 8
  • 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
  • ERNAM : Name of the person who entered the confirmation
    Its data type is C (Character String) with field length 12
  • 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
  • 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
  • WABLNR : Number of Material Document
    Its data type is C (Character String) with field length 10
  • LAEDA : Date of Last Change
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WEBLNR : Number of a document from a goods movement with errors
    Its data type is C (Character String) with field length 10
  • AUERU : Partial/Final Confirmation
    Its data type is C (Character String) with field length 1
  • AUSOR : Clear Open Reservations
    Its data type is C (Character String) with field length 1
  • STNDR : Indicator: Standard confirmation
    Its data type is C (Character String) with field length 1
  • MANUR : Indicator for type of confirmation
    Its data type is C (Character String) with field length 1
  • MEILR : Indicator: Milestone confirmation carried out
    Its data type is C (Character String) with field length 1
  • AUFPL : Routing number of operations in the order
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL : General counter for order
    Its data type is N (Character String with Digits Only) with field length 8
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • APLFL : Sequence
    Its data type is C (Character String) with field length 6
  • AENAM : Name of Person Who Changed Object
    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
  • SUMNR : Node number of the superior operation
    Its data type is N (Character String with Digits Only) with field length 8
  • 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 measurement for the forecast 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
  • 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 measurement for the forecast standard value
    Its data type is C (Character String) with field length 3
  • LEK02 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • 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 measurement for the forecast standard value
    Its data type is C (Character String) with field length 3
  • BUDAT : Posting date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LEK03 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • 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 measurement for the forecast standard value
    Its data type is C (Character String) with field length 3
  • LEK04 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • 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 measurement for the forecast 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
  • 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 measurement for the forecast standard value
    Its data type is C (Character String) with field length 3
  • LEK06 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • ARBID : Object ID
    Its data type is N (Character String with Digits Only) with field length 8
  • 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
  • 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
  • STOKZ : Indicator: Document Has Been Reversed
    Its data type is C (Character String) with field length 1
  • STZHL : Confirmation counter of cancelled confirmation
    Its data type is N (Character String with Digits Only) with field length 8
  • SMENG : Operation Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • RUECK_MST : Completion confirmation number for the operation
    Its data type is N (Character String with Digits Only) with field length 10
  • RMZHL_MST : Confirmation counter
    Its data type is N (Character String with Digits Only) with field length 8