Tables in SAP

Just a list of tables that come in handy.

Sales orders
NameDescription Uses
LIKP Shipped Lines header  
LIPS Shipped Lines detail  
VBAK Order header Every order (unless archiving)
VBAP Table fields Every line item (unless archiving)
VBBE Open sales order line items Great file, but be careful. Contents don't reflect orders that do not affect purchasing (go figure).
VBEP Schedule line item  
VBFA Document flow Let's you move from order to shipping document to invoice.
VBUK Order status  
VBUP Line item detail status  
VBFK Invoicing header  
VBFP Invoicing detail  

Material Management
Name Description Uses
MARA Inventory Master
MARC Plant Data
MARD Current Inventory
MAKT Descriptions
MBEW Material Valuation
T179 Product Hierarchy
MVKE Sales data (materials)
MKPF Material document Status code 'R' in VBFA

Name Description Uses
EINA Purchasing inforecord by MATNR/LIFNR contains things like vendor material number and access key for EINE
EINE Purchasing inforecord detail Contains minimum purchase, group, currency
EKPO Purchase orders  
EKET Scheduled lines  
EKES Vendor confirmed lines  

Name Description Uses

Name Description Uses
KSSK Material number to class
KLAS Class description
KSML Characteristic name
CABN/CABNT Characteristic name description
CAWN/CAWNT Characteristic name
AUSP Numeric values
Name Description Uses
CAUFV Service order header
AFPO Service order line Holds items that will create "reservations"
RESB SM Reservations Materials needed for line

Customer Data

KNA1 Customer Master  
KNVV Sales information  
KNVP Partners (ship-to, etc)  


System tables
Name Description Uses
DD02T Table texts
DD03L Table fields Lists the fields in a table
DD04T Data element texts
USR02 Valid user names

Config tables (normally begin with "T")
Name Description Uses
T001 Client table
T002 Languages
T005 Region (Country)
TCURR Currency and exchange rates
TVAK Order type
TVSB Shipping condition
TVAGT Rejected reason for order line

Other tables
Name Description Uses
STXH Text header
STXL Text detail

Return to ABAP help

[Our portfolio] [A history of Computers and Networks]
[Perl help] [ABAP help] [MySQL help]
[TCP/IP troubleshooting] [HTML help] [Feedback] [Humor]
Advertise on Golden Ink's Georgia Network

In Association with