topic Re: Table maintanance generator problem in Application Development and Automation Discussions

Table maintanance generator problem

Former Member — Wed, 03 Sep 2014 13:13:00 GMT

Hi Experts,

I have created a Ztable with 5 fields like Field1,Field2,Field3,Field4,Field5. I have created Table maintenance generator for that table. I want to disable Field4(created By), Field5(created Date). I have modified in se80 tcode througg screen properties. I want to update the field4,Field5 fileds by sy-datum,sy-uname , How to do without using TMG events? Even TMG events also fine. but my firts preference is without TMG Events....Please give me some sample code. How to Modify the Extract table ?

Moderator Message: There are lot of discussions,documents,wiki links related to this topic. Please do some research before posting.

Message was edited by: Kesavadas Thekkillath

Re: Table maintanance generator problem

former_member202771 — Wed, 03 Sep 2014 13:50:28 GMT

Hi Srinath,

For default value, use TMG event - 05.

A work around is to write a report and run it as periodic batch job

loop the table and

loop ztable into lwa_ztable

lwa_ztable-field4 = sy-datum.

lwa_ztable-field5 = sy-uname.

MODIFY ztable from lwa_ztable.

ENDLOOP.

Thanks,

Anil

Re: Table maintanance generator problem

Former Member — Fri, 05 Sep 2014 02:14:17 GMT

Hi,

Click on the screen number assigned in the TMG, this will let you to screen painter & there you can play with screen fields.

Thanks!

Let me know if this helps you.

Thanks & Regards,

Anil Kumar Sahni

Re: Table maintanance generator problem

AnoopMayamkote — Fri, 05 Sep 2014 02:53:26 GMT

Hi,

Go to the screen painter and hide the fields what u want and you can do what ever you want in the Screen fields

Re: Table maintanance generator problem

former_member1716 — Fri, 05 Sep 2014 04:42:36 GMT

Hi Anoop,

Can you please help out with the below questions.

After reaching the screen painter how will you disable a particular field, is it possible to disable the primary key fields also?

regards,

Satish

Re: Table maintanance generator problem

AnoopMayamkote — Fri, 05 Sep 2014 04:53:55 GMT

Hi Satish,

in pbo write one module for that like

module modify screen.

inside the module write code like below.

LOOP AT SCREEN.

IF screen-group EQ 'group name '.

screen-input = 0.

MODIFY SCREEN.

ENDIF.

ENDLOOP.

Re: Table maintanance generator problem

AnoopMayamkote — Fri, 05 Sep 2014 04:56:34 GMT

Hi ,

Try this also

go to Se11->Table maintenace generation. Double click on screen to edit and assign the field you want to display/hide to groups. In PBO , after the following lines..

LOOP AT EXTRACT WITH CONTROL

TCTRL_ZMARA CURSOR NEXTLINE.

MODULE LISTE_SHOW_LISTE.

ENDLOOP.

Write a new module in PBO and edit the SCREEN as per the Tcode, you are calling,,'

Hope this helps you