Sales and distribution tables comprises of Sales, Billing, Delivery, Copy control and other linking tables. These tables are necessary for all the basic activities in sales and distribution. It is always better to have a copy of these tables with us. Below are the tables which we normally use in the sales and distribution process.
- Tables related to Customer Master
- KNA1 – General Data in Customer Master
- KNB1 – Customer Master (Company Code data)
- KNB4 – Customer Payment History
- KNB5 – Customer master (dunning data)
- KNBK – Customer Master (Bank Details)
- KNKA – Customer master credit management: Central data
- KNKK – Customer master credit management: Control area data
- KNVV – Customer Master Sales Data
- KNVI – Customer Master Tax Indicator
- KNVP – Customer Master Partner Functions
- KNVD – Customer master record sales request form
- KNVS – Customer Master Shipping Data
- KLPA – Customer/Vendor Linking
- V_THIT – Generated Table for View
- KNVH – Customer Hierarchies
- KNVK – Customer Master Contact Partner
- Tables related to Sales document
- VBUK – Sales Document: Header Status and Administrative data
- VBAK – Sales Document: Header Data
- VBKA – Sales Activities
- VBKD – Sales Document: Business Data
- VBPA – Sales Document: Partner
- VBUP – Sales Document: Item Status
- VBPA – Sales Document: Partner
- VBAP – Sales Document: Item Data
- FPLA – Billing Plan
- VBFA – Sales Document Flow
- VBEP – Sales Document: Schedule Line Data
- VBBE – Sales Requirements: Individual Records
- VEDA – Contract Data
- Tables related to Delivery and Billing
- LIPS – SD document: Delivery: Item data
- LIKP – SD Document: Delivery Header Data
- VBRP – Billing Document: Item Data
- VBRK – Billing Document: Header Data
- KONP – Conditions (Item)
- KONV – Conditions (Transaction Data)
- VEKP – Handling Unit – Header Table
- VEPO – Packing: Handling Unit Item (Contents)
- Tables related to Transportation
- VTTK – Shipment Header
- VTTP – Shipment Item
- TVRO – Routes
- TVTK – Shipment Types
- Tables related to Sales Copy control
- TVAK – Sales Document Types
- TVCPA – Sales Documents: Copying Control
- T184 – Sales Documents: Item Category Determination
- TVASP – Sales Documents: Blocking Reasons
- TVCPF – Billing: Copying Control
- TVCPL – Deliveries: Copying Control
- TVAPT – Sales document item categories: Texts
- TVEPZ – Sales Document: Schedule Line Category Determination
- TVLP – Deliveries: Item Categories
- TVPT – Sales documents: Item categories
- TVFSP – Billing: Blocking Reasons
- SD – MM Linking tables
- MARC – Plant Data for Material
- MVKE – Sales Data for Material
- MBEW – Material Valuation
- MARD – Storage Location Data for Material
- T179 – Materials: Product Hierarchies
- MLAN – Tax Classification for Material
- MAKT – Material Descriptions
- MARA – General Material Data
- MARM – Units of Measure for Material
- Number Range Intervals
- NRIV – Number Range Intervals
The tables displayed above are the common tables used in the SD module. But if you want to display the complete list of tables available in the any module we can use SE11 transaction.
1) Goto SE11 Transaction. select the Radio button “Database table” and click on F4 button.
2) Click on SAP Application button.
3) You can find the tables of all the modules in Tree structure. Just expand the structure and view the tables.
