SAP AUVZ Distribution Center Table
Overview
AUVZ is a standard SAP S/4HANA table that stores Distribution Center data. There are total 42 fields in the AUVZ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUVZ 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 AUVZ to other SAP tables and standard CDS views available based on AUVZ table in S/4HANA 2020.
Techincal Settings of AUVZ
Below are technical details of the table AUVZ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUVZ Fields
The following table gives you an overview of the fields available in AUVZ
| 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 |
| VZENT | Distribution center (as customer) | VZENT | KNA1 | CHAR | 10 |
| VZLFR | Supplier Number of Plant | LIFNR_WK | LFA1 | CHAR | 10 |
| PMNGV | Planned GR Quantity Distribution Center | PMNGV | QUAN | 13 | |
| IMNGV | Confirmed Quantity, Distribution Center | IMNGV | QUAN | 13 | |
| MENGE_OPT | Optimized quantity | MENGE_OPT | QUAN | 13 | |
| AUFME | Allocation Unit | AUFME | T006 | UNIT | 3 |
| LIFNR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | |
| WEBAZ | Goods receipt processing time in days | WEBAZ | DEC | 3 | |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| BSTME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| UMLMG | Reduced DC order quantity (in allocation table) | BSTMG_RED | QUAN | 13 | |
| UMLME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| LFMNG | GR qty assigned after alloc tbl adjustment made | EFMNG | QUAN | 13 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| EBLNU | Purchase Order Generated for Supplier | EBLNU | * | CHAR | 10 |
| EBLPU | Generated purchase order item | EBLPU | * | NUMC | 5 |
| ABFST | Status plant notification | ABFST | CHAR | 1 | |
| ABAST | Details status, plant notification | ABAST | CHAR | 1 | |
| BSTST | Supplier Purchase Order Generation | BSTST | CHAR | 1 | |
| UMLST | Status: warehouse order generation | UMLST | CHAR | 1 | |
| LIEST | Status: generate deliveries | LIEST | CHAR | 1 | |
| ABVST | Notification status (DC) | ABVST | CHAR | 1 | |
| WEEST | Entry status of GR in DC | WEEST | CHAR | 1 | |
| KAGST | Status of sales order generation | KAGST | CHAR | 1 | |
| SPERR | Blocking flag, plant | SPBTR | T629 | CHAR | 1 |
| BMERF | Single-Character Flag | CHAR1 | CHAR | 1 | |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| LAND1 | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| WAFLU_VZ | Processing Method / Goods Movement in Distribution Center | WAFLU_VZ | CHAR | 1 | |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| SLS_REL | Single-Recipient Supplier Orders from Allocation Table | SLS_REL | CHAR | 1 |
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 AUVZ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUVZ | ABELN | 1: CN | AUKO |
| AUVZ | ABELP | 1: CN | AUPO |
| AUVZ | AUFME | : | T006 |
| AUVZ | BSTME | 1: CN | T006 |
| AUVZ | BUKRS | : | T001 |
| AUVZ | EKGRP | 1: CN | T024 |
| AUVZ | EKORG | 1: CN | T024E |
| AUVZ | LAND1 | : | T005 |
| AUVZ | LGORT | : | T001L |
| AUVZ | LIFNR | 1: CN | LFA1 |
| AUVZ | MANDT | 1: N | T000 |
| AUVZ | SPART | 1: CN | TSPA |
| AUVZ | SPERR | 1: CN | T629 |
| AUVZ | UMLME | 1: CN | T006 |
| AUVZ | VKORG | 1: CN | TVKO |
| AUVZ | VRKME | 1: CN | T006 |
| AUVZ | VTWEG | 1: CN | TVTW |
| AUVZ | VZENT | 1: CN | KNA1 |
| AUVZ | VZLFR | 1: CN | LFA1 |
| AUVZ | VZWRK | 1: CN | T001W |