Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

TBCTO-LASTSTRTDT DATS empty

former_member220028
Active Contributor
0 Kudos

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

1 ACCEPTED SOLUTION

raymond_giuseppi
Active Contributor
0 Kudos

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

1 REPLY 1

raymond_giuseppi
Active Contributor
0 Kudos

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