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!