Hi BI experts,
I have a requirement to update the last material used date for each Plant, Material and Vendor combination in the DSO active data table. The problem I'm facing at this moment is the last material used date for each Plant, Material and Vendor combination exists in different data packets in the DSO's New Data table, for example:
Data packet number Plant Material Vendor Material LastUseDate
000001 A101 417334 401093 18.07.2005
000002 A101 417334 401093 16.03.2008
000003 A101 417334 401093 09.12.2007
000004 A101 417334 401093 04.05.2007
If I were to run the activation of this DSO, I will end up with 04.05.2007 as the Material Last Used Date in my DSO active data table and this is not correct because 16.03.2008 should be the correct last used date.
Is there a way I can possible sort the data in the DSO New Data table during the DSO activation processing?
Please let me know.
Thanks,
Anthony