SAP Delivery Tables & SAP Shipment Tables In SAP SD

Delivery Tables in SAP store all the data collected for Delivery and Shippinh 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.

Table of Contents

Important SAP Delivery Tables

In SAP SD, for SD (Sales and Distribution) Document, there are 2 main tables storing the Delivery Data of SD Document:

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

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

In the other hand, the main shipment Tables in SAP Sales and Distribution are:

Here a further list for Shippinh 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

The Shipment Cost Tables in SAP in LE (Logistics Execution) are:

SAP 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

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 numer. Delivery number(s) are in VTTP-VBELN.