Sales and TP for Prod. and Prod. Cat. at BP Hier. Node (Day)

Aggregation level: 0TPM_AC03

This aggregation level is used for planning at day level. It is used in sales and trade promotion management for product and product category business partner hierarchy nodes.

This aggregation level restricts the access to certain dimensions of planning data and makes this data available for planning queries and planning functions. This aggregation level provides a restricted view of the planning data for DataStore Object Sales and Trade Promotions (Day Level) (0TPM_DS01).

Technical Data

Type	Simple
InfoProvider Type	DataStore Object
InfoProvider	Sales and Trade Promotions (Day Level) (`0TPM_DS01`)

Required Objects

Object Type	Name	Technical Name
Characteristic	Calendar Day	`0CALDAY`
Characteristic	Calendar Year/Week	`0CALWEEK`
Characteristic	Fiscal Year/Period	`0FISCPER`
Characteristic	Fiscal Year Variant	`0FISCVARNT`
Characteristic	Business Partner	`0BPARTNER`
Characteristic	BP: Business Partner Group (from Hierarchy)	`0BP_GRP`
Characteristic	CRM Plan Version	`0CRMVERSION`
Characteristic	Trade Promotion Agreement	`0CRM_MKTAGR`
Characteristic	CRM Marketing Element (Campaign and Marketing Plan)	`0CRM_MKTELM`
Characteristic	Product Group 1	`0CRM_PRGRP1`
Characteristic	Product	`0CRM_PROD`
Characteristic	Sales Organization CRM	`0CRM_SALORG`
Characteristic	Distribution Channel	`0DISTR_CHAN`
Characteristic	Division	`0DIVISION`
Characteristic	Promotion Phase	`0PERIOD_TYP`
Characteristic	Sales Category	`0PR_CAT_SAL`
Characteristic	Target Group	`0TGGRP_ID`
Unit of Measure	Currency Key	`0CURRENCY`
Unit of Measure	Sales Unit	`0SALES_UNIT`
Key Figure	Base Sales Quantity in Base Unit of Measure	`0BASE_QTYS`
Key Figure	Fixed Bonus for Displays	`0BONUS_DISP`
Key Figure	Fixed Bonus for Features	`0BONUS_FEAT`
Key Figure	Variable Bonus Based on Scanner Data	`0BONUS_SCAN`
Key Figure	Variable Rebate Based on Sales Quantity	`0BONUS_SHIP`
Key Figure	Budget	`0BUDGET`
Key Figure	Buying Pattern	`0BUY_PAT`
Key Figure	Net Revenue	`0COPANETRV`
Key Figure	Revenue	`0COPAREVEN`
Key Figure	Total Sales Bonus/SU	`0CRM_BONPRO`
Key Figure	Total Sales Bonus/SU	`0CRM_BONSAL`
Key Figure	Cost per Case	`0CRM_CPC`
Key Figure	Cost per Incremental Case	`0CRM_CPIC`
Key Figure	Advance Purchase in Sales Unit	`0FORWBUY_SU`
Key Figure	Internal Value	`0INTVALUE`
Key Figure	Billing Quantity in Sales Units	`0INV_QTY`
Key Figure	Key Figure Indicator	`0KYF_IND`
Key Figure	Bill Back (%) per Sales Unit	`0BONUS_BBP`
Key Figure	Discount (%) per Sales Unit	`0BONUS_OIPSU`
Key Figure	Rebate (Amount) per Sales Unit of Measure	`0BONUS_SHSU`
Key Figure	Bill Back % Discount/SU	`0CRM_BBACK`
Key Figure	Off-Invoice % Discount/SU	`0CRM_OFFINV`
Key Figure	Return on Investment (%)	`0CRM_ROIPER`
Key Figure	Every Day Low Price (Off-Invoice) per Sales Unit	`0EDLP_OINV`
Key Figure	Every Day Low Price (Variable) per Sales Unit	`0EDLP_VARI`
Key Figure	Variable Promotional Discount (Invoice Reduction)	`0OFFR_DSCNT`
Key Figure	Promotion Price Per Unit	`0PROPUNIT`
Key Figure	Regular Revenue	`0REG_REVE`
Key Figure	Total Demand	`0SCAN_QTY`
Key Figure	Uplift Quantity in Sales Quantity Unit	`0UPLI_QTYS`
Key Figure	Variable Promotion Discount (Invoice Markdown) per SU	`0OFFR_DSCSU`
Key Figure	List Price per Sales Unit	`0PRICELIST`
Key Figure	Promotional Price	`0PROMPRICE`
Key Figure	Promotional Units	`0PROUNIT`
Key Figure	Regular Retail Price	`0RETLPRICE`
Key Figure	Variable Bonus Based on Scanner Data per SU	`0BONUS_SCSU`