• The "SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA" certification exam validates that the candidate possesses the fundamental and core knowledge required in the profile of MODELING, DATA ACQUISITION and QUERY DESIGN with SAP BW/4HANA. This certification proves that the candidate has an overall understanding and in‐depth technical skills to participate as a member of a project team in a mentored role. This certification exam is recommended as an entry level qualification.


  • To ensure success, SAP recommends combining education courses and hands-on experience to prepare for your certification exam as questions will test your ability to apply the knowledge you have gained in training.
  • You are not allowed to use any reference materials during the certification test (no access to online documentation or to any SAP system).

Topic Areas

Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

Data Acquisition into BW/4HANA > 12%

Describe data acquisition concepts into SAP BW/4HANA. Explain various technologies in support of data acquisition including the traditional BW Extractors, Operational Data Provisioning, Smart Data Integration and CDS views.

BW/4HANA Modeling > 12%

Introduce SAP BW/4HANA modeling. Describe modeling requirements and explain field-based modeling.


BW Query Design > 12%

Explain the concept of SAP BW/4HANA Query design. Define query definitions with eclipse based BW Query Designer in SAP HANA Studio and explain how to make them available for analysis


InfoObjects and InfoProviders 8% - 12%

Describe and explain the use of InfoObjects as well as InfoProviders.


BW/4HANA Data Flow 8% - 12%

Explain the concepts of data flows in SAP BW/4HANA

Native HANA Modeling 8% - 12%

Describe SAP HANA native data modeling. Explain the concepts and how to implement native SAP HANA views.


Fundamentals 8% - 12%

Describe Data Warehouse Fundamentals. Explain modeling requirements and best practices.


SAP Analytics Tools < 8%

Position different SAP Analytics BI Tools and explain what they are used for.


SAP BW/4HANA Project and the Modeling Process < 8%

Explain the modeling process in a SAP BW/4HANA project. Explain modeling requirements and best practices. Explain field-based modeling. Compare BI Content with requirements.


Data Acquisition into SAP HANA < 8%

Describe data acquisition concepts into SAP HANA. Explain how to extract data from SAP source systems and another BW with Operational Data Provisioning (ODP) and how to manage delta data with ODP. Determine how to acquire data from using different interfaces.

General Information

Exam Preparation 

IMPORTANT: All SAP consultant certifications are now available as Cloud Certifications in the Certification Hub and can be booked with product code CER006. With CER006 – SAP Certification in the Cloud, you can take up to six exams attempts of your choice in one year – from wherever and whenever it suits you!  Test dates can be chosen and booked individually.Those of you who prefer to get certified on-site at an SAP training center instead can still do so. Official dates for the certification tests are listed on the right.

Each specific certification comes with its own set of preparation tactics. We define them as "Topic Areas" and they can be found on each exam description. You can find the number of questions, the duration of the exam, what areas you will be tested on, and recommended course work and content you can reference.

Certification exams might contain unscored items that are being tested for upcoming releases of the exam. These unscored items are randomly distributed across the certification topics and are not counted towards the final score. The total number of items of an examination as advertised in the Training Shop is never exceeded when unscored items are used.

Please be aware that the professional- level certification also requires several years of practical on-the-job experience and addresses real-life scenarios.

For more information refer to our FAQs.

SAP Global Certification FAQ – Overview

SAP Global Certification FAQ – Exam Process

SAP Global Certification FAQ – Post-Exam Process


Safeguarding the Value of Certification

SAP Education has worked hard together with the Certification & Enablement Influence Council to enhance the value of certification and improve the exams. An increasing number of customers and partners are now looking towards certification as a reliable benchmark to safeguard their investments. Unfortunately, the increased demand for certification has brought with it a growing number of people who to try and attain SAP certification through unfair means. This ongoing issue has prompted SAP Education to place a new focus on test security. Please take a look at our post to understand what you can do to help to protect the credibility of your certification status.

Our Certification Test Security Guidelines will help you as test taker to understand the testing experience.




Book this product to consume within Certification Hub

See all certifications included in subscription
United States of America
Certification Hub Subscription
$549.00 (USD)

Price excludes tax.

Add to basket