Empty mtart when joining MARA and MAKT tables

[maybeabapjunior]

Hi,

I've been trying to do a join between the MARA and MAKT tables on a help view with a where condition on mtart must be equal to 2 material types.

The result should be display the matnr, mtart and maktx fields of all the materials that have these 2 types, but when I display the search help on a select options it shows the materials with these 2 material types plus some materials with an empty mtart field.

How can I do the where condition to not display these materials with empty mtart?

[xiaosanyu]

Please provide your SQL code.

[adityaIngale]

Hi maybeabapjunior,

Add one more condition
where mtart NE ' '.

Regards,
Aditya

[FredericGirod]

Maybe you have set an AND between the two MTART selection criterias

[xiswanto]

if search help is your issue, then use a custom search help or declare inline search help instead of using the standard one.

[raymond_giuseppi]

Basically, look at definition of help view

• Table/join Conditions (between MARA and MAKT)
• Selection Conditions (MAKT-SPRAS and MARA-MTART < some AND/OR typo?)