SQ01 - Creating Query on Eine and Eina

[Former Member]

Hi,

I have created a query on SQ01, joined these two tables together and assigned it to a user group.

When I execute the query, the Purchasing Info Record Number field (which is my join condition) is blank.

Does anyone know why this is?

Many Thanks,

[Former Member]

Hi,

Thanks for the replies.

I think im currently using an INNER JOIN, how can I change this to LEFT OUTER JOIN?

Below is a screenshot of the join

Thanks

[Former Member]

Dear Brian,

please go through the link it may help u.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6018c1ae-8c44-2d10-6ea9-c3fad2c82...

regards

raj

[Former Member]

I followed these steps and it worked

Many thanks for the help

[former_member184701]

Brian,

I can't believe there is no standard report to meet your requirements...

What are you after?

regards,

[former_member184701]

dear,

please make sure you use Left Outer Join

regards,

[Former Member]

check in the the database table whether the data exist against that field you selected?

Raj

[former_member184701]

Raj,

do you respond to Brian or me ?

regards,

[Former Member]

Dear PIPO,

sorry for dt ,its for Brian.

regards

[former_member184701]

not a problem mate

[Former Member]

Hi Brian,

Please show your join condition screen shot.

[moazzam_ali]

I have tried with SQVI and it is working perfectly. It should also work in SQ02 and SQ01. You should also try first in SQVI if it works or not and then check your assignment of info set to user and check whole process. It should work.