Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data from two DSO's to one DSO

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
Not what you were looking for? View more on this topic or Ask a question