2006 Aug 10 9:03 AM
Hy ALL
I have a little problem with the correct selection.
I select data from VBAK, but the selection is not correct.
Coding
AND aedat GE i_aedat
AND erzet GE i_erzet
But i does not work. For Example, erzet = 12:00:00. If the day Change i could not find data's.
Perhaps anybody have a Tip
2006 Aug 10 9:11 AM
Hi,
Try not passing the ERZET in the selection logic, instead use this to process the internal table after retrieving the data,
Rgds,
2006 Aug 10 9:20 AM
Ok
you tell me this
select * from Vbak where ERDAT = I_ERDAT.
If sy-datum GE I_ERDAT
If sy-Uzeit GE I_ERZet
Perform work.
endif.
Correct so ??
2006 Aug 10 9:26 AM
select * from Vbak into table i_vbak where ERDAT = I_ERDAT .
loop at i_vbak.
if sy-uzeit ge i_vbak-erzet.
continue.
else.
delete i_vbak.
endloop.
Regards
Subbu
2011 Jan 27 6:33 AM
select vbeln erdat erzet into table lt_vbak
from vbak
where ( ( erdat = '20081123' and erzet >= '155127' ) or erdat > '20081123' ) "lower limit date and time
and ( ( erdat = '20081124' and erzet <= '190000' ) or erdat < '20081124' ). "upper limit date and time
VS
Bluesky
