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