CRM Sales: CLTV Models 

Technical name: 0CRM_OLVM_Q0002

Use

This query is used for displaying data about a CLTV model from the sales point of view. This means that data collection for such a CLTV model should use an InfoCube containing sales data, such as sales orders (0CSAL_C03). One example is the delivered CLTV model CLTV from the Sales View (0CRM_SALES).

This query is almost identical to the query CRM CLTV Models (0CRM_OLVM_Q0001). It differs in the fact that this query has the column Net Value per Customer instead of Profit per Customer. This is because an InfoCube with sales data forms the basis for the CLTV model from the sales perspective and only contains details about revenue, not profit. Nevertheless, the same object 0CRMAPROFIT is filled with data in both cases since the ODS object with all CLTV models (0CRM_OLVM) only contains this InfoObject. You need to ensure in the CLTV model that this InfoObject is filled correctly.

Free Characteristics

Info Object	Description
0CRMAMODEL	CLTV Model (Variable 0P_CLTVM)

You should fill the variable 0P_CLTVM using a CLTV model from the sales view (such as 0CRM_SALES).

For more technical information about creating this query, see the documentation on the query CRM CLTV Models (0CRM_OLVM_Q0001).