Hi All,
I have a situation where I restricted my selection to specific records in my select statment with in the transfer routine, but it does not stop updating other records that do not fall within the selection condition. I am updating records that match >= sy-datum but it updates even the older records where time is in the past. Why?
if TRAN_STRUCTURE-PERSON IS NOT INITIAL and
TRAN_STRUCTURE-DATETO >= sy-datum.
SELECT SINGLE A~EE_SNAME
INTO mname
FROM /BIC/AZHROMA0100 AS A
WHERE A~/BIC/ZBUSEMP > 0 and
( A~DATETO >= sy-datum and
A~PERSON = TRAN_STRUCTURE-PERSON ).
if sy-subrc = 0.
RESULT = mname.
else.
RESULT = ''.
endif.
endif.
clear: mname, mperson.
It updated some of the old record with the same name that was updated last. It looks like the mnane is not initialized to spaces.
Any ideas.
Thanks,
Alex.