Planning Levels

The Planning Level TPM: Planning by Prod. Hierarchy (Technical Name: 4TPO1000) is available for SAP Trade Promotion Optimization.

Characteristics and Key Figures

This planning level contains the following characteristics and key figures:

Characteristics
Technical Name	Description	Selection
`0BASE_UOM`	Base Unit of Measure
`0BPARTNER`	Business Partner
`0BP_GRP`	CRM Business Partner: Business Partner Group (from Hierarchy)
`0CALWEEK`	Calendar Year/Week
`0CRMVERSION`	CRM Plan Version
`0CRM_MKTAGR`	Trade Promotion Agreement
`0CRM_MKTELM`	CRM Marketing Element (Campaign and Marketing Plan)
`0CRM_PROD`	CRM Products
`0CRM_SALORG`	CRM Sales Organization
`0CRM_TACTIC`	Tactic
`0CURRENCY`	Currency
`0DISTR_CHAN`	Distribution Channel
`0DIVISION`	Division
`0LOC_CURRCY`	Local Currency	USD
`0PERIOD_TYP`	Action Phase
`0PR_CAT_SAL`	Sales Category
`0SALES_UNIT`	Sales Unit
`0TGGRP_ID`	Target Group
`0VERSION`	Version	TPM
`0VTYPE`	Value Type for Reporting	20
`_AREA_____`	Planning Area	4TPM8000

Key Figures
Technical Name	Description
`0RETPRICE`	Regular Retail Price
`0PROPRICE`	Promotional Price
`0OFFR_DSCSU`	Off-Invoice
`0BONUS_SHSU`	Variable Bonus Based on the Sales Quantity per Sales Unit
`0BONUS_SCSU`	Variable Bonus Based on Scanner Data per Sales Unit
`0COPANETRV`	Net Revenue
`0COPAREVEN`	Revenue
`0SCAN_QTY`	Scan/Sales Quantity
`0REG_REVE`	Regular Revenue
`0PRO_DISC`	Net Promotional Discount
`0TSHP_REB`	Net Rebate Shipment Amount
`0TSCN_AMT`	Net Rebate Scan Amount
`0PROUNIT`	Promotional Units
`0PROPUNIT`	Promotion Price Per Unit
`0TAKERAT1`	Take Rate
`0EDLP_VAR`	Every Day Low Price (Variable) per Sales Unit
`0EDLP_OIV`	Every Day Low Price (Off-Invoice) per Sales Unit
`0BONUS_BBP`	Billback (Percentage) per Sales Unit
`0BONUS_OIP`	Discount (Percentage) per Sales Unit
`0BONUS_DISP`	Fixed Bonus for Displays
`0BONUS_FEAT`	Fixed Bonus for Features
`0OFFR_DSCNT`	Variable Promotion Discount (Invoice Markdown)
`0BONUS_SHIP`	Variable Bonus Based on Sales Quantity
`0BONUS_SCAN`	Variable Bonus Based on Scanner Data
`0PROMOTIONS`	Direct Promotion Costs (External Service)
`0BUDGET`	Budget
`0OICAP_AM`	Off-Invoice Cap Amount
`0OICAP_QU`	Off-Invoice Cap Quantity
`0PRC_LST_SU`	List Price per Sales Unit
`0UPLI_QTYS`	Uplift Quantity in Sales Units
`0INV_QTY`	Billing Document Quantity in Sales Units of Measure
`0FORWBUY_SU`	Forward Buy in Sales Units
`0REGDISC_SU`	Regular Discount
`0REG_DISC`	Total of All Regular Discounts
`0USTOT_VOL`	Forecasted Unit Sales
`0USTACTIC`	Net Unit Sales Due to Total Tactic Impact
`0USBASEVOL`	Forecasted Unit Sales Baseline
`0USPRICE`	Net Unit Sales Due to Price Changes
`0USSEASON`	Net Unit Sales Due to Seasonality
`0USHOLIDAY`	Net Unit Sales Due to Holidays
`0USCANNVOL`	Net Unit Sales Due to Cannibalization
`0TPO_FCI`	Forecast Confidence Index
`0BUY_FCT`	Buying Percentage
`0US_AVAIL`	Net Unit Sales Due to Availability

Planning Layouts

This planning level contains the following planning layouts:

TPO Master Layout (4TPO1010)
TPO Spend & Price Planning (4TPO1011)
Volume Planning (4TPO1012)

Configuration of the Data Columns for TPO Master Layout (4TPO1010)

The master layout covers all Key Figures, and thus the Key Figures that are contained in the planning layouts TPO Spend & Price Planning (4TPO1011) and Volume Planning (TPO1012) are all contained in this TPO Master Layout (4TPO1010).

Configuration of the Data Columns for TPO Spend & Price Planning (4TPO1011)

InfoObject Name	Description	Type and Data Type	Currency / Unit	Aggregation and Exception Aggregation	Cumulative / Non-Cumulative
`0BONUS_OIP`	Discount (Percentage) per Sales Unit	Quantity	Percentage (%)	SUM	CUM
`0OFFR_DSCSU`	Variable Promotion Discount (Invoice Markdown per Sales Unit)	Amount	0CURRENCY	SUM	CUM
`0EDLP_OIV`	Every Day Low Price (Off-Invoice) per Sales Unit	Amount	0CURRENCY	SUM	CUM
`0BONUS_SHSU`	Variable Bonus Based on the Sales Quantity per Sales Unit	Amount	0CURRENCY	SUM	CUM
`0BONUS_SCSU`	Variable Bonus Based on Scanner Data per Sales Unit	Amount	0CURRENCY	SUM	CUM
`0EDLP_VAR`	Every Day Low Price (Variable) per Sales Unit	Amount	0CURRENCY	SUM	CUM
`0BONUS_BBP`	Billback (Percentage) per Sales Unit	Quantity	Percentage (%)	SUM	CUM
`0BONUS_DISP`	Fixed Bonus for Displays	Amount	0CURRENCY	SUM	CUM
`0BONUS_FEAT`	Fixed Bonus for Features	Amount	0CURRENCY	SUM	CUM
`0OFFR_DSCNT`	Variable Promotion Discount (Invoice Markdown)	Amount	0CURRENCY	SUM	CUM
`0BONUS_SHIP`	Variable Bonus Based on Sales Quantity	Amount	0CURRENCY	SUM	CUM
`0PROMOTIONS`	Direct Promotion Costs (External Service)	Amount	0CURRENCY	SUM	CUM
`0BONUS_SCAN`	Variable Bonus Based on Scanner Data	Amount	0CURRENCY	SUM	CUM
`0BUDGET`	Budget	Amount	0CURRENCY	SUM	CUM
`0PRC_LST_SU`	List Price per Sales Unit	Amount	0CURRENCY	SUM	CUM
`0RETPRICE`	Regular Retail Price	Amount	0CURRENCY	SUM	CUM
`0PROPRICE`	Promotional Price	Amount	0CURRENCY	SUM	CUM
`0PROUNIT`	Promotional Units	Quantity	0SALES_UNIT	SUM	CUM
`0PROPUNIT`	Promotion Price Per Unit	Amount	0CURRENCY	SUM	CUM
`0REGDISC_SU`	Regular Discount	Amount	0CURRENCY	SUM	CUM
`0UPLI_QTYS`	Uplift Quantity in Sales Units	Quantity	0SALES_UNIT	SUM	CUM
`0UPLI_PQTYS`	Predicted Uplift Quantity in Sales Unit	Quantity	0SALES_UNIT	SUM	CUM
`0INV_QTY`	Billing Document Quantity in Sales Units of Measure	Quantity	0SALES_UNIT	SUM	CUM
`0SCAN_QTY`	Scan/Sales Quantity	Quantity	0SALES_UNIT	SUM	CUM
`0COPAREVEN`	Revenue	Amount	0CURRENCY	SUM	CUM
`0REG_DISC`	Total of All Regular Discounts	Amount	0CURRENCY	SUM	CUM
`0REG_REVE`	Regular Revenue	Amount	0CURRENCY	SUM	CUM
`0COPANETRV`	Net Revenue	Amount	0CURRENCY	SUM	CUM
`0PRO_DISC`	Net Promotional Discount	Amount	0CURRENCY	SUM	CUM
`0TSHP_REB`	Net Rebate Shipment Amount	Amount	0CURRENCY	SUM	CUM
`0TSCN_AMT`	Net Rebate Scan Amount	Amount	0CURRENCY	SUM	CUM
`0TAKERAT1`	Take Rate	Number	-	SUM	CUM
`0USTOT_VOL`	Forecasted Unit Sales	Quantity	0SALES_UNIT	SUM	CUM
`0FORWBUY_SU`	Forward Buy in Sales Units	Quantity	0SALES_UNIT	SUM	CUM

Configuration of the Data Columns for Volume Planning (4TPO1012)

Key Figure Name	Description	Type and Data Type	Currency / Unit	Aggregation and Exception Aggregation	Cumulative / Non-Cumulative
`0USBASEVOL`	Forecasted Unit Sales Baseline	Quantity	0SALES_UNIT	SUM	CUM
`0UPLI_PQTYS`	Predicted Uplift Quantity in Sales Unit	Quantity	0SALES_UNIT	SUM	CUM
`0USTOT_VOL`	Forecasted Unit Sales	Quantity	0SALES_UNIT	SUM	CUM
`0ADJ_QTY`	Adjusted Quantity per Sales Unit	Quantity	0SALES_UNIT	SUM	CUM
`0SCAN_QTY`	Scan/Sales Quantity	Quantity	0SALES_UNIT	SUM	CUM
`0INV_QTY`	Billing Document Quantity in Sales Units of Measure	Quantity	0SALES_UNIT	SUM	CUM
`0FORWBUY_SU`	Forward Buy in Sales Units	Quantity	0SALES_UNIT	SUM	CUM
`0USPRICE`	Net Unit Sales Due to Price Changes	Quantity	0SALES_UNIT	SUM	CUM
`0USTACTIC`	Net Unit Sales Due to Total Tactic Impact	Quantity	0SALES_UNIT	SUM	CUM
`0USSEASON`	Net Unit Sales Due to Seasonality	Quantity	0SALES_UNIT	SUM	CUM
`0USHOLIDAY`	Net Unit Sales Due to Holidays	Quantity	0SALES_UNIT	SUM	CUM
`0USCANNVOL`	Net Unit Sales Due to Cannibalization	Quantity	0SALES_UNIT	SUM	CUM
`0TPO_FCI`	Forecast Confidence Index	Number	-	SUM	CUM
`0BUY_FCT`	Buying Percentage	Quantity	Percentage (%)	SUM	CUM