Skip to Content
0
Former Member
Dec 14, 2007 at 07:36 PM

how to get all TPLNR for an EQUNR

2389 Views

Hello All,

I am trying to write an ALV, in which user wants to see the tplnr for equipment, I mean they want to know which user move the equipment to which location. Now I got all the parts running except that I can not seem to get the location (tplnr). If I try with the datbi (table equz) with datbi = '99991231', i get only the current location for the equipment. Is it possible to get all the location where this equipment been time by time? There is a field in equz "timbi" , but I can not seem to get the right logic to get the things done.

I inner join equi, equz, and iloa table together on equnr to get the location but so far only able to get only the current location.

Thanks.