This blog is intended to explain the SAP SD tables in detail. We are going to discuss three main aspects of the sales, shipping and billing process. We will cover the tables available for sales and distribution. The SAP SD tables of sales and distribution for alteryx users have also been discussed.
The SAP SD module is built on tables and uses them to store data. We'll go through SAP SD tables and their relationships in this tutorial. SAP SD tables are critical storage for corporate data connected to SAP ERP software's sales and distribution activities. The SD tables are basically divided into three parts:
These are the SD module's building blocks, and it's only natural to address tables in this sequence. Please look at the slides to see how the tables from different blocks were connected. Being an expert in SAP SD necessitates an understanding of these relationships.
In SAP SD, the first block is about sales procedures.This indicates that the SAP SD tables in this block would be related to sales orders, quotations, and other similar transactions. We designed a visual slide that lists all of the tables and their relationships.
ThIs section is about SAP SD's shipping processes. In this section, SAP SD tables deal with inbound and outbound deliveries, as well as shipments. Likewise, we've created a visual slide with links illustrating table relationships.
The billing feature of SAP SD is the last but not least. SAP has a variety of tables which are used to support a company's billing procedures. Billing documents, as well as other related data, such as output conditions, are saved in these tables by SAP.
The following are the SAP SD tables for customers, sales documents, delivery documents, billing documents, shipping unit.
KNA1: General Data
KNB1: Customer Master – Co. Code Data (payment method, reconciliation acct)
KNB4: Customer Payment History
KNB5: Customer Master – Dunning info
KNBK: Customer Master Bank Data
KNKA: Customer Master Credit Mgmt.
KNKK: Customer Master Credit Control Area Data (credit limits)
KNVV: Sales Area Data (terms, order probability)
KNVI: Customer Master Tax Indicator
KNVP: Partner Function key
KNVD: Output type
KNVS: Customer Master Ship Data
KLPA: Customer/Vendor Link
VBAKUK: VBAK + VBUK
VBUK: Header Status and Administrative Data
VBAK: Sales Document - Header Data
VBKD: Sales Document - Business Data
VBUP: Item Status
VBAP: Sales Document - Item Data
VBFA: Document Flow
VBEP: Sales Document Schedule Line
VBBE: Sales Requirements: Individual Records
LIPS: Delivery Document item data, includes referencing PO
LIKP: Delivery Document Header data
VBRK: Billing Document Header
VBRP: Billing Document Item
VEKP: Shipping Unit Item (Content)
VEPO: Shipping Unit Header
For users of Alteryx and the DVW Alteryx Connector for SAP, we'll now look at the most significant SAP Sales and Distribution (SD) tables.
Related Articles SAP SD Modules !
The following SAP systems contain SAP Sales and Distribution tables:
The SAP SD transaction tables for sales, delivery and billing process is as follows:
The documents of SAP Sales include:
The following are the most important tables in a sales document:
The documents of SAP Delivery include:
The key Delivery Document tables are:
Related Articles SAP SD Flow !
The documents of SAP Billing include:
The key Billing Document tables are:
Master Data Tables for SAP Sales and Distribution (SD)
Data Tables for SAP Sales and Distribution (SD) Configuration
We hope this blog is very helpful in knowing various tables discussed on SAP SD.
Batch starts on 4th Feb 2023, Weekend batch
Batch starts on 8th Feb 2023, Weekday batch
Batch starts on 12th Feb 2023, Weekend batch