Datasheet

16 ChApter 1
introduCtion to sAles And distribution
e rst step is to know the important table names—at least the names of the tables
commonly used in the SD application. Table 1.1 lists some of the most important
tables. Once again, for convenience of understanding, we have tried to arrange them
according to the transactions in the basic sales cycle. e appendix contains a list of
all the important tables related to SD.
At this stage, do not try to remember the table names. It is more important to under-
stand the concepts. As you progress further, however, you should make yourself
familiar with these names.
Table 1.1 Database Tables in SD
Transaction Table Name Description
Sales orders VBAK Order header
VBAP Order item
VBEP Order schedule lines
Delivery LIKP Delivery header
LIPS Delivery item
Billing VBRK Billing header
VBRP Billing item
General process information VBFA Document flow
VBUK Header status
VBUP Item status
We’ll now discuss how to access database records and explore the structure of a table.
Data Browser
e data browser allows you to search database tables and fetch stored records. To
access the data browser, use the path SAP Menu
Tools
ABAP Workbench
Overview
Data Browser (SE16), and enter the name of the table that you want to
study.
e next screen contains selection parameters that can help you search for appropriate
database records. Figure 1.14 shows the selection screen for order header table VBAK.
If you know the sales order number, you can enter it in the Sales Document eld on
the selection screen. If, on the other hand, you do not know the order number, you
404737c01.indd 16 2/23/10 9:57:07 AM