SAP Table AUVW
Delivery Phase for Distribution Center
AUVW (Delivery Phase for Distribution Center) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link AUVW to other SAP tables.
AUVW table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
ABELN
Allocation Table Number
|
ABELN | AUKO |
CHAR
|
10 | 0 | |||||||||||||
|
ABELP
Item number of allocation table
|
ABELP | AUPO |
NUMC
|
5 | 0 | |||||||||||||
|
VZWRK
Distribution center as plant
|
VZWRK | T001W |
CHAR
|
4 | 0 | |||||||||||||
|
LFNUM
Serial number
|
LFNR3 |
NUMC
|
3 | 0 | ||||||||||||||
|
WEVDT
Delivery date
|
LFDAT |
DATS
|
8 | 0 | ||||||||||||||
|
WEVTP
Date type (day, week, month, interval)
|
PRGRS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
WEUZT
Delivery Date Time-Spot
|
LZEIT |
TIMS
|
6 | 0 | ||||||||||||||
|
WEPRZ
Delivery phase in percent of total qty
|
LWPRZ |
NUMC
|
3 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MENGE
Quantity
|
MENGE_D |
QUAN
|
13 | 3 | ||||||||||||||
|
AUFME
Allocation Unit
|
AUFME | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
WEMNG
Quantity of Goods Received
|
WEEMG |
QUAN
|
13 | 3 | ||||||||||||||
|
MBLNR
Number of Material Document
|
MBLNR |
CHAR
|
10 | 0 | ||||||||||||||
|
MBLPO
Item in Material Document
|
MBLPO |
NUMC
|
4 | 0 | ||||||||||||||
|
LFMNG
GR qty assigned after alloc tbl adjustment made
|
EFMNG |
QUAN
|
13 | 3 | ||||||||||||||
|
VRKME
Sales unit
|
VRKME | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
BEDAT
Order date/ latest date for generating follow-on documents
|
SPBEDAT |
DATS
|
8 | 0 | ||||||||||||||
|
BSTMG
Purchase Order Quantity
|
BSTMG |
QUAN
|
13 | 3 | ||||||||||||||
|
BSTME
Purchase Order Unit of Measure
|
BSTME | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
EBLNU
Purchase Order Generated for Vendor
|
EBLNU |
CHAR
|
10 | 0 | ||||||||||||||
|
EBLPU
Generated purchase order item
|
EBLPU |
NUMC
|
5 | 0 | ||||||||||||||
|
UMLMG
Reduced DC order quantity (in allocation table)
|
BSTMG_RED |
QUAN
|
13 | 3 | ||||||||||||||
|
UMLME
Purchase Order Unit of Measure
|
BSTME | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
ELIKZ
"Delivery Completed" Indicator
|
ELIKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
IMNGL
Confirmed quantity in delivery phase
|
IMNGL |
QUAN
|
13 | 3 | ||||||||||||||
|
WRF_AT_DL_ID
Dateline ID (GUID)
|
WRF_AT_DL_ID |
CHAR
|
22 | 0 | ||||||||||||||
|
SUBMI
Collective Number
|
SUBMI |
CHAR
|
10 | 0 | ||||||||||||||
AUVW foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| AUVW | ABELN | AUVW | MANDT |
AUKO
Allocation Table Document Header
|
MANDT |
| AUVW | ABELN | AUVW | ABELN |
AUKO
Allocation Table Document Header
|
ABELN |
| AUVW | ABELP | AUVW | MANDT |
AUPO
Allocation Table Document Item
|
MANDT |
| AUVW | ABELP | AUVW | ABELN |
AUPO
Allocation Table Document Item
|
ABELN |
| AUVW | ABELP | AUVW | ABELP |
AUPO
Allocation Table Document Item
|
ABELP |
| AUVW | AUFME | AUVW | MANDT |
T006
Units of Measurement
|
MANDT |
| AUVW | AUFME | AUVW | AUFME |
T006
Units of Measurement
|
MSEHI |
| AUVW | BSTME | AUVW | BSTME |
T006
Units of Measurement
|
MSEHI |
| AUVW | BSTME | AUVW | MANDT |
T006
Units of Measurement
|
MANDT |
| AUVW | MANDT | AUVW | MANDT |
T000
Clients
|
MANDT |
| AUVW | UMLME | AUVW | MANDT |
T006
Units of Measurement
|
MANDT |
| AUVW | UMLME | AUVW | UMLME |
T006
Units of Measurement
|
MSEHI |
| AUVW | VRKME | AUVW | MANDT |
T006
Units of Measurement
|
MANDT |
| AUVW | VRKME | AUVW | VRKME |
T006
Units of Measurement
|
MSEHI |
| AUVW | VZWRK | AUVW | MANDT |
T001W
Plants/Branches
|
MANDT |
| AUVW | VZWRK | AUVW | VZWRK |
T001W
Plants/Branches
|
WERKS |