topic Re: show check table value in Application Development and Automation Discussions

show check table value

Former Member — Thu, 17 Jul 2008 08:32:22 GMT

Dear,

I created new Z table (database table) and it contains the wage type code (lgart). When entering new data in the table (with SM30) the user wants to see the description (lgtxt) from table T512T immidiately when the code is entered. So the text of the wage type has to be shown on the screen of the table maintenance.

Re: show check table value

naveen_inuganti2 — Thu, 17 Jul 2008 08:35:44 GMT

Hi...,

If you created a field with same name as database field and dataelemnet of that field it will automatically shows the description of data element in TMG.

Now tell me what is the problem in ur case..,

Thanks,

Naveen.I

Re: show check table value

Former Member — Thu, 17 Jul 2008 08:37:05 GMT

Hi,

create Event in table maintenance and generator...

Re: show check table value

Former Member — Thu, 17 Jul 2008 09:06:22 GMT

I want the same as on SM30 for V_T555J, when you enter there the time type, the column "time type text" is filled. I need this for the wage type

Re: show check table value

RoySayak — Thu, 17 Jul 2008 09:07:21 GMT

Hi,

You need to show the text of the wage type on the screen of the table maintenance.

Go to the Table Maintenance Generator screen of that Z(database table) table. Utilities --> TMG.

Then go to the events of that table where you can code your requirement. Environment --> Modification --> Events.

There you can write your own form routine.

Best Regards,

Sayak...

"Giving points for helpful answer is always appreciating"

Re: show check table value

Former Member — Thu, 17 Jul 2008 09:37:28 GMT

Hi vprake,

1. For this, one Z table will not suffice.

2. Create another Z VIEW with the above table

and also put T512T table with proper joins.

3. Include the field for text LGTXT in this view.

4. Then create a table maintenance for this view,

then it will work.

5. After creating the table maintenance, u can

disable the field for text field LGTXT by

modifying the screen attribute of that field,

in that function group.

regards,

amit m.

Re: show check table value

Former Member — Thu, 17 Jul 2008 09:44:55 GMT

There are two ways for doing this approach :

1. Using the Events :

Go to the Table Maintenance Generator screen of that Z(database table) table. Utilities --> TMG.

Then go to the events of that table where you can code your requirement. Environment --> Modification --> Events.

There you create the rountine and code in '05'.

2.Using the Function Group :

Same like Module Pool programming but this is the bad approach for table Maintenance because whenever you change the structure of table and activate it, it results the loss of ur code.

Re: show check table value

Former Member — Thu, 17 Jul 2008 10:37:10 GMT

Yhank you amit, point 5 is the trick