SAP4TECH

SAP and ABAP Free Tutorials
Menu
  • SAP Technical
    • ABAP Code Snippets
    • ABAP WebDynPro
    • SAP GW
    • SAP IDOC (ALE)
    • SAP PI (XI)
    • SAP Screen Personas
    • SAP Workflow
  • SAP Functional
    • SAP FI
    • SAP FSCM
    • SAP HR
    • SAP SD & SAP MM
    • SAP PM
    • SAP PP
    • SAP PS
    • SAP QM
    • SAP VIM
    • SAP WM
  • SAP Fiori
  • SAP HANA
  • SAP BW
  • SAP CRM
  • SAP SRM
  • SAP4TECH
    • About Us
    • Contact Us
    • Terms & Conditions
    • Privacy and Cookie Policy

SAP4TECH » List of Important SAP SD Tables (Sales and Distribution)

SAP SD & SAP MM

List of Important SAP SD Tables (Sales and Distribution)

November 11, 2016 John

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
    • SAP Material Master Data Tables
    • SAP SD Tables for Sales Documents
    • SAP SD Tables for Delivery Documents
    • SAP SD Tables for Billing Document
    • Shipping Tables in SAP SD
    • SAP Pricing Tables
    • Others 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. TablesDESCRIPTION
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 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 useful related Tables to Sales Document in SAP SD:

SD Sales TablesDESCRIPTION
VBUKHeader Status and Administrative Data
VBAKSales Document : Header Data
VBKDSales Document : Business Data
VBUPItem Status
VBAPSales Document : Item Data
VBPAPartners
VBFADocument Flow
VBEPSales Document Schedule Line
VBBESales Requirements: Individual Records

You may also check

  • Read SAP Document flow in SAP SD
  • SAP Order Delivery Status for Sales Documents

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 SDDESCRIPTION
LIPSDelivery Document item data includes referencing PO
LIKPDelivery 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 TABLESDESCRIPTION
VBRKBilling Document Header
VBRPBilling Document Item

Check more about Billing Document in SAP SD:

  • The Main SAP Invoice Table for Accounting Document and Material Document
  • The full list of SAP Billing Document User Exit for transfer to accounting

Shipping Tables in SAP SD

Find bellowing the list of Shipping Unit Tables in SAP SD

SHIPPING TABLES IN SAP SDDESCRIPTION
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 :

SAP PricingDESCRIPTION
KOMKPricing Communications: Header (Structure)
KOMPPricing Communication: Item (Structure)
KONVConditions: Transaction Data
KONPConditions: Item
KONHConditions: Header
KONDSAP Contracts Table in SAP SD
VEDAContract 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:

  • Important Tables for SAP SD
  • SD related tables and structures
Prev Article
Next Article
Tags:Material SAP Tables

Related Articles

SAP Material
Trigger MATMAS IDoc using BTE event step by step guide …

Trigger MATMAS IDoc using BTE event

SAP Info Record Table
SAP Info Record Table, Tcodes and Report regroup all the …

SAP Info Record Table, Info Recort Tcodes and SAP Info Record Report

Search on SAP4TECH

The Most Populars

  • The Most Important SAP ISU Tables
    The Most Important SAP ISU Tables
  • SAP Users Tables
    SAP Users Tables (for Personal, Logon, and Address Data)
  • List of SAP Purchase Order Tables in SAP MM SAP PO Tables
    SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • Full list of SAP Movement Types
    SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP GL Account Tcodes SAP GL Account Tables
    The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables
    SAP BOM Tables for BOM Header, Items and components and Category

Related Posts

  • SAP SD
    Create SAP PO with Explicit PO Number
  • SAP Batch Management 1
    SAP Batch Management Tcodes, Tables and Customizing (SAP Batch Management)
  • domino 163522 1280 e1442441105680
    The 3 ways to Mass Update Contacts of Customer in SAP
  • ABAP Workbench
    How To Find easily a SAP BAPI in SAP SD: Two Ways Explained
  • SAP Billing Document User Exit
    The full list of SAP Billing Document User Exit for transfer to accounting

SAP4TECH

SAP and ABAP Free Tutorials

Trending Posts

  • The Most Important SAP ISU Tables
  • SAP Users Tables (for Personal, Logon, and Address Data)
  • SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables for BOM Header, Items and components and Category

The Most Recents

  • The Most Important SAP ISU Tables
  • SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd Lecture
  • The Main SAP Dunning Transaction Codes
  • SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP AP Tcodes & SAP AR Tcodes)
  • The Most Important SAP Payment Terms Tables (ZTERM, Text…)

Search

SAP Tutorials by Topics

  • SAP Tables
  • SAP Tcodes
  • SAP BAPI
  • ABAP Snippets
  • Top SAP Courses
  • Top SAP Books
Copyright © 2021 SAP4TECH

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy