AUFI SAP table for – Allocation Table, Document Sub-item, Stores

Here we would like to draw your attention to AUFI table in SAP. As we know it is being mainly used with the SAP LO-MDS (Merchandise Distribution in LO) component which is coming under LO module (Logistics). AUFI is a SAP standard transparent table used for storing Allocation Table, Document Sub-item, Stores related data in SAP. It comes under the package WAUF.

SAP AUFI table

Table AUFI technical data

TableAUFI
Data storingAllocation Table, Document Sub-item, Stores
ModuleLO
ComponentLO-MDS
SAP PackageWAUF
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • LFNRU
    Its data type is C (Character String) with field length 10
  • PMNGU
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • IMNGU
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MMNGU
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WMNGE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • AUFME
    Its data type is C (Character String) with field length 3
  • ABELN
    Its a key field. Its data type is C (Character String) with field length 10
  • LIEFW
    Its data type is C (Character String) with field length 1
  • EBLNU
    Its data type is C (Character String) with field length 10
  • EBLPU
    Its data type is N (Character String with Digits Only) with field length 5
  • UBSTN
    Its data type is C (Character String) with field length 10
  • UBSTP
    Its data type is N (Character String with Digits Only) with field length 5
  • VBLNU
    Its data type is C (Character String) with field length 10
  • VBLPU
    Its data type is N (Character String with Digits Only) with field length 6
  • BEDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BEDTP
    Its data type is C (Character String) with field length 1
  • VKDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ABELP
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • VKTYP
    Its data type is C (Character String) with field length 1
  • LEWED
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VZENT
    Its data type is C (Character String) with field length 10
  • VZWRK
    Its data type is C (Character String) with field length 4
  • VZLFR
    Its data type is C (Character String) with field length 10
  • AAVIT
    Its data type is C (Character String) with field length 4
  • PLIFZ : Planned delivery time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • WEBAZ : Goods receipt processing time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • ABFDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ABFTP
    Its data type is C (Character String) with field length 1
  • ABELG
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • PSTAB
    Its data type is C (Character String) with field length 1
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • BSTMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BSTME : Order unit
    Its data type is C (Character String) with field length 3
  • UMLMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • UMLME
    Its data type is C (Character String) with field length 3
  • LFMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • ABELF
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • SPERR : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • VQUOT
    Its data type is N (Character String with Digits Only) with field length 13
  • WMERF
    Its data type is C (Character String) with field length 1
  • BMERF
    Its data type is C (Character String) with field length 1
  • BEWZA
    Its data type is N (Character String with Digits Only) with field length 13
  • LABST
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • HMNGU
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • LAND1 : Country Key
    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
  • FILNR
    Its data type is C (Character String) with field length 10
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • ABFST : Flight Scheduling: Breakfast Served
    Its data type is C (Character String) with field length 1
  • ABAST
    Its data type is C (Character String) with field length 1
  • BLGTP
    Its data type is C (Character String) with field length 1
  • EXPECTED_SALES
    Its data type is N (Character String with Digits Only) with field length 13
  • OPEN_ORDERS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TREND_FACTOR
    Its data type is N (Character String with Digits Only) with field length 4
  • FIWRK
    Its data type is C (Character String) with field length 4
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3