customer address in smartform

[Former Member]

hi all,

i need to show customer address in the smartform for tht i need to fetch address no from table vbpa on the basis of vbeln n according to tht address no i need to fetch address from adrc

how to write the query for this

[Former Member]

hi,

u can write like,

select single adrnr from vbpa into zadrnr

where vbeln = ur doc. no.

select single * from adrc into zadrc where

adrcnumber = zadrnr.

declare 1. zadrnr type adrnr

2 . zadrc type adrc

in global definition.

take o/p of req fields from zadrc.

regards

[Former Member]

Hi,

data:v_adrnr type adrnr.

select ADRNR

from vbpa

into v_adrnr

up to 1 rows

where vbeln = '0000010106'

and parvw = '1A'.

endselect.

if sy=subrc eq 0 and V_adrnr is not intial.

Select <Fields>

from adrc

into table <Internal tbale>

where adrnr = v_adrnr.

endif.

Regards

Jana

[Former Member]

hi janardhan...

i need to compare to whether it is customers address or consignees address n nedd to show respectively in smartform....

[Former Member]

Hi

In the program lines in smartform, write a select statement to pick up the address number..

Then under the program lines,Right Click on the program lines node and in create select Address...

Pass on the value u retreived from select statement into the address..

Regards,

Vishwa.