SAP Resources for CAs
Master essential T-Codes for FICO, Audit, and more.
🎓 SAP Fundamentals for
Auditors
POSTING KEYS (PK)
The DNA of a Transaction:
PKs determine (1) Debit/Credit and (2) Field Status (what's required).
PKs determine (1) Debit/Credit and (2) Field Status (what's required).
G/L Accounts:
• 40: Debit
• 50: Credit
• 40: Debit
• 50: Credit
Vendor (K):
• 31: Invoice (Cr)
• 25: Payment (Dr)
• 31: Invoice (Cr)
• 25: Payment (Dr)
Customer (D):
• 01: Invoice (Dr)
• 15: Payment (Cr)
• 01: Invoice (Dr)
• 15: Payment (Cr)
Asset (A):
• 70: Debit
• 75: Credit
• 70: Debit
• 75: Credit
CRITICAL FIELDS
Decode the Document:
- Cost Center (KOSTL): Where the money is spent (Department/Unit).
- Profit Center (PRCTR): Where revenue is earned (Segment reporting).
- Assignment (ZUONR): Sorting key. For GR/IR, it's often the PO Number.
- Text (SGTXT): The narration or line item remark.
- Reference (XBLNR): Vendor's Invoice Number (Crucial for duplicate checks).
T-CODE HACKING
Identifying Custom Reports:
Standard SAP codes are 4 characters (e.g., FB60).
Custom codes ALWAYS start with 'Z' or 'Y' (e.g., Z_PO_REGISTER). These are tailored to your company's implementation.
Standard SAP codes are 4 characters (e.g., FB60).
Custom codes ALWAYS start with 'Z' or 'Y' (e.g., Z_PO_REGISTER). These are tailored to your company's implementation.
How to Extract ALL T-Codes:
1. Go to table TSTC (SE16N > TSTC) for a global list.
2. Use table AGR_TCODES to see T-Codes assigned to specific Roles.
3. Tip: In any menu, enable Extras > Settings > "Display Technical Names".
1. Go to table TSTC (SE16N > TSTC) for a global list.
2. Use table AGR_TCODES to see T-Codes assigned to specific Roles.
3. Tip: In any menu, enable Extras > Settings > "Display Technical Names".
🚀 Navigation
/n
Exit current transaction and return to start
/o
Open new session
/n[T-Code]
End current session and start new T-Code immediately
(e.g., /nFBL3N)
(e.g., /nFBL3N)
/o[T-Code]
Open T-Code in a new window/session
/nex
Log off from system immediately (No confirmation)
F3
Back (Go to previous screen/step)
💰 Finance & Controlling (FICO)
FS00
FI
G/L Account Master Record Maintenance
FB50
FI
Enter G/L Account Document
FB60
FI
Enter Vendor Invoice
FB70
FI
Enter Customer Invoice
F-53
FI
Post Outgoing Payment
F-28
FI
Post Incoming Payment
AS01
FI
Create Asset Master Record
🔍 Audit & Reports
FBL3N
FI
G/L Account Line Items (Ledger Scrutiny)
FBL1N
FI
Vendor Line Items
FBL5N
FI
Customer Line Items
F.01
FI
Financial Statements (Balance Sheet / P&L)
FS10N
FI
G/L Account Balance Display
SE16N
TECH
General Table Display (View raw data tables like BKPF, BSEG)
S_ALR_87012178
Customer Open Item Analysis (Ageing)
📦 MM & SD (Procurement/Sales)
ME23N
MM
Display Purchase Order
MIGO
MM
Goods Movement (GRN entry)
MIRO
MM
Enter Incoming Invoice (Logistics Verification)
VA03
SD
Display Sales Order
VF03
SD
Display Billing Document
XK03
MM
Display Vendor (Central)
XD03
SD
Display Customer (Central)
🏢 Asset Accounting
AW01N
FI
Asset Explorer (Complete Asset History & Values)
AS01
FI
Create Asset Master
⚠️ Reversals & Rectification
FB08
FI
Reverse Individual Document (Correcting Entry)
F.80
FI
Mass Reversal (Reverse multiple docs at once)
FBRA
FI
Reset Cleared Items (Break the link between Invoice & Payment)
KB61
CO
Repost CO Line Items (Fix Cost Center allocation errors)
🇮🇳 Tax & GST (India)
FTXP
CO
Maintain Tax Codes
VK11
SD
Maintain Condition Records (GST Rates)
J1IG*
GST Transaction Series (e.g., J1IG_INWARD)
📅 Period End & Tables
OB52
Open/Close Posting Periods (Critical for Audits)
BKPF
Accounting Document Header Table
BSEG
Accounting Document Segment Table (Line Items)
💡 Pro Execution Tips
F8
EXECUTE
The "Run" Button:
Always press F8 to execute a report after filling your filters.
Always press F8 to execute a report after filling your filters.
F9 or Menu > Program
Run in Background:
1. Menu > Program > Execute in Background.
2. Check status in SM37.
3. View results in SP01 (Spool).
1. Menu > Program > Execute in Background.
2. Check status in SM37.
3. View results in SP01 (Spool).
EXPORT
Exporting to Excel:
• List Display: System > List > Save > Local File > Spreadsheet.
• ALV Grid: Click the "Excel" icon in the toolbar.
• List Display: System > List > Save > Local File > Spreadsheet.
• ALV Grid: Click the "Excel" icon in the toolbar.
EXCEL CLEANING
Text to Columns:
Select Column A > Data Tab > Text to Columns > Delimited > Finish.
Fixes SAP's tendency to paste everything in one cell.
Select Column A > Data Tab > Text to Columns > Delimited > Finish.
Fixes SAP's tendency to paste everything in one cell.
Ctrl S
Save Variant:
Save your filter settings (e.g., "Monthly Audit Filter") to reuse them later.
Save your filter settings (e.g., "Monthly Audit Filter") to reuse them later.
🔌 Connect SAP to External Tools
EXCEL POWER QUERY
Direct Connection (Get Data):
1. Excel > Data Tab > Get Data > From Other Sources > From SAP HANA/BW.
2. Note: Requires SAP Client drivers installed on your PC.
3. Use SQVI (Quick Viewer) to join tables first, then connect to the view.
1. Excel > Data Tab > Get Data > From Other Sources > From SAP HANA/BW.
2. Note: Requires SAP Client drivers installed on your PC.
3. Use SQVI (Quick Viewer) to join tables first, then connect to the view.
GUI SCRIPTING
Automation (VBA/Python):
Enable scripting in SAP Options. Record a macro of your report export steps. Use the VBS code to automate daily dumps.
Enable scripting in SAP Options. Record a macro of your report export steps. Use the VBS code to automate daily dumps.
RESOURCES
📚 Full T-Codes Library
⚠️
Note on Custom T-Codes (Z/Y):
Transactions starting with 'Z' or 'Y' are custom-built for specific entities. These may not work in your organization's SAP system or may be named differently.
Transactions starting with 'Z' or 'Y' are custom-built for specific entities. These may not work in your organization's SAP system or may be named differently.