Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

field selection

Former Member
0 Kudos
81

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*

3 REPLIES 3

Former Member
0 Kudos
56

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

Former Member
0 Kudos
56

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.

Former Member
0 Kudos
56

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