Skip to end of metadata
Go to start of metadata

Purpose

This wiki page will discuss about the various table involved/related to ERP SD.

These can very handy while you are:

  • preparing a Functional Specification
  • looking for transaction data
  • want to know about the respective fields in the table
  • when you want to create a SAP query

1 Enterprise structure

1.1 Definition


FI - Finance

Tables

Description

T880

Company

T001

Company code


CO - Controlling

Tables

Description

TKA01

Controlling area


LO - Logistics Operation

Tables

Description

T001W

Plant / sales organization

T499S

Locations

TSPA

Division


SD - Sales and Distribution

Tables

Description

TVKO

Sales organization / company code

TVTW

Distribution channel

TVBUR

Sales office

TVKBT

Sales office text

TVKGR

Sales group

TVGRT

Sales group text

T171T

Sales district text


MM - Material Management

Tables

Description

T001L

Storage locations

T024E

Purchasing organization

T3001

Warehouse number

TVST

Shipping point

TVLA

Loading point

TTDS

Transportation

T156

Movement Type

T023

Material Group


1.2 Assignment


CO - Controlling

Tables

Description

TKA02

Assign company code to controlling area


LO - Logistics Operation

Tables

Description

T001K

Assign plant (valuation area) to company code


SD - Sales and Distribution

Tables

Description

TVKO

Sales organization / company code

TVKOV

Distribution channel / sales organization

TVKOS

Division to sales organization

TVTA

Sales area

TVKBZ

Sales office to sales area

TVBVK

Sales group to sales office

TVKWZ

Plants to sales organization


MM - Material Management

Tables

Description

T024E

Purchasing organization / company code

T024W

Plant to Purchase organization

T001K

Link plant (= valuation area) / company code

TVSWZ

Shipping point to plant

T320

Assignment MM Storage Location to WM Warehouse


2 Master Data



2.1 Material master

Tables

Description

MARA

Material Master

MAKT

Material Description

MLAH

Material Tax Classification

MARC

Material per plant / stock

MVKE

Sales data - Material Master

MARD

Storage location / stock

MSKA

Sales order stock

MSPR

Project stock

MARM

Units of measure

MEAN

International article number

PROP

Forecast parameters

MAPR

Link MARC <=> PROP

MBEW

Material valuation

MVER

Material consumption

MLGN

Material / Warehouse number

MLGT

Material / Storage type

MPRP

Forecast profiles

MDTB

MRP table

MDKP

Header data for MRP document

MLAN

Tax data material master

MTQSS

Material master view: QM

MKPF

Material Document: Header

MSEG

Material Document: Item

MOFF

List of views not created for the material

PGMI

Planning material

T179

Material Product Hierarchy


2.2 Batches

Tables

Description

MCHA

Batches

MCH1

Batches

MCHB

Stock:Batches


2.3 Customer master data

Tables

Description

KNA1

Customer master - General data

KNB1

Customer master - Company data

KNB4

Customer Payment History

KNVV

Customer master - Sales data

KNBK

Bank details

KNB6

Customer master - Dunning data

KNVH

Customer hierarchy

KNVP

Customer partners function

KNVD

Customer Master Record Sales Request Form

KNVS

Shipment data for customer

KNVK

Contact persons

KNVI

Customer master tax indicator


3 Sales and Distribution (SD)

Tables

Description

VBFA

Document flow (alg.)

VTFA

Flow shipping documents


3.1 Sales order

Tables

Description

VBAK

Header data

VBAP

Item data

VBPA

Partners in sales order

VBKD

Sales Business Data

VBEP

Sales Doc - Schedule Line

VBEH

Schedule Line History

VBUK

Sales document : Header status

VBUP

Sales document : Item status

VBBE

Sales Requirement

VBLB

Release Order Data

FPLA

Billing Plan

FPLT

Billing Plan - Date


3.2 Pricing

Tables

Description

KONH

Conditions header

KONP

Conditions items

KONV

Procedure (billing doc or sales order)

KOND

Condition (data)

KOMK

Pricing Communication Header


3.3 Delivery & Shipping

Tables

Description

LIKP

Delivery header

LIPS

Delivery item

VTTK

Shipment header

VTTP

Shipment item

VTTS

Stage in transport

VTSP

Stage in transport per shipment item

VTPA

Shipment partners

VBUK

Sales Document: Header Status and Administrative Data

VBUP

Sales Document: Item Status

VEKP

Handling Unit - Header Table

VEPO

Packing: Handling Unit Item (Contents)

VEPVG

Delivery Due Index


3.4 Billing document

Tables

Description

VBRK

Header data

VBRP

Item data


3.5 contracts

Tables

Description

VEDA

Contract data


3.6 Output

Tables

Description

NAST

Message Status


3.7 Accounting Document

Tables

Description

BKPF

FI document Header

BSEG

FI document Item

BSET

Tax Data

BSID

Open Items

BSAD

Clear Items


3.8 Text

Tables

Description

STXH

Text File : Header

STXL

Text File : Item


3.9 Change Log

Tables

Description

CDHDR

Change Document: Header

CDPOS

Change Document: Item