topic Re: Last changed record in Application Development and Automation Discussions

Last changed record

Former Member — Mon, 19 Jan 2015 17:04:19 GMT

Hi,

I have a small query. I use the changeddocument_read to fetch the changes on SORT field on LFA1.

I get all the values in internal table.Could you please tell me how to fetch the last changed record ?

When i use SORT itab by date descending time descending , it works like date ascending and time descending.

I need to fetch the last changed using UDATE and UTIME latest value.

Can you help.

Thanks

Re: Last changed record

Former Member — Tue, 20 Jan 2015 03:01:30 GMT

Hi AS

It`s weird, SORT itab BY udate DESCENDING utime DESCENDING. should works fine.

Please past your code here, then we can further check.

regards,

Archer

Re: Last changed record

mayur_priyan — Tue, 20 Jan 2015 06:08:09 GMT

DATA : lt_lfa1 TYPE STANDARD TABLE OF lfa1,

wa_lfa1 TYPE lfa1.

SELECT * FROM lfa1 UP TO 30 ROWS INTO TABLE lt_lfa1.

IF NOT lt_lfa1[] IS INITIAL.

SORT lt_lfa1 by UPDAT DESCENDING UPTIM DESCENDING.

LOOP AT lt_lfa1 INTO wa_lfa1.

WRITE: / wa_lfa1-LIFNR, wa_lfa1-UPDAT, wa_lfa1-uptim.

ENDLOOP.

ENDIF.

Re: Last changed record

VijayaKrishnaG — Tue, 20 Jan 2015 07:14:20 GMT

Hi Swarna,

If you are trying to fetch latest record (last changed, can be newly added Vendor) from LFA1 irrespective to LIFNR, you can use following select statement:

SELECT SINGLE LIFNR MAX( UPDAT ) MAX( UPTIM ) FROM LFA1 INTO LS_LFA1

WHERE LIFNR = P_LIFNR

GROUP BY LIFNR UPDAT UPTIM.

Otherwise, if you are looking for the latest change in a log of particular vendor, you should fetch data from tables like CDHDR CDPOS.

To get the log,

Pass OBJCETCLASS as 'KRED', OBJECTID as <LIFNR> (with leading zeros) and TCODE as 'XK02'.

To get the log details,

Get the CHANGENR field from above statement and pass that to CDPOS. You will get detailed log.

Regards,

Vijay

Re: Last changed record

vinodkumar_thangavel — Tue, 20 Jan 2015 09:26:54 GMT

Hi ,

Try to use Sort syntax as SORT itab by date descending and time descending.

Regards,

Vinodkumar.