SAP SD Table Relationships

An interactive reference showing how SAP Sales and Distribution tables connect across sales orders, deliveries, billing and customer master data in both SAP ECC and SAP S/4HANA.

The SAP Sales and Distribution (SD) module stores the complete order-to-cash document chain: sales orders, deliveries and billing documents, each with its own header and item tables, all linked by document flow. Understanding how these tables join together is essential for building order-book dashboards, delivery performance reporting, billing reconciliations and customer profitability analyses.

Use the diagram below to explore table relationships visually, or scroll to the quick-reference guide for a complete list of tables, join keys and system compatibility. The main S/4HANA changes in SD are pricing conditions (KONV replaced by PRCD_ELEMENTS) and the customer master, which is maintained through the Business Partner model (CVI) while the classic KNA1-family tables remain readable.

Read the Full Blog Post

Interactive Data Model

Hover over any table to see its description, key fields and system compatibility. Dashed red borders indicate S/4HANA-specific tables.

SD Transaction

Master Data

S/4HANA

Cross-Document

Configuration

Quick-Reference Guide

Every table from the diagram with its description, primary join keys and system compatibility.

Table	Description	Primary Join Keys	System
Sales Documents
VBAK	Sales Document Header	VBELN, AUART, KUNNR, KNUMV	ECC + S/4HANA
VBAP	Sales Document Item	VBELN, POSNR, MATNR	ECC + S/4HANA
VBEP	Schedule Line Data	VBELN, POSNR, ETENR	ECC + S/4HANA
VBKD	Sales Document Business Data	VBELN, POSNR	ECC + S/4HANA
VBPA	Sales Document Partner Functions	VBELN, POSNR, PARVW	ECC + S/4HANA
Deliveries
LIKP	Delivery Header	VBELN, VSTEL	ECC + S/4HANA
LIPS	Delivery Item	VBELN, POSNR, MATNR	ECC + S/4HANA
Billing
VBRK	Billing Document Header	VBELN, FKART, KUNAG, KNUMV	ECC + S/4HANA
VBRP	Billing Document Item	VBELN, POSNR, MATNR	ECC + S/4HANA
Cross-Document
VBFA	Sales Document Flow (order to delivery to billing)	VBELV, POSNV, VBELN, POSNN, VBTYP_N	ECC + S/4HANA
KONV	Pricing Conditions (replaced by PRCD_ELEMENTS in S/4HANA)	KNUMV, KPOSN, STUNR, KSCHL	ECC
PRCD_ELEMENTS	Pricing Conditions (replaces KONV)	KNUMV, KPOSN, STUNR, KSCHL	S/4HANA
Customer Master (ECC + S/4HANA)
KNA1	Customer General Data (maintained via the Business Partner / CVI in S/4HANA)	KUNNR, ADRNR	ECC + S/4HANA
KNB1	Customer Company Code Data (maintained via the Business Partner / CVI in S/4HANA)	KUNNR, BUKRS	ECC + S/4HANA
KNVV	Customer Sales Data (maintained via the Business Partner / CVI in S/4HANA)	KUNNR, VKORG, VTWEG, SPART	ECC + S/4HANA
KNKK	Credit Management (replaced by UKM_ACCOUNT where the UKM module is active)	KUNNR, KKBER	ECC + S/4HANA
ADRC	Address Data	ADDRNUMBER	ECC + S/4HANA
Business Partner (S/4HANA)
BUT000	Business Partner General Data	PARTNER	S/4HANA
BUT020	Business Partner Addresses	PARTNER, ADDRNUMBER	S/4HANA
CVI_CUST_LINK	BP to Customer Number Mapping	PARTNER, CUSTOMER (KUNNR)	S/4HANA
UKM_ACCOUNT	Credit Management (replaces KNKK)	PARTNER, CREDIT_SGMNT	S/4HANA
Configuration
TVAK / TVAKT	Sales Document Types and Texts	AUART, SPRAS	ECC + S/4HANA
TVFK / TVFKT	Billing Document Types and Texts	FKART, SPRAS	ECC + S/4HANA
TVKO	Sales Organizations	VKORG, BUKRS	ECC + S/4HANA
TVTW	Distribution Channels	VTWEG	ECC + S/4HANA
TVZB / TVZBT	Terms of Payment and Texts	ZTERM, SPRAS	ECC + S/4HANA

Related Resources

Explore more SAP content from DVW Analytics.

SAP SD Tables Blog Post

Detailed descriptions of every table shown in this diagram, with practical tips for building sales and order-to-cash analytics workflows.

DVW Help Centre

Guides and documentation for the DVW Connector for SAP, DVW Flow Tool and other DVW products. Available to free trial and paid users.

Try it free for 30 days

Free 30-day trial. Full functionality. No commitment.

Start Your Free Trial

Watch demos View pricing Talk to our team