Skip to Content
avatar image
Former Member

BW 7.5 Composite Provider-JOIN Issue

Dear All,

I have the following issue:

Table 1

Doc No Approver

1 abc

1 def

Table 2

Doc no Item no Product qty

1 10 100

1 20 200

When I create a BW Composite Provider of Inner JOIN Table 1 (DSO1)to Table 2(DSO2)

I get the output as

Doc Approver Item Qty

1 abc 10 100

20 200

1 def 10 100

20 200

I am looking for output

1 abc 10 100

1 def 20 200

I tried various cardinality but still does not work. Is there any way to get this output?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 20, 2017 at 08:13 AM

    Hi Ramachandran,

    Here Joining only on Doc no will give only same result.

    The output you are looking for can be obtained, only when you can join it on some other Column along with doc no

    Thanks,

    Anil

    Add comment
    10|10000 characters needed characters exceeded