Need help in retrieving street 1 address from xk03

[Former Member]

Dear gurus

Im stuck in retrieving vendor address .

the vendor master table is LFA1 if im not mistaken

and vendor record is created through xk01.

In my scenario im unable to retrieve data from Street 1 ,2 ,3 ,4 .

how to get this data in my program

please help me

SELECT SINGLE stras
         INTO cust_add
         FROM lfa1
         WHERE lifnr = cust_no.

[vallamuthu_madheswaran2]

remove aslecty single. create on internal table.

SELECT lifnr stras

INTO table cust_add

FROM lfa1

WHERE lifnr = cust_no.

Thanks & Regards,

Vallamuthu.M

[Former Member]

Hello ,

Try this,

SELECT SINGLE stras adrnr
         INTO cust_add addrnr
         FROM lfa1
         WHERE lifnr = cust_no.


select single STR_SUPPL1 STR_SUPPL2 STR_SUPPL3 LOCATION
into .....
from adrc 
where ADDRNUMBER = addrnr.

Vikranth

Edited by: Vikranth.Reddy on Mar 12, 2010 4:41 PM

[kesavadas_thekkillath]

Check whether there is any conversion ( leading zeros ) issues in the variable cust_no.

[Former Member]

Hi,

Street 1 ,2 ,3 ,4 fileds will be avialable in ADRC table not in LFA1 table.

1, select ADRNR from LFA1 using CUST_NO.

2, Select STR_SUPPL1(Street 1) ,STR_SUPPL2 (Street 2) , STR_SUPPL3 (Street 2) from ADRC where ADDRNUMBER = LFA1-ADRNR.

This is how you can retrive street data for vendor.

Regards,

Shanmugavel Chandrasekaran