SAP AA: Advertiser - Revenue Development Over Time 
Query: 0MEMAMC05_Q0008
This query is used in the Analytic Composite Key Account Manager Advertising (MEDIA_NM_ADVERTISER).
This query is used to display revenue development over time (in months) for each publication and advertiser.
Note
Since this query is only used as the basis for views that are used in the Analytic Composite, it should no longer be modified (for example by adding or removing additional key figures or changing the characteristics drilldown). Making changes to the query can mean that views can no longer be executed and the Analytic Composite no longer being provided with data.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Service creation year |
0ME_SRVYEAR |
Restricted to the range previous year (0CYEAR # 1) including the following year (0CYEAR + 1) |
Object Type | Name | Technical Name |
|---|---|---|
| Sold-To Party |
0ME_BMSPRTY |
| Advertiser |
0ME_BMADVRT |
| Publication |
0ME_REVOBJ__0ME_PUBLCT |
Object Type | Name | Technical Name |
|---|---|---|
| Publication |
0P_MEPBL |
| Advertiser |
0P_BPME3 |
| Current Calendar Year |
0CYEAR |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Advertiser |
0ME_BMADVRT |
# |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Revenue |
0ME_CONDVAL |
|
| Revenue in Previous Year |
Vorjahr |
0ME_CONDVAL restricted to the service creation year which is the same as the previous year (0ME_SRVYEAR, variable 0CYEAR - 1) |
| Revenue in Current Year |
akt. Jahr |
0ME_CONDVAL restricted to the service creation year which is the same as the current year (0ME_SRVYEAR, variable 0CYEAR) |
| Revenue in Following Year |
Folgejahr |
0ME_CONDVAL restricted to the service creation year which is the same as the following year (0ME_SRVYEAR, variable 0CYEAR +1) |