AUVZ SAP table for – Distribution Center

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

SAP AUVZ table

Table AUVZ technical data

TableAUVZ
Data storingDistribution Center
ModuleLO
ComponentLO-MDS
SAP PackageWAUF
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • AUFME
    Its data type is C (Character String) with field length 3
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • 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
  • 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
  • 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
  • BSTMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ABELN
    Its a key field. Its data type is C (Character String) with field length 10
  • 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
  • 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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is RW09A
  • 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
  • ABELP
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • BSTST
    Its data type is C (Character String) with field length 1
  • UMLST
    Its data type is C (Character String) with field length 1
  • LIEST
    Its data type is C (Character String) with field length 1
  • ABVST
    Its data type is C (Character String) with field length 1
  • WEEST
    Its data type is C (Character String) with field length 1
  • KAGST
    Its data type is C (Character String) with field length 1
  • SPERR : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • BMERF
    Its data type is C (Character String) with field length 1
  • ELIKZ : “Delivery Completed” Indicator
    Its data type is C (Character String) with field length 1
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • VZWRK
    Its a key field. 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
  • WAFLU_VZ
    Its data type is C (Character String) with field length 1
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is AUVZ_APP600
  • SLS_REL
    Its data type is C (Character String) with field length 1
  • VZENT
    Its data type is C (Character String) with field length 10
  • VZLFR
    Its data type is C (Character String) with field length 10
  • PMNGV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • IMNGV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MENGE_OPT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7