7952  Reviews star_rate star_rate star_rate star_rate star_half

SAP BW/4HANA Modeling

Skills Gained This course will prepare you to: -Outlining advantages of the SAP "In-Memory" database foundation for SAP BW/4HANA in general. -Understanding modeling requirements and comparing...

Read More
$4,600 USD
Course Code BW430-v021
Duration 5 days
Available Formats Virtual, Classroom

Skills Gained

  • This course will prepare you to:
       -Outlining advantages of the SAP "In-Memory" database foundation for SAP BW/4HANA in general.
       -Understanding modeling requirements and comparing modeling approaches
       -Discussing Best Practices guidelines such as LSA++ and separating master and transactional data.
       -Describing steps in developing an SAP BW/4HANA data model.
       -Applying SAP Business Content.
       -Using the power of SAP BW/4HANA modeling artifacts.
       -Leveraging the advantages of field-based modeling.
       -Creating and using hierarchies with SAP BW/4HANA InfoObjects and with native SAP HANA XSA Calculation Views.
       -Harmonizing transactional data from different source systems.
       -Implementing Currency and Unit Conversion with SAP BW/4HANA and with native SAP HANA XSA Calculation Views.
       -Using Data Tiering Optimization
       -Generating external SAP HANA views and understanding "Mixed Scenarios", based on XSA.
       -Creating and using an SAP HANA Analysis Process.
       -Outlining Inventory Management and Stock coverage scenarios

Who Can Benefit

  • Application Consultant
  • Business Analyst
  • Solution Architect
  • System Architect
  • Technology Consultant


  • Essential:
       -Hands-on experience in data warehousing with SAP BW/4HANA
       -BW410 (SAP BW Enterprise Data Warehousing with SAP BW/4HANA)
  • Recommended:
       -HA100 (SAP HANA Introduction)

Course Details

Course Content

  • Introduction to Data Modelling, Challenges, Conflicts
  • Overview about the Business Case (Case Study)
  • Comparing Modeling approaches
       -SAP BW/4HANA modeling
       -SAP HANA modeling
       -SAP Datasphere modeling
       -Mixed strategies
  • Best Practice Standards in BW/4HANA Modeling
       -Understanding Object Changeability
       -Separating Master Data and Transactional Data
       -Using Time-Dependent Master Data, Tracking History
       -Harmonizing Data
       -Designing a BW/4HANA Layered Scalable Architecture (LSA++)
       -Understanding Physical and Logical Partitioning
  • Process of Modeling
       -Defining the Sequence and Phases of SAP BW Projects
       -Developing an SAP BW/4HANA Data Model
  • SAP BW/4HANA Content Add-On
       -Working with SAP Business Content
       -Introducing ABAP CDS Views provided by SAP BW/4HANA
  • Implementing SAP BW/4HANA Field-Based Models
       -Implementing Field-Based Modeling with Open ODS Views
       -Understanding Snapshot and Corporate Memory Models
  • Implementing Models in SAP BW/4HANA
       -Modeling and Implementing SAP BW/4HANA Master Data
       -Modeling and Implementing Advanced DataStore Objects (ADSOs)
       -Modeling and Implementing InfoSources and Transformations
       -Modeling and Implementing Composite Providers
  • SAP BW/4HANA Lifecycle Management
       -Describing Multi-Temperature Data Management
       -Introducing SAP BW/4HANA Data Tiering Optimization (DTO)
  • Implementing Native SAP HANA Views and Mixed Scenarios
       -Modeling Master Data and Transactional Data in SAP HANA Views
       -Generating External SAP HANA Views for SAP BW/4HANA Objects
       -Implementing Mixed Scenarios
  • Additional Modeling aspects in SAP BW/4HANA
       -Introducing the HANA Analysis Process (HAP)
       -Defining Inventory Scenarios


  • This course provides you a very sound foundation of BW/4HANA modeling concepts and contains references to additional documents and information sources. This course has a focus on presenting concepts and a variety of hands- on-tasks partially based on a case study. The trainer will choose 20 – 30 suitable exercises out of more than 30 available exercises.

Course based on software release

  • SAP BW/4HANA 2021 SP04
  • SAP HANA 2.0 SP05
  • SAP S/4HANA 2022
  • SAP HANA Studio 2.3.71
  • SAP BW/4HANA Modeling Tools 1.25.06
  • SAP Analysis for Microsoft Office 2.8
  • SAP BI Platform 4.3 SP2
  • SAP NW Business Client 3.6.3
View Full Schedule