• Replies 15 replies
  • Subscribers 95 subscribers
  • Views 4979 views
  • Users 0 members are here
Options
Related

Database CPU requirements to use SAP functions

Adrian Perez
over 4 years ago

Hi all,

I imported 2 SAP functions using the plugin called "Import SAP functions definition" from a CSV file with 70 rows. After that I created the correspondent SAP function instances but I can see on JobQueueInfo that the DB processes "Interim calculation of the transaction codes to functions relation" that I assume it calculates which SAP groups and employees are involved takes too long.

I don't have any other performance problem and I want to know if someone that have imported SAP functions have faced this problem before.

Thanks,

Adri

  • over 4 years ago in reply to himani1 j

    Steps, very roughly assuming that your rule definitions are stored in CSV file, are:

    1. Create an import script used as a template by using the Data Importer targeting ComplianceRule
    2. Modify the script and adding the steps to modify the where-clauses and where-clause add-ons in the ComplianceRule and create the corresponding ComplianceSubRule entries based on the values in your CSV.
    3. Run the script
  • over 4 years ago in reply to Markus Weiss-Ehlers

    Thanks for input !

    Request your guidance for clarification and confirmation on below sequence of steps:

    1. Shall i import Rule data without where clause in first step in ComplianceRule table using csv? 

    2. In second step, create ComplianceSubRule using Function and uid of ComplainaceRule created in Step1

    3.Modify/insert where clause of ComplianceRules with ComplianceSubRule's created in step 2

    Kindly confirm if the sequence of steps followed and my understanding is correct?

    Thanks !

  • over 4 years ago in reply to himani1 j

    IN step 1: Where clause is mandatory in ComplianceRule, so how it should be handled initially as we do not have ComplianceSubRule created right now

  • over 4 years ago in reply to himani1 j

    If your import sets the properties WhereClausePerson and WhereClausePersonAddOn to correct values like the ones that got created if you choose to select all persons, the customizer will set the WhereClause property to an non-empty value and the save works flawlessly. I am setting these values in my modified import script.

    Then, if you create the ComplianceSubRule entries (again, I am creating these entries in the modified import script), the system will correct the ComplianceSubRule.WhereClause property accordingly.

    This procedure work definitely with 8.1.1.

  • over 3 years ago in reply to Markus Weiss-Ehlers

    Is it possible to add SAP Authorization object with blank T-code using while creating SAP Function?