topic Re: Maintenance View with Subset Fields in Application Development and Automation Discussions

Maintenance View with Subset Fields

Former Member — Thu, 05 Aug 2010 06:16:04 GMT

Hi All,

I have created a maintenance view based on a single DB table. Two key fields are defined to be as subset fields. No selection conditions are added to the view. I have used table maintenance genrator to define the screen (one step) along with the events.

In SM30, i get the popup to fill the subset fields.

I have created an event for AA (to replace default read). I am filling total attribute here.

a) Is there some other attribute that i need to fill apart from total?

I receive following dump

" Exception condition "NO_VALUE_FOR_SUBSET_IDENT" is raised"

When i set <status>-sbsid_rcvd = 'R' in read routine along with total, then the above exception doesn't appear.

But filtering based on the subset values doesn't happen automatically.

b) I also need have to have routines to perform insert, copy and validation.

c) Would the contents displayed be automatically filtered based on the subset values or we need to process this in user routines for read and so on?

As i find very limited documentation available for maintenance views with subset fields, could you suggest me some example to do the above?

Thanks in Advance,

Regards,

Rekha

Re: Maintenance View with Subset Fields

bbalci — Thu, 05 Aug 2010 20:48:36 GMT

Hello Rekha,

Yes I've same idea, documentation for maintenance screens is inadequate.

But there is way to find examples for all events,

table TVIMF is storing the Table name - Event - Form name columns.

For example when u want to do something about "creating a new entry"

Just go se11 > Table maintenance generator and find related event : 05

- Then go to TVIMF and display a record for event = 05

- than go to function group of maintenance screen of the TABLE in that record

- find the subroutine form ( TVIMF-FORMNAME) in that function group

This is a working example for that event, try or copy & use.

I hope it helps you for the coding for all the events.

Bulent

Edited by: Bulent Balci on Aug 5, 2010 11:28 PM

Edited by: Bulent Balci on Aug 5, 2010 11:29 PM

Re: Maintenance View with Subset Fields

Former Member — Thu, 12 Aug 2010 09:08:11 GMT

Hi Bulent,

Thanks a lot for the information. It was indeed a good way to check the possible existing implementations.

Right now, the design has changed. We are using view clusters now. So, is this the same approach (TVIMF table) to view examples for view cluster events?

I would like to know, how i could prefill subset fields with values based on header node selection. Also, i do not want the popup to appear. I would like to pre-fill the values.

Thanks in Advance,

Regards,

Rekha

Re: Maintenance View with Subset Fields

bbalci — Fri, 13 Aug 2010 06:22:28 GMT

Hi Rekha

I think you've a misunderstanding about view clusters

super node and sub node tables should be binded with foreign key relationship in a view cluster

so this fields has to be filled automatically by super node table already.

You can only see popups when you open a view containing fields with type

"S View field is used to form subsets" in SM30 directly - out of view cluster,

or if you set relationships wrongly for view cluster in se54.

So you can't see popups in view clusters already.

You can use same events ( from TVIMF ) To set default values for every field for a table

just like this approach.

Re: Maintenance View with Subset Fields

gokul_radhakrishnan3 — Thu, 18 Aug 2011 02:06:09 GMT

Just a correction. You have to check table VCLMF and not TVIMF for view cluster events.