topic Re: Re : EKKO in Application Development and Automation Discussions

Re : EKKO

Former Member — Sun, 27 Jul 2008 15:11:47 GMT

Hi all,

I want to fetch the purchase order from EKKO table on PO typewise.

For example, If I want to fetch only third - party PO (which is item category BANC / BANS).

how can I achieve that ?

thnks in advance,

raghul

Re: Re : EKKO

Former Member — Sun, 27 Jul 2008 15:23:01 GMT

you can use EKPO-PSTYP in where conditon.

and JOIN EKKO and EKPO

REPORT  ZTEST_PO.

data: begin of it_po occurs 0,
          eblen type ebeln,
       end of it_po.

select ekko~ebeln
from ekko
join ekpo
on ekko~ebeln = ekpo~ebeln
into table it_po
where ekpo~pstyp = 5.

break-point.

Re: Re : EKKO

Former Member — Wed, 30 Jul 2008 01:52:52 GMT

thanks a lot...........