update PRPS table
I am updating DATE2 field of prps table with sys-date.
Can i do that using update command.
Wont it affect other functionality which are dependent on this table.
Yes you can update with UPDATE command.
update prps set date2 = sy-datum.
and it will affect only that time wherever this field is coming with standards programs tcodes.
make sure that the data in table is depend on this date or not.
just try this for one entry and see the result.