Skip to end of metadata
Go to start of metadata

Purpose

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

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

Logical Database

AK V

Sales documents

Delivery Documemt

Table/Structure

Description

LIKP

Delivery Document: Header data

LIPS

Delivery Document: Item data

Shipping

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

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

Logical Database for Material Master

Table/Structure

Description

CKM

Material master

MSM

Material master

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

Others

Table/Structure

Description

JSTO

PP status

SADR

Address

  1. Guest

    Excellent Reference.!!!

    I found easily what I was looking for.!!! (VBFA & LIPK tables)

    Great Thanks

    John

  2. Guest

    DEAR SIR, THANK YOU VERY MUCH THIS IS VERY HELP FULL TO ALL

    ALL THE BEST FOR FETURE

    THANKS

  3. Thanks a lot. Saved me some time googling help.sap.com : )