Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

query

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

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
0 Kudos

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.