Advertising Management (M/AM)
Analysis Scenarios
Advertising Management
Roles
Advertising Manager
Media: Analytic Composite N&M
Sales Representative in Advertising Management (Portal)
Web Templates
Web Template: Revenue Development for Sold-to Parties
Web Template: Revenue Development for Basic Booking Units
Web Template: Revenue Development for Publications
Web Template: Revenue Development for Content Components
Web Template: Revenue Development for Advertisers
Web Template: Revenue Development for Combined Booking Units
Web Template: Revenue Development for Editions
Web Template: Revenue Development for Payers
Web Template: Revenue Development for Sales Offices
Web Template: Key Dte Comp.: Bottom 10 Sold-to Parties/Advertsrs
Web Template: Key Date Comparison: Bottom 10 Basic Booking Units
Web Template: Key Date Comprsn: Bottom 10 Combined Booking Units
Web Template: Key Date Comparison for Sold-to Parties
Web Template: Key Date Comp.: Sold-to Parties With Advertisers
Web Template: Key Date Comparison for Basic Booking Units
Web Template: Key Date Comp.: Bottom 10 Sold-to Parties
Web Template: Key Date Comp.: Bottom 10 Publications
Web Template: Key Date Comp.: Bottom 10 Advertisers
Web Template: Key Date Comp.: Bottom 10 Editions
Web Template: Key Date Comparison: Publications
Web Template: Key Date Comp.: Advertiser Winners
Web Template: Key Date Comp.: Edition Winners
Web Template: Key Date Comparison for Advertisers
Web Template: Key Date Comp.: Combined Booking Units
Web Template: Key Date Comparison: Editions
Web Template: Key Date Comp.: Top 10 Sold-to Parties
Web Template: Key Date Comp.: Top 10 Basic Booking Units
Web Template: Key Date Comp.: Top 10 Publications
Web Template: Key Date Comp.: Top 10 Advertisers
Web Template: Key Date Comp.: Top 10 Editions
Web Template: Key Date Comp.: Top 10 Combined Booking Units
Web Template: Key Date Comp.: Sold-to Party Losers
Web Template: Key Date Comparison: Publication Losers
Web Template: Key Date Comp.: Advertiser Losers
Web Template: Key Date Comparison: Edition Losers
Web Template: Key Dte Comp.: Sold-to Party/Advertiser Winners
Web Template: Key Date Comparison: Basic Booking Unit Winners
Web Template: Key Date Comparison: Combined Booking Unit Winners
Web Template: Key Date Comp.: Top 10 Sold-to Parties/Advertisers
Web Template: Key Dte Comp.: Sold-to Parties/Advertisers Losers
Web Template: Key Date Comparison: Basic Booking Unit Losers
Web Template: Key Date Comp.:Combined Booking Unit Losers
Web Template: Top 10 Sold-to Parties by Revenue
Web Template: Top 10 Basic Booking Units by Revenue
Web Template: Top 10 Publications by Revenue
Web Template: Top 10 Content Components by Revenue
Web Template: Top 10 Advertisers by Revenue
Web Template: Top 10 Combined Booking Units by Revenue
Web Template: Top 10 Editions by Revenue
Web Template: Top 10 Payers by Revenue
Web Template: Top 10 Sales Agents by Gross Value per Month
Queries
Queries for AnalyticComposites
SAP AA: Advertiser - Contracts
SAP AA: Advertiser - Contracts
SAP AA: Advertiser - Contact Person
SAP AA: Advertiser - Contact Person
SAP AA: Advertiser Selection
SAP AA: Advertiser Selection (PreQuery)
SAP AA: Advertiser - Revenue Development per Publication
SAP AA: Advertiser - Revenue Development per Publication
SAP AA: Advertiser - Revenue Development Over Time
SAP AA: Advertiser - Revenue Development Over Time
Current Top N Revenues (Total)
Revenue Development (Total)
Net Sales Volume: Sales Agents per Month
Complaint Reasons for Each Sales Document Level
Complaint Ratio
Key Date Revenues (Total)
Top N Sales Agents by Gross Value per Month
Sales Agent Commission (Simulation)
Value-Oriented Complaint Ratio
InfoCubes
Contract
Contract
Schedule Line/Ad Spec (Ads Only)
Revenues (Order)
Revenues (Order)
Revenues (Billing Document)
Revenue Quantities (Order)
Revenue Quantities (Billing Document)
Billing Document
Media Business Partner Relationships (SAP Business Partner)
Billing Datasets
Billing Datasets (Ads Only)
Complaints
Complaints (Billing Datasets Only)
Sales Agent (Order)
MultiCube: Ad Orders (Total)
MultiCube: Revenues (Total)
MultiCube: Revenue Quantities (Total)
MultiCube: Complaints and Billing Datasets
Complaints
DataStore Objects
Billing Datasets
InfoSources
M/AM Contract (With Time Slices)
M/AM Contract Assignments
M/AM Order: Schedule Line/Ad Spec
M/AM Order: Billing Dataset
M/AM Order: Sales Agent
M/AM Revenues (Order)
M/AM Revenues (Billing Document)
M/AM Revenue Quantities (Order)
M/AM Revenue Quantities (Billing Document)
M/AM Billing Data
M/AM Billing Items With Contract Assignments
M/AM Complaints
Key Figures
Sales Agent Share of the Calculation Basis (in %)
Sales Agent Share of the Commission (in %)
Number of (Publication) Days
Number of Billing Datasets
Number in Contract Assignment
Number of Complaints
Calculation Quantity (Ad Insert)
Gross Value (Header)
Gross Value (Item)
Service Quantity
Planning Quantity for Ad Inserts
Revenues
Revenue (Unbilled)
Revenue Development
Revenue Development (Unbilled)
Revenue Quantity
Revenue Quantity (not Billed)
Revenue Quantity Development
Revenue Quantity Development (Unbilled)
Size in Column mm 1
Size in Column mm 2
Actual Ad Spec Width
Actual Ad Spec Height
Actual Quantity for Distribution
Condition Base Value
Condition Amount/Percentage Rate
Delivery Quantity for Ad Insert
VAT Amount
Quantity
Quantity in Contract Assignment
Quantity Additional Calculation Units
Actual Ad Spec Size
Planned Ad Spec Size
Net Value (Header)
Net Value of Billing Item
Planned Quantity for Distribution Full Booking
Postal Circulation Quantity
Price Including VAT
Price Without VAT
Price Field 1 in the Order
Price Field 2 in the Order
Commission Amount for mm Commission
Postal Circulation Quantity
Price Including VAT
Price Without VAT
Price Field 1 in the Order
Price Field 2 in the Order
Commission Amount for mm Commission
Commission Rate (Percentage)
Planned Ad Spec Width
Planned Height for Ad Spec
Ad Insert Weight
Totaled Width of Sub Ad Specs
Totaled Height for Sub Ad Specs
Sales Volume for the Contract Assignment
Ad Spec Width for Settlement
Height of the Ad Spec for Settlement
Characteristics
Contract Requirement
Contract Number
Color Scheme Ad Type
Shape Ad Type
Design Ad Type
Special Handling Ad Type
Order Ad Spec Number (Ad)
Order Item Type
Order Item Number
Order Sub-Item
Order-Publishing-Media
Order Origin
Initial Booking Unit
Basic Booking Unit
BU Content Grouping
BU Statistics Grouping
Booking Unit
Service Booking Unit
Date on which Services were Created (Settlement Perspective)
Service Type
Schedule Line
Revenue Object
Billing Category
Format Proposal (Ad)
Format Proposal (Online)
Billing Dataset
Content Component
Content Component from Price Hierarchy
Content Component for the Schedule Line
Business Content Component
Technical Content Component
Content Component Type
Campaign (WBS Number)
Agency CommissionIndicator
Agency Order Indicator
OrderObject Cancelled Indicator
BasicBooking Unit Indicator
Schedule Line Published Indicator
Billed Indicator
CombinationSale Indicator
Combined Booking Unit
Competitor Exclusion
Partner Object
Positioning Instruction
Commission Category
Complaint Processor
Complaint Date
Complaint Reason
Complaint Number
Complaint Status
Page Format
Page/Column Format
Ad Insert Category
Sales Document Type
Sales Agent Contract
Contract Category (Sales Agent Contract)
Combination Sale Type
Commercial Cluster
Commercial Broadcast Item
Commercial Position
Commercial Time Slice
Process Chains
Contracts: Delta Upload
Contracts: Init Upload
Contact Person Master Data: Full Upload
Booking Unit: Full Upload
Schedule Lines and Ad Specs: Delta Upload
Schedule Lines and Ad Specs: Init Upload
Revenue and Revenue Quantities (Order): Delta Upload
Revenue and Revenue Quantities (Order): Init Upload
Revenues and Rev. Qntities (BDoc.) - Create New: Full Upload
Revenue and Revenue Quantities (Billing Doc.): Delta Upload
Revenues and Revenue Quantities (Billing Doc.): Init Upload
Revenues and Rev. Qntities (BDoc.) - Create New: Full Upload
Billing Document: Delta Upload
Billing Document: Init Upload
Billing Datasets: Delta Upload
Billing Datasets: Initial Upload
Content Component: Full Upload
Product Hierarchy: Full Upload
Complaints: Delta Upload
Complaints: Init Upload
Master Data – Advertising Management: Full Upload
Sales Agent (Order): Delta Upload
Sales Agent (Order): Init Upload
DataSources
Contract
Contract Assignment
Order Schedule Line/Ad Spec
Order Billing Dataset
Order Sales Agent Assignment
Order Revenues
Order Revenues Restructure
Billing Document Revenues
Billing Document Revenues Restructure
Revenue Quantities Order
Order Revenue Quantities Restructure
Billing Document Revenue Quantities
Billing Document Revenue Quantities Restructure
Billing Data
Billing Data With Conditions
Billing Items With Contract Assignment
Complaints