cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation view graphical : Join type

pamarque
Participant
0 Kudos

Hi Guys,

I have a graphical calculated view with two projection nodes. A node with a calculated view of the ACDOCA table and another node with a calculated view of the LFA1 table. These two nodes are joined by a node of type inner join by the lifnr (provider) field. The issue is that in the acdoca table there are records with the lifnr field set to null, and when doing the inner join with the lfa1 table, these records do not display (they are not shown by the view in the data preview), but I need that show them. How could I do it? Is changing the join type to left join possible?

BR,

Patricia.

Accepted Solutions (0)

Answers (1)

Answers (1)

DotEiserman
Advisor
Advisor
0 Kudos

Hi Patricia,

You can simply change the join type to a left outer join.

Thanks

Dot