topic Re: Search help using 2 tables in Application Development and Automation Discussions

Search help using 2 tables

Former Member — Fri, 02 Apr 2010 09:51:52 GMT

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,

Re: Search help using 2 tables

Former Member — Fri, 02 Apr 2010 19:49:01 GMT

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?

Re: Search help using 2 tables

Former Member — Mon, 05 Apr 2010 11:56:57 GMT

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.