EKBE show on report even if blank

[Former Member]

I have linked tables in the following order EKPO EKET, EKKO and EKBE.

I have got the report to show Purchase order, line item, stat date etc, but when I add EKBE, I only get shown purchase orders which have a transaction done on them already.

I want the query to show all purchase orders and lines whether it has had a movement on it or not.

Basically, I want this report to show whether a movement has been done or not on a purchase line item.

I have searched everywhere and cannot find an answer.

Please help.

Thanks

Pete

[sachin_yadav3]

Hi Peter,

Could you please copy the query which you are using to combine the tables.

Regards

Sachin

[Former Member]

I am just running a report using sq01. I dont have any code

I have the tables setup in the following order

EKPO

EKET

EKKO

Then I need to add EKBE to EKET.

when I run the report on sq01, I filter by EKET-SLFDT.(Stat Date).

Before I add EKBE to the infoset I get every purchase order.

But then I add EKBE and it only shows purchase orders which have a movement against them

[ThomasZloch]

That's likely due to an inner join of table EKBE, means that you only see a result when EKBE has entries for the PO line item.

Try changing this to an outer join (also called left join) and compare.

Also look for additional information on the logic behind inner and outer joins.

Thomas

[Former Member]

Thanks Thomas,

I just put EKBE as an outer join and it worked.

Only been using SAP for a few weeks so wasnt aware of outer joins.

Thanks again.

Pete