SAP Knowledge Base Article - Public

2319401 - Right / Full Outer Join between tables in a Canvas / ORD report using Advanced Reporting Data source


Is it possible to have Full Outer / Right Outer Join between tables in an Advanced Reporting query (REALMS)?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


  • SAP SuccessFactors HCM Suite
    • Online Report Designer / Report - Canvas: Advanced reporting


Product Working as designed


We currently do not have the option for Right outer or Full Outer joins in Advanced Reporting.

We only Inner and Left outer joins:


If you feel the feature is important, we request you to submit an enhancement request for the same.
2090228 - How to submit enhancement requests for SAP SuccessFactors products
This will allow other customers to vote up and thereby express their interest on the same.
Our Product management teams review enhancement requests regularly and implement them if and when feasible.


Advanced, Report, Reporting, REALMS, Canvas, ORD, join, types, Left, outer, full, inner, center , KBA , LOD-SF-ANA-ORD , Online Report Designer , Product Enhancement


SAP SuccessFactors HXM Suite all versions