2007 May 25 12:16 PM
hi experts,
i m working on pm module, well my req is that i wanna to show last saved entry for a perticular equipments, that entry are saveing in ITOB TABLE.
and when we change any single entry it gives 8 lines of duplicates in database so i want last entry for that particular equipment.
in short how we can show the last entry of each line item.
what will be the code step.
please help me this is very urgent
thanks and regards
vijay kumar dwivedi
marks will be sure for each helpfull answer*
2007 May 25 12:18 PM
Hi
Check the Table <b>EQUI</b> for the last saved entry data and see
EQKT is for texts of equipment
Reward points if useful
Regards
Anji
2007 May 25 12:21 PM
Hi,
If the table contains some field as line item no then you have to fetch the relevant data and then sort the internal table based on the line item and this would give you the latest line item.
I can suggest you a better solution if you can provide me the table name.
2007 May 25 12:47 PM
hi anji sir,
i saw the equi table but it dont have j_3gempfae, swerk, iwerk, and gsber
fields that i wanna to show.
well my requirement is that i m making a report in which, i m displaying the equipments for which Recipients, plant maintenance, planning plant, and bussiness area is not same.
and for each equipment entry will be latest , means latest change entry should be there.
fields for show are equnr ,eqktx, j_3gempfae, swerk, iwerk, and gsber.
please help if u have any solution for that..
thanks and regards
vj