General Ledger Data

This Model Table function is used to provide periodic general ledger totals from the relevant accounts.

The function 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: You use this field to specify different values as in some customer system landscapes the relevant accounting data is not retrieved from one general ledger. This field is also available in reporting.

  • Company: You use this field to specify different values as profitability and cost management is usually executed at controlling area level, which spans multiple companies and legal entities. This field is also available in reporting.

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

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

  • Cost Center: This is the lowest 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.

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

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