topic Re: Need Logic in Application Development and Automation Discussions

Need Logic

Former Member — Wed, 02 Jul 2008 02:48:58 GMT

Hi folks,

I have some records in a internal table which has fields like country, start_date etc... I need to find a record in a view, where the country field in the view must be match to country fielld in the internal table record. if it the record is there in the view, i need to update remaining fields of the view. can we compare a internal table record with the record in the view. If so, Could you pls sugest me how to do..

Thanks,

Shyam.

Re: Need Logic

Former Member — Wed, 02 Jul 2008 03:29:08 GMT

Hello Shyam,

loop at internal_table into wa_area.

read table view_table with key wa_area-country_key.

if sy-subrc = 0.

modify view_table from wa_area where wa_area-country_key.

endloop.

Please try with this logic. It might help you.

Regards,

Raghu

Re: Need Logic

Former Member — Wed, 02 Jul 2008 04:20:06 GMT

Hi,

The problem here is, it is a maintance view, so we cannot use select statement or read statement .

Re: Need Logic

Former Member — Wed, 02 Jul 2008 05:42:55 GMT

Hello

Yes, we can compare a internal table record with the record in the view. But we can not modify/insert record in the view.

Goto SE11 -> View -> Display -> Table/join conditions

There are one or more tables in block 'Tables'. May be you need update fields of those tables ?

Re: Need Logic

Former Member — Wed, 02 Jul 2008 10:10:18 GMT

Hi shyam,

You can directly maintain/upadate table using insert/modify.

no need to update maintainance view.