Flexible Lifetime Analysis 
Technical name: 0MEMSDC07_Q0008
Use
This query can be used to analyze the lifetime of a subscription according to flexible criteria. You can specify a date range to restrict the validity period, as well as carry out selection according to a wide range of criteria.
You can enter any validity period for selecting date intervals. You must specify the interval for which the lifetime analysis is to be performed for the Subscription Valid From (0ME_POSEX__0ME_VALID_F)and Subscription Valid To (0ME_POSEX__0ME_VALIDTO) dates. The system selects the corresponding internal items in the subscription orders and determines the key date required to calculate the lifetime of the subscriptions in background processing.
The lifetime analysis only takes account of items that belong to the item types standard item (SI), free item (FI), and trial item (TI). It does not take account of items created when a subscription is split.
Filter
InfoObject |
Description of InfoObject (and restriction or calculation formula) |
0ME_DELSPL |
Alternating address element Filter: Not assigned (#) Exclusion of multiple records with overlapping validity periods for an external item that are created when a subscription is split. When a subscription is split, an attribute value is entered for the alternating address element for the additional records created. |
0ME_POSEX__0ME_VALID_F |
Subscription valid from Variable: Subscription Valid From (0I_ABO02) |
0ME_POSEX__0ME_VALIDTO |
Subscription valid to Variable: Subscription Valid To (0I_ABO03) |
0ME_P_VAL_F |
Item valid from Variable: Item valid from (0I_ABO04) |
0ME_P_VALTO |
Item valid to Variable: Item Valid To (0I_ABO05) |
Freely Defined Characteristics
InfoObject |
Description |
0ME_PUBLCT |
Publication Variable, ready for input: Publication (0S_MEPBL) |
0ME_EDITION |
Edition Variable, ready for input: Edition (0S_MEPVA) |
0ME_POSEX__0ME_PSOTYP |
Sales order type Sales order type (0S_MESOT) |
0ME_POSEX__0SALESORG |
Sales organization Sales organization (0SALEORG) |
0ME_POSEX__0DISTR_CHAN |
Distribution channel Distribution channel (0DISCHAN) |
0ME_POSEX__0DIVISION |
Division Division (0DIVISIO) |
0ME_PPERUN |
Service type Service type (0S_PER01) |
0ME_DELTYPE |
Delivery type Delivery type (0S_MEDTP) |
0ME_PURMOT |
Purchase reason Purchase reason (0S_PUR01) |
0ME_REASEOD |
Termination reason Termination reason (0S_REA01) |
0ME_SALSOUR |
Sales source Sales source (0S_SAL01) |
0ME_SALPROM |
Sales promotion Sales promotion (0S_SALP1) |
0ME_ADVMED |
Advertising medium Advertising medium (0S_ADV01) |
0ME_PSPCAMP |
Campaign (WBS no.) Campaign element (0S_CTELM) |
0ME_MATGIFT |
Gift Gift (0S_MAT01) |
0ME_BMSVRCM |
Commission recipient’s SC Commission recipient’s SC (0S_VSG01) |
0ME_PAYM_M |
Payment method Payment method (0S_PAY01) |
0ME_ITEMTP |
Item type Filter values: Standard Item (SI), Free Item (FI), Trial Item (TI) |
0ME_SALEORD |
Sales order Subscription order number (0S_ABO01) |
Variables Used
Variable |
Description |
0I_ABO02 |
Subscription valid from Selection of valid external items according to flexible interval restriction for date Subscription Valid From (0ME_POSEX__0ME_VALID_F). Selection variable, ready for entry, processed by SAP exit. Default values: Lower limit of interval: 01/01/1900 Upper limit of interval: Current date The date of the top limit of the interval is transferred to the variable Key Date for Lifetime (0P_ABO2) for use in calculating the lifetime of the subscription according to key date logic. Date interval is transferred to variable 0I_ABO04. |
0I_ABO03 |
Subscription valid to Selection of valid external items according to flexible interval restriction for date Subscription Valid To (0ME_POSEX__0ME_VALIDTO). Selection variable, ready for entry, processed by SAP exit. Default values: Lower limit of interval: Current date Upper limit of interval: Unlimited (12/31/9999) Date interval is transferred to variable 0I_ABO05. |
0I_ABO04 |
Item valid from Selection of valid internal items according to flexible interval restriction for date Item Valid From (0ME_P_VAL_F). Selection variable, not ready for input, processed by SAP exit. Interval is transferred from variable 0I_ABO02. |
0I_ABO05 |
Item valid to Selection of valid internal items according to flexible interval restriction for date Item Valid To (0ME_P_VALTO). Selection variable, not ready for input, processed by SAP exit. Interval is transferred from variable 0I_ABO03. |
0P_ABO02 |
Key date for lifetime (FV) Key date for calculating lifetime. Formula variable, not ready for input, processed by SAP exit. Date for key date calculation is transferred from the upper limit of the interval for the variable Subscription Valid From (0I_ABO02) |
0P_ABOD1 |
Subscription valid from (external) (FV) Variable for calculating lifetime. Formula variable, not ready for input, processed by substitution path to Subscription Valid From (0ME_VALID_F) attribute of characteristic Subscription Item (External) (0ME_POSEX). |
0P_ABOD2 |
Subscription valid to (external) (FV) Variable for calculating lifetime. Formula variable, not ready for input, processed by substitution path to Subscription Valid To (0ME_VALIDTO) attribute of characteristic Subscription Item (External) (0ME_POSEX). |
0S_MEPBL |
Publication Selection variable, ready for input |
0S_MEPVA |
Edition Selection variable, ready for input |
0S_MESOT |
Sales order type Selection variable, ready for input |
0SALEORG |
Sales organization Selection variable, ready for input |
0DISCHAN |
Distribution channel Selection variable, ready for input |
0DIVISIO |
Division Selection variable, ready for input |
0S_PER01 |
Service type Selection variable, ready for input |
0S_MEDTP |
Delivery type Selection variable, ready for input |
0S_PUR01 |
Purchase reason Selection variable, ready for input |
0S_REA01 |
Termination reason Selection variable, ready for input |
0S_SAL01 |
Sales source Selection variable, ready for input |
0S_SALP1 |
Sales promotion Selection variable, ready for input |
0S_ADV01 |
Advertising medium Selection variable, ready for input |
0S_CTELM |
Campaign element Selection variable, ready for input |
0S_MAT01 |
Gift Selection variable, ready for input |
0S_VSG01 |
Commission recipient’s SC Selection variable, ready for input |
0S_PAY01 |
Payment method Selection variable, ready for input |
0S_ABO01 |
Subscription order number Selection variable, ready for input |
Lines
InfoObject |
Description of InfoObject (and restriction or calculation formula) |
0ME_POSEX__0CALYEAR |
Year Year from which the subscription is valid according to subscription valid from date (0ME_POSEX__0ME_VALID_F) |
Columns
InfoObject |
Description of InfoObject (and restriction or calculation formula) |
0MEMSDC07_QT001 |
Lifetime Periods The Lifetime Periods structure (0MEMSDC07_QT001) is used to display and, in part, calculate the key figures. |