topic Re: VBAK & VBAP in Application Development and Automation Discussions

VBAK & VBAP

Former Member — Thu, 06 Dec 2007 14:56:25 GMT

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 — Thu, 06 Dec 2007 14:58:38 GMT

I believe we have a filed called WERKS in VBAP

Thanks

Pavan

Former Member — Thu, 06 Dec 2007 14:59:28 GMT

WERKS will be available in VBAP table only.

Regards,

Satish

former_member188829 — Thu, 06 Dec 2007 15:00:00 GMT

Hi,

WERKS is there in VBAP Table.

Former Member — Thu, 06 Dec 2007 15:01:00 GMT

My Bad,

Sorry for this one.

Thanx anyway

Former Member — Thu, 06 Dec 2007 15:01:07 GMT

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

Thanks,

Kasiraman R

Former Member — Thu, 06 Dec 2007 15:02:21 GMT

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.