I am looking to find out when a user executes LI20 to clear a count in WM where I can find their user name?
I can find from the count document the user who entered the count and I can find from the IM ISEG table document who made an adjustment via LI21.
However I do not seem to be able to find who cleared the WM count if no inventory discrepancies were found?
We are developing a custom report to show counts are happening, who entered them, who cleared them, who adjusted them, however I am struggling to find the user who performs LI21.
Any ideas?
Thanks.
Hi Edward,
There is no field "Username" in the tables "LINP" & "LINV". Even LX22 also doesn't have user information who cleared the bin. So I think the data you expected, is no where available and better ask users to include an inventory reference for tracking purpose.
BR, Rosh.
Hello,
When you book the WM Write off with LI20 a Transfer Order is created which moves the stock from the storage bin to the 999 storage type thus you can find the user name in table LTAK for the user id processed the transaction LI20 for which the TO gets created in the system.
So you need to have a logic based on a reference field say movement type from the LTAK table as whenever you have a Movement as 711 in case of LI20 user details should be picked in your customized table from LTAK.
Regards,
Gopal.
Add a comment