Skip to Content

InfoSet using Master Data table

Hi All,

I have a requirement to change the already existing Z info set like below:

Scenario:

My Infoset is having 1 base DSO (i.e. BD1) connected with 7 different DSOs (i.e. D1,D2...D7) via left outer join. Now my requirement is to connect a master data table (M1) with Inner join based on some filteration criteria (S2, S3, S5).

For Ex: In M1, there is a field "status" which has values as S1,S2...S9 with primary key as PK1 which is also Primary key for the Base DSO BD1.

for few PK1, earlier status was S1, S2.. but now the status got changed.

Requirement:

Now I want to show the data in the query which should not have S2, S3 and S5 status.

Inputs invited.

Thanks in advance !!

Regards,

Niranjan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 03, 2015 at 06:32 PM

    Did you try to use conditions?

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2015 at 01:30 AM

    Hi Niranjan,


    Add M1 to the InfoSet joining it to BD1 on the primary key  ( PK1 from M1 = PK1 from BD1 ).  Join should be inner join so that the filter works.


    Add conditions on status field of M1 to filter out rows when status is S2, S3 or S5


    Regards,

    Fernando

    Add comment
    10|10000 characters needed characters exceeded