topic Re: update PRPS table in Application Development and Automation Discussions

update PRPS table

Former Member — Fri, 05 Sep 2008 13:06:28 GMT

Hi,

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.

Thanks,

Sandeep Garg

Former Member — Fri, 05 Sep 2008 13:41:32 GMT

Hi Sandeep,

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.

Thanks,

Sanket.

Former Member — Sat, 06 Sep 2008 04:00:14 GMT

Its never advisable to update SAP Standard Database Tables directly.