List of SAP System Tables

SAP System tables for Sales orders

NameDescriptionUses
LIKPShipped
Lines header
LIPSShipped
Lines detail
VBAKOrder
header
Every
order (unless archiving)
VBAPTable
fields
Every line
item (unless archiving)
VBBEOpen sales
order line items
Great file,
but be careful. Contents don’t reflect orders that do not affect purchasing
(go figure).
VBFADocument
flow
Let’s you
move from order to shipping document to invoice.
VBUKOrder
status
 
VBUPLine item
detail status

SAP System tables for Material Management

NameDescriptionUses
MARAInventory
Master
MARCPlant Data
MARDCurrent
Inventory
MAKTDescriptions
MBEWMaterial
Valuation
 
T179Product
Hierarchy
MVKESales data
(materials)
MKPFMaterial
document
Status
code ‘R’ in VBFA

SAP System tables for Purchasing

NameDescriptionUses
EINAPurchasing
inforecord
by
MATNR/LIFNR contains things like vendor material number and access key for
EINE
EINEPurchasing
inforecord detail
Contains
minimum purchase, group, currency
EKPOPurchase
orders
EKETScheduled
lines
EKESVendor
confirmed lines
 

SAP System tables for Service Management

 
NameDescriptionUses
CAUFVService
order header
AFPOService
order line
Holds
items that will create “reservations”
RESBSM
Reservations
Materials
needed for line

SAP System tables for
Customer Data

KNAICustomer Master
KNVVSales
information
KNVPPartners
(ship-to, etc)

 

 

System tables

NameDescriptionUses
DD02TTable
texts
 
DD03LTable
fields
Lists the
fields in a table
DD04TData
element texts
USR02Valid user
names
 

Config tables (normally
begin with “T”)

NameDescriptionUses
T001Client
table
T002Languages
T005Region
(Country)
 
TCURRCurrency
and exchange rates
TVAKOrder type
TVSBShipping
condition
TVAGTRejected
reason for order line

Other tables

NameDescriptionUses
STXHText
header
STXLText
detail

More References