Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help in retrieving street 1 address from xk03

Former Member
0 Kudos
95

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
48

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

4 REPLIES 4

vallamuthu_madheswaran2
Active Contributor
0 Kudos
48

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
0 Kudos
49

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
Active Contributor
0 Kudos
48

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

Former Member
0 Kudos
48

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