Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

update PRPS table

Go to solution
Former Member

‎09-05-2008 2:06 PM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎09-05-2008 2:41 PM

0 Kudos

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.

2 REPLIES 2

Go to solution
Former Member

‎09-05-2008 2:41 PM

0 Kudos

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.

Go to solution
former_member184657
Active Contributor

‎09-06-2008 5:00 AM

0 Kudos

Its never advisable to update SAP Standard Database Tables directly.

pk