Database Update

[Former Member]

HI all,

I am updating a databse table in loop using a subroutine in which i

need to update date field of this table with system date, the other fields are

being updated successfully.

In loop it is working fine.

But once I come out of the loop it is showing all zeros instead of sy-datum for date field.

I have used commit work also.

It is urgent, Please help.

Thanks,

Mungala.

[Former Member]

Hi,

Please make sure that the date field in database table has data element sy-datum.

Thanks

Arun.

[Former Member]

hi,

when u are using a perform in a loop

you have to send the table to that form

like PERFORM LIST_HEADER TABLES GIT_HEADER

then it will be updated..

reward points if helpful

regards,

venkatesh

[Former Member]

Hi

Better Declare the Internal Table which you are using for Update, similar to the Database table structure and use UPDATE/Insert from ITAB.

it will insert/update all fields

Reward points for useful Answers

Regards

Anji

[Former Member]

Hello praveena,

check the date format in your table.

sy-datum uses Date field (YYYYMMDD) stored as char(8)

Regards