VBAK & VBAP

[Former Member]

Hi all,

I am selecting some data in VBAK and VBAP tables. Except the data from these tables I also need <b>WERKS</b> information for selected record.

Does anyone knows how to get the WERKS data trough JOIN with other tables.

Please help,

Thanks in advance,

Maja

[Former Member]

I believe we have a filed called WERKS in VBAP

Thanks

Pavan

[Former Member]

Hello:

You should be able to do a join between VBAK and VBAP with the sales document(VBELN) as your join condition. The werks field is in the VBAP table.

[Former Member]

WERKS will be available in VBAP table only.

Regards,

Satish

[former_member188829]

Hi,

WERKS is there in VBAP Table.

[Former Member]

My Bad,

Sorry for this one.

Thanx anyway

[Former Member]

hi

WERKS is available in VBAP. Besides this it is also available in MARC table.

Thanks,

Kasiraman R