Data from two DSO's to one DSO

[Former Member]

Hi

I have a requirement where, i have to merge the data from two DSO's to one DSO

DSO1 : has contracts and the materials are included as part of the contract

Fields in DSO1

Sold-To

Ship-to

Contract Nr

Contract Item

Material

Serial#

Net Value

DSO2 had all the materials and they corresponding attributes

Fileds in DSO2

Sold-to

Ship-to

Material

Serial#

Mainframe Indicator

Quantity

Now i want to have a DSO3 which gives all the material which have contract and which doe snot have contract

Fields of DSO3

Material

Serial#

Mainframe Indicator

Sold-to

Ship-to

Contract#(if it has else null)

Contract Item(if it has else null)

Netvalue

Quantity

Please let me know how my DSO3 will have a single record by clubbing the data from both the DSO's

Thanks!

[Former Member]

Hi

whats relation between contract and material is it many to many ?? i mean can 1 contract have multiple materials and 1 material be part of multiple contracts??

if so geting one line in DSO3 wont make much sence.

please share some more details of your requirements.

Regards

Sudeep

[Former Member]

Hi,

Map the common fields from both DSO's and other fields from respective DSO's in the transformation.

[Former Member]

What are the keys of DSO1 & DSO2?

[Former Member]

The keys for DSO1 :

Contract Nr, Contact Item and Material

keys of DSO2 are :

Ibase No.

Keys of DSO3:

Contract Nr, Contact Item and Material

[Former Member]

I think you need to have 'Ibase no.' as key in DSO3. Maybe Material can be removed.

[Former Member]

Hi,

The Keys of the 3rd DSO will be the union of the Keys of DSO 1 and DSO 2.

So teh keys of the 3rd DSO will have all the keys specified for both DSO1 and DSO2.

Regards,

Rahul

[cornelia_lezoch]

Hi,

that means you could only use transformation if you could fill the full key by any rules.

I suggest you create APD and use the outer join to join the data records and post them into your 3rd dso.

regards

Cornelia

[cornelia_lezoch]

Hi,

your DSO 3 will have a single data record, if the key fields in DSO 3 are filled with the same values from DSO 1 and DSO 2.

If this is not possible, you can either create an info set or create the data records through APD using different join.

regards

Cornelia