Search help using 2 tables

[Former Member]

Hello Experts,

Consider 2 tables MARA and ZCODES.

1) I have the material number entered by the user on the screen.

2) Now in need to get the Product hierarchy for this Material and get the codes from ZCODES for this Product hierarchy.

3) This Codes are also stored in the table MARA-ZCODE.

My Searchhelp should be responsible for showing me all the materials for this ZCODEs.

Regards,

[Former Member]

Have you tried creating a Help view in SE11, joining the tables? Or, alternatively, constructing a help with function module F4IF_INT_TABLE_VALUE_REQUEST?

[Former Member]

You need to create a database view having table MARA and ZCODES. Specify the join conditions in that view.

And the create a search help using that view name.