01-13-2017 4:18 PM
Hi all,
in Tabelle
TBCTO the Field LASTSTRTDT is empty. It is a DATS Type-Field and as far as i know an empty date should be saved as 00000000 on DB-Table. But The Field on DB is empty - how can this be? i thought, all DATS Types are stored as 00000000 when nothing was assigned.
(Has nothing to do with NULL-Values)
Regards
Stefan Seeburger
01-16-2017 8:52 AM
On database those are character field, so space value is possible, look at some standard program like SAPMSSY2 for code like
data:
(...)
no_date like sy-datum value ' ',
no_time like sy-uzeit value ' ',
(...)
if tbtco-laststrtdt ne no_date and
tbtco-laststrttm ne no_time and
not ( tbtco-laststrtdt is initial ).
Regards,
Raymond
01-16-2017 8:52 AM
On database those are character field, so space value is possible, look at some standard program like SAPMSSY2 for code like
data:
(...)
no_date like sy-datum value ' ',
no_time like sy-uzeit value ' ',
(...)
if tbtco-laststrtdt ne no_date and
tbtco-laststrttm ne no_time and
not ( tbtco-laststrtdt is initial ).
Regards,
Raymond