SAP Database Tables – April 2011 SAP Training Batch

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”

  1. Who created the Order ?
  2. What is the Document Date ?
  3. What is the Document Category ?
  4. What is the Document Currency ?
  5. What is the Net Value of the Order ?
  6. 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.

  1. What is the Description of the material ?
  2. What is the item category of the material ?
  3. What is the Product Hierarchy of the material ?
  4. What is the net value of the material ?
  5. What is the volume unit of the material ?
  6. 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

  1. How many schedule lines are available for line item # 30 ? How did you find out without going through the front end ?
  2. For the second schedule line of line item # 30, what is the SAP Schedule Line category ?
  3. What is the Transportation Planning Date ?
  4. 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?

 

 

Advertisements