Delta or Full Load

Hi experts,

I am having a problem that I can't resolve. I have my master and transactional data and want to load the dso. I have successfully loaded my master data but I have a problem loading the transactional data to the DSO.

Please see the images attached for my flat file. Im loading these data based on my primary key F_Key.

Image in the left is Master Data and in the right is Transactional Data.

I want to load the sales data for each F_Key but the problem is that when I use full load for transactional data, everything in DTP monitor is with green color but when I activate data of DSO and execute the request, it turns red and doesn't load the data in the DSO. The same thing if I use delta, it just gives an error and the data is not loaded in the dso.

If you see on the right picture for the F_Key 101 there are two different reportings days 22 and 23 and I want the both dates to be stored in DSO but under F_Key 101.

Is this possible to be done? Should I change something at DTP settings so that this can work out?

Thank you in advance.

Best Regards,

Regys, M.