AUFI

Allocation Table, Document Sub-item, Stores | #transactional | Component: Allocation
Column Name Description
MANDT FK Client
ABELN FK Allocation Table
ABELP FK Allocation Table Item
ABELG FK Store Group of an Allocation Table
ABELF Identifier of a Recipient of an Item of an Allocation Table
Column Name Description
Column Name Description
📏 Allocation Unit (AUFME):
PMNGU Planned Quantity of Sub-Item
IMNGU Confirmed Quantity of Plant
MMNGU Minimum Quantity of Plant in Plant Group
WMNGE Quantity requested by store
LFMNG GR qty assigned after alloc tbl adjustment made
LABST Valuated Unrestricted-Use Stock
HMNGU Maximum Quantity for Plants in Plant Group
OPEN_ORDERS Purchase Order Quantity
📏 Purchase Order Unit of Measure (BSTME):
BSTMG Purchase Order Quantity
📏 Purchase Order Unit of Measure (UMLME):
UMLMG Purchase Order Quantity
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
BEDAT Purchase Order Date
VKDAT Date of start of sales at plant
LEWED Latest Possible Goods Receipt
ABFDT Confirmation request date
Column Name Description
BEDTP Date type (day, week, month, interval) Show values
VKTYP Date type (day, week, month, interval) Show values
ABFTP Date type (day, week, month, interval) Show values
PSTAB Maint. status of plant Show values
ELIKZ "Delivery Completed" Indicator Show values
ABFST Status plant notification Show values
ABAST Details status, plant notification Show values
BLGTP Doc.Cat. for Follow-On Doc. to be Generated in Alloc. Tble Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
LIEFW Flag: delivery phase exists CHAR1
EBLNU Purchase Order Generated for Supplier EBELN
EBLPU Generated purchase order item EBELP
UBSTN Generated warehouse order EBELN
UBSTP Generated stock transport order item EBELP
VBLNU Generated delivery number VBELN
VBLPU Generated delivery note item POSNR
PLIFZ Planned Delivery Time in Days DEC3
WEBAZ Goods receipt processing time in days DEC3
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
SPART Division SPART
VQUOT Quotas (Base for qty calculation) VQUOT
WMERF Single-Character Flag CHAR1
BMERF Single-Character Flag CHAR1
BEWZA Evaluation Figure of Plant UPOBZ
EXPECTED_SALES Evaluation Figure of Plant UPOBZ
TREND_FACTOR Trend Factor NUMC04
Master Data Relations Join Conditions
Notification Category Allocation: Info Exchance HQ - Plant
  • AUFI.MANDT == T626.MANDT
  • AUFI.AAVIT == T626.AAVIT
Allocation Unit
  • AUFI.MANDT == T006.MANDT
  • AUFI.AUFME == T006.MSEHI
Purchase Order Unit of Measure
  • AUFI.MANDT == T006.MANDT
  • AUFI.BSTME == T006.MSEHI
Company Code
  • AUFI.MANDT == T001.MANDT
  • AUFI.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • AUFI.EKGRP == T024.EKGRP
  • AUFI.MANDT == T024.MANDT
Purchasing organization
  • AUFI.MANDT == T024E.MANDT
  • AUFI.EKORG == T024E.EKORG
Customer Number
  • AUFI.MANDT == KNA1.MANDT
  • AUFI.FILNR == KNA1.KUNNR
Store
  • AUFI.MANDT == T001W.MANDT
  • AUFI.FIWRK == T001W.WERKS
Country/Region Key
  • Country/Region Key
  • Client
  • AUFI.LAND1 == T005.LAND1
  • AUFI.MANDT == T005.MANDT
Account No. of Supplier/Creditor of Sub-Item
  • AUFI.MANDT == LFA1.MANDT
  • AUFI.LFNRU == LFA1.LIFNR
Storage location
  • Storage location
  • Client
  • Store
  • AUFI.LGORT == T001L.LGORT
  • AUFI.MANDT == T001L.MANDT
  • AUFI.FIWRK == T001L.WERKS
Client AUFI.MANDT == T000.MANDT
Blocking flag, plant
  • AUFI.MANDT == T629.MANDT
  • AUFI.SPERR == T629.SPERR
Purchase Order Unit of Measure
  • AUFI.MANDT == T006.MANDT
  • AUFI.UMLME == T006.MSEHI
Sales unit
  • AUFI.MANDT == T006.MANDT
  • AUFI.VRKME == T006.MSEHI
Distribution center (as customer)
  • AUFI.MANDT == KNA1.MANDT
  • AUFI.VZENT == KNA1.KUNNR
Supplier Number of Plant
  • AUFI.MANDT == LFA1.MANDT
  • AUFI.VZLFR == LFA1.LIFNR
Distribution Center
  • AUFI.MANDT == T001W.MANDT
  • AUFI.VZWRK == T001W.WERKS