SAP SD Tables

SD related tables and structures

Purpose

This page will discuss SAP tables and structures used in SAP Sales and Distribution. This can be used as a ready reference for writing FS or for data analysis.

  • Transaction code: SE16N can be used to view data in Table
  • Transaction code: SE11 can be used to view Table structure

Sales Document

Table/Structure Description
VBAK Sales Document: Header Data
VBAP Sales Document: Item Data
VBKD Sales Document: Business Data/Sales district data
VBPA Partners
VAKPA Partner index
VBFA Document Flow
VBEP Sales Document: Schedule Line / Data related to line items, delivery lines
VBAKUK Sales Document: Header and Status Data
VBUP Sales Document: Item Status
VBUK Header Status and Administrative Data
VBBE Sales Requirements: Individual Records
VBBS Summarized requirements
VBUV Incompletion log
VBLB Forecast delivery schedules
VMVA Matchcodes
VEDA Contract Data
VBKA Sales activity

 

Outbound Delivery Document

Table/Structure Description
LIKP Delivery Document: Header data
LIPS Delivery Document: Item data

Shipping and Transportation Management

Table/Structure Description
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit – Header Table
VEPO Packing: Handling Unit Item – Contents

Customer Billing Document

Table/Structure Description
VBRK Billing: Header data
VBRP Billing: Item data

Customer Master

Table/Structure Description
KNA1 Customer Master: General Data
KNB1 Customer Master: Company Code Data
KNB4 Customer Payment History
KNB5 Customer Master: Dunning data
KNBK Customer Master: Bank Details
KNBW Customer Master: Wwithholding tax types
KNKA Customer Master: Credit Mgmt.
KNKK Customer Master: Credit Control Area Data – credit limits
KNVA Customer Master: Loading/Unloading Points
KNVD Customer Master: Record sales request form/documents
KNVH Customer Hierarchies
KNVI Customer Master: Tax Indicator
KNVK Customer Master: Contact Partner
KNVL Customer Master: Licenses
KNVP Customer Master: Partner Functions
KNVS Customer Master: Shipping Data
KNVT Customer Master: Record Texts for Sales
KNVV Customer Master: Sales Data
KLPA Customer/Vendor Link

Material Master

Table/Structure Description
MARA General Material Data
MVKE Sales Data for Material
MARC Plant Data for Material
MARD Storage Location Data for Material
MAKT Short texts
MARM Conversion factors
MVKE Sales data – for each sales organization and distribution channel
MLAN Sales data – for each country
MAEX Export licenses
MBEW Valuation data
MLGN Warehouse management inventory data
MLGT Warehouse management inventory type data
MVER Consumption data
MAPR Pointers for forecast data
MCHA Batches
MCH1 Cross-plant Batches
MCHB Batch stocks
KNMTK Header table – for increased performance
KNMT Data table

Bill of Material (BOM)

Table/Structure Description
MAST Material assignment to BOM
EQST Equipment assignment to BOM
KDST Sales order assignment to BOM
DOST Document assignment to BOM
STST Standard object assignment to BOM
TPST Functional location assignment to BOM
STKO BOM header data
STZU Time-independent STL data
STAS BOM item selection
STPO BOM item data
STPU BOM sub-item data

Sales and Purchasing Pricing

Table/Structure Description
KOMK Pricing Communications: Header (Structure)
KOMP Pricing Communication: Item (Structure)
KONV Conditions: Transaction Data
KONP Conditions: Item
KONH Conditions: Header
KOND Contracts
VEDA Contract Data

Output

Table/Structure Description
NAST Output: Message Status

Text

Table/Structure Description
STXH Texts: Header
STXL Texts: Line