Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Complex(Advance Join) In the Information design tool

Hi Experts,

I need to implement the join like below. When i added AND condition(Which is in BOLD below) manually,  I am seeing " No table found" from the tables table Drop down. Please see screen picture. Does it make a Cross Join when i use it in the reporting? Please advise with your thoughts.

FROM PO_HEADERS_ALL poh

inner join PO_LINES_ALL pol

    on poh.po_header_id = pol.po_header_id

inner join PO_DISTRIBUTIONS_ALL pod

    on pol.po_line_id = pod.po_line_id

inner join PO_LINE_LOCATIONS_ALL poll

    on poll.line_location_id   = pod.line_location_id

inner join mtl_system_items_b msib   

    on pol.item_id = msib.inventory_item_id

    AND poll.SHIP_TO_ORGANIZATION_ID = msib.organization_id

Regards,

Sree

Complex Join.PNG (33472 B)
Former Member
Not what you were looking for? View more on this topic or Ask a question