cannot join table for table pool

[Former Member]

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

[Former Member]

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

[Former Member]

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