topic Re: Search help - help in Application Development and Automation Discussions

Search help - help

Former Member — Wed, 21 Oct 2009 21:01:39 GMT

I am trying to create a search help which will run in MMBE for available batches with available quantity. I am having problem in that creating the view using tables MCHA, MCHB, and RESB uses an inner join. This causes issues because if there is no record in RESB, then no values are returned. Can anyone help with a way to get this to work correctly?

Re: Search help - help

former_member156446 — Wed, 21 Oct 2009 21:33:58 GMT

when there is not matching record, its obvious no data will be poped up..

machb-matrn = resb-matnr
machb-werks = resb-werks
            lgort =             lgort
             charg = charg

Re: Search help - help

Former Member — Wed, 21 Oct 2009 21:56:06 GMT

I understand this, as it is stated in my question. The goal is to show "available batches" = clabs - bdmng, in the search help. I have the calculation to work but am unsure of how to get the data needed for all cases. How is this possible?

Re: Search help - help

prasenjit_sharma — Wed, 21 Oct 2009 23:20:59 GMT

Hi,

Use left outer join for the table RESB.

Regards

Prasenjit

Re: Search help - help

Former Member — Thu, 22 Oct 2009 05:23:47 GMT

Hi Justin,

Better use left outer join for the table RESB in ur case, since you need the records which are not matching with other table.

Try this, you may find solution.

Regards,

Sujatha

Re: Search help - help

former_member156446 — Thu, 22 Oct 2009 05:56:52 GMT

[Creating Views|http://help.sap.com/saphelp_nwce711/helpdata/en/48/57a333956b72d0e10000000a42189c/content.htm]

Re: Search help - help

Former Member — Thu, 22 Oct 2009 09:40:08 GMT

in that case rather make and exit dan using view. use inner join and make ranges in select query

Re: Search help - help

Former Member — Fri, 23 Oct 2009 09:09:26 GMT


> Hi Justin,
> 
> Better use left outer join for the table RESB in ur case, since you need the records which are not matching with other table.
> 
> Try this, you may find solution.
> 
> Regards,
> Sujatha

As my knowledge, We can not create left outter join in a search help view.

For this situation, you can create a search help exit. It may solve problem

Regards,

Thien

Re: Search help - help

Former Member — Fri, 23 Oct 2009 13:20:42 GMT

I have tried creating a view as a "help view" which should be outer join, but the cardinality does not allow the tables to be joined. You can only go RESB to MCHA OR MCHB to MCHA, but not all three Can you pull new information into a search help exit or does it only use the data that is in the view? Sorry, I am traveling and am unable to try this at the moment.

Re: Search help - help

Former Member — Fri, 23 Oct 2009 13:37:40 GMT

You should create a search help exit. Then select from first two tables and add values that are not in the list.