Customer and Channel Positions

This Model Table function is used to provide periodic customer and channel positions from the relevant operational source systems.

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.

• Product and Service: You use this field to define the product or service.

• Sales Channel: You use this field as a unique ID to identify the sales channel through which the products are sold.

• Customer ID: You use this field to identify the customer in the position.

• Average Revenue per User/Customer: You use this field to define the average spending that a customer pays for specific products and services.

• Currency [TC]: The transaction currency is the currency used to calculate profitability in the sample content. 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.

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

• Market Area: You use this field to define the region that data relates to. It is used to compare different results by geographical region (for example, the United States, Middle East, Asia or European countries).