topic Re: Issue When moving Dates in Application Development and Automation Discussions

Issue When moving Dates

former_member216668 — Fri, 06 Jun 2008 06:32:06 GMT

Hi,

I am selecting dates from a Database table and moving it to an internal table, When values are present in DB table it copies it correctly whereas when there is no value in DB table a Zero gets stored in the internal table and gets subsequently printed.

I want to avoid this issue and i want only blanks in the internal table when the value in DB is not filled.

Thanks & Rgrds,

Ken

Re: Issue When moving Dates

Former Member — Fri, 06 Jun 2008 06:33:34 GMT

in internal table change field dats type to char type , then it wil not display zero..

Reward if useful

Ankesh

Re: Issue When moving Dates

Former Member — Fri, 06 Jun 2008 06:34:02 GMT

data dt type sy-datum.

dt = sy-datum.

write 😕 dt.

clear dt.

if dt is initial.

dt = space.

endif.

write 😕 dt.

does that help???

Re: Issue When moving Dates

Former Member — Fri, 06 Jun 2008 06:35:22 GMT

hi!

As ur variable is in date format its displaying Zeros when there is no data in DB.

By declaring the variable as string r char you can avoid this Zero (or)

fetch all the data as u need in Tab and Loop the Itab for date = 0 and replace 0 to Blank space.

Reward me if its useful.

Regards,

Nagulan

Re: Issue When moving Dates

Former Member — Fri, 06 Jun 2008 06:38:02 GMT

Write ur date field to a character type field of the same length as follows

data: lv_date(10) type c.

WRITE itab-date to lv_date.

Thanks,

Anon

Re: Issue When moving Dates

Former Member — Fri, 06 Jun 2008 07:10:44 GMT

Hi Ken,

Did the answers help you to solve the problem.

If not quote the problem.

If yes, close the thread..

Thanks,

Anon