Failure Analysis for Series Sales - Terminations for Key Date &0T_SUB01& 
Query: 0MEMPSC01_Q0009
This query is used to analyze all terminations 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 |
|---|---|---|
No restriction required |
No restriction required |
Interval [start of key date year; key date] |
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Subscription start |
0ME_SUBVALF |
|
| Contract start |
0ME_ITMVALF |
|
| Contract end |
0ME_ITMVALT |
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 |
| Item category |
0ITEM_CATEG |
Object Type | Name | Technical Name |
|---|---|---|
| Media product family |
0ME_MED_FAM |
| Media product |
0ME_MED_PRO |
| Termination reason — Filter condition: Exclude non-assigned (#) from the selection |
0ME_CANCREA |
| Campaign (WBS no.) |
0ME_PSPCAMP |
| Ship-to party |
0BP_MEDIA |
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 |
| 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 |
|---|---|---|---|
| Month |
0ME_VALT_M |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Lifetime periods |
0MEMPSC01_QT001 |
The Lifetime Periods structure (0MEMPSC01_QT001) is used to display and calculate the key figures. |