Skip to Content
0
Former Member
Feb 09, 2007 at 12:36 PM

infoset - left outer join

24 Views

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.