Sunday, May 19, 2024

SAP Table AUVDI – Worklist for Deliveries (Follow-on Doc. Generation)

AUVDI is a standard SAP table in SAP ERP (or) S/4HANA which stores Worklist for Deliveries (Follow-on Doc. Generation) data. There are total 51 fields in AUVDI table.This blog post provides key technical details of SAP table AUVDI, including its availability across SAP S/4HANA versions and the list of CDS views for AUVDI 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 AUVDI Table Fields

The following is the list of fields that are available in SAP AUVDI 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)
VSTEL Shipping Point / Receiving Point VSTEL VSTEL TVST CHAR (4)
LEDAT Delivery Creation Date LEDAT DATUM DATS (8)
LPRIO Delivery Priority LPRIO LPRIO TPRIO NUMC (2)
ROUTE Route ROUTE ROUTE TVRO CHAR (6)
SPDNR Forwarding Agent SPDNR LIFNR LFA1 CHAR (10)
WADAT Goods Issue Date WADAT DATUM DATS (8)
FILNR Customer no. of plant FILNR KUNNR KNA1 CHAR (10)
ABELN Allocation Table ABELN ABELN AUKO CHAR (10)
ABELP Allocation Table Item ABELP ABELP AUPO NUMC (5)
ABELG Store Group of an Allocation Table ABELG ABELG AUFG NUMC (5)
ABELF Identifier of a Recipient of an Item of an Allocation Table ABELF ABELF AUFI NUMC (5)
LFNUM Consecutive Number LFNUM CHAR5 CHAR (5)
KUNAG Sold-To Party KUNAG KUNNR KNA1 CHAR (10)
VZENT Distribution center (as customer) VZENT KUNNR KNA1 CHAR (10)
VZWRK Distribution Center VZWRK WERKS T001W CHAR (4)
VKORG Sales Organization VKORG VKORG TVKO CHAR (4)
VTWEG Distribution Channel VTWEG VTWEG TVTW CHAR (2)
SPART Division SPART SPART TSPA CHAR (2)
VKBUR Sales office VKBUR VKBUR TVBUR CHAR (4)
VKGRP Sales group VKGRP VKGRP TVKGR CHAR (3)
AUTLF Complete Delivery Defined for Each Sales Order? AUTLF XFELD CHAR (1)
MATNR Material Number MATNR MATNR MARA CHAR (40)
MENGE Quantity MENGE_D MENG13 QUAN (13)
AUFME Allocation Unit AUFME MEINS T006 UNIT (3)
LFDAT Delivery date LFDAT DATUM DATS (8)
BRGEW Open gross weight of all schedule lines for this key BRGEW_VG MENG15 QUAN (15)
GEWEI Weight Unit GEWEI MEINS T006 UNIT (3)
VOLUM Open volume of all schedule lines for this key VOLUM_VG MENG15 QUAN (15)
VOLEH Volume unit VOLEH MEINS T006 UNIT (3)
BEARZ Processing time in days BEARZ_VG DEC3_2 DEC (5)
ADRNR_AG Address number of the sold-to party ADRNR_AG ADRNR * CHAR (10)
ADRNR_WE Address number of the ship-to party ADRNR_WE ADRNR * CHAR (10)
LFART Delivery type of allocation table LFART_AUFT LFART TVLK CHAR (4)
VBLNU Generated delivery number VBLNU VBELN * CHAR (10)
VBLPU Generated delivery note item VBLPU POSNR * NUMC (6)
SPERR Blocking flag, plant SPBTR SPERR_A T629 CHAR (1)
APSTP Item category of allocation table APSTP APSTP T621 CHAR (4)
ELIKZ Delivery Completed Indicator ELIKZ XFELD CHAR (1)
LIFMG Delivery qty LIFMG MENG13 QUAN (13)
VRKME Sales unit VRKME MEINS T006 UNIT (3)
WEDAT Delivery date LFDAT DATUM DATS (8)
WETYP Date type (day, week, month, interval) PRGRS PRGRS CHAR (1)
WERKS Plant WERKS_D WERKS T001W CHAR (4)
LGORT Storage location LGORT_D LGORT T001L CHAR (4)
AKTNR Promotion WAKTION WAKTION WAKH CHAR (10)
LFUHR Time of delivery LFUHR LFUHR TIMS (6)
RETPO Returns Item RETPO XFELD CHAR (1)
SAPOS Allocation table item of material on higher level POSNR_SA ABELP * NUMC (5)
AUREL Relevant to Allocation Table AUREL AUREL CHAR (1)
ABLAD Unloading Point ABLAD TEXT25 CHAR (25)

Availability

The SAP table AUVDI 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 AUVDI table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.