How do you fetch the URL corresponding to a particular ADRNR number?

[Former Member]

I have the address number ADRNR, I want the URL corresponding to the same.

How do you fetch the URL corresponding to a particular ADRNR number?

[Former Member]

i suppose you want email address if so use this

select adr6-addrnumber from table adr6 join table lfa1 with key adr6-addrnumber = lfa1-adrnr

[Former Member]

No I dont need the Email Address, i need the corresponding URL of the ADRNR ( Address number)

[Former Member]

Thanks ...your answer was only partly right but it gave me the right approach...My Question is answered ...thank you