Excel Model to Compute Who Has Violated User Access In SAP

About This Resource
This spreadsheet shared by Claire Worledge was used as the first practical exercise in the virtual event on Thursday July 22nd, 2021 "Segregation of Duties Audit in SAP". In this spreadsheet we see the methodology followed in order to check who has violated user access, based on the general ledger header table. Normally, this process would be done in a data mining tool (ACL, IDEA, SQL, Alteryx, QLIK), however, here we show it in Excel, for the purpose of understanding the process and to help those of you that don't have access to any of the above tools.
Type of Resource
Industry
Resource Files

Login or create free account to download resource files.

Ready to Get Involved?

Why should everyone reinvent the wheel? Let’s share our internal audit resources so we can all add more value to our organizations.

 

To share one of your resources with the community, either use the upload function under Share Resources or email us at resources [at] auditopia [dot] com.

 

We know confidentiality is important. Please do not share any sensitive content, let’s focus on methodology only. Note that only your first name will be visible to the community when uploading a resource. You can also change this display name to an alias if you prefer.

 
Shared By: AuditopiaTeam
Date: August 20, 2021
Share this resource
Share on linkedin
Share on twitter
Share on facebook
Report this resource

Reported resources will be reviewed by us. Report this resource to let us know if this resource violates Auditopia's Terms of Use.

Responses

About
Auditopia

Auditopia is a new learning and collaboration platform for internal auditors. We tap into our collective knowledge by sharing original resources and engaging in virtual community events and collaboration groups.

Report This Resource

    Create Free Account
    [ultimatemember form_id="117"]

    Contact us