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
KNA1Customer Master: General Data
KNB1Customer Master: Company Code Data
KNB4Customer Payment History
KNB5Customer Master: Dunning data
KNBKCustomer Master: Bank Details
KNBWCustomer Master: Wwithholding tax types
KNKACustomer Master: Credit Mgmt.
KNKKCustomer Master: Credit Control Area Data – credit limits
KNVACustomer Master: Loading/Unloading Points
KNVDCustomer Master: Record sales request form/documents
KNVHCustomer Hierarchies
KNVICustomer Master: Tax Indicator
KNVKCustomer Master: Contact Partner
KNVLCustomer Master: Licenses
KNVPCustomer Master: Partner Functions
KNVSCustomer Master: Shipping Data
KNVTCustomer Master: Record Texts for Sales
KNVVCustomer Master: Sales Data
KLPACustomer/Vendor Link
Check also   MVKE Table in SAP MM (Material Sales Data Table)

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:

SD Sales Doc 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

Check also   Trigger MATMAS IDoc using BTE event

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
VTTKShipment header
VTTPShipment item
VTTSStage in transport
VTSPStage in transport per shipment item
VTPAShipment partners
VEKPHandling Unit – Header Table
VEPOPacking: 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

Source:

Sab125

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 *