Skip to Content
avatar image
Former Member

SAP OPInt clean

Hi all,

Does anybody have a clear instruction on how to clean for SAP OPInt.

In order to get familiar with the tool I have created a lot of Business Scenarios and now I want to remove them from and I was interested what would be the logic way in deleting/cleaning the objects? Any specific order to deleted the generated artifacts?

Thanks in advance.

Best regards,

Stefania Rusu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 16, 2015 at 12:01 PM

    Hi Stefania,

    the necessary steps to delete your generated artifacts are described here: Common errors & its resolution in SAP OPInt scenario generation.

    However this will not delete these scenarios from To do so you have to delete the scenario from the metadata table using your SQL console:

    DELETE FROM "SYS_PROCESS_VISIBILITY"."sap.opi.pv::SPVD_SCENARIO_METADATA" WHERE scenario_name = '<scenario_name>'

    (replacing <scenario_name> with your scenario name)

    Please note that this is my personal experience for which I cannot quote any official source, so I cannot take any responsibilities for this advice. Use deletions carefully.

    Best regards


    Add comment
    10|10000 characters needed characters exceeded

    • Hello Stefania,

      To delete the Business Scenario, you have to goto SAP HANA Modeler perspective in HANA Studio --> Select the Business Scenario you want to delete --> right click to get the context menu and select Delete Scenario option. This would delete the business scenario, together with all related generated artifacts. This action also updates all the related tables etc.

      It is NOT recommended to use SQL queries to update tables or other artifacts in the SYS_PROCESS_VISIBILITY schema as this would end up corrupting related references in other tables.

      If your purpose is not to delete the scenario but just not make it appear in then you can update the User from HANA Studio :

      1. Goto SAP HANA Modeler/Administration perspective in HANA Studio

      2. Select <your user> in Security/Users

      3. In the Editor, select Granted Roles tabs

      4. Delete the *_OPERATOR role

      5. Save the user

      Next, when you login into with this user you will not see the business scenario