Skip to Content
0
Former Member
Feb 26, 2010 at 12:39 PM

How using select with TIMESTMP and sy-datum and sy-uzeit ?

106 Views

Hello,

on table ADR6, there's fields VALID_FROM and VALID_TO type TIMESTMP.

How we have to use instead sy-datum ???

select SINGLE smtp_addr into wa_zfink_address_new-email

from adr6

where addrnumber = wa_but021_fs-addrnumber

and PERSNUMBER = w_persnumber

and validfrom < sy-datum

and validto > sy-datum .

Tks.