AUFM SAP table for – Goods movements for order

Here we would like to draw your attention to AUFM table in SAP. As we know it is being mainly used with the SAP PM-WOC (Maintenance Processing in PM) component which is coming under PM module (Plant Maintenance). AUFM is a SAP standard transparent table used for storing Goods movements for order related data in SAP. It comes under the package IWO1.

SAP AUFM table

Table AUFM technical data

TableAUFM
Data storingGoods movements for order
ModulePM
ComponentPM-WOC
SAP PackageIWO1
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AUFM 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 AUFM 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
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • 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
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • DMBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • MBLNR : Number of Material Document
    Its a key field. Its data type is C (Character String) with field length 10
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • 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
  • 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
  • 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
  • MJAHR : Year of material document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • 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
  • RSART : Record type
    Its data type is C (Character String) with field length 1
  • 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
  • WEUNB : Goods Receipt, Non-Valuated
    Its data type is C (Character String) with field length 1
  • PS_PSP_PNR : 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
  • 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
  • ZEILE : Item in material or invoice verification document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • SAKTO : Cost Element
    Its data type is C (Character String) with field length 10
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • BLDAT : Document Date in Document
    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
  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • 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