Success Analysis for Series Sales - Active New Subscriptions &0T_SUB01& 
Query: 0MEMPSC01_Q0008
This query is used to analyze all new subscriptions that are still active in the current year up to the key date. The lifetime is still calculated as the number of days the series subscription lasted from its creation until the key date.
You can specify any key date you wish. This date is used to calculate the lifetime periods and also to determine the limits of the interval for selecting the series subscriptions that might be included in the analysis.
Selection criteria for the date intervals used to select all new subscriptions in the current year:
Subscription start |
Contract start |
Contract end |
|---|---|---|
Interval [start of key date year; key date] |
Interval [start of key date year; key date] |
> key date |
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Subscription start |
0ME_SUBVALF |
Variables: Start of key date year (0P_ABO09); Key date for lifetime (0P_ABO01) Filter condition: Interval from start of key date year to lifetime key date |
| Contract start |
0ME_ITMVALF |
Variables: Start of key date year (0P_ABO10); Key date for lifetime (0P_ABO03) Filter condition: Interval from start of key date year to lifetime key date |
| Contract end |
0ME_ITMVALT |
Variable: Key date for lifetime (0P_ABO04) Filter condition: greater than (>) |
| Termination reason |
0ME_CANCREA |
Filter condition: Non-assigned (#) |
| Item category |
0ITEM_CATEG |
Object Type | Name | Technical Name |
|---|---|---|
| Media product family |
0ME_MED_FAM |
| Media product |
0ME_MED_PRO |
| Campaign (WBS no.) |
0ME_PSPCAMP |
Object Type | Name | Technical Name |
|---|---|---|
| Media product family |
0P_MEP05 |
| Media product |
0P_MEP02 |
| Campaign (WBS element) |
0P_CAMP1 |
| Key date for lifetime — Key date entry for subscription start date (0ME_SUBVALF). — Selection variable, ready for entry, processed by SAP exit. — Default value Today's date — Transfers the key date to the variables 0P_ABO03, 0P_ABO04, 0P_ABO09, 0P_ABO10, 0F_SUB02. |
0P_ABO01 |
| Key date for lifetime — Selection of valid items according to key date entry for the variable 0P_ABO01. — Selection variable, not ready for input, processed by SAP exit. |
0P_ABO03 |
| Key date for lifetime — Selection of valid items according to key date entry for the variable 0P_ABO01. — Selection variable, not ready for input, processed by SAP exit. |
0P_ABO04 |
| Start of key date year — Determine the start of year (Format: yyyy0101) for the key date year from the key date entry for the variable 0P_ABO01. — Selection variable, not ready for input, processed by SAP exit. |
0P_ABO09 |
| Start of key date year — Determine the start of year (Format: yyyy0101) for the key date year from the key date entry for the variable 0P_ABO01. — Selection variable, not ready for input, processed by SAP exit. |
0P_ABO10 |
| Key date for lifetime for subscriptions (FV) — Variable for calculating lifetime. Formula variable, not ready for input, processed by SAP exit. — Transfer key date from variable 0P_ABO01. |
0F_SUB02 |
| Subscription start (FV) — Variable for calculating lifetime. — Formula variable, not ready for input, processed by replacement path for the attribute Subscription Start (0ME_SUBVALF) |
0F_SUB01 |
| Contract end (FV) — Variable for calculating lifetime. — Formula variable, not ready for input, processed by replacement path for the attribute Contract End (0ME_ITMVALT). |
0F_SUB04 |
| Key date year — Display key date year in the query. — Text variable, not ready for input, processed by SAP exit. Transfer key date from variable 0P_ABO01. |
0T_SUB01 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Calendar month |
0CALMONTH2 |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| New subscriptions |
0MEMPSC01_QT002 |
The New Subscriptions structure (0MEMPSC01_QT002) is used to display and calculate the key figures. |