Show TOC

Planning by Prod Cat and Prod at BP Hier. Node (Week Level) Locate this document in the navigation structure

Query Query: 0TPM_AC05_IRQ1002

 

This query is used for planning at week level with rates in SAP NetWeaver Business Warehouse (SAP NetWeaver BW).

The key account manager can use this query to plan product and product category trade promotions at the business partner hierarchy node level. This query is used to synchronize SAP CRM application data to SAP NetWeaver BW planning data.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Sales Category

0PR_CAT_SAL

—

Characteristic Characteristic

Promotion Phase

0PERIOD_TYP

—

Characteristic Characteristic

BP:Group (Hierarchy)

0BP_GRP

—

Characteristic Characteristic

CRM Marketing Elem.

0CRM_MKTELM

0I_TPM_IMP_MKTELMID

Characteristic Characteristic

Currency

0CURRENCY

—

Characteristic Characteristic

Distribution Channel

0DISTR_CHAN

—

Characteristic Characteristic

Division

0DIVISION

—

Characteristic Characteristic

CRM Sales Org.

0CRM_SALORG

—

Characteristic Characteristic

Sales Unit

0SALES_UNIT

—

Characteristic Characteristic

Product

0CRM_PROD

—

Characteristic Characteristic

Calendar Year/Week

0CALWEEK

—

Characteristic Characteristic

CRM Plan Version

0CRMVERSION

—
Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

CRM Plan Version

0CRMVERSION

Characteristic Characteristic

Sales Unit

0SALES_UNIT

Characteristic Characteristic

CRM Sales Org.

0CRM_SALORG

Characteristic Characteristic

Division

0DIVISION

Characteristic Characteristic

Distribution Channel

0DISTR_CHAN

Characteristic Characteristic

Currency

0CURRENCY

Characteristic Characteristic

CRM Marketing Elem.

0CRM_MKTELM

Characteristic Characteristic

BP: Group (Hierarchy)

0BP_GRP

Variables

Object Type

Name

Technical Name

Variable Variable

Marketing Element ID

0I_TPM_IMP_MKTELMID

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Sales Category

0PR_CAT_SAL

—

Characteristic Characteristic

Product

0CRM_PROD

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Base Sales Quantity

0BASE_QTYS

—

Key Figure Key Figure

Uplift

RW_UPLIFT_QTYS

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 30(PRE-DIP)

0PERIOD_TYP = 50(BUYING)

0PERIOD_TYP = 70(POST-DIP)

Total Volume

0INV_QTY

—

Key Figure Key Figure

Advance Purchase

RW_FORWBUY_SU

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

Key Figure Key Figure

Scan/Sales Volume

RW_SCAN_QTY

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 00(PLAN)

Key Figure Key Figure

Discount (%) /SU

RW_BON_OIPSU

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Promotion Discnt/SU

RW_OFFR_DCSU

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

EDLP (Off-Invoice)/SU

RW_EDLP_OINV

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Off-Invoice (%) Disc/SU

RW_CRM_OFFINV

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Total Promotional Off-Invoice Discount/SU

RW_CRM_BONPRO

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Bill Back (%) /SU

RW_BON_BBP

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

Rebate (Amount) /SU

RW_BON_SHSU

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

EDLP (Variable)/SU

RW_EDLP_VARI

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Bill Back (%) /SU

RW_CRM_BBACK

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Tot Sales Bonus/SU

RW_CRM_BONSAL

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Scanner Rebate/SU

RW_BON_SCSU

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 00(PLAN)

Key Figure Key Figure

Rebate for Displays

RW_BONUS_DISP

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

0PERIOD_TYP = 00(PLAN)

Key Figure Key Figure

Rebate for Features

RW_BONUS_FEAT

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

0PERIOD_TYP = 50(BUYING)

0PERIOD_TYP = 00(PLAN)

Key Figure Key Figure

Promotional Discount

RW_OFFR_DSCNT

0PERIOD_TYP = 50(BUYING)

Key Figure Key Figure

Sales-Based Rebate

0BONUS_SHIP

—

Key Figure Key Figure

Scanner-Based Rebate

RW_BONUS_SCAN

0PERIOD_TYP = 00(PLAN)

Key Figure Key Figure

Budget

0BUDGET

—

Key Figure Key Figure

List Price /SU

0PRICELIST

—

Key Figure Key Figure

Revenue

0COPAREVEN

—

Key Figure Key Figure

Regular Revenue

0REG_REVE

—

Key Figure Key Figure

Net Revenue

0COPANETRV

—

Key Figure Key Figure

Regular Retail Price

0RETLPRICE

—

Key Figure Key Figure

Promotional Price

0PROMPRICE

—

Key Figure Key Figure

Promotional Units

0PROUNIT

—

Key Figure Key Figure

Prom. Price per Unit

0PROPUNIT

—

Key Figure Key Figure

Return on Investment (%)

0CRM_ROIPER

—

Key Figure Key Figure

Cost per Case

0CRM_CPC

—

Key Figure Key Figure

Cost per Incr. Case

0CRM_CPIC

—

Characteristic Characteristic

Key Figure Indicator

0KYF_IND

—

Key Figure Key Figure

Buying Pattern

RD_BUY_PAT

0CRM_MKTELM = 0I_TPM_IMP_MKTELMID

Distr.Ratio/ TimeUnit

0DISTRATIO

—

Promotion Phase

0PERIOD_TYP

—

Characteristic Characteristic

Calendar Year/Week

0CALWEEK

—