cancel
Showing results for 
Search instead for 
Did you mean: 

infoset - left outer join

Former Member
0 Kudos
47

HI Gurus,

I am using infoset based on 2 ODS 0figl_o02 and 0fiap_o03 for queiry.

I have a requirment like ...

0fiap_o03

doc no. item amount vendor

3333 1 10000 101

3333 2 20000 101

0figl_o02

doc no. item amount

3333 1 10000

3333 2 20000

3333 3 30000

3333 4 40000

3333 5 50000

Now data required in Infoset

doc no. item amount vendor

3333 1 10000 101

3333 2 20000 101

3333 3 30000 101

3333 4 40000 101

3333 5 50000 101

i am currently join it with company code and doc no.

plz provide me your input to get above data in infoset.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

SSMS,

Your problem solved or not?

If not Rt click on the ods 0fiap_o03 and select Left outer join then select the fileds comp code and doc.no and map it to ods 0figl_o02.

Check for the consistency then save and activate.

Let me know.

Urs,

Rakesh

Former Member
0 Kudos

Hi all,

data is not coming as it required .

give your inputs.

Message was edited by:

SSMS

Former Member
0 Kudos

Hi,

Try out for temproal join dont use left outer join.

And what are the key fields in both ods's??

What is the output ur getting as of now.

Urs,

Rakesh

Former Member
0 Kudos

HI Rakesh,

if i join it then i am getting o/p like.

doc no. item amount vendor

3333 1 10000 101

3333 2 20000 101

BUt data required like.

doc no. item amount vendor

3333 1 10000 101

3333 2 20000 101

3333 3 30000 101

3333 4 40000 101

3333 5 50000 101

plz provide me your input to get above data in infoset.

Former Member
0 Kudos

Hey,

The o.p of that the report is based on temp join or left outer join??

thats wat i am asking . And go thru the previous replies which i have given and reply then.

Urs,

Rakesh

former_member184494
Active Contributor
0 Kudos

SSMS,

have 0figl_o02 on left outer join and join on the fields of company code and document number...

Arun

Hope it helps....

Former Member
0 Kudos

Thanks for reply arun,

i can see outer join written on link of doc. no. compa code and line item. of both ods.

all three info object showing outer join.

former_member184494
Active Contributor
0 Kudos

SSMS,

that should be okay or other wise - right click on the ODS and select 'Left Outer Join' - it will get displayed in cream / yellow and the links will get specified as left outer join..

Arun

Hope it helps...