List of the main Delivery Tables & Shipment Tables in SAP SD (Sales & Distribution)
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 | DESCRIPTION |
|---|---|
| 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
I find this part very interesting
- Table- VTDST Status of deliveries within transportation planning
- Field- STATE Status of a 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 Agnt
- 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 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
In the other hand, the main shipment Tables in SAP Sales and Distribution are:
- VEKP Shipping Unit Item (Content)
- VEPO Shipping Unit Header
Here a further list for Shipping Tables in SAP :
| SAP TABLES | DESCRIPTION |
|---|---|
| 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 | DESCRIPTION |
|---|---|
| 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. 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
