cancel
Showing results for 
Search instead for 
Did you mean: 

InfoSet using Master Data table

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member285534
Active Participant
0 Kudos

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

former_member186696
Active Contributor
0 Kudos

Did you try to use conditions?