AFFW SAP table for – Goods Movements with Errors from Confirmations

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

SAP AFFW table

Table AFFW technical data

TableAFFW
Data storingGoods Movements with Errors from Confirmations
ModulePP
ComponentPP-SFC
SAP PackageCORU
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • 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
  • KDEIN : Delivery schedule for sales order
    Its data type is N (Character String with Digits Only) with field length 4
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • WEBLNR : Number of a document from a goods movement with errors
    Its a key field. Its data type is C (Character String) with field length 10
  • ERFMG : Quantity in unit of entry
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ERFME : Unit of entry
    Its data type is C (Character String) with field length 3
  • ELIKZ : “Delivery Completed” Indicator
    Its data type is C (Character String) with field length 1
  • WEMPF : Goods recipient
    Its data type is C (Character String) with field length 12
  • ABLAD : Unloading Point
    Its data type is C (Character String) with field length 25
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • RSNUM : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • RSPOS : Item Number of Reservation / Dependent Requirements
    Its data type is N (Character String with Digits Only) with field length 4
  • KZEAR : Final issue for this reservation
    Its data type is C (Character String) with field length 1
  • KZBEW : Movement Indicator
    Its data type is C (Character String) with field length 1
  • WEBLPOS : Internal counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • LGNUM : Warehouse Number / Warehouse Complex
    Its data type is C (Character String) with field length 3
  • LGTYP : Storage Type
    Its data type is C (Character String) with field length 3
  • LGPLA : Storage Bin
    Its data type is C (Character String) with field length 10
  • RUECK : Completion confirmation number for the operation
    Its data type is N (Character String with Digits Only) with field length 10
  • RMZHL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • AUFPL : Routing number of operations in the order
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • AUFPS : Order item number
    Its data type is N (Character String with Digits Only) with field length 4
  • MSGID : Application Area
    Its data type is C (Character String) with field length 20
  • MSGNO : System Message Number
    Its data type is C (Character String) with field length 3
  • ERSDA : Created On
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • MSGTY : Message Type
    Its data type is C (Character String) with field length 1
  • MSGV1 : Message variable 01
    Its data type is C (Character String) with field length 50
  • MSGV2 : Message variable 02
    Its data type is C (Character String) with field length 50
  • MSGV3 : Message variable 03
    Its data type is C (Character String) with field length 50
  • MSGV4 : Message variable 04
    Its data type is C (Character String) with field length 50
  • WABLNR : Number of Material Document
    Its data type is C (Character String) with field length 10
  • AUTYP : Order category
    Its data type is N (Character String with Digits Only) with field length 2
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is C (Character String) with field length 10
  • INSMK : Stock Type
    Its data type is C (Character String) with field length 1
  • FEVOR : Production Supervisor
    Its data type is C (Character String) with field length 3
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • DISPO : MRP controller
    Its data type is C (Character String) with field length 3
  • FWDAT : Date when the error first arose
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SMBLN : Number of Material Document
    Its data type is C (Character String) with field length 10
  • SMBLP : Item in material document
    Its data type is N (Character String with Digits Only) with field length 4
  • SJAHR : Year of material document
    Its data type is N (Character String with Digits Only) with field length 4
  • RSART : Record type
    Its data type is C (Character String) with field length 1
  • MHDAT : SLED/Best-Before Date or Date of Production
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DNOTW : Indicator: Dialog necessary
    Its data type is C (Character String) with field length 1
  • LAEDA : Date of Last Change
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • MJAHR : Year of material document
    Its data type is N (Character String with Digits Only) with field length 4
  • MBLPO : Item in material document
    Its data type is N (Character String with Digits Only) with field length 4
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • ERZET : Entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FWZET : Time when the error first arose
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • PRVBE : Production Supply Area
    Its data type is C (Character String) with field length 10
  • PRTNR : Confirmation number
    Its data type is N (Character String with Digits Only) with field length 10
  • REFBLN : Reference doc. number for linked entries in AFFW
    Its data type is C (Character String) with field length 10
  • INACT : Indicator: Planned confirmation
    Its data type is C (Character String) with field length 1
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • PARBU : Clearing company code
    Its data type is C (Character String) with field length 4
  • .INCLUDE : Structure for Include in AFFW
    Its include structure/component is is AFFW_GRUND
  • GRUND : Reason for movement
    Its data type is N (Character String with Digits Only) with field length 4
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • KUNNR : Account number of customer
    Its data type is C (Character String) with field length 10
  • BERKZ : Material Staging Indicator for Production Supply
    Its data type is C (Character String) with field length 1
  • LINE_ID : Unique identification of document line
    Its data type is N (Character String with Digits Only) with field length 6
  • BATCH_TYPE : Type of Batch
    Its data type is C (Character String) with field length 1
  • LICHA : Vendor Batch Number
    Its data type is C (Character String) with field length 15
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • WERKS : Plant
    Its data type is C (Character String) with field length 4