Tables in SAP

Just a list of tables that come in handy.

Sales orders

Name	Description	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

Purchasing

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

Forecasting

Name	Description	Uses
MAPR
PROP
PROW

Classification

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

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