The following table shows the frequently used tables in SAP Sales and Distribution module
TABLE | NAME | DATA |
KNA1 | General Data |
Customer Master Data
|
KNB1 | Customer Master – Code Data (payment method, recon. acct) |
Customer Master Data
|
KNB4 | Customer Payment History |
Customer Master Data
|
KNB5 | Customer Master – Dunning info |
Customer Master Data
|
KNBK | Customer Master Bank Data |
Customer Master Data
|
KNKA | Customer Master Credit Mgmt. |
Customer Master Data
|
KNKK | Customer Master CCA Data (credit limits) |
Customer Master Data
|
KNVV | Sales Area Data (terms, order probability) |
Customer Master Data
|
KNVI | Customer Master Tax Indicator |
Customer Master Data
|
KNVP | Customer master partner Function |
Customer Master Data
|
KNVD | Output type |
Customer Master Data
|
KNVS | Customer Master Ship Data |
Customer Master Data
|
KLPA | Customer|Vendor Link |
Customer Master Data
|
V_THIT | Customer Hierarchy Types |
Customer Master Data
|
KNVH | Customer Hierarchies |
Customer Master Data
|
KNVK | Customer master Contact partner |
Customer Master Data
|
VBAKUK | VBAK + VBUK |
Sales Documents
|
VBUK | Header Status and Administrative Data |
Sales Documents
|
VBAK | Sales Document – General Header Data |
Sales Documents
|
VBKA | Sales Activities |
Sales Documents
|
VBKD | Sales Document – Business Header|Item Data |
Sales Documents
|
VBPA | Sales Document – Partners Header Data |
Sales Documents
|
VBUP | Item Status |
Sales Documents
|
VBPA | Sales Document – Partner Item Data |
Sales Documents
|
VBAP | Sales Document – General Item Data |
Sales Documents
|
FPLA | sales Document – Items Conditions data |
Sales Documents
|
VBFA | Document Flow |
Sales Documents
|
VBEP | Sales Document Schedule Line |
Sales Documents
|
VBBE | Sales Requirements: Individual Records |
Sales Documents
|
VEDA | Sales Contract Data |
Sales Documents
|
VBELN | Sales and Distribution Document Number |
Sales Documents
|
LIPS | Delivery Document item data, includes refer. PO | SD Delivery |
LIKP | Delivery Document Header data | SD Delivery |
VBRK | Billing Document Header |
Billing Document
|
VBRP | Billing Document Item |
Billing Document
|
KONP | Conditions Item |
Pricing Document
|
KONV | Condition for Transaction Data |
Pricing Document
|
VEKP | Shipping Unit Header | Handling Unit |
VEPO | Shipping Unit Item | Handling Unit |
VTTK | Shipment Header | Transportation |
VTTP | Shipment Item | Transportation |
TVRO | Routes | Transportation |
TVTK | Shipment Types | Transportation |
VTRLK | Delivery in shipment: Header | Transportation |
TVAK | Sales Document Types |
Sales Documents Copy Control Tables
|
TVCPA | Sales Documents: Copying Control |
Sales Documents Copy Control Tables
|
T184 | Sales Documents: Item Category Determination |
Sales Documents Copy Control Tables
|
TVASP | Sales Documents: Blocking Reasons |
Sales Documents Copy Control Tables
|
TVCPF | Billing: Copying Control |
Sales Documents Copy Control Tables
|
TVCPL | Deliveries: Copying Control |
Sales Documents Copy Control Tables
|
TVAPT | Sales document item categories: Texts |
Sales Documents Item Categories Copy Control Tables
|
TVCPA | Sales Documents: Copying Control |
Sales Documents Item Categories Copy Control Tables
|
TVCPF | Billing: Copying Control |
Sales Documents Item Categories Copy Control Tables
|
TVCPL | Deliveries: Copying Control |
Sales Documents Item Categories Copy Control Tables
|
TVEPZ | Sales Document: Schedule Line Category Determination |
Sales Documents Item Categories Copy Control Tables
|
TVLP | Deliveries: Item Categories |
Sales Documents Item Categories Copy Control Tables
|
TVPT | Sales documents: Item categories |
Sales Documents Item Categories Copy Control Tables
|
TVCPA | Sales Documents: Copying Control |
Sales Documents Schedule Line Categories Copy Control Tables
|
TVCPF | Billing: Copying Control |
Billing Documents Copy Control Tables
|
TVFSP | Billing: Blocking Reasons |
Billing Documents Copy Control Tables
|
T184L | Sales Documents: Item Category Determination |
Delivery Documents Copy Control Tables
|
TVCPF | Billing: Copying Control |
Delivery Documents Copy Control Tables
|
TVCPL | Deliveries: Copying Control |
Delivery Documents Copy Control Tables
|
TVLSP | Delivery Blocks |
Delivery Documents Copy Control Tables
|
KNVP | Customer Master Partner Functions |
SD Links to FI tables
|
KNVV | Customer Master Sales Data |
SD Links to FI tables
|
KNVD | Customer master record sales request form |
SD Links to FI tables
|
KNA1 | General Data in Customer Master |
SD Links to FI tables
|
KNB1 | Customer Master (Company Code) |
SD Links to FI tables
|
KNB5 | Customer master (dunning data) |
SD Links to FI tables
|
MARC | Plant data for material |
SD Links to MM tables
|
MVKE | Sales data for material |
SD Links to MM tables
|
MBEW | Material Valuation |
SD Links to MM tables
|
MARD | Storage Location data for Material |
SD Links to MM tables
|
T179 | Materials: product hierarchy |
SD Links to MM tables
|
MLAN | Tax classification for material |
SD Links to MM tables
|
MAKT | material description |
SD Links to MM tables
|
MARA | General material data |
SD Links to MM tables
|
MARM | Units of measure of material |
SD Links to MM tables
|
MTART | Material Types |
SD Links to MM tables
|
VBDKA | Document Header View for Inquiry, Quotation, Order |
SAP SD Structures
|
VBDPA | Document Item View for Inquiries, Quotation, Order |
SAP SD Structures
|
KOMK | Communication Header for pricing |
SAP SD Structures
|
KOMP | Communication Item for pricing |
SAP SD Structures
|