topic Re: Table maintainance in Application Development and Automation Discussions

Table maintainance

Former Member — Thu, 21 Jun 2007 06:29:08 GMT

Hi friends,

When we try to assign transaction code for table maintainance generator..we are giving the VIEWNAME = ztable and

UPDATE = X.

May i know why we are givin this ...wats happend internally ?

wat is viewname and update ?

also pls tel me what is the difference in One step and two step table maintainace ?

ur matchin answer wil b defintely rewarded......

Thanks in advance ...

BALAJI

Re: Table maintainance

Former Member — Thu, 21 Jun 2007 06:32:58 GMT

in 2 step the first screen will display key fields and char fields while all other fields will be displayed in second screen.

now, if u go for 1 step all fields will be displayed in one screen which is a better view.

when you create a two-step maintenance, the first screen is made for giving only an overview to the user by presenting the key and some text. The second (detail-)screen shows the whole dataset.

However the generated screens have always had some kind of suggestional character. So a developer is invited to add or remove fields of his choice manually at the selected screen.

Assume your table has the fields KEY1; KEY2, F1, F2, and F2 has not been generated to the overview screen. After you have added Field F1 in the screen layout, just don't forget to add the appropriate field-statements to the flow logic like this:

process before output.

module liste_initialisieren.

loop at extract with control

tctrl_table1 cursor nextline.

module liste_show_liste.

endloop.

process after input.

module liste_exit_command at exit-command.

module liste_before_loop.

loop at extract.

module liste_init_workarea.

chain.

field table1-key1 .

field table1-key2.

field table1-f1.

field table1-f2. "<<<<<<<<<<<<<ADD

module set_update_flag on chain-request.

endchain.

field vim_marked module liste_mark_checkbox.

chain.

field table1-key1 .

field table1-key2.

module liste_update_liste.

endchain.

endloop.

module liste_after_loop.

Re: Table maintainance

Former Member — Thu, 21 Jun 2007 06:39:23 GMT

Hi Balaji,

wat is viewname and update ?

View name is nothing but table name for which u want to create t-code,

and update flag is for aloowing update the table.

For step 1 and step 2 as per above kishi suggestions exactly for that purpose we are using those two parameters.

Hope this helps you. Reply for queries, shall post the updates.

Regards.

Kumar

Re: Table maintainance

Former Member — Thu, 21 Jun 2007 06:45:34 GMT

Hi,

View name = ztable name --> this enables the user to correctly cal the particular ztable for which the tcode is created and table maintainence is done.

Update = X --> enables the user to give in new entries thro transaction SM31 when the table/its tcode is executed.

Diff betw one step and two step:

In 2 step the key fields and char fields wil b displayed in the first screen, while all other fields will be displayed in second screen.

but for 1 step all fields are simultaneously displayed in one screen.This 1 step is mostly preferred.

Hope this answer is helpful.

*****Reward points if so.

All the best