List of Important SAP Delivery Tables & Shipment Tables in SAP SD

Delivery Tables in SAP 2

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 TABLESSAP Delivery Tables
LIKPSD Document: Delivery Header Data
LIPSSD document: Delivery: Item data
VBFASales Document Flow
VFSIShipment Costs: Sub-item Data
VTFAShipment Document Flow
VTTKShipment Header
VTTPShipment 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
VTTKshipment Header Logistics Execution
VTTPshipment Item Logistics Execution
VFKPshipment Costs: Item Data Logistics Execution
VTTSStage of shipment Logistics Execution
VFKKshipment Costs: Header Data Logistics Execution
VTFAshipment Document Flow Logistics Execution
TVTKshipment Types Logistics Execution
VFSIshipment Costs: Sub-item Data Logistics Execution
VFKNAccount Determination in shipment Costs Item Logistics Execution
VTRDIshipment 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
VFKPshipment costs: Item Data
VFKKshipment costs: Header Data
VFKNAccount Determination in shipment costs Item Logistics Execution
TVFTshipment cost Item Categories Logistics Execution
TVFTKDetermination: shipment cost Item Categories Logistics Execution
VFSIshipment costs: Sub-item Data Logistics Execution
VFPAPartner for shipment costs
TVFAWshipment cost Info Profile & Planning Profile Assig. (VT04)
TVFCDService Agent Procedure Group for shipment costs
TVFPAssignment 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