Customer and Channel Positions

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

The function defines the following fields:

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

• Position ID: This field specifies a unique ID to identify the position.

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

• Channel: You use this field to specify the distribution channel, for example, wholesale or retail.

• Product for Profitability Analysis: You use this field to define the product or service.

• Unit: You use this field to define the quantity unit, for example, pieces.

• Quantity: You use this field to define the quantity of products and services, which the customer received via the given channel on the posting date.

• Position Amount [TC]: You use this field to define the price the customer paid for the quantity of products and services.

• Currency Key of Original Transaction 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 one single currency so that only one currency (controlling area currency) is used in the complete profitability model.