topic Re: Problem updating table MVKE in Application Development and Automation Discussions

Problem updating table MVKE

Former Member — Thu, 31 Jan 2008 17:32:23 GMT

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 — Fri, 01 Feb 2008 03:43:31 GMT

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 — Fri, 01 Feb 2008 03:47:54 GMT

Hi,

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

Regards

Shiva

Former Member — Fri, 01 Feb 2008 08:35:56 GMT

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