Community
Application Development and Automation 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: 
Read only

Data Base Trigger

Former Member

‎2010 Oct 01 3:39 PM

0 Likes
1,220

Hi All,

Can any body guide me as to how to delete a database trigger of standard a table?

While applying the pre implement manual steps included in the oss Note 1441246,

i.e. while adding a field LAST_PRCS_TIME of type OIU_RUN_TIME in table 'OIU_PR_DNSTD' we have got an activation error as below,

Table change is not possible.There is a DB Trigger on the table..

According to The performance assistant ,

We need to delete the Db Trigger manually using the report 'SFSRFW_DROP_FSI_TRIGGER' which does not exists in the required system.

And after making the changes in the table we need to create DB Trigger by using report 'SFSRFW_CREATE_FSI_TRIGGER' .Which also doesn't exists in the required system.

Please Guide.

Kate is right.

SAP note 1387560 says the error will be corrected with Basis SP level 21 for release 700. Yours is 17.

Well, 17 < 21.

For higher SP levels the message will be:

Delete the DB trigger using the same means with which it was created.

hope this helps

Edited by: Joe Bo. on Oct 5, 2010 3:12 PM

Reply
3 REPLIES 3
Read only

Former Member

‎2010 Oct 01 8:06 PM

0 Likes
978

Hi,

Maybe the message is wrong.

Please see the OSS Note 1387560 - Long text for message DA 515 is misleading:

"Summary

Symptom

The long text of message DA 515 refers to two non-existent programs SFSRFW_DROP_FSI_TRIGGER and SFSRFW_CREATE_FSI_TRIGGER.

Reason and Prerequisites

There is an error in the documentation.

Solution

The message text is corrected by importing the Support Packages specified in this note."

I don´t know your support package, so this is just a guess.

Regards,

Kate

Read only

Former Member

‎2010 Oct 04 7:17 AM

0 Likes
978

hi,

my system is at support pack level 14 for IS_OIL component of release 600.

and the note 1387560 suggested by you is applicable for component SAP_BASIS .

For the companent sap_basis my system is at SP level 17 for release 700.

but the note 1441246 regarding which i am facing the problem is applicable to IS_OIL component.

please clarify.

Read only

Former Member
In response to Former Member

‎2010 Oct 05 2:09 PM

0 Likes
978

Kate is right.

SAP note 1387560 says the error will be corrected with Basis SP level 21 for release 700. Yours is 17.

Well, 17 < 21.

For higher SP levels the message will be:

Delete the DB trigger using the same means with which it was created.

hope this helps

Edited by: Joe Bo. on Oct 5, 2010 3:12 PM