Show TOC

BI Content for SAP Accelerated Trade Promotion Planning (New) Locate this document in the navigation structure

Technical Data

Product Version

BI Content 7.37 and 7.47 SP03 for SAP NetWeaver 7.30 SP08 and 7.31 SP03

Area

SAP Accelerated Trade Promotion Planning

Country Relevance

Valid for all countries

 

As of BI Content 7.37 and 7.47 SP03 for SAP NetWeaver 7.30 SP08 and 7.31 SP03, the following BI Content is available for SAP Accelerated Trade Promotion Planning:

  • Queries (New)

    • Master: BP Hierarchy Node w/ Prod Cat. and Prod (Week Level) (0TPM_AC05_IRQ0001)

    • Planning by Prod Cat and Prod at BP Hier. Node (Week Level) (0TPM_AC05_IRQ1002)

    • Planning by Prod Cat. and Prod at BP Hier. Node (Day Level) (0TPM_AC03_IRQ0002)

    • Master: Target Group and Product (Day Level) (0TPM_AC03_IRQ0171)

    • Planning by Product and Target Group (Day Level) (0TPM_AC03_IRQ0174)

    • Master: Target Grp w/ Explosion and Prod. Group (Week Level) (0TPM_AC05_IRQ1141)

    • Planning by Target Grp w/ Explosion and Prd Grp (Week Level) (0TPM_AC05_IRQ1142)

    • Master: Business Partner and Product (Week Level) (0TPM_AC05_IRQ1071)

    • Master: BP Hierarchy Node w/ Prod Cat. and Prod (Day Level) (0TPM_AC03_IRQ0001)

    • Master: BP with Product Group and Product (Day Level) (0TPM_AC03_IRQ0081)

    • Planning by BP w/ Product and Product Group (Day Level) (0TPM_AC03_IRQ0082)

    • Planning by Prod. Cat. and Prod. at BP Hier Node (Day Level) (0TPM_AC03_IRQ0004)

    • List of Trade Promotions Related to Agreement (Week Level) (0TPM_DSD03_Q1006)

    • List of Trade Promotions Related to an Agreement (Day Level) (0TPM_DS01_Q0006)

    • TPM Read Query (Week Level) (0TPM_DS03_Q1003)

    • TPM Read Query (Day Level) (0TPM_DS01_Q0003)

    • TPM Read Query SOA (Week Level) (0TPM_DS03_Q1005)

    • TPM Read Query SOA (Day Level) (0TPM_DS01_Q0005)

  • MultiProviders (New)

    • Baseline and Planning (Day Level) (0TPM_MC02)

    • Baseline and Planning (Week Level) (0TPM_MC03)

  • DataStore Objects (New)

    • Sales and Trade Promotions (Day Level) (0TPM_DS01)

    • Sales and Trade Promotions (Week Level) (0TPM_DS03)

    • TPM Base Sales Quantity (Week Level) (0TPM_DS04)

    • TPM Base Sales Quantity (Week Level) (0TPM_DS04)

  • Key Figures (New)

    • Distribution Ratio/Time Unit (0DISTRATIO)

  • Key Figures (Enhanced)

    • Discount (%) per Sales Unit (0BON_OIPSU)

    • Bill Back (%) per Sales Unit (0BON_BBP)

    • Variable Promotion Discount (Invoice Markdown) per SU (0OFFR_DCSU)

    • Every Day Low Price (Off-Invoice) per Sales Unit (0EDLP_OINV)

    • Rebate (Amount) per Sales Unit of Measure (0BON_SHSU)

    • Every Day Low Price (Variable) per Sales Unit (0EDLP_VARI)

    • Bill Back (%) Discount/SU (0CRM_BBACK)

    • Return on Investment (%) (0CRM_ROIPER)

    • Variable Bonus Based on Scanner Data per SU (0BON_SCSU)

    • Regular Retail Price (0RETLPRICE)

    • Promotional Price (0PROMPRICE)

    • List Price per Sales Unit (0PRICELIST)

  • Key Figures (Reused)

    • Uplift Quantity in Sales Units (0UPLI_QTYS)

    • Billing Document Quantity in Sales Units of Measure (0INV_QTY)

    • Scan/Sales Quantity (0SCAN_QTY)

    • Revenue (0COPAREVEN)

    • Regular Revenue (0REG_REVE)

    • Net Revenue (0COPANETRV)

    • Promotional Units (0PROUNIT)

    • Promotion Price Per Unit (0PROPUNIT)

    • Fixed Bonus for Displays (0BONUS_DISP)

    • Fixed Bonus for Features (0BONUS_FEAT)

    • Variable Bonus Based on Sales Quantity (0BONUS_SHIP)

    • Variable Bonus Based on Scanner Data (0BONUS_SCAN)

    • Budget (0BUDGET)

    • Internal Value (0INTVALUE)

    • Forward Buy in Sales Units (0FORWBUY_SU)

    • Total Sales Bonus/SU (0CRM_BONPRO)

    • Total Sales Bonus/SU (0CRM_BONSAL)

    • Off-Invoice % Discount/SU (0CRM_OFFINV)

    • Promotion Price Per Unit (0PROPUNIT)

    • Variable Promotion Discount (Invoice Markdown) (0OFFR_DSCNT)

    • Base Sales Quantity in Sales Unit of Measure (0BASE_QTYS)

    • Buying Pattern (0BUY_PAT)

    • Cost per Incremental Case (0CRM_CPIC)

    • Cost per Case (0CRM_CPC)

    • Key Figure Indicator (0KYF_IND)

  • Characteristics (Reused)

    • Calendar Year/Week (0CALWEEK)

    • Calendar Day (0CALDAY)

    • Fiscal Year/Period (0FISCPER)

    • Fiscal Year Variant (0FISCVARNT)

    • Currency (0CURRENCY)

    • Sales Unit (0SALES_UNIT)

    • Sales Category (0PR_CAT_SAL)

    • Product (0CRM_PROD)

    • CRM Product Hierarchy Levels 1 to 7 (0CRM_PR_A01 to 0CRM_PR_A07)

    • CRM Business Partner: Business Partner Group (From Hierarchy) (0BP_GRP)

    • Business Partner Group – Levels 1-7 (0BP_GRP_A01, 0BP_GRP_A02, 0BP_GRP_A03, 0BP_GRP_A04, 0BP_GRP_A05, 0BP_GRP_A06, 0BP_GRP_A07)

    • CRM Marketing Element (Campaigns and Marketing Plan) (0CRM_MKTELM)

    • Promotion Phase (0PERIOD_TYP)

    • CRM Sales Organization (0CRM_SALORG)

    • Division (0DIVISION)

    • Distribution Channel (0DISTR_CHAN)

    • CRM Plan Version (0CRMVERSION)

    • CRM Product Group 1 (0CRM_PRGRP1)

    • Target Group (0TGGRP_ID)

  • Aggregation Levels (New)

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

    • Baseline for Prod and Prod Cat. at BP Hier. Node (Day Level) (0TPM_AC04)

    • Sales and TP for Prod. and Prod. Cat at BP Hier. Node (Week) (0TPM_AC05)

    • Baseline for Prod and Prod Cat at BP Hier. Node (Week Level) (0TPM_AC06)

    • Baseline for Product at BP and Target Group (Week Level) (0TPM_AC07)

    • Baseline for Prod Grp and Prod at BP Target Grp (Day Level) (0TPM_AC08)

  • Planning Functions (New)

    • Baseline and FOX for Prod Cat and Prod at BP Hier Node (Day) (0TPMIMP_PCPRD_BPHN_D)

    • Execute FOX (Day Level) (0TPMIMP_EXEC_ALL_D)

    • Baseline FOX for Prod Cat. and Prod at BP Hier. Node (Week) (0TPMIMP_PCPRD_BPHN_W)

    • Execute FOX (Week Level) (0TPMIMP_EXEC_ALL_W)

    • Baseline and FOX for Prod. Group and Prod. at BP (Day Level) (0TPMIMP_PGRPPRD_BP_D)

    • Baseline and FOX for Prod Grp at Target Grp w/ Expl. (Week) (0TPMIMP_PRGRP_TG_W)

    • Baseline and FOX for Prod. at Business Partner (Week Level) (0TPMIMP_PROD_BP_W)

    • Baseline and FOX for Prod at Target Grp w/o Explosion (Day) (0TPMIMP_PROD_TG_D)