The most important SAP Sales and Distribution (SD) tables for users of Alteryx, KNIME, Power BI, Tableau & Snowflake

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
• KNIME and the DVW KNIME Connector for SAP
• Power BI and the DVW Power BI Connector for SAP
• Tableau and the DVW Tableau Connector for SAP
• Snowflake and the DVW Snowflake 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!

GET A FREE TRIAL TODAY