AUVDI SAP (Worklist for Deliveries (Follow-on Doc. Generation)) Table details
Dictionary Type: Table
Description: Worklist for Deliveries (Follow-on Doc. Generation)
Description: Worklist for Deliveries (Follow-on Doc. Generation)
Table field list including key, data, relationships and ABAP select examples
AUVDI is a standard SAP Table which is used to store Worklist for Deliveries (Follow-on Doc. Generation) data and is available within R/3 SAP systems depending on the version and release level.
The AUVDI table consists of various fields, each holding specific information or linking keys about Worklist for Deliveries (Follow-on Doc. Generation) data available in SAP. These include VSTEL (Shipping Point/Receiving Point), LEDAT (Delivery Creation Date), LPRIO (Delivery Priority), ROUTE (Route).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AUVDI table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | TVST | VSTEL | VST | ||
| LEDAT | Delivery Creation Date | LEDAT | DATS | 8 | DATUM | ||||
| LPRIO | Delivery Priority | LPRIO | NUMC | 2 | TPRIO | LPRIO | |||
| ROUTE | Route | ROUTE | CHAR | 6 | TVRO | ROUTE | |||
| SPDNR | Forwarding agent | SPDNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
| WADAT | Goods Issue Date | WADAT | DATS | 8 | DATUM | ||||
| FILNR | Customer no. of plant | FILNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
| ABELP | Item number of allocation table | ABELP | NUMC | 5 | AUPO | ABELP | |||
| ABELG | Sub-item no. of plant group (alloc tbl) | ABELG | NUMC | 5 | AUFG | ABELG | |||
| ABELF | Sub.item no. of plant (alloc. tbl) | ABELF | NUMC | 5 | AUFI | ABELF | |||
| LFNUM | Consecutive Number | LFNUM | CHAR | 5 | CHAR5 | ||||
| KUNAG | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
| VZENT | Distribution center (as customer) | VZENT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| VZWRK | Distribution center as plant | VZWRK | CHAR | 4 | T001W | WERKS | VZW | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
| SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
| VKBUR | Sales Office | VKBUR | CHAR | 4 | TVBUR | VKBUR | VKB | ||
| VKGRP | Sales Group | VKGRP | CHAR | 3 | TVKGR | VKGRP | VKG | ||
| AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
| AUFME | Allocation Unit | AUFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| LFDAT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
| BRGEW | Open gross weight of all schedule lines for this key | BRGEW_VG | QUAN | 15(3) | MENG15 | ||||
| GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
| VOLUM | Open volume of all schedule lines for this key | VOLUM_VG | QUAN | 15(3) | MENG15 | ||||
| VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| BEARZ | Processing time in days | BEARZ_VG | DEC | 5(2) | DEC3_2 | ||||
| ADRNR_AG | Address number of the sold-to party | ADRNR_AG | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
| ADRNR_WE | Address number of the ship-to party | ADRNR_WE | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
| LFART | Delivery type of allocation table | LFART_AUFT | CHAR | 4 | TVLK | LFART | ALT | LFART_FOR_ALLOCATION | |
| VBLNU | Generated delivery number | VBLNU | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
| VBLPU | Generated delivery note item | VBLPU | NUMC | 6 | VBUP | POSNR | |||
| SPERR | Blocking flag, plant | SPBTR | CHAR | 1 | T629 | SPERR_A | |||
| APSTP | Item category of allocation table | APSTP | CHAR | 4 | T621 | APSTP | |||
| ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
| LIFMG | Delivery qty | LIFMG | QUAN | 13(3) | MENG13 | ||||
| VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| WEDAT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
| WETYP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | PRGRS | ||||
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
| AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
| LFUHR | Time of delivery | LFUHR | TIMS | 6 | LFUHR | ||||
| RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
| SAPOS | Number of alloc tbl item of material on higher level | POSNR_SA | NUMC | 5 | Assigned to domain | ABELP | |||
| AUREL | Relevant to Allocation Table | AUREL | CHAR | 1 | AUREL | ||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 |
| Key field | Non-key field |
How do I retrieve data from SAP table AUVDI using ABAP code
The following ABAP code Example will allow you to do a basic selection on AUVDI to SELECT all data from the tableDATA: WA_AUVDI TYPE AUVDI.
SELECT SINGLE *
FROM AUVDI
INTO CORRESPONDING FIELDS OF WA_AUVDI
WHERE...
How to access SAP table AUVDI
Within an ECC or HANA version of SAP you can also view further information about AUVDI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects