Table maintenance generator

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

Try this one, in se93,

Add the following:

Name of the Screen Field as 'UPDATE' and

Value as 'X'.

Regards,

Viji

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi Raj,

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

REgards,

viji

[Former Member]

Hi Viji,

I want create a new entries and display entries.

plz help me out.

Thanks.

Raj.

[Former Member]

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 <b>UTILITIES->TABLE CONTENTS-->CREATE ENTRIES</b> enabled from SE11.

Hope this helps,

Sajan Joseph.

[Former Member]

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.

[Former Member]

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 "<b>veiw fields</b>" tab, enter <b>'S' in column 'P'</b> for the fields which you want in the selection screen. (<b>you will not see this column unless you scroll the horizontal scroll bar to the left</b>)

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.

[Former Member]

hi Raj,

The view you created for the pupose has to be a <b>Maintenance view</b>.

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.