Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table maintenace generator

Former Member
0 Likes
867

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 ?

6 REPLIES 6
Read only

Former Member
0 Likes
819

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

Read only

Former Member
0 Likes
819

Hi,

In the default values for transaction enter SM30.

In

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

Read only

Former Member
0 Likes
819

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

Read only

shishupalreddy
Active Contributor
0 Likes
819

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

Read only

0 Likes
819

Hi Sanju,

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

regards

Read only

0 Likes
819

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