Entering content frame

Query CRM CLTV Predictions Locate the document in its SAP Library structure

Technical name: 0CRM_OLVF_Q0001

Based on ODS object: 0CRM_OLVF CLTV Prediction

Use

You can use this query to display the data for the CLTV predictions that you calculated during CLTV modeling.

Free Characteristics

InfoObject

Description

0CURRENCY

Currency

Structure link0CRMAFOREC

CLTV prediction (variable 0P_CLTV)

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Structure link0CRMASEGID

Segment (variable 0S_CLTV)

Structure link0CRMADATE

CLTV key date (variable 0F_CLTVS)

Structure link0CRMAFCPER

Prediction period (variable 0F_CLTVS)

Structure link0CRMAPERIOD

Lifetime period

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Structure link0CRMACACT

Active customers

Structure link0CRMACLOS

Lost customers

Structure link0CRMAPROF

Total profit

Structure link0CRMACOSTS

Other costs

 

 

 

Leaving content frame