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
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
Bluesky
