select quirey

[Former Member]

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]

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