Skip to Content
0
Jul 22, 2016 at 01:27 AM

Join Conditions

42 Views

Hello, i have a question about a infoset. i am trying to create a infoset on 2 infoobjects and 3 custom dsos ok. the characteristics are:

0profit_ctr and 0costcenter and dsos are custom dsos

profit center is an attribute of cost center

i created a left outer join between these 2 chars making cost center as my left outer join because i want my users to run the query by profit centers. the other dsos i did simple join from either profit center or cost center char..

i created a query and put cost center from 0cost_center table and 0profit_ctr from 0profit_center table. i created a variable off profit center char.

i ran that query and put in profit center on variable screen and i know that one profit center exists because i went to cost center table and i was able to see the profit center value which i input in that variable.

is there something am i doing wrong? please share your opinion.

thanks.