06-06-2007 10:38 AM
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.
06-06-2007 10:40 AM
Hi,
Please make sure that the date field in database table has data element sy-datum.
Thanks
Arun.
06-06-2007 10:42 AM
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
06-06-2007 10:43 AM
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
06-06-2007 10:44 AM
Hello praveena,
check the date format in your table.
sy-datum uses Date field (YYYYMMDD) stored as char(8)
Regards