cannot join table for table pool

Former Member — Wed, 03 Dec 2014 09:43:28 GMT

Hi All!

Kindly need ur help

i want to get the tax rate, below is the logic

based on EKKO-EBELN, match EKKO-KNUMV = KONV-KNUMV; and
based on EKKO-EBELN = EKPO-EBELN and where EKPO-EBELP = KONV-KPOSN display where KONV-KSCHL = “ZMIT”, display KONV-KBETR / 10

i did try to get the data through join table, but, it cant.

Thanks and Regards

liyana

Re: cannot join table for table pool

Former Member — Wed, 03 Dec 2014 10:07:18 GMT

Hi Liyana,

You should select knumv from konv to a itab first. Then use itab to :

select ekko join ekpo

FOR ALL ENTRIES IN itab

ekko-knumv = itab-knumv.

regards,

Archer