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

6 thoughts on “SAP Database Tables – April 2011 SAP Training Batch

  1. Zahid Abbas says:

    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

    Like

  2. justin says:

    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
    _________________________________________________________________

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s