Duplication of records in material movement cube

[Former Member]

Hi,

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?

Thank you,

Regards,

ram

[Former Member]

Hi,

what's the quantity in PSA? 14400 or 0? Looks like it creates a 0 sum line for some reason. To be sure you can add requestid in lidtcube.

Check if you use a startrotine where you may duplicate the data.

If you're not sure you can debug the update rule. Goto monitor on your request. Goto the data apckage. press right mouse button and choose simulate update into data targets. Then you can choose either transfer rules or update rules. Check update rules and all data. Then you will get to the debugger and you will see where your data gets duplicated.

Hope it helps.

Regards,

Juergen

[Former Member]

Hi

Check your update rules. I think you are mapping once with intial value and again mapping to some values in infosource

Regards

N Ganesh

[Former Member]

Hi Ganesh,

Thanks for your reply.

we checked, but the scenario here is not like that.

Can you forsee any other reason?

Thanks in advance

ram