We have discussed some SAP Database tables/Structures in today’s SAP SD Training class. For more information on other SAP Training modules, please visit our home page.
VBAK – Sales Document Header
VBAP – Sales Document Item
VBEP – Sales Document Schedule Lines
LIKP – Delivery Header
LIPS – Delivery Line Items
VBRK – Billing Document Header
VBRP – Billing Document Item
VBFA – Document Flow
Exercises : Please complete the following exercises without going through the front end transactions. Only use the transaction codes SE11 or SE16 ( SAP Data Browser ). Please do not use front end transactions like VA01, VL01 etc.
Question 1 : Find out from the SAP Database tables the following fields for the SAP Sales Order # 4982. For each of the questions below, give the technical name.
For example, for the question, “Who created the order” , the answer should be “BOLLINGER and the technical name is VBAK-ERNAM”
- Who created the Order ?
- What is the Document Date ?
- What is the Document Category ?
- What is the Document Currency ?
- What is the Net Value of the Order ?
- What is the Customer Credit Group ?
Question 2 : Find out from the SAP Database tables, the following fields and their values for the SAP Sales Order # 4982 , line item 20.
- What is the Description of the material ?
- What is the item category of the material ?
- What is the Product Hierarchy of the material ?
- What is the net value of the material ?
- What is the volume unit of the material ?
- What is the delivering Plant ?
Question 3 : Find out from the SAP Database tables, the following fields and their values for the SAP Sales Order # 4982, line item 30 and the corresponding schedule lines
- How many schedule lines are available for line item # 30 ? How did you find out without going through the front end ?
- For the second schedule line of line item # 30, what is the SAP Schedule Line category ?
- What is the Transportation Planning Date ?
- What is the movement type ?
Question 4 : What is the delivery document for Sales Order # 4982 ?
Question 5 : What is the billing Document for Sales Order # 4982 , line item # 40 ?
Explain how you found out answers to Q.4 and Q.5 ?
Question 6 : Find out from the database table/view, the relationship between Company Code and Plant as specified in the Enterprise Structure for Plant 1200?
Answers:
Question 1 : Find out from the SAP Database tables the following fields for the SAP Sales Order # 4982. For each of the questions below, give the technical name.
Who created the Order
Bollinger VBAK-ERNAM
What is the Document Date
22-01-1991 VBAK-ERDAT
What is the Document Category
C- ORDER VBAK-VBTYP
What is the Document Currency
DEM VBAK-WAERK
What is the Net Value of the Order
43.004 VBAK-WAERK
What is the Customer Credit Group
2 vBAK-GRUPP
_________________________________________________________________
Question 2 : Find out from the SAP Database tables, the following fields and their values for the SAP Sales Order # 4982 , line item 20.
What is the Description of the material ?
SUNNY XA1 VBAP-ARKTX
What is the item category of the material ?
TAN VBAP-PSTYV
What is the Product Hierarchy of the material ?
0012500100000000110 VBAP-PRODH
What is the net value of the material ?
11328 VBAP-NETWR
What is the volume unit of the material ?
M3 VBAP-VOLEH
What is the delivering Plant ?
1200 VBAP-VSTEL
_________________________________________________________________
Exercises : Please complete the following exercises without going through the front end transactions. Only use the transaction codes SE11 or SE16 ( SAP Data Browser ). Please do not use front end transactions like VA01, VL01 etc.
Question 1 : Find out from the SAP Database tables the following fields for the SAP Sales Order # 4982. For each of the questions below, give the technical name.
For example, for the question, “Who created the order” , the answer should be “BOLLINGER and the technical name is VBAK-ERNAM”
A.Who created the Order ?
ANS: Created By Bollinger
B.What is the Document Date ?
ANS: 22-01-97
C.What is the Document Category ?
ANS: OR
D.What is the Document Currency ?
ANS: DEM
E.What is the Net Value of the Order ?
ANS: 43004.00 DEM
F.What is the Customer Credit Group ?
ANS: 02
Question 2 : Find out from the SAP Database tables, the following fields and their values for the SAP Sales Order # 4982 , line item 20.
A.What is the Description of the material ?
ANS: Sunny Xa1
B.What is the item category of the material ?
ANS: TAN
C.What is the Product Hierarchy of the material ?
ANS: 001250010000000110
D.What is the net value of the material ?
ANS: 11.328,00 DEM
E.What is the volume unit of the material ?
ANS: 0,900 M3
F.What is the delivering Plant ?
ANS: 1200
Question 3 : Find out from the SAP Database tables, the following fields and their values for the SAP Sales Order # 4982, line item 30 and the corresponding schedule lines
A.How many schedule lines are available for line item # 30 ? How did you find out without going through the front end ?
ANS: 2 ….by double clicking the line item and then schedule lines tab.
B.For the second schedule line of line item # 30, what is the SAP Schedule Line category ?
ANS: CV
C.What is the Transportation Planning Date ?
ANS: 22.01.1997
D.What is the movement type ?
ANS: 601
Question 4 : What is the delivery document for Sales Order # 4982 ?
ANS: 80003384
Question 5 : What is the billing Document for Sales Order # 4982 , line item # 40 ?
ANS: 90005192
Explain how you found out answers to Q.4 and Q.5 ?
ANS: By going to the document flow of the order
Please provide the technical names as well.