Skip to Content

TBCTO-LASTSTRTDT DATS empty

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 16, 2017 at 08: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

    Add comment
    10|10000 characters needed characters exceeded