Territory Sales Data 
Technical Name: 0PH_C01
Use
This InfoCube aggregates sales data for territories, based on data provided by IMS.
Info Sources
ODS Object: Territory Sales Data
Characteristics
|
InfoObject |
Description |
|
0PH_PRODGRP |
Product Grouping |
|
0CRM_TRAT |
Territory Attribute Set |
|
0PH_MEDAFFS |
Medical Affiliation Source |
|
0PH_PRESCRI |
Prescriber |
|
0COUNTRY |
Country Key |
|
0CRM_BRICK |
Business Partner (BP) Market Segmentation |
|
0CRM_GROUP |
BP Group Territory |
|
0CRM_MAINSP |
BP Key of Qualification |
|
0CRM_SUBGRP |
BP Subgroup Territory |
|
0CRM_TR |
Territory |
|
0CRM_TRPID |
Territory Path ID |
|
0PH_ASSPC |
Assigned Product Category |
|
0PH_EXT_DC |
External Distribution Channel |
|
0PH_MKT |
Market |
|
0PH_PLN |
Plan |
|
0POSTALCODE |
CAM: Postal Code |
|
0PROD_CATEG |
Product Category |
|
0PH_QNTL |
Quantile Market |
|
0PH_QNTL_PG |
Quantile Product Group |
|
OREGION |
Region (State, Province, County) |
|
0VALIDFROM |
Valid From |
|
0VALIDTO |
Valid To |
Time Characteristics
|
InfoObject |
Description |
|
Calendar Year / Month |
|
|
0FISCVARNT |
Fiscal Year Variant |
|
0CALQUARTER |
Calendar Year / Quarter |
|
0CALYEAR |
Calendar Year |
|
0FISCPER |
Fiscal Year / Period |
|
0FISCPER3 |
Posting Period |
|
0FISCYEAR |
Fiscal Year |
Key Figures
|
InfoObject |
Description |
|
New Prescriptions Amount |
|
|
0PH_NRX_NUM |
New Prescriptions Number |
|
0PH_NRX_QTY |
New Prescriptions Quantity |
|
0PH_TRX_AMO |
Total Prescriptions Amount |
|
0PH_TRX_NUM |
Total Prescriptions Number |
|
0PH_TRX_QTY |
Total Prescriptions Quantity |
Units
|
InfoObject |
Description |
|
Currency Key |
|
|
0UNIT |
Unit of Measure |