topic TBCTO-LASTSTRTDT DATS empty in Application Development and Automation Discussions

TBCTO-LASTSTRTDT DATS empty

Former Member — Fri, 13 Jan 2017 16:18:08 GMT

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

Re: TBCTO-LASTSTRTDT DATS empty

RaymondGiuseppi — Mon, 16 Jan 2017 08:52:16 GMT

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