AUVZ

Distribution Center | #transactional | Component: Allocation
Column Name Description
MANDT FK Client
ABELN FK Allocation Table
ABELP FK Allocation Table Item
VZWRK FK Distribution Center
Column Name Description
Column Name Description
📏 Allocation Unit (AUFME):
PMNGV Planned GR Quantity Distribution Center
IMNGV Confirmed Quantity, Distribution Center
MENGE_OPT Optimized quantity
LFMNG GR qty assigned after alloc tbl adjustment made
📏 Purchase Order Unit of Measure (BSTME):
BSTMG Purchase Order Quantity
📏 Purchase Order Unit of Measure (UMLME):
UMLMG Reduced DC order quantity (in allocation table)
Column Name Description
Column Name Description
ABFST Status plant notification Show values
ABAST Details status, plant notification Show values
BSTST Supplier Purchase Order Generation Show values
UMLST Status: warehouse order generation Show values
LIEST Status: generate deliveries Show values
ABVST Notification status (DC) Show values
WEEST Entry status of GR in DC Show values
KAGST Status of sales order generation Show values
ELIKZ "Delivery Completed" Indicator Show values
WAFLU_VZ Processing Method / Goods Movement in Distribution Center Show values
SLS_REL Single-Recipient Supplier Orders from Allocation Table Show values
Column Name Description Domain name
PLIFZ Planned Delivery Time in Days DEC3
WEBAZ Goods receipt processing time in days DEC3
EBLNU Purchase Order Generated for Supplier EBELN
EBLPU Generated purchase order item EBELP
BMERF Single-Character Flag CHAR1
Master Data Relations Join Conditions
Allocation Unit
  • AUVZ.MANDT == T006.MANDT
  • AUVZ.AUFME == T006.MSEHI
Purchase Order Unit of Measure
  • AUVZ.MANDT == T006.MANDT
  • AUVZ.BSTME == T006.MSEHI
Company Code
  • AUVZ.MANDT == T001.MANDT
  • AUVZ.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • AUVZ.EKGRP == T024.EKGRP
  • AUVZ.MANDT == T024.MANDT
Purchasing organization
  • AUVZ.MANDT == T024E.MANDT
  • AUVZ.EKORG == T024E.EKORG
Country/Region Key
  • Country/Region Key
  • Client
  • AUVZ.LAND1 == T005.LAND1
  • AUVZ.MANDT == T005.MANDT
Storage location
  • Storage location
  • Client
  • Distribution Center
  • AUVZ.LGORT == T001L.LGORT
  • AUVZ.MANDT == T001L.MANDT
  • AUVZ.VZWRK == T001L.WERKS
Vendor's account number
  • AUVZ.MANDT == LFA1.MANDT
  • AUVZ.LIFNR == LFA1.LIFNR
Client AUVZ.MANDT == T000.MANDT
Division
  • AUVZ.MANDT == TSPA.MANDT
  • AUVZ.SPART == TSPA.SPART
Blocking flag, plant
  • AUVZ.MANDT == T629.MANDT
  • AUVZ.SPERR == T629.SPERR
Purchase Order Unit of Measure
  • AUVZ.MANDT == T006.MANDT
  • AUVZ.UMLME == T006.MSEHI
Sales Organization
  • AUVZ.MANDT == TVKO.MANDT
  • AUVZ.VKORG == TVKO.VKORG
Sales unit
  • AUVZ.MANDT == T006.MANDT
  • AUVZ.VRKME == T006.MSEHI
Distribution Channel
  • Distribution Channel
  • Client
  • AUVZ.VTWEG == TVTW.VTWEG
  • AUVZ.MANDT == TVTW.MANDT
Distribution center (as customer)
  • AUVZ.MANDT == KNA1.MANDT
  • AUVZ.VZENT == KNA1.KUNNR
Supplier Number of Plant
  • AUVZ.MANDT == LFA1.MANDT
  • AUVZ.VZLFR == LFA1.LIFNR
Distribution Center
  • AUVZ.MANDT == T001W.MANDT
  • AUVZ.VZWRK == T001W.WERKS