Computer Competency Practical Training (CCPT) incl. SAP / ACL Training
Computer Competency Practical Training (CCPT) tests hands-on use of office productivity tools and audit/ERP systems, typically including spreadsheet work, SAP navigation and ACL data analysis. Expect practical tasks: formulas, document formatting, transaction entry, filters and summaries.
Core rules and concepts
- Spreadsheets: distinguish relative and absolute references; use VLOOKUP/INDEX-MATCH, SUMIFS and pivot tables; validate totals.
- SAP navigation: transaction codes open tasks; key modules include FI (financial accounting), MM (materials management) and CO (controlling). A posting needs the correct company code, posting date, document date, currency and amount.
- ACL: import data, define fields, filter, sort, summarise and join tables; use AND/OR logic correctly; preserve the source file.
- Audit trail: do not overwrite source data; keep evidence of the query or posting.
Worked example
A vendor invoice of USD 5,000 is dated 15 March but is posted on 31 March. In SAP, enter the company code, vendor, invoice date (15 March), posting date (31 March), amount and tax code. The posting date determines the accounting period; the document date is the vendor's date. If you enter 15 March as the posting date, the expense may hit the wrong period. After posting, review the document in display mode.
For ACL, to find payments over Rs 1,000,000 with no purchase order, filter Amount > 1,000,000 AND PO_Number is blank, then summarise by vendor.
Traps that cost marks
- Confusing posting date with document date.
- Hard-coding values instead of using cell references.
- Deleting rows before copying formulas.
- Using incorrect AND/OR logic in ACL filters.
- Ignoring data types such as text-formatted numbers.
Exam focus
Show the transaction code or formula, the input fields and the verification step. Practical competency includes proving the result reconciles.