Skip to Content
0
Former Member
Jun 07, 2010 at 09:15 PM

Not able to add Join condition to SAP query

48 Views

Hi,

I want to create a query in SQ01 for the following criteria.

EKKO INNER JOIN LFM1

Conditions

EKKO-EKORG = LFM1-EKORG

EKKO-LIFNR = LFM1-LIFNR

I was able to create that using the graphical editor.

Now another condition has to be added.

From the resulting set i only have to display records that fulfil the criteria

EKKO-ZTERM not equal to LFM1-ZTERM

but im not able to add conditions like this to the inner join link in the graphical editor.

Is adding this condition possible in the graphical editor or do i have to write a ABAP program for this?