topic Re: Reg: displaying record in Application Development and Automation Discussions

Reg: displaying record

Former Member — Wed, 05 Nov 2008 06:51:41 GMT

hello guys,

can u guys tell me,how to display single latest date record at the output,i need the code.reply ASAP.

with regards,

sumanth

Re: Reg: displaying record

Former Member — Wed, 05 Nov 2008 06:54:34 GMT

Hi,

could u clear the Question,

Tks,

Krishna

Re: Reg: displaying record

Former Member — Wed, 05 Nov 2008 06:58:34 GMT

Hi,

I think you can get the updated or latest value using the select stament .

Suppose your date field name is ASDFG

DAta: DAt type sy-datum.

SELECT MAX( ASDFG ) INTO DAT FROM ZTABLE.

write: DAT.

So my DAT is holding the latest value.

Cheers!!

VEnk@

Re: Reg: displaying record

Former Member — Wed, 05 Nov 2008 07:07:36 GMT

thanks for ur reply dude

but wat i need is, if i have the 10 customers in the itab,in that

10 records we have the duplicates,in that i need latest single record as per date at the out put.

i need to display only 1 latest record in that dupliactes at the output

Re: Reg: displaying record

Former Member — Wed, 05 Nov 2008 09:05:12 GMT

Hi S.Reddy,

If you are using any field with time in that case we can achieve since duplicate entries are there but under what criteria we have to achieve the latest record means i can suggest you with time will give you good results with with seconds difference too, if you are using time proceed with achieve writing a simple select statement.

Cheers!!

VEnk@

Re: Reg: displaying record

Former Member — Wed, 05 Nov 2008 09:18:17 GMT

hello venkat,

thanks for ur reply,i got an idea about this,may i know where r u from? juz i want make abap network in sense friends.

with regards,

sumanth reddy

Re: Reg: displaying record

Former Member — Wed, 05 Nov 2008 09:41:02 GMT

Hi Sumanth,

There's one more way to do that.....

Sort the internal table(Descending) based on date field, now you will get latest date as first record in your internal table, then delete the duplicates. Here's the sample code:

SORT ITAB BY DATE DESCENDING.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING <fields>.

Give field names for which you are find the duplicate record.

Cheers!

Sidharth

Re: Reg: displaying record

Former Member — Wed, 05 Nov 2008 10:21:23 GMT

hello siddarth,

thanks for ur answer,it was a very helpful answer.

with regards,

sumanth reddy