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

Table maintenace generator

Former Member — Fri, 06 Apr 2007 00:16:36 GMT

Hello Expert's

I have few requirement regarding table maintenance generator,for a given 'Z' table

i need to create a table maintenance generator , but here is the twist , it

is going to be call from a tcode , i know how to assign tcode to a table , but

the requirement is when user enter tcode , it should bring a selection screen

for that table and based on the entry in selection screen , record should get

displayed in table maintenace generator . How to design these initial screen

is my question ?

Re: Table maintenace generator

Former Member — Fri, 06 Apr 2007 00:30:06 GMT

Hi,

Create a report with the selection screen for filtering the data..

Then use the FM VIEW_MAINTENANCE_CALL to call the table maintenance screen..

You can also pass the values in the parameter DBA_SELLIST

Thanks,

Naren

Re: Table maintenace generator

Former Member — Fri, 06 Apr 2007 00:33:35 GMT

Hi,

In the default values for transaction enter SM30.

name of the screen field values

VIEWNAME zf_tablename

SHOW X

UPDATE X

you may enter as many values as provided in the F4 dropdown of the screen field and enter a value for that .

Thanks

Dany

Re: Table maintenace generator

Former Member — Fri, 06 Apr 2007 02:10:02 GMT

Hi, sanju joseph

When you make a maintenace view, You have to set 'Maintenance attribute for view field' with <b>'S' for selection.</b>

refer this one.

Maintenance attribute of a field for a maintenance view.

You can use the maintenance attribute to define how individual fields of a maintenance view can be maintained. There are the following options:

R : Only read access allowed. Maintenance using the table view maintenance transaction (SM30) is not allowed for such fields.

<b>S : Generate subsets when maintaining view data. A subset of the data determined by the value entered in this field is displayed.</b>

H: The field is not displayed for the user in the interactive maintenance transaction. The field therefore does not appear in the maintenance screen. The user himself must make sure that such fields have correct contents. Such fields are empty as default value.

: No restrictions with respect to field maintenance.

Hope this helps.

Regards.

Kyung Woo

Re: Table maintenace generator

shishupalreddy — Fri, 06 Apr 2007 04:15:21 GMT

Hi ,

Just one month I did the same kind of task.

Follow the steps.

1. create a report program with selction screen .

2. select the data in to ITAB .

3. Pass the data in ITAB to a MEMORY ID using EXPORT statement.

4. Now use CALL TRANSACTION <tmg transaction> and SKIP first screen .

5. Create a tcode for the report created.

Now go to FUNCTION GROUP OF Table maintenece generator.

1.select PBO of the screen .

2. write a module

MODULE data_select.

In the MODULE

ENDMODULE

WRITE THE FOLLOWING CODE.

module data_sel_output output.

DATA : JTAB like<TABLE NAME> OCCURS 0 WITH HEADER LINE.

IMPORT itab = jtab from memory id 'ABCD' .

LOOP AT total.

read table jtab with key matnr = total+3(18).

if sy-subrc ne 0.

delete table total.

endif.

endloop.

endmodule. " data_sel_output OUTPUT

YOUR REQUIREMENT WILL BE FULLFILLED.

THANKS

Re: Table maintenace generator

shishupalreddy — Fri, 06 Apr 2007 04:26:45 GMT

Hi Sanju,

Let me know If u need any clarifications on this ......

regards

Re: Table maintenace generator

Former Member — Mon, 23 Apr 2007 22:40:17 GMT

Hi,

Can you please elborate your point as i am not able to get the clear

picture of what exactly i need to do

thanks in advance