topic Re: Sales Orders with diffrent partner functions in Application Development and Automation Discussions

Sales Orders with diffrent partner functions

Former Member — Mon, 07 Jul 2008 18:51:27 GMT

Hi,

I wanted to find all the sales orders for which sold-to-party is diffrent than ship-to party.

can you help me.

Thanks in advance

jack

Re: Sales Orders with diffrent partner functions

former_member156446 — Mon, 07 Jul 2008 19:01:59 GMT

select vbeln posnr parvw kunnr
      from vbpa into it_vbpa
  where vbeln in so_vbeln.

loop at it_vbpa into wa_vbpa where parvw = 'AG'.
     read table it_vbpa into wa_buff with key vbeln = wa_vbpa-vbeln
                                                              posnr = wa_vbpa-posnr
                                                              parvw = 'WE'.
if sy-subrc eq 0.
if wa_vbpa-kunnr = wa_buff-kunnr.
delete it_vbpa index sy-tabix.
clear: wa_buff, wa_vbpa.
endif.
endif.
endloop.
"<<finally it_vbpa will contain all such entries which Sold to is not equal to ship to..

Edited by: Jay Sadaram on Jul 7, 2008 12:02 PM

Re: Sales Orders with diffrent partner functions

Former Member — Mon, 07 Jul 2008 19:16:40 GMT

Hi,

Select data from vbpa as shown below:

data: i_vbpa type standard table of vbpa-vbeln.

select a~vbeln

from vbpa as a

inner join vbpa as b

on a_{vbeln = b}vbeln

and a_{kunnr <> b}kunnr << Not equal to sign not displaying by editor

into table i_vbpa

where a~PARVW = 'AG'

and b~PARVW = 'WE'.

check sy-subrc = 0.

Regards,

Joy.

Edited by: Joyjit Ghosh on Jul 7, 2008 9:17 PM