TMG

[Former Member]

hello all,

My requirement is ...

Fields	Property	Default value
Material
Created on
username	INVISIBLE	SY-UNAME
date	INVISIBLE	SY-DATUM
time	INVISIBLE	SY-UZEIT
indicator	INVISIBLE	(A/U)
A- Addition U- Update

Create a Z table and maintain entries in it through TMG.

In TMG, the columns – username, date, time, indicator should be invisible and it should get updated whenever the user entering the value.

The indicator field should be updated -  ‘A’ on putting new entry, ‘U’ – on editing the current entry.

can anyone tell  me how to do this ..

thanks in advance .

[Former Member]

Hi Nitin,

In TMG you can use EVENTS for achieving this.

In se11 Menu bar, choose Utilities >> Table Maintenance Generator.

Here  in Environment >> Modification >> Events.

Hope this will help you

Thanks & Regards

Manu S

[Former Member]

Thanks , i got it and done it sucessfully..:)

Can u please tell me which event i have to use for the updation purpose.

Thanks in advance.

[Former Member]

Hi Nitin,

You can use the 'before save' event that is - '01', check whether that entry is already there in the table using the primary keys and Update the table as 'U' as per your requirement  

Hope this will solve your issue

Thanks & Regards

Manu S

[sivaganesh_krishnan]

Hi nitin,

For making the fields to be invisible . check out this link :How to hide fields in Table maintenace screen | SCN

For Updating the values in TMG on saving , You have to write your logic in  events using TMG.

Please do refer : http://scn.sap.com/docs/DOC-10318                           http://help.sap.com/saphelp_nw70/helpdata/en/91/ca9f0ba9d111d1a5690000e82deaaa/content.htm

Regards,

Sivaganesh.

[former_member392866]

Hi Nitin,

We have Events concept in in Data dictionary. Please follow below steps

-> Go to se11 and open the table name in change mode.

-> Go to utilities tab and click table maintenance generator option.

->  Go to Environment and go to Modification and click on events

-> now click on New entries and provide values as  01(event)--------ZFORM_CUSTOM(form routine)  and press enter.

-> Now editor will enable beside form routine and go to that routine and write custom logic what ever you want .

Hope this will helpful to you to resolve your problem .  Thank you .

Regards,

Balaji.

[Former Member]

Hi Nitin,

In TMG you go in change mode and follow the path in below screen shot as:

Then against the following events you can write your form routines to achieve your requirement:

[Former Member]

Hi Nitin,

The following link will guide you step by step process:

<removed the external link>

Regards

Purnand

Message was edited by: Suhas Saha

[Former Member]

Hi Nitin,

You can try opening the TMG screen,which gets created by default when you create TMG. Then make the screen invisible by double clicking the field and then checking the check box.

Hope this helps.

Regards,

Supratik

[RaymondGiuseppi]

IMHO easiest way

• Create a maintenance view, declare fields to be hidden... as hidden fields, or read-only if you want, - Maintenance Attribute of a View Field
• Use events to fill those fields, e.g. Event 01 before saving the data in the data (Filling background fields)

Regards,

Raymond