AUBSI

Worklist for PO (Follow-on Document Generation) | #transactional | Component: Allocation
Column Name Description
MANDT FK Client
BEDAT Purchase Order Date
EKORG FK Purchasing organization
EKGRP FK Purchasing Group
LIFNR FK Vendor's account number
BETRB FK Customer no. of plant
ABELN FK Allocation Table
ABELP FK Allocation Table Item
ABELG FK Store Group of an Allocation Table
ABELF FK Identifier of a Recipient of an Item of an Allocation Table
LFNUM Consecutive Number
Column Name Description
Column Name Description
📏 Allocation Unit (AUFME):
MENGE Quantity
📏 Purchase Order Unit of Measure (BSTME):
BSTMG Purchase Order Quantity
Column Name Description
BEDAT Purchase Order Date
WEDAT Delivery date
WEVDT Delivery date
WEUZT Delivery Date Time-Spot
Column Name Description
WETYP Date type (day, week, month, interval) Show values
WEVTP Date type (day, week, month, interval) Show values
ELIKZ "Delivery Completed" Indicator Show values
AUREL Relevant to Allocation Table Show values
RETPO Returns Item Show values
SLS_REL Single-Recipient Supplier Orders from Allocation Table Show values
CONS_ORDER Consignment Processing in Allocation Table (FBG) Show values
Column Name Description Domain name
SAPOS Allocation table item of material on higher level ABELP
RFKTN Reference outline agreement EBELN
RFKTP Reference outline agreement item EBELP
WRF_AT_DL_ID Dateline ID (GUID) SYSUUID_22
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • AUBSI.AKTNR == WAKH.AKTNR
  • AUBSI.MANDT == WAKH.MANDT
Item category of allocation table
  • Item category of allocation table
  • Client
  • AUBSI.APSTP == T621.APSTP
  • AUBSI.MANDT == T621.MANDT
Allocation Unit
  • AUBSI.MANDT == T006.MANDT
  • AUBSI.AUFME == T006.MSEHI
Customer no. of plant
  • AUBSI.MANDT == KNA1.MANDT
  • AUBSI.BETRB == KNA1.KUNNR
Order Type in Allocation Table (for External Supplier)
  • ?
  • Order Type in Allocation Table (for External Supplier)
  • AUBSI.MANDT == T161.MANDT
  • AUBSI.[column in domain "BSTYP"] == T161.BSTYP
  • AUBSI.BSART == T161.BSART
Purchase Order Unit of Measure
  • AUBSI.MANDT == T006.MANDT
  • AUBSI.BSTME == T006.MSEHI
Plant
  • AUBSI.MANDT == T001W.MANDT
  • AUBSI.BTWRK == T001W.WERKS
Company Code
  • AUBSI.MANDT == T001.MANDT
  • AUBSI.BUKRS_BTWRK == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • AUBSI.EKGRP == T024.EKGRP
  • AUBSI.MANDT == T024.MANDT
Purchasing organization
  • AUBSI.MANDT == T024E.MANDT
  • AUBSI.EKORG == T024E.EKORG
Customer no. of plant
  • AUBSI.MANDT == KNA1.MANDT
  • AUBSI.FILNR == KNA1.KUNNR
Store
  • AUBSI.MANDT == T001W.MANDT
  • AUBSI.FIWRK == T001W.WERKS
Country/Region Key
  • Country/Region Key
  • Client
  • AUBSI.LAND_BTWRK == T005.LAND1
  • AUBSI.MANDT == T005.MANDT
Storage location
  • Storage location
  • Client
  • Distribution Center
  • AUBSI.LGORT == T001L.LGORT
  • AUBSI.MANDT == T001L.MANDT
  • AUBSI.VZWRK == T001L.WERKS
Vendor's account number
  • AUBSI.MANDT == LFA1.MANDT
  • AUBSI.LIFNR == LFA1.LIFNR
Client AUBSI.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • AUBSI.MATNR == MARA.MATNR
  • AUBSI.MANDT == MARA.MANDT
Blocking flag, plant
  • AUBSI.MANDT == T629.MANDT
  • AUBSI.SPERR == T629.SPERR
Distribution center (as customer)
  • AUBSI.MANDT == KNA1.MANDT
  • AUBSI.VZENT == KNA1.KUNNR
Distribution Center
  • AUBSI.MANDT == T001W.MANDT
  • AUBSI.VZWRK == T001W.WERKS