Tables VBAK and VBAP

[Former Member]

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....

[Former Member · Accepted solution]

Dear swetha,

There is a one table generated view ,

VBAP_VAPMA

you will get VBAK + VBAP + VBKD

saravanan

[jignesh_mehta3]

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

[Former Member]

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

[Former Member]

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