SAP AUVW Delivery Phase for Distribution Center Table
Overview
AUVW is a standard SAP S/4HANA table that stores Delivery Phase for Distribution Center data. There are total 27 fields in the AUVW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUVW belongs to Allocation (LO-RFM-PUR-AL) module and is located in the package Application development R/3 Purchasing, Allocation table (WAUF).
In addition, following links provide an overview of foreign key relationships, if any, that link AUVW to other SAP tables and standard CDS views available based on AUVW table in S/4HANA 2020.
Techincal Settings of AUVW
Below are technical details of the table AUVW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUVW Fields
The following table gives you an overview of the fields available in AUVW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ABELN | Allocation Table | ABELN | AUKO | CHAR | 10 |
| ABELP | Allocation Table Item | ABELP | AUPO | NUMC | 5 |
| VZWRK | Distribution Center | VZWRK | T001W | CHAR | 4 |
| LFNUM | Serial number | LFNR3 | NUMC | 3 | |
| WEVDT | Delivery date | LFDAT | DATS | 8 | |
| WEVTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| WEUZT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | |
| WEPRZ | Delivery phase in percent of total qty | LWPRZ | NUMC | 3 | |
| MENGE | Quantity | MENGE_D | QUAN | 13 | |
| AUFME | Allocation Unit | AUFME | T006 | UNIT | 3 |
| WEMNG | Quantity of goods received | WEEMG | QUAN | 13 | |
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | |
| MBLPO | Item in Material Document | MBLPO | NUMC | 4 | |
| LFMNG | GR qty assigned after alloc tbl adjustment made | EFMNG | QUAN | 13 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| BEDAT | Order date/ latest date for generating follow-on documents | SPBEDAT | DATS | 8 | |
| BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| BSTME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| EBLNU | Purchase Order Generated for Supplier | EBLNU | * | CHAR | 10 |
| EBLPU | Generated purchase order item | EBLPU | * | NUMC | 5 |
| UMLMG | Reduced DC order quantity (in allocation table) | BSTMG_RED | QUAN | 13 | |
| UMLME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| IMNGL | Confirmed quantity in delivery phase | IMNGL | QUAN | 13 | |
| WRF_AT_DL_ID | Dateline ID (GUID) | WRF_AT_DL_ID | CHAR | 22 | |
| SUBMI | Collective Number | SUBMI | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AUVW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUVW | ABELN | 1: CN | AUKO |
| AUVW | ABELP | 1: CN | AUPO |
| AUVW | AUFME | : | T006 |
| AUVW | BSTME | 1: CN | T006 |
| AUVW | MANDT | 1: N | T000 |
| AUVW | UMLME | 1: CN | T006 |
| AUVW | VRKME | 1: CN | T006 |
| AUVW | VZWRK | : | T001W |