Skip to Content
0
May 17, 2010 at 06:37 AM

Retrieving latest changed date UDATE for Vendor.

175 Views

Hi All,

I have a requirement to retrieve latest changed date UDATE field from CDHDR table based on company code wise??.

As the vendor can be same for different company codes, I need to retrieve the company code wise latest changed date of vendor.

Hope am clear.

Currently am doing this

SELECT objectclas objectid tcode udate
    FROM cdhdr INTO  CORRESPONDING FIELDS OF TABLE it_cdhdr
    FOR ALL ENTRIES IN it_lfa2
    WHERE objectclas = 'KRED' AND
          objectid   = it_lfa2-objectid
    AND   change_ind = 'U'.

SORT it_cdhdr BY objectid udate  DESCENDING.

Its giving me the latest changed date. But I need latest changed date -company code wise?

Any help is highly appreciated.

Thanks & regards

Himayat.