AUVW is a standard SAP table in SAP ERP (or) S/4HANA which stores Delivery Phase for Distribution Center data. There are total 27 fields in AUVW table.This blog post provides key technical details of SAP table AUVW, including its availability across SAP S/4HANA versions and the list of CDS views for AUVW table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Application development R/3 Purchasing, Allocation table (WAUF) |
| Technical Component | Allocation (LO-RFM-PUR-AL) |
SAP AUVW Table Fields
The following is the list of fields that are available in SAP AUVW table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| ABELN | Allocation Table | ABELN | ABELN | AUKO | CHAR (10) |
| ABELP | Allocation Table Item | ABELP | ABELP | AUPO | NUMC (5) |
| VZWRK | Distribution Center | VZWRK | WERKS | T001W | CHAR (4) |
| LFNUM | Serial number | LFNR3 | LFNR3 | NUMC (3) | |
| WEVDT | Delivery date | LFDAT | DATUM | DATS (8) | |
| WEVTP | Date type (day, week, month, interval) | PRGRS | PRGRS | CHAR (1) | |
| WEUZT | Delivery Date Time-Spot | LZEIT | UZEIT | TIMS (6) | |
| WEPRZ | Delivery phase in percent of total qty | LWPRZ | PROZENT100 | NUMC (3) | |
| MENGE | Quantity | MENGE_D | MENG13 | QUAN (13) | |
| AUFME | Allocation Unit | AUFME | MEINS | T006 | UNIT (3) |
| WEMNG | Quantity of goods received | WEEMG | MENG13 | QUAN (13) | |
| MBLNR | Number of Material Document | MBLNR | BELNR | CHAR (10) | |
| MBLPO | Item in Material Document | MBLPO | MBLPO | NUMC (4) | |
| LFMNG | GR qty assigned after alloc tbl adjustment made | EFMNG | MENG13 | QUAN (13) | |
| VRKME | Sales unit | VRKME | MEINS | T006 | UNIT (3) |
| BEDAT | Order date/ latest date for generating follow-on documents | SPBEDAT | DATUM | DATS (8) | |
| BSTMG | Purchase Order Quantity | BSTMG | MENG13 | QUAN (13) | |
| BSTME | Purchase Order Unit of Measure | BSTME | MEINS | T006 | UNIT (3) |
| EBLNU | Purchase Order Generated for Supplier | EBLNU | EBELN | * | CHAR (10) |
| EBLPU | Generated purchase order item | EBLPU | EBELP | * | NUMC (5) |
| UMLMG | Reduced DC order quantity (in allocation table) | BSTMG_RED | MENG13 | QUAN (13) | |
| UMLME | Purchase Order Unit of Measure | BSTME | MEINS | T006 | UNIT (3) |
| ELIKZ | Delivery Completed Indicator | ELIKZ | XFELD | CHAR (1) | |
| IMNGL | Confirmed quantity in delivery phase | IMNGL | MENG13 | QUAN (13) | |
| WRF_AT_DL_ID | Dateline ID (GUID) | WRF_AT_DL_ID | SYSUUID_22 | CHAR (22) | |
| SUBMI | Collective Number | SUBMI | CHAR10 | CHAR (10) |
Availability
The SAP table AUVW is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AUVW table
The following is the list of AUVW CDS views, which can also be used instead of AUVW table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_ALLOCTABLEDISTRCTRDELIVPHASE | BASIC | Allocation Table Distr. Ctr. Delivery Phase |
| I_ALLOCTABLESUBSQNTPURORD | COMPOSITE | Allocation Table Subsequent Purchase Orders |
| C_ALLOCTBLOBJPGSUBSQNTPURORD | CONSUMPTION | Allocation Table Object Page – Subsequent Purchase Orders |
