Skip to Content
1
Former Member
Apr 18, 2013 at 03:42 AM

Combining Sales Delivery Billing Data in one DSO

569 Views

Hi Experts ,

I have a requirement where I need to combine Sales , Delivery , Billing Data into one single consolidation DSO . At first level I will be using a staging DSO to pull the data from 2LIS_11_VAITM , 2LIS_11_VASCL , 2LIS_12_VCITM , 2LIS_13_VDITM . Please advice on how to design a consolidation DSO on top of all these 4 DSOs . The crucial part I beleive is going to be the Key Combination . 2LIS_11_VAITM , contains Sales Order No and Item as Key . 2LIS_12_VCITM , contains Delivery Order No and Item as Key . 2LIS_13_VDITM , contains Billing Order and Item as Key . I know there exists a relation between all these three flows through reference document number , but look up doesnt work as for single Sales Document No there exists multiple Deliveries and Billings and these different Deliveries are posted at different point of time . Also cannot use Multi Provider , as I need to do some calculations in the backend .

I have gone through many threads before posting this , but still no match to my requirement . Please help on this .