SAP SD Tables; SAP SD; document flow sap sd; SAP EDI transactions; Edi Code; Order Delivery Status; EDI 846; SAP Add a custom field to Sales Order, Explicit PO Number; files on application server, SAP CRM Document flow, SAP SRM Confirmation; SAP SD Tcodes, doc. flow sap sd, Add custom field to Sales Order

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   Step by Step Guide How to Add custom field to Sales Order in SAP

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

SAP Pricing Tables

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

PricingTables in SAP SD 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

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:

Leave a Reply

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