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 |