Your cleared invoice visibility problem has three root causes that need to be addressed systematically:
1. CDS View Filter Logic (Primary Issue)
The standard CDS view I_SUPPLIERINVOICE that powers the “Manage Supplier Invoices” Fiori app has built-in filter logic that excludes cleared items for performance optimization. The view definition includes:
define view I_SUPPLIERINVOICE as select from bsik
{
key bukrs as CompanyCode,
key belnr as DocumentNumber,
augdt as ClearingDate,
...
}
where augdt = '00000000'
The WHERE clause augdt = '00000000' explicitly filters for items with no clearing date, which means only open items from table BSIK are returned. Cleared items in BSAK (which have a populated AUGDT) are excluded by design.
This is intentional to prevent the view from needing to UNION data from both BSIK and BSAK tables, which would cause performance degradation in large invoice datasets. However, this design means cleared items require a separate data source.
Solution for CDS View: The standard solution is to use the companion view I_SUPPLIERINVOICE_CLEARED which queries BSAK:
define view I_SUPPLIERINVOICE_CLEARED as select from bsak
{
key bukrs as CompanyCode,
key belnr as DocumentNumber,
augdt as ClearingDate,
augbl as ClearingDocument,
...
}
where augdt <> '00000000'
Your Fiori app needs to query both views to show complete invoice history. This requires configuration at the app level (see next section).
2. Fiori Selection Variant (Configuration Gap)
The “Manage Supplier Invoices” app uses selection variants to control which data is displayed. On 1909, the standard app configuration has separate variants for open and cleared items, but many implementations only configure the open items variant.
Verification steps:
Step 2a - Check Current Variant:
- Open the Fiori app
- Click Settings icon → Manage Variants
- Check which variant is active (likely “Open Items Only”)
Step 2b - Configure Cleared Items Variant:
- Transaction SFP (Form Painter) or use Fiori app “Manage KPIs and Reports”
- Find the selection variant for your AP report (typically starts with SAP_FIN_AP)
- Create new variant: “Cleared Items - Current Period”
- Set parameters:
- Data Source: I_SUPPLIERINVOICE_CLEARED
- Clearing Date: Current fiscal period (dynamic parameter)
- Company Code: Your company code(s)
- Vendor: Leave blank for all vendors
Step 2c - Add Variant to Launchpad:
The variant must be exposed as a separate tile or added as a view option in the existing app:
- Transaction /UI2/FLPD_CUST (Fiori Launchpad Designer)
- Navigate to your AP catalog
- Add new tile or modify existing tile to include cleared items variant
- Assign tile to appropriate role
Alternative Approach: Modify the existing variant to include both open and cleared items by using a UNION-based analytical query, but this impacts performance.
3. Analytics Query Update (Missing Data Source)
The underlying analytical query that feeds the Fiori app needs to be configured to include cleared items data. This is often overlooked during initial setup.
Step 3a - Verify Current Query:
- Transaction RSRT (Query Designer)
- Find the query used by your Fiori app (typically 2CFIN_AP_* prefix)
- Display query definition
- Check if data source includes BSAK table or I_SUPPLIERINVOICE_CLEARED view
Step 3b - Update Query to Include Cleared Items:
If the query only uses BSIK/I_SUPPLIERINVOICE, you need to extend it:
Step 3c - Update OData Service:
The Fiori app’s OData service needs to expose the cleared items query:
- Transaction /IWFND/MAINT_SERVICE
- Find service SAP_FIN_AP_ODATA (or similar)
- Add entity set for cleared items query
- Regenerate service metadata
- Test in Gateway Client (/IWFND/GW_CLIENT)
Business Catalog Assignment (Access Control):
As mentioned by sap_basis_config, you need the correct business catalog:
- Open items: SAP_FIN_AP (you have this)
- Cleared items: SAP_FIN_AP_CL (missing - this is critical)
- Payment history: SAP_FIN_AP_PAYMENT (recommended for full visibility)
In transaction PFCG, add these catalogs to your AP user roles. Without SAP_FIN_AP_CL, the cleared items tile won’t even appear in the launchpad even if you configure it correctly.
Verification Process:
After implementing all three fixes:
- Log out and back into Fiori launchpad
- Verify new tile “Cleared Supplier Invoices” appears (or cleared items view in existing tile)
- Click tile and verify cleared items from BSAK display
- Filter by current fiscal period - should show invoices cleared via F110
- Select a cleared invoice - verify clearing document number and payment details display
- Cross-check with transaction FBL1N (Vendor Line Items) - Fiori should show same cleared items
Month-End Reconciliation Workflow:
For your AP team’s reconciliation process, configure:
- Tile 1: “Open Invoices” (existing) - shows BSIK items
- Tile 2: “Cleared Invoices - Current Period” (new) - shows BSAK items for current month
- Tile 3: “Payment Run History” (optional) - shows F110 payment documents with invoice references
This three-tile setup gives complete visibility: what’s still open, what was paid this period, and payment run details for audit trails.
Performance Optimization Note:
If you have high invoice volumes, consider these optimizations:
- Limit cleared items query to current fiscal year only (older data in archive)
- Use materialized views or BW extraction for historical cleared items analysis
- Set up automatic archiving of cleared items older than 2 years per retention policy
After implementing the CDS view configuration, selection variant setup, and analytical query update, your AP team will have full visibility into both open and cleared invoices with proper payment history for reconciliation.