HANA Overview:
HANA Database Compatible SAP Versions:
SAP ERP Central Component (ECC) 6.0: 24 October 2005
o SAP enhancement package 1 for SAP ERP 6.0 (EHP1 FOR SAP ERP 6.0): 21 December 2006
o SAP enhancement package 2 for SAP ERP 6.0 (EHP2 FOR SAP ERP 6.0): 27 July 2007
o SAP enhancement package 3 for SAP ERP 6.0 (EHP3 FOR SAP ERP 6.0): 7 December 2007
o SAP enhancement package 4 for SAP ERP 6.0 (EHP4 FOR SAP ERP 6.0): 21 November 2008
o SAP enhancement package 5 for SAP ERP 6.0 (EHP5 FOR SAP ERP 6.0): 12 July 2010
o SAP enhancement package 6 for SAP ERP 6.0 (EHP6 FOR SAP ERP 6.0): 24 August 2011
o SAP enhancement package 7 for SAP ERP 6.0 (EHP7 FOR SAP ERP 6.0): 13 August 2013
o SAP Fiori 1.0 for SAP ERP (UI FOR EHP7 FOR SAP ERP 6.0): 29 November 2013
o SAP enhancement package 8 for SAP ERP 6.0 (EHP8 FOR SAP ERP 6.0): 20 January 2016
SAP S/4HANA
o SAP S/4HANA 1511: November 2015 [3]
o SAP S/4HANA 1610: 31 October 2016 [4]
o SAP S/4HANA 1709: 15 September 2017 [5]
o SAP S/4HANA 1809: 21 September 2018 [6]
o SAP S/4HANA 1909: 20 September 2019 [7]
o SAP S/4HANA 2020: 7 October 2020 [8]
Yellow – HANA DB Compatible. Not mandatory
Green – HANA DB is mandatory
SAP - ERP – Enterprise Resource Planning – 80%
Takeovers: (Acquired)
GRC
BO- Business Objects
ARIBA
CONCUR
Their Own Developments:
EP is Front End Application
Fiori as Front end
HANA Database
HANA stands for?
High Performance Analytic Appliance
SAP HANA is an in Memory, Column Oriented Relational Database
Management System that combines OLAP and OLTP operations into a
single system (RDBMS)
OLTP - Online Transactional Processing - Data Provider (ECC)
OLAP - Online Analytical Processing - Data Source (BW)
What does S/4 HANA stand for?
SAP Business Suite 4 SAP HANA (or SAP S/4HANA) is a business suite
that is built on SAP's proprietary operational database system and in-
memory computing platform called SAP HANA
1972 - R2 System - Any DB
1992 - R3 System - Any DB
2001 - ECC (ERP Central Component) System EHP 1 to 6 - Any DB
ECC - EHP7, 8 ------ > HANA Compatible (Not Mandatory)
2015 - S4 HANA System - HANA DB Mandatory - (No Choice)
How HANA does come in?
Pre Installed ---- > New Set Up (Hardware +Software)
To be Installed ---- > Existing Set up (Software)
SAP HANA - Act as a standard SQL based relational database
When database is migrated from Oracle/Db2 to HANA for your ECC
system, what will be the roles and responsibilities of Security
Consultant?
Ans: Nothing
When database is migrated from Oracle/Db2 to HANA for your ECC
system, what precautions should be taken?
ABAP Programs - Convert Programs into HANA format – HANAtization
Ex,, SORT command – where ever this command is used, it has to be
adjusted.
Why HANA?
1. Not just a database
2. Row and Column Based Storage
3. Speed, Data and Real Time
4. Replace OLTP, OLAP and ETL systems
5. Parallel execution capabilities
What is the difference between ROM and RAM?
RAM is temporary Storage
ROM is Permanent Storage - Hard Disk
HANA is ACID Compliant
Business professionals generally look for when evaluating databases
Atomicity
Consistency
Isolation
Durability
Brief History of SAP HANA
Vishal Sikka, the company's top technology leader, was the leading advocate of SAP's Hana in-
memory platform. He was also the protege of SAP Supervisory Board Chairman Hasso Plattner,
Hana's earliest proponent and inventor.
HANA Versions
HANA 1.0 ----- > 2011
HANA 2.0 ------- > 2017
Latest HANA 2.0 SPS 05 REV1,2,3..10 SPS06
Ex,, 2.00.040.00.1553674765
SPS - Support Pack Stack
REV - Revisions - Max 10 in between 2 SPS
Maintenance Revision - Particular Fix
Hierarchy:
Version
SPS
REV
Maintenance Rev
Types of Projects:
1. Fresh S4HANA Implementation – Greenfield
2. Upgrade Projects (ECC to S4HANA) – Greenfield and Brownfield
3. Database Migration (ECC) Oracle ---- > HANA
Projects: Database Migration (ORACLE to HANA)
#############################################
ECC EHP1 to 6 --- > Not HANA Compatible
ECC EHP7 & 8 --- > HANA Compatible
As a Security Consultant, we don’t have any role to play
S4HANA ---- > HANA is mandatory
After migrating the DB, if HANA is used for reporting purpose:
HANA Security
Reporting Tools: SAP /Non SAP
Data sources: SAP BW/ HANA DB/ SAP BW4HANA
SAP – BPC, BO
Non SAP – Power BI, Tableau, Click view, Cognos, Informatica
BW System - Reporting Purpose
Storage ---> Info Providers = Infocube/Multiprovider ---- > Query(Report)
Old - Authorization Set Up is done – Analysis Authorizations
HANA DB --- SAP analytics - Reporting
Storage ---- > Composite Provider/DB Tables ---- > HANA views (reports)
Old - Authorization Set Up is done – Analysis Authorization is converted
into Analytical Privilege through Stored Procedure.
New - Authorization Set Up is done
