Media Sales and Distribution (M/SD)
Analysis Scenarios
Analyses of the Media Sales and Distribution Circulation Book
Lifetime Analyses of Live Subscriptions
Periodical Sales and Distribution
Success and Failure Analyses of Live Subscriptions
Roles
Sales Manager (Publisher)
Queries
ABC: Average Circulation - Annual Comparison
ABC: Average Circulation per Weekday
ABC: Average Circulation per Weekday (Media Issue)
ABC: Average Circulation - Monthly Comparison
ABC: Average Circulation According to Distribution Zone
ABC: Average Circulation - Quarterly Comparison
Failure Analysis - Terminations (SI) &0T_ABO01& to Key Date
Failure Analysis - Expected Terminations (SI) to End &0T_ABO01&
Subscription Address History
Subscription Payment Data
Number of Publications per Weekday
Average Circulation per Weekday
Average Circulation per Weekday (Hierarchy Display)
Flexible Lifetime Analysis
Flexible Success/Failure Analysis
Lifetime Analysis Active Subscriptions
Lifetime Analysis Active Terminated Subscriptions
Lifetime Analysis of Active Subs w/Ref. to Publication
Lifetime Analysis of Active Subs w/Ref. to Promotion Data
Lifetime Analysis Inactive Subscriptions
Lifetime Analysis Terminated Subscriptions
Lifetime Analysis Subscriptions Not Terminated
Gift Analysis
Success Analysis - All New Subscriptions Still Active (SI) &0T_A
Success Analysis - All New Subscriptions (SI) &0T_ABO01&
Success Analysis- Subscriptions Already Inactive (NP) &0T_ABO01&
InfoCubes
Subscription Addresses
Subscription Orders on Hand on a Key Date
Subscription Order Items
Subscription Promotion Data
Subscription Payment Data
Circulation Book
Retail Sales Statistics
Delivery Quantities
Deliveries and Complaints
DataStore Objects
Subscription Order Items (Internal)
Structures
Terminations
Circulation per Weekday
Circulation - Comparison Period (Year)
Circulation - Comparison Period (Month)
Circulation - Comparison Period (Quarter)
Lifetime Periods
New Subscriptions
InfoSources
M/SD Subscription Addresses
M/SD Subscription Orders on Hand on a Key Date
M/SD Subscription Order Items
M/SD External Subscription Order Items
M/SD Subscription Promotion Data
M/SD Subscription Payment Data
M/SD Circulation Book (With Delivery Quantities)
M/SD Deliveries (With Order Data)
M/SD Deliveries (Without Order Data)
M/SD Complaints
M/SD Returns
Key Figures
Amortization Amount
Proportional Circulation Inserted
Proportional Combined Circulation
Number of Amortized Deliveries in Billing Cycle
Number of Billed Deliveries in Billing Cycle
Number of Printed Copies
Purchase Quantity
Purchase Quantity (Partial Subscription Weighting)
Purchase Price
Gift Transfer Quantity
Gift Transfer Quantity (Partial Subscription Weighting)
Edition Delivery Quantity
Subsequent Delivery Quantity
Expected Returns
Redirection Quantity (Additional Copy)
Redirection Quantity (Additional Copy) (Partial Subscription Wei
Redirection Quantity
Redirection Quantity (Partial Subscription Weighting)
Complaint Quantity
Quantity Returned
Charitable Transfer Quantity
Charitable Transfer Quantity (Partial Subscription Weighting)
Partial Subscription Weighting
Partial Suspension Quantity
Partial Suspension Quantity (Partial Subscription Weighting)
Transfer Amount
Suspension Quantity
Suspension Quantity (Partial Subscription Weighting)
Additional Payment Amount (Gift)
Characteristics
Subscription Valid To
Subscription Valid From
Subscription Item
Subscription Item (External)
Circulation Book (ID)
Audit Return ID for Edition Delivered
Audit Return ID for Edition (Order)
Audit report category
Audit Report Category for Calculated Free Period
Order Change Type
Order Number for Gift 'Free Subscription'
Exclusion Days for Media Issue
Exclusion Days for Issue
Start of Commitment Period
Billing From
Billing To
Alternating Address Element
Audit Report Category for Calculated Free Period
Order Change Type
Order Number for Gift 'Free Subscription'
Exclusion Days for Media Issue
Exclusion Days for Issue
Start of Commitment Period
Billing From
Billing To
Alternating Address Element
Address Alternation Group
Purchase Reason
Service Type
Service Type (Billing-Relevant)
Mix Type
Data Origin of Circulation
Tuesdays
Thursdays
Schedule Line Type in Sales Order
Created On
Billing Frequency
Fridays
Geographical Unit
Business Partner Sales Agent (Subscriptions)
Start of Validity of Campaign Framework
Copy Number of First Issue to be Delivered
Copy Number of Last Issue to Be Delivered
IS-M: Currency Key for Purchase Price
IS-M: Time Unit for Maximum Delivery Suspension
IS-M: Time Unit for Minimum Length of Subscription
Indicator for Initial Introduction Record
Indicator for Main Sales Agent for Subscription
Indicator for Backdated Item
Indicator: Display Reversal Transactions
Indicator for Original Item
Relevant for Circulation Auditing
Billing-Relevant Indicator
Social Facility Indicator
Termination Reason
Delivery Type
Regular Start of Delivery for Item
Delivery Round
Type of Delivery
Logistical Delivery Type
Maximum Delivery Suspension (in Months)
Minimum Length of Subscription (in Months)
Wednesdays
Mondays
Newspaper Designated Market Zone (NDM) for ABC
Media City Number (One Entry)
Period Start
Item Valid To
Item Valid From
Item Type
Postal Codes Evaluation Territory
Postal Code Area Variant (Circulation Book)
Gift Shipping Date
Customer Price Group
Price Frequency
Pricing Key for Subscription
Gift
Saturdays
Sundays
Block Indicator for Gift Shipping
Cancellation Reason
Trading Zone for ABC
Suspension Reason
(Publishing) Sales Order
Sales Order Introduction
Media Product Family Sold
Media Product Sold
Commitment Period for Sales Agent Reader (in Months)
SC Commission Recipient
Ship-to Party
Sales Promotion
Sales Source
Advertising Bonus Sent
Advertising Medium
Payment Method
Time Slice Classification
Process Chains
Subscription Addresses: Delta Upload
Subscription Addresses: Init Upload
Subscription Order Item (External): Delta Upload
Subscription Order Item (External): Init Upload
Subs. Order Items (Internal) with Promotion Data: Delta Upload
Subs. Order Items (Internal) with Promotion Data: Init Upload
Circulation Book: Delta Upload
Circulation Book: Initial Upload
Audit Report Category Hierarchy: Full Upload
Master Data Media Sales and Distribution: Full Upload
DataSources
M/SD: Circulation Book (With Delivery Quantities)
M/SD Orders on Hand on a Key Date
M/SD Subscription Order Data
M/SD Subscription Order Item
M/SD Transactions Affecting Live Subscriptions
M/SD Subscription Promotion Data
M/SD Address Data for Subscription Order
M/SD Liability Account
M/SD Renewal Payment
M/SD Delivery (With Order Attributes
M/SD Delivery (Without Order Attributes)
M/SD Complaint
M/SD Return