List of Important SAP SD Tables (Sales and Distribution)

List of Important SAP SD Tables (Sales and Distribution) : list of the most used tables in SAP SD including Customer, Sales Documents, Delivery and Billing.

You may also check SAP SD Tcodes (Transaction Tcodes) in Sales and Distribution

SAP SD Tables

SAP SD Tables for Customer

Let’s start within the SAles and Distribution Tables with Customer Tables in SAP SD.
Note that the main tables for a customer in SAP SD is KNA1.
A Customer in SAP SD is identified by KUNNR.

Here the main Customer Tables in SAP SD:

Delivery Doc Tables Description
KNA1 Customer Master: General Data
KNB1 Customer Master: Company Code Data
KNB4 Customer Payment History
KNB5 Customer Master: Dunning data
KNBK Customer Master: Bank Details
KNBW Customer Master: Wwithholding tax types
KNKA Customer Master: Credit Mgmt.
KNKK Customer Master: Credit Control Area Data – credit limits
KNVA Customer Master: Loading/Unloading Points
KNVD Customer Master: Record sales request form/documents
KNVH Customer Hierarchies
KNVI Customer Master: Tax Indicator
KNVK Customer Master: Contact Partner
KNVL Customer Master: Licenses
KNVP Customer Master: Partner Functions
KNVS Customer Master: Shipping Data
KNVT Customer Master: Record Texts for Sales
KNVV Customer Master: Sales Data
KLPA Customer/Vendor Link
Check also   SAP MM03 Tcode - Display Material Master Data Overview

Check also for SAP SD Customer 

SAP Material Master Data Tables

You can find the whole list of SAP Material Tables in The Main Important SAP Material Master Tables ( Data & Customizing )

SAP SD Tables for Sales Documents

Once Customer is defined, let’s check the list of Sales Documents tables in SAP SD.
The SAP SD Table for Sales Document Header is VBAK. The items details are stored in VBAP.

Check the list of usefull related Tables to Sales Document in SAP SD:

You may also check

SAP SD Tables for Delivery Documents

After sending a sales document to customer comes the Delivery.
The main Tables for Delivery Documents in SAP Sales and Distribution are:

Delivery Tables in SAP SD Description
LIPS   Delivery Document item data includes referencing PO
LIKP   Delivery Document Header data

Check more about SAP Order Delivery Status for Sales Documents

SAP SD Tables for Billing Document

Once the delivery is done, a billing document is issued. Here the list of Billing Document Tables in SAP SD:

Billing Doc Tables Description
VBRK   Billing Document Header
VBRP   Billing Document Item

Check more about Billing Document in SAP SD: 

Shipping Tables in SAP SD

Find bellowing he list of Shipping Unit Tables in SAP SD

Shipping Tables in SAP SD Description
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit – Header Table
VEPO Packing: Handling Unit Item – Contents

SAP Pricing Tables

Here the list of the most important tables for Pricing in SAP :

Others usefull tables for SAP SD

Here I regrouped some usefull when dealing with SAP SD ( Sales and Distribution):

  • NAST : Document Output- Message Status
  • STXH : Document Texts Table Header
  • STXL : Document Texts Table Line
  • JSTO : PP status
  • JEST : Status Table
  • SADR : Address Table



Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ... Sab

Leave a Reply

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