SAP SD Tables

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

Leave a Comment