General Ledger Data

This Model Table function is used to provide periodic general ledger totals from 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: In some system landscapes, not all the relevant accounting data comes from one general ledger. In this case, the Finance Source field can have different values. This field is also available in reporting.

• Company: This field can have different values since 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.

• 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.

• 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 chosen in the sample content to calculate profitability. It is common practice to translate every amount into the same currency so that only one currency (controlling area currency) is used in the complete profitability model.