List of Important SAP SD Tables (Sales and Distribution)
List of Important SAP SD Tables (Sales and Distributio.
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.
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:
- Credit Limit for Customer in SAP SD
- SAP KNVV: Customer Master Sales Data
- The 3 ways to Mass Update Contacts of Customer in SAP
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:
| 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 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:
- The Main SAP Invoice Table for Accountiing Document and Material Document
- The full list of SAP Billing Document User Exit for transfer to accounting
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 :
| 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 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
Source: