The SAP Sales and Distribution (SD) tables every KNIME user should know

​In this blog we identify the SAP Sales and Distribution (SD)  tables that users of KNIME and the DVW KNIME Connector for SAP should know.

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

GET A FREE TRIAL TODAY