Skip to Content
avatar image
Former Member

Realtionship between tables

Hello,

i have created a quick view and it works fine.

Now i need an additional field STZU-CSTEXT. How can i connect both tables?

if i try to connect table MAST with STZU, i only get a result from 1 row from my QuickView.

If there is no STLNR table MAST, i need the rest information in the Quick View (Screenshot).

Thanks, Mike  

pic.jpg (164.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 16, 2015 at 07:22 AM

    Hello Mike,

    Sounds like you want to use STZU table more than once to join to different tables: If it is the case Alias tables is the answer. See my post here: Alias Tables in Infosets and QuickViews

    Good luck

    KJogeswaraRao

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry I did not notice that the previous join is also Left outer. You can try other option also by removing the previous left outer join (MARC-MAST) and having the MST-STZU as left outer.

      Perhaps that's all from me.

      Regards

      KJogeswaraRao