Start of Content Area

Procedure documentation Example: Defining Cells for Changes to Key Figures  Locate the document in its SAP Library structure

...

Procedure

1. Call Cell Definition

       1.      Call the cell definition function in BEx Query Designer.

       2.      A table appears containing the columns and rows that you defined in Example: Defining Filters, Free Characteristics, Columns and Rows. The cells are empty and need to be filled as follows:

Cell Definition

 

Reporting Period /&0T_FPERF& to &0T_FPERT&

Comparison Period /&0T_FPERF& to &0T_FPERT&

Second Comparison Period /&0T_FPERF& to &0T_FPERT&

Result

 

 

 

Depreciation

 

 

 

Reserves

This graphic is explained in the accompanying text Reporting Period / Reserves

This graphic is explained in the accompanying text Comparison Period / Reserves

This graphic is explained in the accompanying text Second Comparison Period / Reserves

Increase in Reserves

This graphic is explained in the accompanying text Reporting Period / Increase in Reserves

This graphic is explained in the accompanying text Comparison Period / Increase in Reserves

 

Decrease in Reserves

This graphic is explained in the accompanying text Reporting Period / Decrease in Reserves

This graphic is explained in the accompanying text Comparison Period / Decrease in Reserves

 

Inventories and Receivables from Goods and Services

This graphic is explained in the accompanying text Reporting Period / Inventories and Receivables from Goods and Services

This graphic is explained in the accompanying text Comparison Period / Inventories and Receivables from Goods and Services

This graphic is explained in the accompanying text Second Comparison Period / Inventories and Receivables from Goods and Services

Changes to Inventory and Receivables

This graphic is explained in the accompanying text Reporting Period / Changes to Inventory and Receivables

This graphic is explained in the accompanying text Comparison Period / Changes to Inventory and Receivables

 

Payables from Goods and Services

This graphic is explained in the accompanying text Reporting Period / Payables from Goods and Services

This graphic is explained in the accompanying text Comparison Period / Payables from Goods and Services

This graphic is explained in the accompanying text Second Comparison Period / Payables from Goods and Services

Changes to Liabilities

This graphic is explained in the accompanying text Reporting Period / Changes to Liabilities

This graphic is explained in the accompanying text Comparison Period / Changes to Liabilities

 

Cash Flow from Ongoing Business Activities

 

 

 

2. Define Cell References

       3.      To define a cell in the table as a reference for subsequent use in formulas, select the cell and choose New Cell Reference in the context menu.

       4.      Give the cell reference a unique description (Column Name/Row Name for example) so that it can be quickly identified. Change the description in the Properties of the Selection/Formula dialog.

The cell reference is flagged in the table using the This graphic is explained in the accompanying text symbol.

3. Define Changes to Basic Key Figures

...

...

       1.      To calculate changes to the basic key figures, place the cursor in the relevant cell, choose New Formula from the context menu and define the cell using the cell references as operands.

○       Define the formulas for the cells in the Reporting Period column as follows:

Reporting Period / <Key Figure from the Rows> - Comparison Period / <Key Figure from the Rows>

○       Define the formulas for the cells in the Comparison Period column as follows:

Comparison Period / <Key Figure from the Rows> - Second Comparison Period / <Key Figure from the Rows>

       2.      Give the formulas a unique description (Column Name/Row Name for example) so that they can be quickly identified. Change the description in the Properties of the Selection/Formula dialog.

The formulas are flagged in the table using the This graphic is explained in the accompanying text symbol.

4. Define Increase / Decrease of Basic Key Figures

...

       1.      To calculate increases and decreases of basic key figures, place the cursor in the relevant cell, choose New Formula from the context menu and define the cell using the cell references as operands.

○       Define the formulas for the cells in the Reporting Period column as follows:

■       Increases : MAX0 (Reporting Period / <Key Figure from the Rows> - Comparison Period / <Key Figure from the Rows>)

■       Decreases : MIN0 (Reporting Period / <Key Figure from the Rows> - Comparison Period / <Key Figure from the Rows>

○       Define the formulas for the cells in the Comparison Period column as follows:

■       Increases MAX0 (Comparison Period / <Key Figure from the Rows> - Second Comparison Period / <Key Figure from the Rows>)

■       Decreases MIN0 (Comparison Period / <Key Figure from the Rows> - Second Comparison Period / <Key Figure from the Rows>)

Note

For the increases and decreases of key figures, you can use the mathematical functions Maximum of 0 and Operand (MAX0) and Minimum of 0 and Operand (MIN0).

       2.      Give the formulas a unique description (Column Name/Row Name for example) so that they can be quickly identified. Change the description in the Properties of the Selection/Formula dialog.

The formulas are flagged in the table using the This graphic is explained in the accompanying text symbol.

More Information

Defining Exception Cells

 

 

End of Content Area