Search help - help

[Former Member]

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?

[former_member156446]

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

[Former Member]

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?

[prasenjit_sharma]

Hi,

Use left outer join for the table RESB.

Regards

Prasenjit

[Former Member]

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

[Former Member]

>

> 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

[former_member156446]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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