As the data shown below here, we are getting the duplication of entries in the cube.When i check my psa, we have only one record, however when it goes to target, it is getting doubled.But however qty is not repititive.
If we see the below, we can find two differences, one is qty is not duplicating and another is 0unit is blank for one and another has as EA.
Depot Material prod code batch doc num Date 0unit Qty
HBLH DTTEST1 DTTEST1 01C6007200 4900011227 28.07.2006 0
HBLH DTTEST1 DTTEST1 01C6007200 4900011227 28.07.2006 EA 14,400.00
Can you please let me know, what could be the reasons or in what scenario this would happen?