topic Refresh data in Table Maintenance view in Application Development and Automation Discussions

Refresh data in Table Maintenance view

Former Member — Tue, 16 Nov 2010 20:45:46 GMT

Hi,

I have created a table maintenance view for db table A and added my function button to this view. When I click the button I append a few records to the table A from table B. But this recoreds are not displaied in the view.

If I rerun the view I can see added records.

How I have to refresh the view to display added records?

Regards,

Ilya

Re: Refresh data in Table Maintenance view

former_member211627 — Tue, 16 Nov 2010 21:39:15 GMT

Hi Malnor

Try to use a COMMIT WORK after the INSERT statement.

Regards

Jesus Martinez

Re: Refresh data in Table Maintenance view

Former Member — Tue, 23 Nov 2010 04:32:56 GMT

Hi Jesus,

COMMIT WORK isn't help me.

I found that I have to use TOTAL and EXTRACT structures to modify data in maintenance view.

It's fine. I do something like this in my FM

MODULE 9CUSTOM_PF_BUTTON INPUT.

...

lt_total[] = total[].

lt_extract[] = extract[].

CASE function.

WHEN '9DOWNSH'.

.......

modify lt_total from wa_total.

modify lt_extract from wa_extract

ENDCASE.

total[] = lt_total[].

extract[] = lt_extract[].

ENDMODULE. " 9CUSTOM_PF_BUTTON INPUT

But TOTL and EXTRACT tables contain data of the current maintenance view.

I work with a view cluster and I have to append or delete records from one view if I do something in other view.

How I can modify data one view from another maintenance view?

If I have modified database tables directly I don't see changes in the view cluster.

Regards,

Malnor

Edited by: Malnor on Nov 23, 2010 9:19 AM

Edited by: Malnor on Nov 23, 2010 9:38 AM