SQLScript for BW Consultants

May 8 - 12, 2023

for Conti

Jörg Brandeis

(C) Brandeis Consulting

Welcome

  • Welcome
  • Introduction Jörg Brandeis
  • Organizational points
    • Agenda
    • Schedule
    • Learning Portal
  • Introduction of the participants
(C) Brandeis Consulting

Jörg Brandeis

  • Self-employed since 2015 as
    • trainer
    • technical SAP BW/4HANA consultant
    • ABAP & SQLScript developer
    • author of SQLScript for/for SAP HANA
  • Diploma in Business Informatics
  • Since 2002 experience in the area of SAP software and SAP BW
  • My focus is development
  • From 2002 to 2015 permanently employed at zetVisions AG, from 2006 as development manager for product development in ABAP
  • Experience with SAP BW since release 3.1

Social Media

(C) Brandeis Consulting

Agenda

Monday

  • Welcome
  • What is SQLScript
  • IDEs and SQL Console
  • Syntax Basics
  • Anonymous blocks, procedures and functions
  • Declarative programming and table variables

Tuesday

  • SELECT statement
  • Window Functions
  • Data Types & SQL Functions

Wednesday

  • AMDP Basics / Example
  • BW transformation routines (1/2)

Thursday

  • BW transformation routines (2/2)
  • Examples from BW
  • Tips and Tricks

Friday - Expert Day

  • Migrate one of your Transformations
  • Scenarios on your System
  • Optional:
    • Performance Analysis
    • Dynamic SQL
    • Imperative Programming
(C) Brandeis Consulting

Times (CET)

  • Monday - Friday 7:30am to 2:00pm
  • Plus 2 hours expert Session - Proposal: We do it on Friday up to 4pm
  • 11 am - 12 pm lunch break
  • some short breaks in between
(C) Brandeis Consulting

Systems

Your BW and HANA system

Fallback: My HANA Express System

(C) Brandeis Consulting

Learning portal

Navigation is in german

Contents

In the learning portal you will find:

  • All slides shown
  • Code examples
  • Notes from the live event

Login

  • URL: training.brandeis.com

There please follow the instructions to register. Your e-mail addresses are already assigned to the training room.

(C) Brandeis Consulting

Introductions

  • Expectations for the training?
  • Previous experience with SQL or SQLScript?
  • Do you use Eclipse for ABAP development?
  • Programming experience with ABAP (OO?), Java, C or any other programming language?
  • What are your daily tasks?
(C) Brandeis Consulting