This query displays the profitability of financial transactions and instruments by business segment. It uses the plan costs and actual costs for periods. The system uses the structure for the contribution margin schema (0BA_PA_MP01_QT01) to calculate profitability. It also shows the deviation between plan and actual costs.
The query accesses MultiProvider Contribution Margin: Periodic)0BAPAMP01).
You can branch from this report to the Contribution Margin Accounting by Customer (0BA_PA_MP01_Q0004) query.
Note
The filter characteristics Fiscal Year Variant (0FISCVARNT) and Source System ID (0SOURSYSTEM) are used as constants. To use the query for your own purposes, replace the predefined values or create your own variables.
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Legal Entity | 0BA_1LGENT | |
| Accounting System | 0BA_1ACCSY | |
| Fiscal Year/Period | 0FISCPER | |
| Fiscal Year Variant | 0FISCVARNT | =K0 |
| Source System ID | 0SOURSYSTEM | =PC |
| Business Segment | 0BA_1SEGM |
Object Type | Name | Technical Name |
|---|---|---|
| Profit Center | 0BA_1PRFCTR |
| External Product | 0BA_EXTPROD |
| Business Segment | 0BA_1SEGM |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Interest Income | 0BA_BZINBE | — |
| Income from Funding of Deviation from Expected Amount | 0BA_1FUDEI | — |
| Total Interest Income | 0BA_PA_MP01_CK001 | 'Interest Income' + Income from Funding of Deviation from Expected Amount' |
| Interest Expense | 0BA_BZINAG | — |
| Expense from Funding of Deviation from Expected Amount | 0BA_1FUDEE | — |
| Total Interest Expense | 0BA_PA_MP01_CK002 | 'Interest Expense' + Expense from Funding of Deviation from Expected Amount' |
| Funding Income | 0BA_1FUNDI | — |
| Funding Expense | 0BA_1FUNDE | — |
| Funding Result | 0BA_PA_MP01_CK014 | 'Funding Income' - 'Funding Expense' |
| Net Interest Margin | 0BA_PA_MP01_CK003 | 'Total Interest Income' - 'Total Interest Expense' + 'Funding Result' |
| Bonus | 0BA_1BONIE | — |
| Penalty Interest | 0BA_1PENII | — |
| Adjustment of Net Interest Margin | 0BA_PA_MP01_CK015 | 'Bonus' - 'Penalty Interest' |
| Commission Income | 0BA_VVPROE | — |
| Commission Expense | 0BA_VVPROA | — |
| Commission Margin | 0BA_PA_MP01_CK004 | 'Commission Income' - 'Commission Expense' |
| Contribution Margin I | 0BA_PA_MP01_CK005 | 'Net Interest Margin' + 'Adjustment of Net Interest Income' + 'Commission Margin' |
| Standard Risk Costs | 0BA_VVRIKO | — |
| Standard Unit Costs | 0BA_VVSTKO | — |
| Equity Capital Costs | 0BA_VVEKKO | — |
| Total Standard Costs | 0BA_PA_MP01_CK012 | 'Standard Risk Costs' + Standard Unit Costs' + 'Equity Capital Costs' |
| Contribution Margin II | 0BA_PA_MP01_CK008 | 'Contribution Margin I' - 'Total Standard Costs' |
| Overhead Costs | 0BA_VVGKZU | — |
| Contribution Margin III | 0BA_PA_MP01_CK010 | 'Contribution Margin II' - 'Overhead Costs' |
| Standard Risk Costs | 0BA_VVRIKO | — |
| Actual Risk Costs | 0BA_VVRKOI | — |
| Risk Result | 0BA_PA_MP01_CK006 | 'Standard Risk Costs' - 'Actual Risk Costs' |
| Standard Unit Costs | 0BA_VVSTKO | — |
| Actual Direct Costs | 0BA_VVDKOI | — |
| Productivity Result | 0BA_PA_MP01_CK009 | 'Standard Unit Costs' - 'Actual Direct Costs' |
| Equity Capital Costs | 0BA_VVEKKO | — |
| Actual Equity Capital Costs | 0BA_1COAC | — |
| Risk-Adjusted Equity | 0BA_PA_MP01_CK007 | 'Equity Capital Costs' - 'Actual Equity Capital Costs' |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Actual | — | |
| Plan | — | |
| Variance between plan cost and actual cost | 'Plan' -' Actual' | |
| Variance Plan/Actual in % | 'Plan' % 'Actual' |