Skip to Content
avatar image
Former Member

invoice smart form

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 04, 2007 at 11:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded