The most important SAP Sales and Distribution (SD) tables for Alteryx users

In this blog we identify the most important SAP Sales and Distribution (SD) tables for users of Alteryx and the DVW Alteryx Connector for SAP.

SAP Sales and Distribution tables are found in the following SAP systems:

• SAP ECC 
• SAP ERP
• SAP S/4HANA

SAP Sales and Distribution (SD) Transaction Tables

Sales Document Tables

SAP Sales Documents include:

• Inquiries
• Quotations
• (Sales) Orders
• Contracts
• Credit Memo Requests
• Debit Memo Requests

The key Sales Document tables are:

• VBAK - Sales Document: Header Data
• VBAP - Sales Document: Item Data

Delivery Document Tables

SAP Delivery Documents include:

• Delivery / Shipping Notifications
• Deliveries

The key Delivery Document tables are:

• LIKP - SD Document: Delivery Header Data
• LIPS - SD document: Delivery: Item data

Billing Document Tables

SAP Billing Documents include:

• Invoices
• Credit Memos
• Debit Memos
• Intercompany Invoices

The key Billing Document tables are:

• VBRK - Billing Document: Header Data
• VBRP - Billing Document: Item Data

SAP Sales and Distribution (SD) Master Data Tables

• KNA1 - General Data in Customer Master
• KNB1 - Customer Master (Company Code)
• KNKK - Customer master credit management: Control area data
• KNVV - Customer Master Sales Data

SAP Sales and Distribution (SD) Configuration Data Tables

• TVFK - Billing: Document Types
  
• TVFKT - Billing: Document Types: Texts
• TVKO - Organizational Unit: Sales Organizations
• TVZB - Customers: Terms of payment 
  
• TVZBT - Customers: Terms of Payment Texts

Other Sources of SAP Table Information

Google is your best friend when searching for SAP Table data. Give it a go!

Download the sample workflow, "Extract SAP Sales Document Data, Customer Master Data and Configuration Data from SAP ECC & SAP S/4HANA" from Alteryx Gallery.