topic Re: plz solve this problem in Application Development and Automation Discussions

plz solve this problem

Former Member — Mon, 14 Aug 2006 08:03:01 GMT

i have to tables zfm_kfz and zfm_kmvrg.

zfm_kmvrg fields are kfznr ( carno), kostentraeger(costcenter) kmstand(kilometers)

how to maintain data in a table zfm_kmvrg and update the kmstand in the table zfm_kfz table.

i already creating table control for zfm_kmvrg

Re: plz solve this problem

Former Member — Mon, 14 Aug 2006 09:07:38 GMT

Hi Narendra,

This is just suggestion.

You can create a table maintenance view (tcode : se11) that contains these 2 tables. you should mention the foreign keys for the second table.

After you create the view, you can create table maintenance (Utilities -- Table Maintenance Generator).

Hope it will solve your problem.

best regards,

yudie

Re: plz solve this problem

Former Member — Mon, 14 Aug 2006 09:17:52 GMT

Hi,

There are many ways of maintaining data in two tables. Some of them :

1. Through ABAP Program

2. Using Maintenance View

Since you already have a table control in place, you can do the updation programmatically. Let`s consider the belowsaid:

After inserting values for the first table, you can move the corresponding values from the table control to the second database table. Now insert the values, this will serve your need.

Reward if helpful.

Regards

Re: plz solve this problem

Former Member — Mon, 14 Aug 2006 09:24:19 GMT

i was implament new subscreen in me21n with badi

ME_GUI_PO_CUST , now i want to add field to ekpo

and apdate him when save the document ( in me21n ) .

how can i do it ?

i add my field to ekpo .

thanks .