topic Re: Table maintenance generator in Application Development and Automation Discussions

Table maintenance generator

Former Member — Wed, 14 Mar 2007 04:45:23 GMT

H All,

I created a Ztable and i created Tcode for that Ztable.

My queries is we can add a selection screen for search help and for new entries in the maintenance program for the table.How? and tell me the procedure.

Pl help me out.

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 05:15:41 GMT

Yes,

U can add sel screen.

In Se93,

- transaction with variant

-skip initial screen (tick the checkbox)

use these selections

1)in name of screen field ,give -VIEWNAME,

in value, give ur table name.

2)Then in the next line

Name of the Screen Field as 'SHOW_LTD' and

Value as 'X'.

Regards,

Viji

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 05:20:08 GMT

hi Raj,

yes we can have this selection screen for restricting the data to be displayed in the maintenance screen.

step1: create a maintenance view for the table from SE11.

step2: in the "veiw fields" tab, enter 'S' in column 'P' for the fields which you want in the selection screen. (you will not see this column unless you scroll the horizontal scroll bar to the left)

step3:now create the maintenance screen (one step).

goto sm30 and maintain/display the view, you will first get a popup with the fields you want to restrict the data.

Hope this helps.

Sajan Joseph.

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 05:59:16 GMT

Hi Vijaya,.

As per ur suggestion i tried .

I selected some of fields and i enter values in that fields,but that values is not updating in database for that particular Ztable.

Plz help me out.

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 07:21:56 GMT

Hi,

Try this one, in se93,

Add the following:

Name of the Screen Field as 'UPDATE' and

Value as 'X'.

Regards,

Viji

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 07:40:56 GMT

Hi,

Try this one, in se93,

instead of show_ltd,

use the foll,

Name of the Screen Field as 'UPDATE_LTD' and

Value as 'X'.

Regards,

Viji

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 07:53:45 GMT

hi Raj,

The view you created for the pupose has to be a Maintenance view.

When you insert values into a maintenance view from SM30, the records

get updated in the underlying database table; this is SAP standard.

There might be some mistakes from our side, while creating the view, or

while inserting records from SM30.

Hope this helps,

Sajan Joseph.

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 08:45:58 GMT

Hi Viji,

I tried as per ur suggestions,but its not working.

Giving error message as in status bar "No entries found that match selection criteria".

Plz help me out.

Thanks.

Raj Kumar.

Re: Table maintenance generator

Former Member — Wed, 14 Mar 2007 15:57:42 GMT

Hi Raj,

U need to display the table entries or u want to change the table entries or create new entries?

REgards,

viji

Re: Table maintenance generator

Former Member — Thu, 15 Mar 2007 04:17:17 GMT

Hi Viji,

I want create a new entries and display entries.

plz help me out.

Thanks.

Raj.

Re: Table maintenance generator

Former Member — Thu, 15 Mar 2007 04:32:15 GMT

hi Raj,

Initially, your query was how to include selection screen for some particular

fields. For this query the solution posted as the second answer in this thread

is the right one (create maintenance view for the table and the maintenance generator has to be based on this maintenance view).

if you just want to create and display table entries, you dont require even a maintenance generator!

In the technical attributes of the table, choose the option table maintenance allowed. Then you wil get the option in UTILITIES->TABLE CONTENTS-->CREATE ENTRIES enabled from SE11.

Hope this helps,

Sajan Joseph.

Re: Table maintenance generator

Former Member — Thu, 15 Mar 2007 06:04:34 GMT

Hi ,

I created a Ztable and i created Tcode for that Ztable.

How to include selection screen for some particular

fields in the maintenance program .

My queries is we can add a selection screen for search help and for new entries in the maintenance program for the table.How? and tell me the procedure.

Pl help me out.