S01 - Getting Started

Welcome to
BW4HANA
Training

Trainer Bio

Getting 1. OneDrive - Sharing

Started 2. Course Structure
3. Definition of SAP BW and Evolution of SAP BW to BW4HANA 2.0
4. Architecture of SAP BW4H 2.0
5. Difference between HANA & BW4HANA modeling.
6. BW4HANA Licensing
7. The new Eclipse feature and tools to work with BW4H
8. Salient features of SAP HANA as a DB
9. Setting up Eclipse Project.
10. Setting up BW4H Modeling Tools
11. BW4 Cockpit
12. Q & A

Batch_2 Page 1
OneDrive Sharing

Important Links The material OneDrive folder has been shared with all of you via a separate email. Please access the folder via that link and bookmark
that link.
This folder is your one-stop-shop for accessing the following:

1. Link to join the weekend classes:

This meeting link will remain the same for all the classes. If, due to any reason, the meeting link changed, then it’ll be updated in this
word document so this will be your reference to get the meeting link for the class.
2. Session-specific material which we’ll go through during each class.
These folders will have naming convention as ‘S**_<Topic_Covered>’ and this will have the class notes both in OneNote and PDF
format:

3. Material Folder which contains:

a. Certification material – this contains material for both full and delta certification
b. Business Scenario – which will be used as the basis for our exercises.
c. SAP Press Book on BW4HANA.
d. Topic specific material such as on ADSOs, CDS Views, Simplification List etc.

4. Recording Links
All the recording links will be updated in a word document in the below folder:

you can access all the recordings either on the YouTube channel, mentioned in the next point below, or from the individual links in
this word document.

5. Certification Practice questionnaire

This contains list of 80 practice questions which’ll give you an idea on what type of questions you can expect in the certification.
YouTube Playlist for All recordings will be uploaded on YouTube and access will be granted to you all.
all the recordings You can access the recording after 1 day. E.g. for class on 1st August’ 2020, recording will be available on 2nd August’ 2020.

YouTube Playlist where all the videos will be uploaded (plz bookmark this link):
https://www.youtube.com/playlist?list=PL55XwhlunOKbbQ0iyqBd5hNFnhwukFgFq

Batch_2 Page 2
Batch_2 Page 3
Course Structure & Details

Who is this course for? 1. BW consultants with basic knowledge.

2. Seasoned BW consultants looking for upskilling in BW4HANA.
3. Frontend consultants (Functional/Reporting users/BPC/SAC) interested to know the backend infrastructure.
4. Anyone who's interested to know about or start a career in BW (will require additional efforts)
Certifications
E_BW4HANA200 This is specialist/delta certification which I did. This you can only do if you have BW on HANA certification.
BW On HANA (7.3, 7.4, 7.5)

https://training.sap.com/certification/e_bw4hana200-sap-certified-application-specialist--sap-bw4hana-20-delta-g/
C_BW4HANA_20 - This is full certification meaning if you don't have BW on HANA certification then you can take this. This has no pre-requisite.

https://training.sap.com/certification/c_bw4hana_20-sap-certified-application-associate---reporting-modeling-and-data-
acquisition-with-sap-bw4hana-2x-g/

Server Vendors Get Trained GT sruthi.getraind@gmail.com Best server and Support. SAC Integration.
B4H 2.0 SP4
S4H 1909
ODP
SDA
SAC integrated

Course Modus Business Scenario based ▪ Requirement for a custom story from business in SAC.
Operandi ▪ We'll start with business blueprint of reports and story.
▪ Create Native HANA models using the HANA CVs, Table function
and DB Procedures based on SDA virtual tables.
▪ Then create and enhance BW Stnd Datasources. (LO Cockpit)
▪ Create and enhance CDS Views and extractors based on CDS Views.
▪ Creation of custom CDS Views in S4.
• Introduction to CDS Views and types of CDS Views.
• Main CDS View + Extension CDS View
▪ Activate delta from CDS view based extractors - generic and ODQ-based.
▪ Using ODQ and understand the new subscription based model.
▪ Custom ADSOs, DTPs and Transformations creation in BW.
▪ Staging ADSO based on fields as Corporate memory layer.
▪ Standard ADSO based on InfoObjects in DWH layer.
▪ Custom routines in transformations using AMDP Class and Methods.
▪ Creating OpenODS views for virtual access using SDA.
▪ Creating Composite Provider based on the ADSOs, OpenODS Views and HANA CV using
UNION/JOIN.
▪ Using new Composite Provider features such as Aggregation, Projection, SQL filter and
Calculated column.
▪ Create Custom BW Query in Eclipse for Sales Hdr and Sales Item.
▪ Creating customer exit variables using Enhancement Spot RSROA_VARIABLES_EXIT_BADI.
▪ Creating HANA Exit variables using RSROA_VARIABLES_HANA_EXIT and AMDP Class and
method.
▪ Custom BW process chain creation and monitoring in BW4 Cockpit.
Activating streaming process chain feature for near-real time extraction.
▪ Data manipulation using Inbound table - replacement of PSA-based data modifications.
▪ Configuring SAC to BW connectivity using CORS.
▪ Consuming BW Query in SAC and creating SAC Model and Story.

Optional FI new datasource and extraction.

(Based on time availability) Setting up analysis authorizations on ADSOs.
Generation of CVs from ADSOs, CompProvs and BW Queries.
Inventory Data Flow
Streaming process chain
OpenHub
Migration scenarios

Duration and Timing 1. Course Duration :

7 weeks (Weekends-only : Saturday | Sunday).
1st Aug to 13th Sept

2. Course timing

Weekends Time (EST - Canada) Time (IST - India) Time (UTC - UK) Time (AEDT - Australia)**
Saturday 8:30 AM - 10:30 AM 6:00 PM - 8:00 PM 1:30 PM - 3:30 PM Saturday (10:30 PM - 12:30 AM )
Sunday 8:30 AM - 10:30 AM 6:00 PM - 8:00 PM 1:30 PM - 3:30 PM Sunday (10:30 PM - 12:30 AM )

**For Australian timezone, this might be nonviable.

3. Course Duration :
7 weeks (Weekends-only : Saturday | Sunday).
Batch starting: 1st August

Software Used Zoom Meeting. Link will be in the 'Meeting Link' word document.
Recordings Available to view-only on YouTube Channel (Lifetime Access)
BW4HANA - Training - Batch 2

Batch_2 Page 4
 Downloadable: No
Recording Availability: Next Day

Q&A 30 min before the main session

30 min after the main session.

Topics and Timing

Topic Description Date | Time

Getting Started 1. Definition of SAP BW and Evolution of SAP BW to BW4HANA 2.0 1st Aug: 8:30 AM - 10:30 AM
2. Architecture of SAP BW4 2.0
3. Difference between HANA & BW4HANA modeling.
4. The new Eclipse feature and tools to work with BW4
5. Salient features of SAP HANA as a DB
6. BW4 Cockpit
SAP Native HANA Modeling 1. HANA Calculation Views 2nd Aug: 8:30 AM - 10:30 AM
Fundamentals - Part 1 2. HANA Virtual Tables
3. HANA Analytic Privileges
4. HANA DB Procedure
5. HANA XS Jobs - scheduling DB Procedures
SAP Native HANA Modeling 1. HANA Calculation Views 8th Aug: 8:30 AM - 10:30 AM
Fundamentals - Part 2 2. HANA Virtual Tables
3. HANA Analytic Privileges
4. HANA DB Procedure
5. HANA XS Jobs - scheduling DB Procedures
B4H - Intro, Architecture & LSA++ 1. B4H Introduction 9th Aug: 8:30 AM - 10:30 AM
2. Old vs New modeling Objects
3. B4H Architecture
4. LSA++ flow
5. New CDS View based Datasources
Datasources, Enhancements & ODQ - 1. Scenario Introduction - Report from User 15th Aug: 8:30 AM - 10:30 AM
Part 1 2. LO Cockpit Datasource activation process
3. 2LIS_11_VAHDR Activation
4. 2LIS_11_VAHDR Enhancement
1. Old way
2. New way - RSU5_SAPI_BADI
3. Method 1 -
New BADI Implementation for every DS.
Method 2 - New method for every DS
5. 2LIS_11_VAITM Activation
6. 2LIS_11_VAITM Enhancement using Method 2

Datasources, Enhancements & ODQ - 1. ODP concept 16th Aug: 8:30 AM - 10:30 AM
Part 2 2. ODQs and Delta
3. Delta from stnd datasources - 2LIS_11_VAHDR/ITM
4. CDS View Intro
5. Datasource based on CDS View - Full.
6. Datasource based on CDS View - Delta
(Generic w/o ODQs)
7. Datasource based on CDS View - Delta
(Generic with ODQs)
8. Enhancing datasource based on CDS views using extension CDS
Views.
Datasources, Enhancements & ODQ - 1. ODP concept 22nd Aug: 8:30 AM - 10:30 AM
Part 3 2. ODQs and Delta
3. Delta from stnd datasources - 2LIS_11_VAHDR/ITM
4. CDS View Intro
5. Datasource based on CDS View - Full.
6. Datasource based on CDS View - Delta
(Generic w/o ODQs)
7. Datasource based on CDS View - Delta
(Generic with ODQs)
8. Enhancing datasource based on CDS views using extension CDS
Views.
9. More on CDS Views
B4H - Modeling - Part 1 1. Definition and Positioning 23rd Aug: 8:30 AM - 10:30 AM
ADSOs 2. Types of ADSOs
3. Mapping to previous versions
4. Details on each type of ADSO
5. Active/Nonactive concept
6. Partitioning and Indexing
B4H - Modeling - Part 2 1. Transformations in BW4HANA. 29th Aug: 8:30 AM - 10:30 AM
ADSOs & Transformations 2. DTP in BW4HANA
3. Creating LSA++ flow for Header and Item.
Header from stnd DS and Item from CDS View DS.
4. Enhance CDS view for item for material type.
5. Crate Infosource for Header and Item

Batch_2 Page 5
 5. Crate Infosource for Header and Item
6. Create transformation (1st level)
7. Create transformation (2nd level)
8. Create lookups
9. Create formulae
10. Create AMDP based Start routine for removing special
characters.
11. Create AMDP based field routine for quantity conversion from
sales unit to base unit (0QUANT_B)
12. Create ABAP based end routine to populate update
date.(0UPD_DATE)
13. Debug AMDP transformation.
14. Test the overall flow.
B4H - Modeling - Part 3 1. Purpose 30th Aug: 8:30 AM - 10:30 AM
OpenODS Views 2. Usage
3. Types
4. OpenODS view - virtual model using SDA
5. OpenODS view - Generate Data Flow
B4H - Modeling - Part 4 1. Purpose 5th Sep: 8:30 AM - 10:30 AM
Composite Providers 2. Usage
3. UNION & JOIN
4. 2.0 Enhancements
5. Navigation Attribute
B4H - Reporting - Part 1 1. BW Query 6th Sep: 8:30 AM - 10:30 AM
BW Query & exit variables 2. Customer Exit Variables using BADI
3. HANA Exit Variables using AMDP Class and Method
4. Debugging customer exit variables.
5. Debugging HANA exit variables.
B4H - Reporting - Part 2 1. What is SAC (SAP Analytics Cloud) 12th Sep: 8:30 AM - 10:30 AM
B4H - SAC Integration 2. Live vs Import Data connections
3. BW4-SAC Live data connectivity via CORS
4. BW4-SAC features
5. SAC Models and Stories using B4H Queries
BW4 - Miscellaneous Topics - Part 2 1. Inventory Mgmt 13th Sep: 8:30 AM - 10:30 AM
2. Streaming Process Chains
3. Migration Scenarios
B4H Useful Tcodes List of handy BW4 tcodes and programs 5th July: 10 AM - 12 Noon
BW4 Interview Questions List of questions for BW4 interview 5th July: 10 AM - 12 Noon
Resume Preparation Tips Resume preparation tips 5th July: 10 AM - 12 Noon
B4H Certification Practice Questionnaire List of 80 questions for practice
Useful for certification

Batch_2 Page 6
Definition of SAP BW and Evolution of SAP BW to BW4HANA 2.0

What is BW4HANA BW4HANA is SAP's proprietary Datawarehousing Software.

New Product (version starting from 1.x, 2.x...)

DWC - Datawarehouse Cloud

History of BW

BW4HANA 2.0 - Feb'25 2019

Batch_2 Page 7
Architecture of SAP BW4 2.0

Q What is the difference between SAP NetWeaver Application Server ABAP (SAP_ABA 750) and the so called
“Lean ABAP Application Server” (SAP_ABA 75A)?
A 1. The primary difference is that SAP_ABA 75A/B/C/D includes support for long material numbers
(CHAR 40, see SAP Note 2267140).
2. Millions of lines of code for obsolete objects were removed such as old interfaces, EP portal, BSP applications, and the
migration workbench. In a nutshell, objects related to JAVA stack are no longer there.
Side note: SAP_ABA 75A is also the foundation for SAP S/4HANA.

Batch_2 Page 8
B4H - Dataflow - LSA++

Batch_2 Page 9
BW4H - Stnd Content

Batch_2 Page 10
Important/Useful BW Tcodes

RSA1 To check process chains and BI Content Activation

1. BI Activation
2. Transports
3. Administration
BW4WEB To launch BW4 Cockpit

Batch_2 Page 11
Difference between HANA & BW4HANA modeling.

HANA Modeling • Done in HANA DB

• DB Schemas and Tables
• DB Packages
• Calculation Views
• DB Procedures
• DB Table Functions

BW4H Modeling

Batch_2 Page 12
BW/4HANA Licensing

BW/4HANA Licensing

1st choose HANA DB Size

License - Runtime (REB, REAB) | Full Use (Stnd | Enterprise)

Batch_2 Page 13
Batch_2 Page 14
Batch_2 Page 15
Batch_2 Page 16
Batch_2 Page 17
Batch_2 Page 18
Batch_2 Page 19
The tools to work with BW4

Tools

Eclipse ▪ Completely Eclipse-based Modeling for BW4HANA Infoproviders.

▪ Tcode based navigation within Eclipse wherever necessary.

▪ Eclipse based BW Query creation.

Batch_2 Page 20
 ▪

▪ Native HANA Modeling:

https://access.getraind.com/#/client/MTM4AGMAbXlzcWw=

BW4 Cockpit ▪ BW4 Cockpit based modeling, data maintenance and monitoring.

Difference between HANA ▪ HANA Studio

Studio and Eclipse is a plugin so if you install HANA Studio, you'll get bundle:
Eclipse + HANA Studio Plugin

▪ Eclipse
Only Eclipse. Need to install the plugins manually:

Batch_2 Page 21
Batch_2 Page 22
BW4H - Eclipse Shortcut

Operations Shortcuts
Open SAP GUI Ctrl+6
Create a new object Ctrl+N
Activate an object Ctrl+F3
Validate an Object Ctrl+F2
Maximize\Restore tab Ctrl+M
Search\Find object Ctrl+H
Open Resource Ctrl+Shift+R
Open an Object Ctrl+Shift+D
Toggle tab Ctrl+F7
Toggle perspective Ctrl+F8
Toggle between Open objects Ctrl+E
Move across open objects Alt+(→ or ←)
Close current Object Ctrl+(F4 or W)
Close all open objects Ctrl+Shift+(F4 or W)
Get Where used list Ctrl+F5
Undo Ctrl+Z
Redo Ctrl+Y
Quick Access Ctrl+3
Open views Alt+Shift+Q
Show error logs Alt+Shift+Q+L
Refresh data preview Ctrl+Shift+P

You can get the list of available shortcuts in eclipse using the
command Ctrl+Shift+L.

Batch_2 Page 23
BW4 Cockpit

Batch_2 Page 24
Salient features of SAP HANA as a DB

Evolution of SAP HANA

Evolution of HANA &

BW4HANA

Batch_2 Page 25
Options for SAP BW/4HANA

Recommended: Scale-up for BW.

Main concepts of SAP HANA

DB

Column and Row Store:

Row Vs Column Store:

Batch_2 Page 26
 Example:

Compression of Column Store:

Batch_2 Page 27
SAP HANA as Platform

Batch_2 Page 28
SAP HANA as Platform

Batch_2 Page 29
Batch_2 Page 30
Batch_2 Page 31