Skip to Content
avatar image
Former Member

Tables VBAK and VBAP

Hi there!

When i want to extract data ,partly related to header and partly related to item , what i do is, i give the conditions(header conditions like sales org.) for which i need data in VBAK and when i get the sales order numbers i exceute VBAP for these sales order to get item data....is this the correct way or is there a way to get the header as well as item data from the same table....Please suggest....

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 23, 2008 at 11:50 AM

    Dear swetha,

    There is a one table generated view ,

    VBAP_VAPMA

    you will get VBAK + VBAP + VBKD

    saravanan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2008 at 09:57 AM

    Hi,

    You approach is correct.

    If you want to see the header and item data together then you can create a simple query using transaction SQVI.

    Regards

    Karan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2008 at 10:08 AM

    Hi,

    You can use the other table VAPMA with header and item fields in keys.

    Of course, create a report with the link between VBAK and VBAP.

    Regards,

    Lionel

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 23, 2008 at 11:39 AM

    Dear Swetha,

    If you want to pull data from a single table use T-code: SE16N.

    If you want to join multiple Tables then create a Query thrrough SQ00. You can select the required feild in this Query & generate a report based on required selection criteria..

    Hope this Helps..

    Thanks,

    Jignesh Mehta

    Add comment
    10|10000 characters needed characters exceeded