Plan and Forecast Data

This Model Table function is used to provide periodic plan and forecast totals for the relevant accounts.

It defines the following fields:

  • Version: If you connect a real general ledger, you use this field to enter a fixed value. There is no variance because a general ledger provides only real data. You can use this field if versioned data is provided along with real general ledger data.

  • Posting Date: You use this field to provide GL totals on a yearly, quarterly, monthly, or even daily basis to run the profitability and cost management process.

  • Finance Source: There are customer system landscapes, where not all relevant accounting data is coming from one General Ledger. In this case, the Finance Source field can have different values and is still available in reporting.

  • Company: Profitability and Cost Management is usually executed at controlling area level, which spans multiple companies and legal entities. In such cases, this field can have different values and is still available in reporting.

  • Profit Center: This field is required because the model incorporates costs as well as revenues. The profit center is the lowest granularity in a company or legal entity that generates profit.

  • Cost Center: This is the lowest level of granularity in a company or legal entity where costs are pooled and controlled. The plan and forecast data is often maintained by the corresponding cost center business owner.

  • GL Account: You use this field to record revenues and costs at a granular level. This field is also referred to as Cost Element.

  • Currency [TC]: The transaction currency is the currency chosen in the sample content to calculate profitability. Irrespective of the currency used in an implementation project, it is common practice to translate every amount into one single currency (controlling area currency) so that only one currency is used in the complete profitability model.

  • Amount [TC]: You use this field to specify the amount in transaction currency that represents costs or revenues.

  • Functional Area: You use this field for business segment reporting and drill down. This field is also referred to as Business Segment.

  • Scenario: You use this field to maintain different data set scenarios.