Course Outline

Introduction

  • What is data warehousing?
  • Overview of SAP BW (Business Warehouse)
  • What is SAP ABAP (Advanced Business Application Programming)?

Getting Started

  • Preparing the Development Environment
  • Accessing SAP BW

Using ABAP

  • ABAP syntax
  • Creating a simple application

Working with Data

  • Understanding Dataflows
  • Understanding and executing queries
  • Using ABAP for querying
  • Working with ABAP objects

Data Modeling

  • Designing and implementing a Layered Scalable Archictecture (LSA)
  • Acquiring data
  • Staging and modeling data
  • Understanding Corporate Memory
  • Data distribution and data analysis

Developing a Data Application

  • Gathering requirements
  • Querying data
  • Generating reports
  • Integrating with other SAP applications

Testing the Application

  • Debugging the Application

Improving Performance

  • The importance of programming style
  • Writing code that is readable and maintainable
  • Tightening queries

Summary and Conclusion

Requirements

  • An understanding of data warehousing concepts
  • ABAP programming experience

Audience

  • Developers
  • Application architects
  14 Hours
 

Testimonials

Related Courses

SAP S/4 Hana (S/4Hana)

 21 hours

SAP S/4 HANA (S/4Hana) is SAP's next generation business suite and is built on SAP's in-memory HANA database platform. This instructor-led, live training (online or onsite) is aimed at functional consultants who wish to set up, migrate and manage

SAP ABAP for Developers

 21 hours

SAP ABAP (Advanced Business Application Programming) is an enterprise programming language for business systems. This instructor-led, live training (online or onsite) is aimed at developers who wish to use the ABAP programming language to

SAP ASE for Database Administrators

 28 hours

SAP ASE (SAP Adaptive Server Enterprise), previously known as Sybase SQL Server, Sybase DB and Sybase ASE is a relational database for businesses. In this instructor-led, live training, participants will learn the fundamentals of SAP

SAP Basis for Administrators

 35 hours

SAP Basis refers to the applications and tools that an SAP Basis administrator uses to operate and manage an SAP system, including the database, operating system, communication protocols and SAP modules. This instructor-led, live training (online

SAP Financial Accounting and Controlling (FICO) for Consultants

 28 hours

SAP FICO (Financial Accounting and Controlling) is SAP's central module for storing financial transactions data. This instructor-led, live training (online or onsite) is aimed at SAP power users who wish to learn the consulting skills to

SAP Hana for Data Analysts

 21 hours

SAP HANA is a hardware and software based in-memory database and platform. This instructor-led, live training (online or onsite) is aimed at data analysts who wish to use SAP HANA to capture data from diverse data sources for fast processing and

SAP Human Capital Management (HCM) for Consultants

 28 hours

SAP Human Capital Management (HCM) is one of the main SAP modules and is used to organize and manage human resource processes within an enterprise.  This instructor-led, live training (online or onsite) is aimed at persons who wish to

SAP Hybris

 14 hours

SAP Hybris is a cloud based CRM (Customer Relationship Management) suite. Users can address the shortcomings of traditional CRMs with SAP Hybris and its sales, services, marketing, and analytic capabilities. This instructor-led, live training

SAP MM

 7 hours

SAP MM (Material Management) is a module in SAP. SAP MM consists of four components master data, purchasing, inventory, and material resource planning, all of which are essential to business processes. This instructor-led, live training (online

SAP ERP Fundamentals

 28 hours

SAP is an ERP (Enterprise Resource Planning) software application for streamlining business processes. This instructor-led, live training (online or onsite) is aimed at end users with no previous experience with SAP or ERP. We will demonstrate

SAP EWM (Extended Warehouse Management)

 35 hours

SAP EWM (Extended Warehouse Management) is a software platform for managing inventory in a warehouse, including the movement of goods to and from the warehouse. This instructor-led, live training (online or onsite) is aimed at persons who wish to

SAP Automation with UIPath

 14 hours

UIPath is a software platform for automating business processes that are usually done manually and repetitively by humans. SAP has a number of processes, tasks and interfaces that are well suited for software robot automation provided by