Creating table view with text descriptions

[Former Member]

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

[Former Member]

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

[uwe_schieferstein]

Hello Nuno

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

Add the text field MAKTX to the view fields and set in the column labelled <b>P</b> (perhaps you have to use the horizontal scroll bar) and choose <b><u>R</u></b> (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

[Former Member]

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

[uwe_schieferstein]

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:

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

<b>- Event 05: When Creating a New Entry</b>

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

Regards

Uwe

[Former Member]

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