1. Home
  2. Resources
  3. SAP Tables
  4. LEDLV_DELNOTE - Delivery Note Data: Transfer-Structure for Smartform

SAP Table LEDLV_DELNOTE

Delivery Note Data: Transfer-Structure for Smartform

LEDLV_DELNOTE (Delivery Note Data: Transfer-Structure for Smartform) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LEDLV_DELNOTE to other SAP tables.

LEDLV_DELNOTE table fields

Field Data element Checktable Datatype Length Decimals
HD_GEN LEDLV_HD_GEN STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
SOLD_TO_PARTY Sold-to party KUNAG CHAR 10 0
SHIP_TO_PARTY Ship-to party KUNWE CHAR 10 0
FWDAGENT Forwarding agent SPDNR CHAR 10 0
INCOTERMS1 Incoterms (Part 1) INCO1 CHAR 3 0
INCOTERMS2 Incoterms (Part 2) INCO2 CHAR 28 0
ROUTE Route ROUTE CHAR 6 0
SHIP_COND Shipping Conditions VSBED CHAR 2 0
CREA_DATE Date on Which Record Was Created ERDAT DATS 8 0
CHG_DATE Changed On AEDAT DATS 8 0
DLV_DATE Delivery date LFDAT DATS 8 0
TOT_WEIGHT Total Weight GSGEW QUAN 15 3
BRT_WEIGHT Gross weight BRGEW_15 QUAN 15 3
NET_WEIGHT Net weight NTGEW_15 QUAN 15 3
UNIT_OF_WEIGHT Weight Unit GEWEI UNIT 3 0
TOT_VOLUME Volume VOLUM_15 QUAN 15 3
VOLUME Volume VOLUM_15 QUAN 15 3
VOLUMEUNIT Volume unit VOLEH UNIT 3 0
NOSHPUNITS Total number of packages in delivery ANZPK NUMC 5 0
EXTDELV_NO External Identification of Delivery Note LIFEX CHAR 35 0
DLV_PRIO Delivery Priority LPRIO NUMC 2 0
PICK_LOC Picked items location BEROT CHAR 20 0
SHIPPING_TYPE Shipping type VERSART CHAR 2 0
GI_DATE Goods Issue Date WADAT DATS 8 0
HD_ADR LE_T_DLV_HD_ADR TTYP 0 0
HD_GEN_DESCRIPT LEDLV_HD_GEN_DESCRIPT STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
NAME_ROUTE Route description ROUTE_BEZ CHAR 40 0
NAME_SHIP_COND Description of the shipping conditions VSBED_BEZ CHAR 20 0
NAME_INCOTERMS1 Incoterm description INCO1_BEZ CHAR 30 0
NAME_SHP_MAT_TYPE Description of shipping material type TRATY_BEZ CHAR 20 0
NAME_DELIV_TYPE Delivery type description LFART_BEZ CHAR 20 0
NAME_DELIV_PRIO Description of delivery priorities LPRIO_BEZ CHAR 20 0
NAME_SALES_DISTR Name of the district BZTXT CHAR 20 0
NAME_DELIV_BLOCK Description of reason for delivery block LIFSK_BEZ CHAR 20 0
NAME_CUST_GROUP Description of customer group KDGRP_BEZ CHAR 20 0
NAME_TRANSP_GROUP Description of transportation group TRAGR_BEZ CHAR 20 0
NAME_TRANSP_BLOCK Description of reason for shipment block TRSPG_BEZ CHAR 20 0
NAME_ROUTE_SCHED Description of route schedule AULWE_BEZ CHAR 40 0
NAME_SHIPPING_TYPE Description of the Shipping Type VERSARTBEZ CHAR 20 0
HD_ORG LEDLV_HD_ORG STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
SHIP_POINT Shipping Point/Receiving Point VSTEL CHAR 4 0
SHIP_POINT_ADR Address ADRNR CHAR 10 0
SALESORG Sales Organization VKORG CHAR 4 0
SALESORG_ADR Address ADRNR CHAR 10 0
LOADING_PT Loading Point LSTEL CHAR 2 0
SALES_OFF Sales Office VKBUR CHAR 4 0
SALES_OFF_ADR Address ADRNR CHAR 10 0
WHSE_NO Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
SALES_DIST Sales district BZIRK CHAR 6 0
WHSE_DOOR Door for Warehouse Number LGTOR CHAR 3 0
UNLOAD_PT Unloading Point ABLAD CHAR 25 0
HD_ORG_DESCRIPT LEDLV_HD_ORG_DESCRIPT STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
SALES_ORG_DESCR Description of sales organization VKORG_BEZ CHAR 20 0
LOADING_PT_DESCR Loading point description LSTEL_BEZ CHAR 20 0
SALES_OFFICE_DESCR Description of sales office VKBUR_BEZ CHAR 20 0
SHIPPING_PT_DESCR Description of shipping point VSTEL_BEZ CHAR 30 0
WHS_NUMB_DESCR Warehouse number description LVS_LNUMT CHAR 25 0
HD_PART_ADD LE_T_DLV_HD_PART_ADD TTYP 0 0
HD_FIN LE_T_DLV_HD_FIN TTYP 0 0
HD_FT LEDLV_HD_FT STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
DEST_CNTRY Country of Destination LLAND CHAR 3 0
DEPCOUNTRY Departure country (country from which the goods are sent) ALAND CHAR 3 0
TRNSP_MODE Mode of Transport for Foreign Trade EXPVZ CHAR 1 0
CUSTOMS Customs Office: Office of Exit/Entry for Foreign Trade DZOLLS CHAR 6 0
OFFICE_OF_DEST Customs office: Office of destination for foreign trade DZOLLB CHAR 6 0
CUSTOMS_OFFICE1 Customs office: Customs office 1 for foreign trade DZOLL1 CHAR 6 0
CUSTOMS_OFFICE2 Customs office: Customs office 2 for foreign trade DZOLL2 CHAR 6 0
CUSTOMS_OFFICE3 Customs office: Customs office 3 for foreign trade DZOLL3 CHAR 6 0
CUSTOMS_OFFICE4 Customs office: Customs office 4 for foreign trade DZOLL4 CHAR 6 0
CUSTOMS_OFFICE5 Customs office: Customs office 5 for foreign trade DZOLL5 CHAR 6 0
CUSTOMS_OFFICE6 Customs office: Customs office 6 for foreign trade DZOLL6 CHAR 6 0
QUAL_MEANS_TR Indicator for means of transport crossing the border KZGBE CHAR 30 0
QUAL_MEANS_TR_OUT Indicator for the means of transport at departure KZABE CHAR 30 0
NAT_MEANS_TR Origin of Means of Transport when Crossing the Border STGBE CHAR 3 0
NAT_MENAS_TR_OUT Country of Origin of the Means of Transport at Departure STABE CHAR 3 0
CURRENCY_BORDER Currency of statistical values for foreign trade GRWCU CUKY 5 0
HD_FT_DESCRIPT LEDLV_HD_FT_DESCRIPT STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
MODETRANSPDESC Description of mode of transport EXPVZ_BEZ CHAR 20 0
CUSTOFFDESC Customs office description CUSTA_BEZ CHAR 30 0
CUSTOFFDESTDESC Description of office of destination CUSTB_BEZ CHAR 30 0
CUSTOFF1DESC Customs office 1 description CUST1_BEZ CHAR 30 0
CUSTOFF2DESC Customs office 2 description CUST2_BEZ CHAR 30 0
CUSTOFF3DESC Customs office 3 description CUST3_BEZ CHAR 30 0
CUSTOFF4DESC Customs office 4 description CUST4_BEZ CHAR 30 0
CUSTOFF5DESC Customs office 5 description CUST5_BEZ CHAR 30 0
CUSTOFF6DESC Customs office 6 description CUST6_BEZ CHAR 30 0
INLMODETRANSDSCR Description of inland mode of transport IEVER_BEZ CHAR 20 0
CNTRYMNSTRNSP Description of country of affiliation of means of transport STGBE_BEZ CHAR 15 0
CNTRYMNSTRNSDEP Cntry of affil. of means of transport at departure of goods STABE_BEZ CHAR 15 0
HD_REF LEDLV_HD_REF STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
PURCH_NO Customer purchase order number BSTNK CHAR 20 0
PURCH_DATE Customer purchase order date BSTDK DATS 8 0
PO_SUPPLEM Purchase order number supplement BSTZD CHAR 4 0
CUST_REFERENCE Your Reference IHREZ CHAR 12 0
REF_DOC Document number of the reference document VGBEL CHAR 10 0
REF_DOC_TYPE SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
PURCH_NO_C Customer purchase order number BSTKD CHAR 35 0
PO_METHOD Customer purchase order type BSARK CHAR 4 0
PURCH_NO_S Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
PO_DAT_S Ship-to party's PO date BSTDK_E DATS 8 0
PO_METH_S Ship-to party purchase order type BSARK_E CHAR 4 0
REF_1_S Ship-to party character IHREZ_E CHAR 12 0
ORDER_NUMB Order VBELN_VAUF CHAR 10 0
ORDER_DATE Sales order date AUDAT_VAUF DATS 8 0
HD_SCHED LE_T_DLV_HD_SCHED TTYP 0 0
HD_TECH LE_T_DLV_HD_TECH TTYP 0 0
IT_GEN LE_T_DLV_IT_GEN TTYP 0 0
IT_GEN_DESCRIPT LE_T_DLV_IT_GEN_DESCRIPT TTYP 0 0
IT_ORG LE_T_DLV_IT_ORG TTYP 0 0
IT_ORG_DESCRIPT LE_T_DLV_IT_ORG_DESCRIPT TTYP 0 0
IT_REF LE_T_DLV_IT_REF TTYP 0 0
IT_REFORD LE_T_DLV_IT_REFORD TTYP 0 0
IT_REFPURORD LE_T_DLV_IT_REFPURORD TTYP 0 0
IT_TECH LE_T_DLV_IT_TECH TTYP 0 0
IT_FT LE_T_DLV_IT_FT TTYP 0 0
IT_FT_DESCRIPT LE_T_DLV_IT_FT_DESCRIPT TTYP 0 0
IT_SCHED LE_T_DLV_IT_SCHED TTYP 0 0
IT_FIN LE_T_DLV_IT_FIN TTYP 0 0
IT_SERNR LE_T_DLV_IT_SERNR TTYP 0 0
IT_CONFITM LE_T_DLV_IT_CONFITM TTYP 0 0
IT_CONFBATCH LE_T_DLV_IT_CONFBATCH TTYP 0 0
IT_QM LE_T_DLV_IT_QM TTYP 0 0
MSR_HD MSR_S_LEDLV_HD STRU 0 0
DELIV_NUMB Delivery VBELN_VL CHAR 10 0
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
MSR_IT MSR_T_LE_DLV_IT TTYP 0 0