Skip to Content
0
Former Member
Jun 12, 2007 at 05:14 PM

DSO Consolidation

36 Views

Hi,

I have 3 DSOs YFRD, YBIL and YFRF all having keyfields Plant, Material and Fiscal Period. I need to consolidate the records from these DSOs to another YFRH DSO having the same keyfields.

Also I have to calculate two fields Actual Sales and Forecast sales.

Actual Sales = Base Quantity * Billed Quantity

Forecast Sales = Base Quantity * Total Forecast

I will get Base Quantity from YFRD, Billed Quantity from YBIL and Total Forecast from YFRF DSO.

Can anyone please help me out with the logic for how to consolidate all these records into the final YFRH DSO.

Thanks & Regards

Salini