‎2007 Apr 06 1:16 AM
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 ?
‎2007 Apr 06 1:30 AM
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
‎2007 Apr 06 1:33 AM
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
‎2007 Apr 06 3:10 AM
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
‎2007 Apr 06 5:15 AM
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
‎2007 Apr 06 5:26 AM
Hi Sanju,
Let me know If u need any clarifications on this ......
regards
‎2007 Apr 23 11:40 PM
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