SAP SD Table Relationships

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

The SAP Sales and Distribution (SD) module stores transaction data across dozens of related tables. Understanding how these tables join together is essential for building accurate reporting and analytics workflows. This page provides an interactive diagram and a quick-reference table covering the full order-to-cash data model, including the Business Partner changes introduced in SAP S/4HANA.

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.

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.

Transaction

Master Data

S/4HANA

Configuration

Cross-Document

Quick-Reference Guide

All 26 SAP SD tables with their primary join keys and SAP system compatibility.

Table	Description	Primary Join Keys	System
Transaction Tables - Sales Documents
VBAK	Sales Document Header	VBELN, AUART, KUNNR, KNUMV	Both
VBAP	Sales Document Item	VBELN, POSNR, MATNR	Both
VBEP	Schedule Line Data	VBELN, POSNR, ETENR	Both
VBKD	Sales Document Business Data	VBELN, POSNR	Both
VBPA	Sales Document Partner Functions	VBELN, POSNR, PARVW	Both
Transaction Tables - Deliveries
LIKP	Delivery Header	VBELN, VSTEL	Both
LIPS	Delivery Item	VBELN, POSNR, MATNR	Both
Transaction Tables - Billing
VBRK	Billing Document Header	VBELN, FKART, KUNAG, KNUMV	Both
VBRP	Billing Document Item	VBELN, POSNR, MATNR	Both
Cross-Document Tables
VBFA	Document Flow	VBELV, POSNV, VBELN, POSNN, VBTYP_N	Both
KONV	Pricing Conditions	KNUMV, KPOSN, STUNR, KSCHL	ECC
PRCD_ELEMENTS	Pricing Conditions (replaces KONV)	KNUMV, KPOSN, STUNR, KSCHL	S/4HANA
Customer Master Tables (ECC)
KNA1	Customer General Data	KUNNR, ADRNR	ECC
KNB1	Customer Company Code	KUNNR, BUKRS	ECC
KNVV	Customer Sales Data	KUNNR, VKORG, VTWEG, SPART	ECC
KNKK	Credit Management	KUNNR, KKBER	ECC
ADRC	Address Data	ADDRNUMBER	Both
Business Partner Tables (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 Tables
TVAK / TVAKT	Sales Document Types and Texts	AUART, SPRAS	Both
TVFK / TVFKT	Billing Document Types and Texts	FKART, SPRAS	Both
TVKO	Sales Organisations	VKORG, BUKRS	Both
TVTW	Distribution Channels	VTWEG	Both
TVZB / TVZBT	Terms of Payment and Texts	ZTERM, SPRAS	Both

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 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