SAP SD Tables (Sales And Distribution)

List of Important SAP SD Tables (Sales and Distribution).

In the beginning, you will find the main SAP SD Tables for Customer and Material Master Data.

The next part covers the Sales and Distribution Tables for Sales Document, Delivery, Billing, Shipping and Pricing Tables related to SAP SD Module.

The last part will list some useful Tables for SAP SD.

Table of Contents

SAP SD Tables

SAP SD Tables for Customer

Let’s start within the Sales and Distribution Tables with Customer Tables in SAP SD.

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

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 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 useful related Tables to Sales Document in SAP SD:

SD Sales Tables	DESCRIPTION
VBUK	Header Status and Administrative Data
VBAK	Sales Document : Header Data
VBKD	Sales Document : Business Data
VBUP	Item Status
VBAP	Sales Document : Item Data
VBPA	Partners
VBFA	Document Flow
VBEP	Sales Document Schedule Line
VBBE	Sales Requirements: Individual Records

You may also check

SAP SD Tables for Delivery Documents

After sending a sales document to the 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 the 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 :

SAP Pricing	DESCRIPTION
KOMK	Pricing Communications: Header (Structure)
KOMP	Pricing Communication: Item (Structure)
KONV	Conditions: Transaction Data
KONP	Conditions: Item
KONH	Conditions: Header
KOND	SAP Contracts Table in SAP SD
VEDA	Contract Data

For more Pricing information, read SAP Pricing Condition Tables & Pricing Condition Tcodes in SAP

Others useful tables for SAP SD

Here I regrouped some useful 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

Source: