REFERENCES

Project title: implementation / migration SAP BW 4/HANA (greenfield approach)

Industry: timber

Module: CO, SD, MM, PP, HR, FI, HO and QM

Tasks:

- SAP BW/4HANA implementation (Recompilation - greenfield approach)

- Implementation of Infosources, Composite Provider, Open ODS Views, ADSOs, DTPs and         

  Tranformations

- Setting up data flow objects for master data and transaction data (greenfield approach)

- Development of portal ability reports by setting up queries (BeX tools)

- ODP connection

- Process chain management

- SAP HANA analysis process

- SQL-Script & ABAP-OO

- Data modeling

- Data analysis / data reconciliation of both systems

- Establishment of workbooks by BO for Microsoft Excel (greenfield approach)

- Going Live

- Training courses for key users

- Support activities

- Monitoring

Project title: monitoring / dispatching / ticket-system

Industry: crystal glass

Module: CO, SD, MM, PP and QM

Tasks:

- Dispatching operative system BW on HANA

- Support activities 1st, 2nd, 3rd Level

- Monitoring process chains, productive system in all SAP modules

- Debugging operations in the productive system

- Bringing in planning data

- Ticket management - solving incidents and requests of key users

- Executing small requirements

Project title: measure system

Industry: metal processing

Module: PP

Tasks:

- Definition of measures in consultation of the business

- Setting up queries and web templates (BI 7.0)

- Presentation of reports via SAP Netweaver 2004s

- Development of process chains for delta processing

- Development and extension of ETL processes

- Training courses for key users

Project title: rollout

Industry: metal processing

Module: CO, SD, MM, PP, HR and QM

Tasks:

- Introduction of a reporting system for the announced modules via BI 7.0

- Datastaging

- ETL processes

- Development of portal ability reports

- Going Live

- Training courses for key users

- Support activities

- Monitoring

Project title: customer income statement

Industry: trade

Module: SEM BPS

Tasks:

- Development of new planning levels, planning functions and planning sequences

- Generation of new planning layouts

- Automated process via process chain management

Project title: customer service

Industry: trade

Module: COPA

Tasks:

- Extension of data models (DSOs, Cubes and Multiprovider)

- Development of new analysis processes (APDs) including complexe routines (reading out mapping

  tables) and aggregations

- Development of new interfaces including transformations and update rules (ABAP routines in expert,

  start and end routines)

- Automated data load process via process chain management

- Data loading across system - interface programming via IFS, RFC functional components and open hub

  tables

- Development of complex planning layouts via Query Designer and Web Application Designer

- Establishment of portal ability reports

- Support activities

Project title: marketing management

Industry: trade

Module: CO

Tasks:

- Development of new data models (DSO, Cubes and Multiprovider) in consultation of the business

- Activation of SAP default extractors (internal jobs - 0CO_OM_OPA_1, cost center ccounting 0CO_OM_CCA_1)

- Development of generic extractors via functional components (campaigns - master data and transactional data)

- Establishment of portal ability marketing reports (BeX Analyzer, BeX Query Designer und BeX Web Application Designer)

- Development of complex process chain management

- Support activities

- Training courses for key users

- Monitoring

Project title: customer profitability analysis

Industry: trade

Module: BI-IP

Tasks:

- Development of new aggregation levels, filters, planning functions and planning sequences

- Realization of complex planning functions via FOX formulas

- Development of new data models (Cubes and Multiprovider) for integrated planning

Project title: SCM scorecard

Industry: trade

Module: MM

Tasks:

- Development of new data models (Datasources, Infosources, DSOs and Cubes)

- Implementation of complex calculations including expert routines and methods

- Automated data loading process via process chain management

- Support activities

Project title: performance report

Industry: energy supply

Module: FICO, SEM BCS

Tasks:

- Implementation of user exits and interfaces (Transformation and DTPs)

- Development of functional components for data loading for parametres DSOs including complex ABAP

  logics

- Development of new data models (DSOs and process chains)

- Development of complex queries and web templates via BI 7.0

- BI-IP: input forms (BeX queries and web templates), aggregation levels, planning functions and planning sequences

- Concept and documentation

- Creation of test cases

- Support activities

Project title: cost center and project reporting

Industry: Munich Airport

Module: COPA, PS

Tasks:

- Data models

- Development of a EDWH layer model up to item level

- Extraction of data from SAP ERP

- Process chain management

- Establishment of reports via SAP BO Analysis for Microsoft Excel

- Concept and documentation

- Creation of test cases

- Training courses for key users

- Support activities

Project title: vehicle management

Industry: Munich Airport

Module: PM, CS

Tasks:

- Development of compliance lists and project definitions

- Data modeling

- Development of a EDWH layer model

- Development of generic extractors

- Extraction of data from SAP ERP and a third-party system (Oracle data base)

- Process chain management

- Implementation of reports following dashboard forms

- Connection and establishment of reports within the Netweaver portal

- Concept and documentation

- Creation of user manual

- Creation of test cases

- Training courses for key users

- Support activities

Project title: planning layout - investment management

Industry: Munich Airport

Module: IM

Tasks:

- Development of new default planning functions (copy and delete functions)

- Implementation of categories for blocking logics (data slices)

- Implementation of planning layout via SAP BO Analysis for Microsoft Excel

Project title: HR relaunch - migration NON-SAP subsidiaries

Industry: Munich Airport

Module: HR

Tasks:

- Development of new data models (EDWH layer concept)

- Development of input logic for flatfile via VBA

- Implementation of new analysis processes via APD

- Automation via process chain management

- Establishment of new queries and BO analysis workbooks for the current number of staff (heads, employee capacity, sick rate, ...)

Project title: GMD - global market database

Industry: hygiene

Module: BI-IP

Tasks:

- Development of new data models (real time Cubes and Multiprovider) for Integrated Planning

- Development of new aggregation levels, filters, planning functions

- Planning functions - top down (retrograde) distribution and copy function

- Planning layout via BeX Analyzer and SAP BO Analysis for Microsoft Excel

Project title: budget planning

Industry: construction

Module: SEM-BCS Reporting

Tasks:

- Establishment of new queries and workbooks via BeX Analyzer

- Implementation of new Customer Exit variables

- Planning layout via BeX Analyzer and macros via VBA

- Creation of new roles and assignment of new workbooks

- Documentation and specifications

Project title: BW on HANA migration

Industry: timber

Module: all SAP modules

Tasks:

- Preparatory work (deleting PSA requests, deleting the table content of change logs, compressing Cubes)

- Converting Cubes into SAP HANA optimized Cubes

- Adapting process chains - deleting unnecessary process chain variations (deleting index, reconstructing index and rolling up aggregates / BIA)

- Replacing Infosets with Composite Provider

- Establishments of new data flow objects via ADSO and Composite Provider (HANA Studio)

Project title: support, dispatcher, incidents und requests

Industry: trade

Module: All SAP moduls

Tasks:

- Monitoring & debugging, process chains

- Ticket system: working on incidents and requests from different departments

- Implementing small requirements

Druckversion | Sitemap
© sauerwein consulting GmbH