topic Re: sd in Application Development and Automation Discussions

sd

Former Member — Tue, 24 Apr 2007 09:13:02 GMT

Hi,

where do we get ship to address field.

Regards,

Nasru

Re: sd

Former Member — Tue, 24 Apr 2007 09:15:39 GMT

KNA1.

SHIP to Party is also a Cusotmer , so u can get details from KNA1 and ADRC.If u have KUNNR OR KUNAG number.

u can also follow CHAND's POST If u have SO number.

THEN Y u started ur THRED with SD

in what process u are in ? MM or SD ?

Regards

Prabhu

Re: sd

Former Member — Tue, 24 Apr 2007 09:15:46 GMT

SELECT SINGLE ADRNR FROM VBPA INTO GV_ADRNR WHERE VBELN = GV_VBELV AND PARVW = 'WE'.

and from ADRC , u can get the address

Re: sd

Former Member — Tue, 24 Apr 2007 09:23:58 GMT

Ship to party is also a customer so you can find it in Customer Master Table and his address is in Adrc table

But to know the Customer Number of this Customer in VBPA Table this Customers

Partner function (PARVW) should be 'SH' or 'WE'.

The customers having this Partner Function will only be called as Ship-to-Party

Regards Rk

Re: sd

Former Member — Tue, 24 Apr 2007 09:26:03 GMT

Hi Prabhu,

Some say it is vendor address from lfa1.

Which is correct.

Exactly i have retrieved ebeln,vendor,date.. from ekko in one window. in second window i have to display the ship to address. Now here which one will come whether customer/vendor.

Regards,

Nasru

Re: sd

Former Member — Tue, 24 Apr 2007 09:45:05 GMT

Hi,

How to get the address when lifnr is given from kna1 and adrc.

Regards,

Nasru

Re: sd

Former Member — Tue, 24 Apr 2007 10:01:16 GMT

select single adrnr from kna1 into v_adrnr where lifnr eq v-lifnr.

select * from adrc into wa_adrc where addrnumber eq v_adrnr.