ROI (Return on Investment)

Technical name: 0ECCS_C01_Q9011

Based on InfoCube: 0ECCS_C01 (Transaction Data, Consolidation).

Use

This query serves to display the return on investment for different versions (for example plan version and actual version). The system calculates the return on investment using the following:

Characteristics, and
Constants that you enter in the formula editor.

The result of the Return On Investment query indicates the profitability of the investment expressed in percent (as a cumulative and then annual value). The calculation is based on the "DuPont System of Financial Control" model and divides the ROI into two ratios: "Capital Turnover" (Net Sales / Invested Total Capital) and "Return on Sales" (NOPAT / Net Sales).

The calculation of the ROI is exclusively based on the data of statutory consolidation. The system calculates the return on investment using the structure ROI (Return on Investment) ( 0ECCS_C01_QTROI ). The ROI calculation structure is based on the consolidation chart of accounts 01, that is the selection of items ( 0CS_ITEM ) is performed using the consolidation chart of accounts ( 0CS_CHART ) 01. As you enter the constants in the formula editor, no history of constants is available.

Filters

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0REQUID	Request ID : You have to copy the characteristic 0REQUID with the variable 0S_RQMRC (Most Current Data) to the filter. The variable provides the most current BW data from the transactional InfoCube.
0FISCPER	Fiscal Year / Period : Period of the fiscal year to be analyzed (for example 12/2001)
0FISCVARNT	Fiscal Year Variant (for example calendar year, 4 special periods)
0CS_GROUP	Consolidation Group (hierarchy node in the respective view); forms the basis of the analysis in SAP Business Information Warehouse (SAP BW)
0CS_CHART	Consolidation Chart of Accounts that is used in the SAP System
0CS_DIMEN	Dimension that is used in the SAP System, in which the data is saved
0CS_HDATFR	Hierarchy from : The transaction data of the Consolidation component is dependent on a hierarchy of consolidation groups. As these are in turn time-dependent, the characteristics 0CS_HDATFR and 0CS_HDATTO have to be added to the filter with the variables 0P_CSHF (Hierarchy from (SAP exit)), or 0P_CSHT (Hierarchy to (SAP Exit)). These variables are derived from the query key date and are replaced using an SAP exit.
0CS_HDATTO	Hierarchy to : See the explanation for "0CS_HDATFR" above.

Free Characteristics

InfoObject	Description
0CS_UNIT	Consolidation Unit

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0ECCS_C01_QTROI	Structure for ROI calculation
Return on Investment (Annual)	Formula (expressed in percent): 'Return on Investment (Cumulative)' / 'Number of Months (from variable 0I_FPER )’ *12
Return on Investment (Cumulative)	Formula (expressed in percent): 'Return on Investment' * ‘Profit in % of Sales’
Capital Turnover	Formula: –1 * 'Net Sales‘/ 'Invested Total Capital'
Profit in % of Sales	Formula (expressed in percent): 'NOPAT' / (–1 * 'Net Sales')
NOPAT	Formula: 'Operating Profit' * (1 – NODIM ('Tax Rate') / 100)
Tax Rate	Formula (expressed in percent): 50 Enter the value (constant) to be used at runtime in the formula editor.
Operating Profit	Formula: –1 * 'Net Sales' – 'Cost of Sales' – 'Operating Costs'
Net Sales	Item range: 301000 to 302999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Cost of Sales	Item range: 303000 to 303999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Operating Costs	Item range: 310100 to 313999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Invested Total Capital	Formula: 'Current Assets' + 'Tangible Assets Net' + 'Intangible Assets'
Current Assets	Formula: 'Means of Payment' + 'Current-Asset Securities' + 'Receivables from Goods and Services' + 'Inventory' + 'Deferred Taxes' + ‘Deferred Charges'
Means of Payment	Item range: 110100 to 110199 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Current-Asset Securities	Item range: 110200 to 110299 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Receivables from Goods and Services	Item range: 120000 to 131999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Inventory	Item range: 135000 to 135999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Deferred Taxes	Item range: 150000 to 150999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Deferred Charges	Item range: 140000 to 140999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Tangible Assets Net	Item range: 190000 to 199999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )
Intangible Assets	Item range: 180000 to 185999 (Restricted key figure), restricted as Cumulative (Year-to-Date) Value in Group Currency ( 0CS_YTD_GC )

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CSVERSION	Cumulated Balance in Group Currency (0CS_YTD_GC) for the selected fiscal year and Consolidation Version (0CS_VERSION) (Enter this information in the selection dialog.)