topic Table maintenance issue in Application Development and Automation Discussions

Table maintenance issue

Former Member — Fri, 21 Aug 2009 12:06:22 GMT

I have created Table maintenance generator for a custom Transparent table.

In the table there are fields suppose ABC (some company code in it), XYZ (having company name description for the respective ABC fields value). Now when i create a new entry in this table thru SM30, i enter company code(field ABC) value as '10', now when i hit ENTER key the company description (XYZ field) should be populated automatically. i have attached Explicit search helps for the fields required.

How should i get the description populated automatically?

Regards,

Manjari

Re: Table maintenance issue

Former Member — Fri, 21 Aug 2009 12:12:22 GMT

Hi Manjari,

Why are you storing the company code description in your table? It's already stored in T001. You are duplicating data and iIf T001 gets updated all of your Z-table entries will all have the wrong text.

Create a view that joins your z-table to T001 instead.

Regards,

Nick

Re: Table maintenance issue

Former Member — Fri, 21 Aug 2009 12:15:06 GMT

i agree but as per the requirement i need to get the description populated when i hit ENTER key..

Re: Table maintenance issue

Former Member — Fri, 21 Aug 2009 12:20:12 GMT

Hi,

Would a view joining your Z-table and T001 not satisfy this requirement?

Regards,

Nick

Re: Table maintenance issue

Former Member — Fri, 21 Aug 2009 17:02:31 GMT

HI,

In order to get the description automatically populated, do the field level enhancement on the table.

in the table go to utilities, table maintenance generator, there double click on the screen number, which will take to the screen elements.

in the screen under which ever field you want the data to be auto populated, in the chain -endchain of the fields

write the statement module sub_description next to the company code field.

double click on the module sub_description, it will take to the pbo module of the table.

in the module,

you will have the entries available in the chain loop.

based on the chain loop entry, pass the entries to T001 table and get the description.

now assign the description to the field description.

save and activate it.

From next time onwards, when ever the company code is given, description will be automatically populated.