Share feedback

We are aware of intermittent issues in accessing the learning content

We are aware of intermittent issues in accessing the learning content

Personalize your learning.

Why create an SAP account?

Enhance your learning experience

SAP Learning

Choose your subscription

Manage your subscription

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

Please try again later

Sorry, we encountered an error

Try again or reset results to continue browsing

We didn’t find what you’re looking for

To continue, please log in

Your session has timed out

Validate your skills and learning by completing the certification exam and gain a highly recognised accreditation.

Book your certification exam

Complete the assessment to validate your SAP PartnerEdge competency qualifications.

Ready to take your assessment?

Learn about the key features and essentials in the latest release to help you prepare for the Stay Certified assessment.

Prepare for assessment

Learn new skills you need at your own pace with our bite-sized lessons.

Prepare for certification

In your My Learning account you can view your certification and learn how to take your Stay Certified assessment.

Ready to take your Stay Certified assessment?

Explore {title} at SAP Learning. Find out more!

You have earned a new badge!

You've completed

Something went wrong when connecting to the badge service. You can always check your achievements in My Learning.

Badge couldn’t be issued

You’ve finished the course, but the external system didn’t verify it. Please try again later or refresh the page to update your record.

We couldn’t confirm your completion

The learning content has been updated. Refresh the page to reload the most recent content.

Your course content has changed

This badge was already awarded earlier, so no new one is added. You can view it anytime in My Learning.

You’ve already earned this badge

We couldn’t finish your request due to an unexpected error. Please refresh the page and try again. If the issue continues, check My Learning or try again later.

Something went wrong...

The saved progress data isn’t valid, so we couldn’t update your course status. Please try again later or refresh the page.

We couldn’t load your progress

What you'll learn

Prove your knowledge and earn a badge that validates your expertise.

Earn a badge

Complete this section to get all the required knowledge.

Learn

Enroll to Google NotebookLM to flexibly interact with SAP Learning content. It’s free and activates instantly.

You are all set. Google NotebookLM is now active. You will have access to AI powered learning for all our eligible courses.

Enrollment successful!

Get started with AI-powered learning

Explore the course content through podcasts, mind maps, and study guides, while getting instant answers to your questions.

Upskill faster with AI

Join scheduled live courses led by experienced SAP trainers.

Learn with an instructor

Other ways to learn

This certification is no longer offered. To check your certitication details click on Go to My Learning.

This certification is retired

Visit My Learning to check your status and schedule your assessment. You can also watch <link>Certification Support videos</link> to guide you through the process.

Ready to renew? It’s time to take your Stay Certified assessment

This certification has expired and cannot be renewed. You can explore recommended alternatives in the <link>SAP Certification portfolio</link> or visit My Learning for status updates.

This certification has been retired and is no longer active

Visit My Learning to see if you have attempts left to retake. For more details, see our guide: <link>How to Get Certified with SAP Certification</link>.

Unfortunately, you didn't pass the assessment this time

You certification is current. View details anytime in My Learning.

Your certification is up to date

Quiz

Congratulations on completing this {objType}

Subscribe to be informed about updates to this learning journey. We will inform you when a new unit is available.

Get notified

Assessment

Course Completion

Knowledge Badge

Certification Exam

Theoretical Exam

Schedule

External Course

Practical Exercise

Practical Test

External Hands-On

External Resource

Learning Journey

Learning Journey Assessment

Lesson

Live Session

Practice System

Scenario Based Assessment

Course Assessment

Course

Stay Certified

Subscription

System Based Assessment

Test Out

Unit

Video

Video Playlist

Week

Appears in

Badge earned

Badge you can earn

Goals

Learning outcome

Toggle full description

Overview

Prerequisites

Products and Roles

cleanFiles/bookmap_Implementing_an_On-Premise_Data_Warehouse__en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2025-09-19T10:18:33.000Z

Introducing Enterprise Data, SAP BW/4HANA and the Role of SAP HANA in SAP BW/4HANA

Working with SAP BW/4HANA Tools

Introducing a Data Warehousing Scenario

Introducing Data Warehousing in SAP BW/4HANA

Introducing InfoObjects

Defining Characteristics

Defining Key Figures

Modeling InfoObjects in SAP BW/4HANA

Introducing Data Flow Modeling

Introducing Graphical Data Flow Modeling

Modeling Data Flows

Introducing ODP

Creating ODP_SAP DataSources

Replicating ODP_SAP DataSources

Creating Transformations and Data Transfer Processes

Executing Data Transfer Processes and Exploring Master Data

Loading Master Data to SAP BW/4HANA

Introducing DataStore Objects (advanced)

Using the Data Mart DataStore Object

Using the Standard DataStore Object

Using the Staging DataStore Object

Modeling DataStore Objects (advanced) in SAP BW/4HANA

Loading Transactional Data from SAP S/4HANA

Loading Transactional Data from a Flat File

Updating Transactional Data in a Standard DataStore Object

Loading Transactional Data to SAP BW/4HANA

Introducing InfoSources

Using Transformation Rules

Using Rule Groups

Using Start Routine, End Routine and Expert Routine

Identifying Runtime in Transformations

Exploring Additional Options With Transformations

Introducing Open ODS Views

Using Open ODS Views in Modeling Scenarios

Loading Data Based on an Open ODS View

Modeling Open ODS Views

Introducing CompositeProviders

Introducing Queries

Modeling CompositeProviders and Queries

Administrating Master Data

Administrating DataStore Objects (advanced)

Using Process Chains

Describing SAP HANA Delta Merge Related To SAP BW/4HANA

Exploring Administrative and Operational Activities Related to Data Loading

SAP BW/4HANA Data Warehousing

This course will enable you to develop the skills to implement a data warehouse using SAP BW/4HANA.