Product Cost Forecast & Simulation (SAP HANA-Optimized)

Prerequisites

Maintain Customizing Table /IMO/CFS_PARAMS

Transfer Exchange Rates from SAP ERP

Enhance DataSource 0MAT_PLANT_ATTR

Define Schema Mapping

Assign SQL Privileges for BW System Schema

Activate BW Content (EDW Core Layer) and Generating SAP HANA Dat

Activate SAP HANA Information Models

Activate BW Content (Virtual Data Mart Layer)

DataStore Objects

CO-PC: Material Standard Costs with Cost Component Split - /IMO/

CO-PC: Material Itemization (Parent-Child Relationship) - /IMO/C

CO-PC: Cost Drivers (Planning, Input) - /IMO/CFS_D01

CO-PC: Correlation Cost Drivers (Planning, Input) - /IMO/CFS_D02

CO-PC: FX Rates Plan (Planning, Input) - /IMO/CFS_D03

CO-PC: FX Rates Plan (Upload) - /IMO/CFS_D031

CO-PC: Locking (Planning, Insert) - /IMO/CFS_D04

CO-PC: Planning Horizon (Planning, Input) - /IMO/CFS_D05

CO-PC: Material Sales Plan (Planning, Insert) - /IMO/CFS_D06

CO-PC: Raw Material Prices (Planning, Results) - /IMO/CFS_DR1

CO-PC: Cost and Volume Itemization (Planning, Results) - /IMO/CF

CO-PC: Margin Impact Analysis (Planning, Results) - /IMO/CFS_DR3

InfoSources

CO-PC: Product Costing Analysis: Cost Components (0CO_PC_PCP_20)

CO-PC: Product Costing Analysis: Cost Components - /IMO/CFS_IS20

CO-PC: Product Costing Analysis: Itemization (0CO_PC_PCP_30) - /

CO-PC: Product Costing Analysis: Itemization - /IMO/CFS_IS301

Process Chains

CO-PC: Upload ERP Product Costing - /IMO/CFS_UPLOAD_D30

DataSources

CO-PC: Foreign Exchange Rates - /IMO/CFS_FX_RATES

InfoCubes

CO-PC: Raw Material Prices - /IMO/CFS_VR1

CO-PC: Cost and Volume Itemization - /IMO/CFS_VR2

CO-PC: Margin Impact Analysis - /IMO/CFS_VR3

MultiProvider

CO-PC: Cost Drivers - /IMO/CFS_M01

CO-PC: Cost Driver Correlations - /IMO/CFS_M02

CO-PC: FX Rates Plan - /IMO/CFS_M03

CO-PC: Locking Percentages - /IMO/CFS_M04

CO-PC: Planning Horizon - /IMO/CFS_M05

CO-PC: Material Sales Plan - /IMO/CFS_M06

CO-PC: Raw Material Prices - /IMO/CFS_MR1

CO-PC: Cost and Volume Itemization - /IMO/CFS_MR2

CO-PC: Margin Impact Analysis - /IMO/CFS_MR3

Queries

CO-PC: Cost Driver Input - /IMO/CFS_Q0001

CO-PC: Cost Driver Correlations Input - /IMO/CFS_Q0002

CO-PC: FX Input - /IMO/CFS_Q0003

CO-PC: Locking Input - /IMO/CFS_Q0004

CO-PC: Planning Horizon - /IMO/CFS_Q0005

CO-PC: Material Sales Plan - /IMO/CFS_Q0006

CO-PC: Raw Material Prices Report (SAP HANA) - /IMO/CFS_QR001

CO-PC: Cost and Volume Itemization Report (SAP HANA) - /IMO/CFS_

CO-PC: Total Spend Report - /IMO/CFS_QR003

CO-PC: Margin Impact Analysis - /IMO/CFS_QR004

Key Figures

CO-PC: Correlation Cost Driver to MDS

CO-PC: Cost Driver Quotation Quantity

CO-PC: Price of Cost Driver

CO-PC: Percentage of Lock

CO-PC: Product Cost per Lot Size (Global Currency)

CO-PC: Product Cost per Lot Size (Local Currency)

CO-PC: Product Cost per Piece (Global Currency)

CO-PC: Product Cost per Piece (Local Currency)

CO-PC: Product Cost Total Spend (Global Currency)

CO-PC: Product Cost Total Spend (Local Currency)

CO-PC: Purchase Price (Global Currency)

CO-PC: Purchase Price (Local Currency)

CO-PC: S-Level Purchase Price (Local Currency)

CO-PC: X-Level Purchase Price (Local Currency)

CO-PC: Gross List Price (Global Currency)

CO-PC: Technical Key Figure

Characteristics

CO-PC: Cost Driver

CO-PC: Cost Driver Type

CO-PC: First Planning Period

CO-PC: HANA Input Parameter 0FISCPVARNT

CO-PC: HANA Input Parameter 0CFS_FPP

HANA Input Parameter 0VERSION

CO-PC: Material (Parent)

CO-PC: Material (Child)

CO-PC: Plant (Parent)

CO-PC: Plant (Child)

CO-PC: Material Driver Segment (MDS)

CO-PC: SQL Procedure (CFS)