topic field selection in Application Development and Automation Discussions

field selection

Former Member — Fri, 25 May 2007 11:16:27 GMT

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*

Re: field selection

Former Member — Fri, 25 May 2007 11:18:54 GMT

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

Re: field selection

Former Member — Fri, 25 May 2007 11:21:19 GMT

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.

Re: field selection

Former Member — Fri, 25 May 2007 11:47:03 GMT

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