topic Re: select quirey in Application Development and Automation Discussions

select quirey

Former Member — Fri, 11 Aug 2006 13:10:07 GMT

hi can u plz help me how to write the code for this coz its very urgent for me

Secondary Index for Customers (BSID)

billing documents (VBELN)

Read Sales Document Partner Table (VBPA) for billing document number

Read partner function (PARVW) = ‘WE’

Retrieve Name (NAME1) for partner function ‘WE’ and billing document from BSEG

regards

siri

Former Member — Fri, 11 Aug 2006 13:22:21 GMT

select a_{vbeln b}name1

into table itab

from bsid as a inner join vbpa as b

on a_{vbeln = b}vbeln

where b~parvw = 'WE'.

Note --

U have few queries open...please close if you have got the soln and do assign points for appropriate replies.

Thanks

Message was edited by: Anurag Bankley