Problem WITH ERZET

[Former Member]

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

[Former Member]

Hi,

Try not passing the ERZET in the selection logic, instead use this to process the internal table after retrieving the data,

Rgds,

[Former Member]

Hi,

Try not passing the ERZET in the selection logic, instead use this to process the internal table after retrieving the data,

Rgds,

[Former Member]

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.

endif.

Correct so ??

[Former Member]

Hi,

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.

endif.

endloop.

Regards

Subbu

[Former Member]

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

Regards

VS