invoice smart form

[Former Member]

in my invoice i have to get the address for 'ship-to-party','sold-to-party' based on vbrk-vbeln. i clicked F1 on 'ship-to-party'&'sold-to-party' for tables&field names in VA02 screen.

'sold-to-party' -KUAGV-KUNNR

'ship-to-party'-KUWEV-KUNNR.but KUAGV&KUWEV are structures.how to write 'select' statements for this based on VBAK-VBELN or VBRK-VBELN.how to use address node for this?please give solution.

[Former Member]

Hi Srinivas,

I have some idea .plz see wheather it is useful

First from vbak based on vbeln select kunnr(customer number).

and from kna1 based on kunnr select ADRNR(address number) and LAND1 (country key).

select land(country) from t005 based on country key.

Now in address node give adrnr in address umber field. and country name in selected country field.

Reward points if helpful

Thanks,

Suma.