Skip to Content

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

DSO Flow Design

Hello,

We have SO data and Invoice data in there respective DSO's with ( 6 records each ) and a third DSO is required that consolidates the records from these two DSOs and give 6 records only.

SO Data :  ( Key is SO Number and SO Item )

sosoitemvalueckeyqtyunit
1001010500INR5TON
1001020200INR6TON
1001030300INR7TON
1002040600USD8TON
1002050400USD5TON
1005010800INR9

TON

Invoice Data :  ( Key is Invoice Number and Invoice Item )

sosoitemin_valueckyin_qtyunitin_noin_item
1001010500INR5TON20005110
1001020100INR3TON20005120
1001030300INR7TON20005130
1002040600USD8TON20005210
1002050400USD5TON20005220
1005010800INR9TON20005310

We need to create a third DSO that gets data from these DSO and displays all records : 

( SO Number, SO Item, Invoice Number, Invoice Item, SO value, SO qty, Invoice value, Invoice qty, cky, unit )

Is it possible to design and implement this requirement in a third DSO ? I have kept SO/SO Item as Keys in third DSO but results I am getting is :

Data is over-written for Key figures by the last request that gets activated.

Please help in designing part.

Thanks,

M

Not what you were looking for? View more on this topic or Ask a question