topic Re: Creating table view with text descriptions in Application Development and Automation Discussions

Creating table view with text descriptions

Former Member — Fri, 10 Aug 2007 10:43:05 GMT

Hello everyone,

I need to create a table view to a table ZMATERIAL (example) that needs to enter MATNR and MAKTX. But when i insert the material number and press enter, the view should automatically search the text description MAKTX of that material on it's respective table.

How can i do this ?

Thank you,

Nuno

Re: Creating table view with text descriptions

uwe_schieferstein — Fri, 10 Aug 2007 10:53:35 GMT

Hello Nuno

Add table MAKT to your view (using button Relations) on tabstrip Tables/Join Conditions).

Add the text field MAKTX to the view fields and set in the column labelled P (perhaps you have to use the horizontal scroll bar) and choose R (view field can only be read).

When you enter a material into your view you have to push the ENTER button. Then the view automatically adds the material text.

Regards

Uwe

Re: Creating table view with text descriptions

Former Member — Fri, 10 Aug 2007 11:16:38 GMT

Thank you, Uwe, for your fast answer. It works fine with one material. But now i have one more doubt: imagine that my table ZMATERIAL has two table keys MATNR1 and MATNR2, and in the view i need to add the maktx of both material. Where do i specify that ?

Nuno

Re: Creating table view with text descriptions

uwe_schieferstein — Fri, 10 Aug 2007 11:29:49 GMT

Hello Nuno

Most likely my variant works only for a single material number. In this case you have to use table maintenance events:

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/91/ca9f0ea9d111d1a5690000e82deaaa/content.htm">Extended Table Maintenance Events</a>

Probably you have to use two or three events:

- Event AA: Instead of the Standard Data Read Routine (Here you read to material texts for both possible materials per record)

- Event 05: When Creating a New Entry

- Event 08: After Correcting the Contents of a Selected Field (when the user changes the second material number)

Regards

Uwe

Re: Creating table view with text descriptions

Former Member — Fri, 10 Aug 2007 13:16:17 GMT

Thank you, Uwe. Solved problem with the maintenance events.