topic Re: query in Application Development and Automation Discussions

query

Former Member — Fri, 30 Mar 2007 10:04:29 GMT

Hi ,

please can you hlep me in this.

Ship to address is to be printed along with sold to party address.

Get the ship to party customer number from table VBPA by passing

delivery number and partner as AG. Then pick the address for ship to

party.

Thanks & Regards

Former Member — Fri, 30 Mar 2007 10:07:11 GMT

Hi.

select Kunnr from VBpa into v_shipto

where vbeln = <delivery No> and

parvw = 'WE'.

then pass this KUNNR to KNA1 and get his address.

select single * from kna1 where kunnr = <above no>

reward if useful

regards,

Anji

Message was edited by:

Anji Reddy Vangala

Former Member — Fri, 30 Mar 2007 10:10:58 GMT

select kunnr from VBPA

into G_KUNNR

where vbeln = s_vbeln and PARVW = 'AG'.

select ADRNR from KNA1

into G_ADRNR

where kunnr = g_kunnr.

select field1 field2 ....

from ADRC

where adrnr = g_adrnr.