williamcorrea23 SAP RPT1 — Regulatory Reporting Workflow
SAP RPT1 provides country-specific local tabular prediction for FI/CO statutory reporting.
1. Scope
| Area | Coverage |
|---|---|
| Local GAAP | Country-specific accounting principles (BR GAAP, US GAAP, etc.) |
| Tax Reporting | VAT, GST, withholding tax prediction |
| Statutory Reporting | Local balance sheet, P&L |
| Audit Support | Predictive audit trail generation |
2. Configure Country-Specific Reports
" RPT1 configuration tables
" Check country-specific tax rules (T005)
SELECT * FROM t005 WHERE land1 = 'BR'.
" Fiscal year variant for statutory dates
SELECT * FROM t009 WHERE periv = lv_fiscal_variant.
" Local GAAP BAdI implementation (country-filtered)
" SE19 → Create implementation for BAdI RPT1_LOCAL_GAAP
" Filter by country to avoid cross-country conflicts
3. Execute RPT1
Transaction: RPT1
→ Select country code
→ Select report type (Balance Sheet / P&L / Tax)
→ Choose fiscal year and period
→ Execute → Review tabular prediction
→ Export to CSV/Excel
4. API Integration
# Via ZROUTER FI handler:
python scripts/sap_router.py route --action FI_POST_DOCUMENT
python scripts/sap_router.py route --action FI_CHECK_ACCOUNTS
python scripts/sap_router.py route --action FI_REVERSE_DOCUMENT
# CSV template for batch document posting
python scripts/xls_to_bapi.py template --output fi_doc.csv \
--module FI --action POST_DOCUMENT
# Fields: comp_code, doc_type, doc_date, posting_date, currency, amount, account
Pitfalls
- Local GAAP BAdI not country-filtered → Cause: BAdI implementation runs for all countries. Solution: add country check in BAdI filtering logic (use
T005table). - Tax code not determined → Cause: T005 not configured for country-specific tax rules. Solution: verify T005 entries for target country; configure tax code determination via OBCN.
- Statutory dates offset → Cause: fiscal year variant mismatch. Solution: ensure T009/T009B matches the reporting entity's fiscal year; check period variant in OB29.
- Balance sheet not aligning → Cause: local GAAP rules differ from SAP standard. Solution: configure country-specific chart of accounts (OB13) and financial statement versions (OB58).
Verification
# Run RPT1 for a known country and verify tabular output
# SE38 → RPT1 → select country → execute → export CSV
# Check tax configuration
python scripts/sap_router.py route --action FI_CHECK_ACCOUNTS
Related
- FI handler in ZROUTER for document posting (BAPI_ACC_DOCUMENT_POST)
- GL account balance check via BAPI_GL_GETACCOUNTSALDO
- Document reversal via BAPI_ACC_DOCUMENT_REV_POST