I am working on 2LIS_11_VAITM & 2LIS_13_VDITM and have taken them into individual ODS (Sales & Billing). I have taken Sales Doc and Sales Item as key fields. In the next stage I have combined Sales and Billing ODS into a single ODS with Sales Doc and Sales Item as key field. But when I checked the data, the billing doc is not showing all the relevant items e.g
Sales Doc Sales Item Billing Doc BillItem
10006765 10 3300000016 12
The Billing doc is having two more items like 10, 11 along with 12. The result is showing only the last item of the billing doc. And this is wrong for all the other doc nos. Why ?? Could you throw some light on this???