Skip to Content
-2

Save current date in a query

Nov 15, 2017 at 04:39 PM

31

avatar image
Former Member

Hello guys, I am trying to make a little update where I want to save a status and date, but somethimes the date do not save. What happen? Thanks..

UPDATE zmmta007 SET status = '2' date = SY-DATUM 
WHERE ebeln = p_ebeln.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Horst Keller
Nov 15, 2017 at 04:45 PM
2
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks. So If I don't validate the past action this affect my update? For example.
So, why my status field if is updated?

An action...
IF SY-SUBRC = 0.
UPDATE zmmta007 SET status = '2' date = SY-DATUM WHERE ebeln = p_ebeln. ENDIF.
0

hmm. Horst answer could have been read the documentation then check sy-subrc. You could place the sy-subrc check at a better position...

0