Skip to Content
0
Former Member
Jan 30, 2007 at 01:32 PM

infoset doc no. and item data Outer Join Problam

12 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.

null

Message was edited by:

SSMS

Message was edited by:

SSMS

null