Delivery Tables in SAP store all the data collected for Delivery and Shipping for SAP Materials and Services.
You will find following the list of the main SAP Delivery Tables for Sales Document in SAP SD.
The next part will deal with the most important Shipment Tables in SAP.
The last part will cover the relationship between Deliver and Shipment in SAP.
Important SAP Delivery Tables
SAP Delivery Tables in SD
In SAP SD, for SD (Sales and Distribution) Document, there are 2 main tables storing the Delivery Data of SD Document:
- LIKP – SD Document: delivery Header Data
- LIPS – SD document: delivery: Item data Logistics Execution – Shipping
Here the list of SAP Delivery Tables for Sales Document in SAP SD or SAP Tables having Delivery Information of SO:
| SAP TABLES | SAP Delivery Tables |
|---|---|
| LIKP | SD Document: Delivery Header Data |
| LIPS | SD document: Delivery: Item data |
| VBFA | Sales Document Flow |
| VFSI | Shipment Costs: Sub-item Data |
| VTFA | Shipment Document Flow |
| VTTK | Shipment Header |
| VTTP | Shipment Item |
SAP Delivery Status Tables and Fields
Table- VTDST Status of deliveries within transportation planning
Field- STATE Status of delivery in transportation planning
Table- VTDSTC Condition of Deliveries for Freight Planning by Fwdng Agent
Field- STATE Condition of Delivery in Freight Planning by Forwarding Agent
Table- VBUK Sales Document: Header Status and Administrative Data
Field- LFSTK Delivery status
Table- VBUP Sales Document: Item Status
Field- LFSTA Delivery status
Table- VSVBUK_CN Sales Document: Header Status and Administrative Data
Field- LFSTK Delivery status
Table- VSVBUP_CN Sales Document: Item Status
Field- LFSTA Delivery status
Table- ZFFXJV FX Difference Adjustment JV posting
Field- LFSTK Delivery status
Table- NMATO IS-H: Material requisition by nurse station
Field- LFSTA IS-H: Delivery Status of Material Requisition Item
Table- NMATP IS-H: Material planned for the case
Field- LFSTA IS-H: Delivery Status of Material Requisition Item
Table- S541 Backlog reports structure
Field- LFSTA Delivery status
Table- S542 Backlog Reports Structure
Field- LFSTA Delivery status
(source: table and field name for the delivery status – sales order)
Read more on Delivery Status for Sales Order SAP Order Delivery Status for Sales Documents
Main SAP Shipment Tables in SAP SD
On the other hand, the main shipment Tables in SAP Sales and Distribution are:
- VEKP Shipping Unit Item (Content)
- VEPO Shipping Unit Header
Here is a further list of Shipping Tables in SAP :
| SAP TABLES | SAP Shipment Tables |
|---|---|
| VTTK | shipment Header Logistics Execution |
| VTTP | shipment Item Logistics Execution |
| VFKP | shipment Costs: Item Data Logistics Execution |
| VTTS | Stage of shipment Logistics Execution |
| VFKK | shipment Costs: Header Data Logistics Execution |
| VTFA | shipment Document Flow Logistics Execution |
| TVTK | shipment Types Logistics Execution |
| VFSI | shipment Costs: Sub-item Data Logistics Execution |
| VFKN | Account Determination in shipment Costs Item Logistics Execution |
| VTRDI | shipment Planning Index Logistics Execution |
Shipment Cost tables in SAP
The Shipment Cost Tables in SAP in LE (Logistics Execution) are:
| TABLES | Shipment Cost tables in SAP |
|---|---|
| VFKP | shipment costs: Item Data |
| VFKK | shipment costs: Header Data |
| VFKN | Account Determination in shipment costs Item Logistics Execution |
| TVFT | shipment cost Item Categories Logistics Execution |
| TVFTK | Determination: shipment cost Item Categories Logistics Execution |
| VFSI | shipment costs: Sub-item Data Logistics Execution |
| VFPA | Partner for shipment costs |
| TVFAW | shipment cost Info Profile & Planning Profile Assig. (VT04) |
| TVFCD | Service Agent Procedure Group for shipment costs |
| TVFP | Assignment of Purchasing Data for shipment costs |
Link Between Shipping and Delivery in SAP
Delivery header data is in table LIKP.
Delivery item data is in table LIPS.
Shipment header data is in table VTTK.
The Shipment delivery data is in table VTTP.
Shipment stage data is in table VTTS.
The link from delivery to shipment is table VBFA with VBELV = the delivery number and VBTYP_N = 8.
The shipment number is in VBFA-VBELN.
The link from shipment to delivery is table VTTP with TKNUM = the shipment number. Delivery number(s) are in VTTP-VBELN.
Source: relation between delivery and shipping tables