Problem updating table MVKE

[Former Member]

Dear Experts,

I'm trying to update MVKE-KTGRM on the basis of MBEW-BKLAS for which i need to join tables MVKE and MBEW.

Is it possible to do so and how?

Please help me guys.

B.Siddhesh.

[Former Member]

Hi, chk dis, may be of help.

In case of joining two database tables you need to use inner join. try this statement.

select ausp~objek

ausp~atinn

ausp~klart

ausp~atwrt

klah~class

into corresponding fields of table i_ausp

from ausp inner join klah

on ausp_{klart eq klah}klart.

regs,

hema.

[Former Member]

Hi,

Do you want to update database table or to pass it to internal table

Regards

Shiva

[Former Member]

Hi,

Thanks Hema & Shiva for your replies.

Shiva, i'm trying to update MVKE-KTGRM field of the database but on the basis of field MBEW-BKLAS.

But apart from MATNR field there no other key field common in these two tables which i can use to join them.

Any further suggestions?

regards,

B.Siddhesh