Skip to Content
0

TBCTO-LASTSTRTDT DATS empty

Jan 13, 2017 at 04:18 PM

21

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Raymond Giuseppi
Jan 16, 2017 at 08:52 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded