InfoSet /SAPQUERY/CFM_REVENUE

Use

You can use the CFM_REVENUE InfoSet to evaluate revenues earned within a given period. This enables you to analyze all the revenues for the respective due date or period.

Evaluations can be generated with the CFM_REVENUE InfoSet in the following form:

Prerequisites

Customizing for the Information System in the Transaction Manager

Features

  • This InfoSet is based on the FTI_TR_PL_CF logical database so that the same fields are available in both.

  • Additional fields

    You can display all the expenses and revenues that are classified by profit/loss types in Customizing in separate columns. Three additional fields have been defined for each relevant profit/loss type (two additional fields for FX profit/loss types):

    • Profit/loss in position currency

    • Profit/loss in local currency

    • Profit/loss in display currency

      Entries are made in the fields using GET custom coding. Choose Start of the navigation path Goto Next navigation step Coding Next navigation step GET. End of the navigation path The code analyzes the respective profit/loss type for the individual flows and assigns it to the corresponding additional fields.

      Example Example

      If the flow is assigned to P/L type 310 , the net income amount is assigned to the additional field defined for this purpose using the GET custom coding. The defined additional fields can then be used for the query definition. This enables a detailed analysis of revenues/expenses.

      Example:

      Expenses and revenues are assigned to the corresponding profit and loss key figures, depending on the profit/loss type assigned to each update type. In this example, the realized price gains, achieved at the time of outflow are assigned to the "realized gains securities LC / P/L C" key figures. All other revenues are displayed in the same way in separate columns.

      End of the example.

      Product Type

      P/L Type

      ID Number

      Due on:

      Total Realized Gains Securities LC

      LC

      Total Realized Gains Securities P/L C

      P/L C

      Fixed interest sec.

      Realized security price gains

      444444

      10/01/02

      46,016.27

      EUR

      90,0000.00

      USD

      Zero bonds

      Realized security price gains

      8548547

      10/24/02

      9,160,082.37

      EUR

      17,915,563.91

      USD

      Note Note

      These settings apply to the sample Customizing settings delivered with the system. If you require different settings for the profit/loss types, the GET custom coding has to be adjusted accordingly.

      End of the note.

Activities

To edit the InfoSet, choose Start of the navigation path Transaction Manager Next navigation step Information System Next navigation step Tools Next navigation step SAP Query Next navigation step MaintainInfoSets. End of the navigation path