Skip to Content
0
Former Member
Feb 14, 2006 at 12:27 PM

JOINS and Matchcodes

47 Views

Hi All

On a selection screen I have parameter that has a search help atached in order to allow the user to select a KUNNR item from the KNA1 table. However, rather than the search help displaying all of the customer records I would like to restrict it to only those for which there is a certain type of sales item (VBAP). I have tried to do this by creating a view with a join in it and linking the matchcode for the parameter to this view. However, while this restricts the set to KNA1 records with a corresponding VBAP record, I don't seem to be able to make it 'distinct' so I end up with multiple rows for each KNA1 record.

Any help would be greatly appreciated - I'm new to ABAP so am probably missing something obvious!

Kind regards

Andy