|
|
 |
LIST of TABLES
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).
|
|
VBFA
|
Document
flow
|
Let's you
move from order to shipping document to invoice.
|
|
VBUK
|
Order
status
|
|
|
VBUP
|
Line item
detail status
|
|
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
|
|
|
|
|
|
Service Management
|
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
|
KNAI
|
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
|
|
|
SAP Technical Tutorials
ABAP
DICTIONARY
INTERNAL TABLES
ALV Reports
SAPSCRIPTS
SMARTFORMS
LSMW
BDC
ALE
IDOC
USER EXITS
TRANSPORTING
ITS
SAP Functional Tutorials
FI (Financial)
CO (Controlling)
HR (Human
Resource)
LO (Logistics)
MM (Materials
Management)
PP (Production
Planning)
QM (Quality
Management)
SD (Sales
and Distribution)
TR (Treasury
and cash)
WM (Warehouse
Management)
PS (project
Systems)
PM (plant
Maintenance)
CA (Cross
Application)
SAP
Interview
questions
Architecture
faqs
BDC faqs
DATADICTIONARY faqs
Logical Database Faqs
Modularization Faqs
Reports Faqs
Transactions Faqs
SAP References
transaction
codes
System
Fields
Function Modules
SAP TABLES
code
optimization
TOOLS
SQL Trace tool
Runtime Analysis
LSMW
ABAP Query
CTS
|