Retrieving Change Indicator.

[Former Member]

Can anybody tell me the logic to retrieve change indicator,

change number,udate,utime from CDHDR table where object class = KRED,objectid = vendor number and transaction code = xk01,xk02,xk05,xk06.

Thanks and Regards

Ajay

Edited by: ajaya moharana on Sep 20, 2008 1:14 PM

[Former Member · Accepted solution]

Hi,

Check below code:

select single * from cdhdr  where CHANGENR = changenumber AND
UDATE = date AND
UTIME = time AND
OBJECTCLAS = 'KRED' AND
OBJECTID = vendornr AND
 TCODE = 'XK01' OR 
 TCODE ='XKO2' OR
 TCODE ='XK05' OR 
TCODE ='XK06'.

Regards,