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.