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 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.

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
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

I find the part very interesting ( source: table and field name for the delivery status – sales order )

  • 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

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 Shippinh Tables in SAP :

SAP Tables Description
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:

SAP Tables Description
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 ProfilePlanning Profile Assig. (VT04)
TVFCDService Agent Procedure Group for shipment costs
TVFPAssignment of Purchasing Data for shipment costs

[amazon_link asins=’1592299040′ template=’ProductAd’ store=’sap4tech-20′ marketplace=’US’ link_id=’9a6f6460-12ed-11e7-9515-1d9b2cc9546d’]

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.
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.

Source: relation beteween delivery and shipping tables

Sab

Hi, I am a father and a sap developer.

Leave a Reply

Your email address will not be published. Required fields are marked *