Last updated on Nov 07, 2023
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.
Kavya works for HKR Trainings institute as a technical writer with diverse experience in many kinds of technology-related content development. She holds a graduate education in the Computer science and Engineering stream. She has cultivated strong technical skills from reading tech blogs and also doing a lot of research related to content. She manages to write great content in many fields like Programming & Frameworks, Enterprise Integration, Web Development, SAP, and Business Process Management (BPM). Connect her on LinkedIn and Twitter.
|Batch starts on 12th Dec 2023||
|Batch starts on 16th Dec 2023||
|Batch starts on 20th Dec 2023||