topic Re: Problem WITH ERZET in Application Development and Automation Discussions

Problem WITH ERZET

Former Member — Thu, 10 Aug 2006 08:03:30 GMT

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 — Thu, 10 Aug 2006 08:11:26 GMT

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 — Thu, 10 Aug 2006 08:20:20 GMT

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 ??

Former Member — Thu, 10 Aug 2006 08:26:48 GMT

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 — Thu, 27 Jan 2011 06:33:44 GMT

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