SAP HANA Certification Online Training India

Module – 1
Getting started with SAP HANA and SAP HANA Architecture


  • Introduction to SAP HANA
  • Introduction to In-Memory Computing
  • HANA: the best of OLAP and OLTP in one tool
  • Fundamentals of SAP HANA
  • What SAP HANA Can do
  • What SAP HANA Can’t do
  • High Performance functionalities in SAP HANA
  • In-Memory computing
  • Columnar store database
  • Massive Parallel Processing
  • Data Compression
  • Version & Service pack details
  • SAP HANA Architecture
  • SAP HANA Used Case Scenarios
  • Explore the SAP HANA landscape”

Module – 1
Introduction to HANA Studio IDE & HANA Database SQL Basics


  • Introduction to In-Memory Computing Studio
  • Role of Hana Studio
  • Role of Hana Client
  • Add SAP HANA System Perspectives Administration
  • Modelling Development Plan Viz Folders Catalog Content
  • Provisioning Security””.
  • Introduction to SAP HANA Database SQL Script
  • Expressions Loops CATALOG SCHEMA TABLE

Hands On;

  • Create a Catalog Schema
  • Create a Package
  • Create Column Table
  • Create Row Table
  • Insert Data into tables
  • Create Database View
  • Create UDF [User define functions]
  • Create Stored Procedures
  • Create Public Synonyms
  • Create Sequences
  • Create Indexes
  • Create Triggers”

Module – 3
SAP HANA Modelling


Introduction Types of Models Attribute Views Joins
Using Filter Operations Creating Restricted & Calculated Columns Using Hierarchies Analytic Views Star Schema design Muti-Dimensional modelling Using Variables Using Input parameters Advantages & Limitations

Hands On;

  • Create Un-Structured Package
  • Edit Package to make Structured
  • Create Attribute View
  • Create Analytic View
  • Apply Static filter
  • Create Variable
  • Create Input Parameter
  • Create Calculated objects
  • Create Restricted Measures
  • Create Hierarchies”

Module – 4
Calculation Views


Calculation Views (GUI) Dimension Calculation View Star Join Calculation view OLTP Calculation view Using Projection Using Join Using Aggregation Using Union Using RankCalculation Views (Scripted) CE functions Introduction Creating Content Procedure

Hands On;

  • Create GUI Calculation view – Dimension
  • Create GUI Calculation View – Star Join Cube
  • Create GUI Calculation View – Cube
  • Use Projection Node
  • Use Aggrigation Node
  • Use Join Node
  • Use Union Node
  • Use Rank Node
  • Create Scripted Calculation View – Cube
  • Use CE functions
  • Use SQL Script
  • Create Procedure and use it in Scripted Calculation view”

Module – 5
Analytic Privileges & Decision Tables

Analytic Privileges Classical Analytic Privileges SQL Analytic Privileges Dynamic analytic Privileges Turning Business Rules into Decision tables Table Functions

Hands On;

  • Create Analytic Privileges
  • Classical Analytic Previliges
  • SQL Analytic Previliges
  • Dynamic Analytic Previliges
    Assign Analytic Previliges to User or role
  • Create Update Decesion Table
  • Create Return Decesion Table
  • Call Decision tables as procedures in catalog
  • Create Table Function
  • Use Table Function in GUI Calculation view”

Module – 6
Advance Modelling Topics

Advance Modelling Union Pruning Refactoring information models Schema Mapping Propagate to schematics Show Lineage Find Where used Schema Mapping Generating Time Data Using Time Travel Migrating deprecated Information models Using Currency ConversionWeb Based Modelling Workbench Advance HANA Database Objects Temporary tables Triggers Exceptions Handling”

Hands On;

  • Create Union Pruning Configuration table
  • Insert conditions as rows into pruning configuration table
  • Assign configuration table to Union GUI calculation view
  • Refactoring Information Views
  • Configure Schema Mapping
  • Generating Time Data
  • Enable Time Travel Queries for catalog Tables
  • Migrating Depreciated views to GUI Calculation views
  • Migrating Classical Analytic Previliges to SQL Analytic Previliges
  • Migrating Scripted Calculation Views to GUI Calculation Views with Table Functions
  • Enabling currency conversion for Calculation view measure objects
  • Working with Web based modelling workbench
  • Creating temporary tables
  • Using Exception Handling in SQL Script Procedures”

Module – 7
Application Life Cycle Management

Application Life Cycle Management Transport Using Developer mode Transport Using Delivery Unit modeChange management Analyzing Query Performance with Explain Plan Visualize plan Performance traceFull Text Search Overview Datatypes & full text Indexes Using Full text search

Hands On;

  • Transporting Content objects
  • Using Developer mode
  • Creating Delivery unit
  • Transporting Content objects
  • Using Delivery unit mode
  • Creating change requests
  • Creating full text search queries”

Module – 8
Data Provisioning Services

What is Data ProvisioningData Provisioning Scenarios Loading Data to HANA Database Table Excel File, Flat File, Oracle Database, SAP ECC, SAP BW Data Provisioning Using BODS Data Provisioning Using SLT (SAP Landscape Transformation Replication Server)”

Hands On;

  • Configuration SLT on SLT Server
  • Loading/Replicating Tables using above configuration
  • Loading data using file import mechanism
  • BODS
  • Executing Job to transfer data from various source to Target
  • 1. ECC-HANA
  • 2. RDBMS – HANA
  • 3. File – HANA”

Module – 9
User Management, Provisioning and Security

Understand the Key Concepts of SAP HANA Security Define Data Access Security User Creation Role Creation Assigning role to user Analytical privileges to role” Object Previleges Package Previleges

Hands On;

  • Create a user account
  • Create roles
  • Assign roles to user
  • Assign Analytical privileges to role”

Module – 10
SAP Reporting


  • SAP Reporting/Dashboard creation
  • Introduction to Lumira
  • Using Lumira Prepare, Visualize compose data
  • SAP HANA Dynamic tiring
  • Delta Merge
  • Partitioning of tables
  • SAP HANA cloud Platform overview

Hands On;

  • Creating Live Connection to HANA source
  • Create New document using above connection
  • Prepare, Visualize and compose objects from Calculation Views
  • Create Partitioning of Column tables
  • Create Cloud account for using Hana instance.”

Module – 12 Project;


SAS Grid Administration Online Training India

1. architecture of sas
2. types of installation
3. how to do hardware sizing
4. how to get the sas software
5. how to prepare the hardware environment
6. pre-installation checklist
7. non-distributed installation
8. distributed installation
9. how to do the clustering
10. types of clustering
11. post-installation configuration
12. setting up the initial environment
13. taking backups
14. regular monitoring the environment
15. spds installation
16. registering libraries – lasr, db, spds, sas etc.,
17. user, groups, roles
18. act – access control templates
19. server management
20. grid manager
21. environment manager
22. major issues and resolutions
23. how to interact with technical support
24. how to make documentation of the environment for auditing
25. how to keep track of tickets.
26. grid nodes, load balancing, high availability, ego scripts
27. how to use grid manager in the management console
28. how to schedule the jobs, lsf flow monitor, smc.
29. how to run codes in interactive mode, grid mode, batch mode
30. how to monitor users, space, memory.
31. how to monitor jobs, kill jobs, manage the space.
32. how to take the spk backup, physical files backup, metadata backup.
33. server start and stop orders
34. config, sas home directory structure
35. user loggin information to the metadata server, workspace server, pooled workspace server.
36. find the location of installation and configuration of server files.
37. license update
38. hotfix installation
39. LDAP authentication.

Reach us @ +91 8790679998 you want to learn About SAS Administration Course Online click here.


SAP Hybris C4C Functional Online Training

About SAP Hybris Cloud for Customer Administrator Guide
Set Up your SAP Hybris Cloud for Customer System
Initial Setup for your SAP Hybris Cloud for Customer System
Know your Tenant Systems and Workcenters
Profile and Scope your Solution
Create Service Agent and Other Administrators
Choose a Default Client

Minimum System and Software Requirements
Web Applications
Mobile Applications
Language Setting

RACI Compliance Matrix for SAP Hybris Cloud for Customer
User Management
Configure Employee and Business Role
Partner Contacts

Configure Org. Structures in your SAP Hybris Cloud for Customer System
Distribution Channels
External Identifiers

Maintain Access to Work Centers, Views, Fields, or Users
Setting Up User Access Rights and Restrictions
Overview of Restriction Rules
Assign Work Centers and Work Center Views to Business Roles
Maintaining Access Context
Hide Fields Based on UI Switches
Restricting Authorizations by Fields & Actions
Hide Fields Based on User or Business Role

Export Create Business Data Using Microsoft Excel

SAP Hybris Cloud for Sales: Solution Overview
Scope your SAP Hybris Cloud for Sales Solution
Getting Started for SAP Hybris Cloud for Sales Administrators
Sales Features
Sales Quotes and Orders
Sales Planning
Retail Execution
Sales Campaigns
Sales Tools

SAP Hybris Cloud for Service and Social and Process Overview
Enabling Features in Scoping for SAP Hybris Cloud for Service or SAP Hybris Cloud for Social Engagement
Getting Started for SAP Hybris Cloud for Service Administrators
Setup and Configuration Tasks
Service Features
Enabling Resource Scheduler
Configuring Installed Base
Registered Products
Complaint Management
Configuring Maintenance Plans
Configuring Tickets for Customer and Employee Support
Defining Rules for Ticket Routing by Organization or Employee
Configuring Service Level Agreements
Item Processing Codes for Service Quantity Contracts
Setting-up Item Processing Codes for Tickets
Master Data and Other Functionality

Account Management
Scoping and Configuring Accounts
Product Administration
Important tasks
Configuring Product Categories
Creating and Maintaining Product Lists
Workflows, Approvals and Business Task Management
Workflows, Approvals
Notifications using Business Task Management
FAQs for Workflows
Party Processing
Important tasks
Parties in Documents
Recommended Combinations of Party Roles and Business Partners

Groupware Add-Ins
Integrated E-Mail Using Microsoft Outlook Add-In

Service Control Center
Systems Quick Guide
System Availability
Maintenance Schedule
Contact Details
User Subscriptions

System Usage & Monitoring
Usage Statistics
How to Run Background Jobs

Support & Incidents
Business background
Handling Incidents

Work Distribution at Organization and Employee Level
Organizational Work Distribution
Employee Work Distribution

Microsoft Silverlight
SAP Fiori Client


SAP BW Online Training from India | SAP BI/BW Online Course

Course Objectives;

  • Describe the architecture of SAP NetWeaver and BI and explain their advantages.
  • Manage metadata.
  • Define various BI objects, Info Objects, Data Sources, Info Cubes, Data Store objects and so on.
  • Describe the different ETL flows.
  • Create and use data transformations and Data Transfer processes to load and transform data from flat files and from SAP Systems.
  • Define Info providers and when they should be used in your BI implementation.
  • Schedule and monitor data loading processes with BI
  • Activate BI Content in BI.
  • Use Aggregates to improve query performance.
  • Understand BI IP (Integrated Planning) at a High Level.

Course Introduction

Ground Rules

  • Participate – Ask Questions
  • Learn from Everyone’s Comments
  • Please turn off cellular phones
  • Honour time schedule
  • Relax and Have Fun
  • Introduce Yourself
  • Name, Operating Group, Location
  • Your SAP BI Bootcamp objective(s)

Reference Material

  • Key Fields in SAP Tables
  • List of codes of be used in BI Key fields in SAP tables
  • SAP BI Bootcamp Transaction Codes
  • List of Transaction Codes used in BI

Requirements of Information Systems Software

  • Immediate single-point access to all relevant information, regardless of source
  • Coverage of all business processes; cross-system and cross process analyses are becoming increasingly important
  • High quality of information not only in terms of data content but also in terms of the ability to flexibly evaluate data
  • High quality of decision making support; The BI System must support the requirements of both operative and strategic management; only then is it possible to support decisions fully
  • Short implementation time with less resources; As well as being quick to implement a Data ware house must enable simple and quick access to relevant data, avoiding the labour intensive preparation of heterogeneous data.


A KPI in the Data warehouse is used to measure customer response on surveys. Based on the survey responses, the customers are grouped into target groups in BW. On the business strategy side a marketing campaign could be planned to target specific customer target groups for higher effectiveness.

Properties of a data warehouse

Read Only access; Users have read-only access, Meaning that the data is primarily loaded into the data warehouse via the extraction, Transformation and loading (ETL) Process.Cross – Organizational focus data sources from the entire organization (production, sales and distribution, controlling), and possibly external sources, make up the basis of the system.Data Warehouse data is stored persistently over a particular time period. Data is stored on a long-term basis. Designed for efficient query processing; the technical environment and data structures are optimized to answer business questions, not to quickly store transactions.



SAP BI, BW, BO, Hana Online Training from India

SAP BI Online Course | Key Components Features of SAP BI


DW Level BI Services BI Suite /
BE x Tool set
Data ETL -OLAP Services Query Designer
Aggreation RRI Report Designer
BI Accelerators Hierarchy Web Aplication Designer
Warehouse Mgmt Current / Unit BEx Analyzer ( Micro soft excel based)
Cude – summarized Planning BEx Web analyzer
Dimensional Data Analysis Process BE X  General Analysis functions
Designer Information Broadcasting
DSO Granular Data Mining Portal Integration
Volatile Data Meta Data Repository services BI Suite /
Master Data Exchange
Data warehousing Search

TIBCO Certification Online Training India

EAI Architecture

  • Point to point Architecture
  • Hub and Spoke Architecture
  • Bus Architecture

What is Point to Point Architecture?

  1. This is the most primitive form of integration method
  2. In this architecture, direct connectivity is established between two systems/application as show in the picture below.
  3. It is extremely difficult to implement and equally difficult to maintain.
  4. When a large number of systems are inter-connected, Integration tends to be impossible.
  5. The number of connections needed to have fully meshed point – to – point connections, with n number of applications. I,e n(n-1)/2.

What is Point – to – Point Architecture?

  1. If there are 5 applications in an enterprise, we need 10 connects to integrate them. I,e n(n-1)/2.
  2. Examples; Postal Services, Telegram…

What is Hub and Spoke Architecture?

  1. In this architecture the central hub publishes and subscribes the messages and also co-ordinates the movement of message traffic.
  2. The central performs necessary content and format transformation.
  3. It also provides better maintenance of transformation and routing rules due to centralized approach.
  4. This architecture is convenient for companies with limited IT Resources and moderate transaction volumes.

What is Bus Architecture?

  1. In this mode of architecture the nodes are linked in a series along a common communication back bone with helps in reducing performance bottlenecks and single point of failure.
  2. It is better suited for large – scale environments involving hundreds of systems with heavy transaction volumes. In such a design integration logic (Transformation and routing information) is not maintained centrally.
  3. It also provides better sclability compared to hub and spoke architecture but more difficult to administer as the environment scales up.

Click here for Tibco video 



TIBCO Certification Online Training India

Definition of EAI

Enterprise application integration (EAI) is the use of software and computer systems” architectural principles to integrate a set of computer applications in an Enterprise. Enterprise application integration (EAI) is an integration framework composed of a collection of technologies and services which form a middle-ware or “middle ware framework” to enable integration of systems and applications across an enterprise. EAI is the unrestricted sharing of data and business process among any connected application or data sources in the enterprise.

What is the Need of Integration in an Enterprise?

Many types of business software such as supply chain management applications, ERP Systems, CRM Applications, business intelligence applications, payroll and human resources systems typically cannot communicate with one another in order to share data or business rules.

Enterprise application integration is the process of linking such applications within a single organization together in order to simplify and automate business processes to the greatest extent possible. At the same time avoiding have to make sweeping changes to the existing applications or data structures.

The various systems that need to be linked together may reside on different operating systems, use different database solutions or computer languages, or different data and time formats, or may be legacy systems that are no longer supported by the vendor who originally created them


SAP MM Certification Online Training India

SAP Materials Management Certification Online Course

Introduction to SAP MM

Exploring MM Module in SAP; In a company various transactions related to goods or materials, such as maintaining records and invoicing the purchase orders, need to recorded on regular basis. The SAP System provide the MM Module to store all these transaction details in the form of organizational data. The MM Module is the core Module of the my sap ERP System, as it helps to implement the supply chain. The Module allow you to plan for future production on the basis of post consumption trends.

What is the Role of MM Module in SAP

In the world of Business, the movement of goods or material from a vendor to company and finally to a customers in termed as supply chain. This chain is implemented in the mysap ERP System with the Help of MM Module. The MM Module allows a company to control its inventory, Forecast customer demand, and keep itself updated on all the transactions of supply chain.

The Instant transfer of information among various Modules of the SAP System facilitates smooth functioning. The MM Module helps to transfer the information, such as order details. The status of the Inventory in the storage location and the delivery status to other modules.


Consider a scenario where a customer places order of 50 items in a company now suppose that 20 items are already available in the warehouse; therefore the company has to manufacture 30 items to fulfil the order. The details of this order are maintained in the SD Module of the mysap ERP System which are further forwarded to the MM Module after checking the availability of items in stock. The movement of details from one module to another module is known as flow of Information.

Register today to attend free Demo session on SAP MM Material Management Online Training India





SAP Fiori Interview Question and Answers

Question What are the different configuration steps in SAP Fiori?
Answer Configurations of SAP Fiori Apps are divided into two parts: Configuration of Transaction Apps and Fact sheets, Configuration of Analytical Apps.
Before configuring anything, the complete infrastructure for SAP Fiori apps must be installed. Once that is completed there will be activities to configure on back-end and front-end servers.
Question Note down the steps that are required to configure SAP Fiori Transactional Apps?
Answer step 1 Configuring SAP Web Dispatcher specifies routing rules to define which URL is forwarded to which system is done for both Transactional Apps and Factsheets.
step 2 only needs to be configured for Factsheets. If we just have to configure Transactional Apps we can skip step 2.
step 3 is configuring the front-end server and this is done for both Transactional Apps and Factsheets. At high level we need to configure −
SAP NetWeaver Gateway
The Central UI Add-Ons (Launchpad Configuration)
Product Specific Add-Ons
step 4 is configuring the back-end server and this is done for both Transactional Apps and Factsheets.
Viewing from a high level – Roles, Users and Authorizations
Note – Transactional Apps can run on any DB whereas the Factsheets must run on SAP Hana.
Question Note down the steps that are required to configure SAP Fiori Analytical Apps?
Answer Step 1 Configure SAP Web Dispatcher −
Needs to be configured to specify routing rules stating which URL is forwarded to which request
Step 2
Configuring authentication and SSO needs to be done in the HANA database.
Step 3 configuring the front-end server −
Configuring NetWeaver Gateway
Central UI add-Ons
Product specific add-Ons
Step 4 (Only needed for Smart business apps) −
Enable user access to KPI data
Model KPIs
Configure navigational targets for KPI catalogs
Question KPI framework is installed for which of the following Apps?
Answer Analytical apps and the SAP Smart Business apps share the setup of HANA XS engine and KPI Framework only (in Smart Business Apps). After setup of SAP Fiori System Landscape with SAP Hana XS engine we need to be following the KPI modeler on front-end server and respective SAP Smart Business Products on SAP Hana server.
Question To enable remote logon for users who use the same user data in both SAP NetWeaver Gateway host and SAP system, which connection type needs to be configured?
Answer To define a trust relationship between SAP system and SAP NetWeaver gateway host by configuring SAP system to be trusting system and NetWeaver gateway host to be the trusted system. It enables remote logon for users who use the same user data in both SAP NetWeaver Gateway host and SAP system.
To configure SAP system as the trusting system −
Create an RFC destination for use in the trust configuration.
Define system to be trusting system using transaction SMT1.
Configure the system to create and accept assertion tickets from SAP NetWeaver Gateway host using SSO2 wizard.
To configure SAP NetWeaver Gateway host as trusted system −
Create an RFC destination for communicating with the trusting SAP system.
Question To configure Enterprise search in back end, what is important perquisite for this?
Answer To configure Enterprise search in back end, we must have Embedded Search Technology setup.
Question What are the different authentication methods that can be configured in SAP Fiori for internal and external company communication?
Answer By implementing SAP Single Sign-On, your apps become automatically available after just one initial user authentication at the users Windows desktop, with no need for further log-on procedures.
Kerberos technology is the method of choice in intranet scenarios for SSO. It simply re-uses your Windows domain authentication for single sign-on.
X.509 certificates provide a viable option for creating a secure SSO infrastructure if you’re considering extending single sign-on to extranet or cross-company scenarios.
Question What are the components that are configured in SAP Front End Server?
Answer Configure ABAP Front-end server includes- Configure SAP NetWeaver Gateway, Configure the Central UI Add-On, Configure SAP Fiori Launchpad.
Question What are the components that are configured as part of configuration of KPI data?
Answer Configure access to KPI data (SAP Smart Business only) includes – enables user access to KPI data, KPI modeler, Configure navigation targets for KPI’s.
Question Explain SAP NetWeaver Gateway Central Hub deployment in SAP Fiori?
Answer In NetWeaver Gateway Central Hub deployment − UI layer and SAP NetWeaver gateway is contained in ABAP Front-end server. The ABAP back end server contains business logic and back end data. Separating business logic and back end data from UI layer has below advantages −
Single Point of maintenance for UI issues- such as browser support and updated version of SAP UI5 libraries.
Central place for theming and branding SAP Fiori Apps.
Routing and composition of multiple backend systems is supported.
Single Point of access to backend systems and enhanced security because of no direct access to backend system.
SAP recommends Central Hub deployment especially for Productive environment. Separate NetWeaver Gateway system is required.
Question Explain SAP NetWeaver Gateway Embedded Hub deployment in SAP Fiori?
Answer In Embedded Hub Deployment − NetWeaver gateway is deployed on same server as the Business Suite. So multiple Business Suite systems requires Gateway to be configured multiple times. It is not recommended by SAP especially for customers with multiple back ends.
No additional separate NetWeaver Gateway system is required. It is usually used for sandbox purposes only.
Question To enable communication between the front-end ABAP and back-end ABAP server, which communication type is used?
Answer Trusted RFC
Trusted RFC provides data from backend Business suite to the apps. SAP Business suite is present in ABAP back-end server with all its modules- ERP, CRM, SRM, SCM. Fiori Apps are available in ABAP frontend server in Fiori Launchpad.
Question Transaction Apps, Factsheets and Analytical Apps require which of the SAP system to run?
Answer Transaction Apps are only apps that don’t have to run on Hana system. They can run on any Database. All factsheets, Analytical apps and Small Business Apps run on SAP Hana. Only Fact sheet requires Search Models. Only Analytical Apps requires Hana XS Engine and KPI Framework is needed for Smarts Business Apps.
Question What is the function of SAP Web Dispatcher in SAP Fiori architecture?
Answer SAP Web Dispatcher (Reverse proxy) is entry point for HTTP(s) request in SAP Fiori Architecture. It can accept or reject connections as per user request.
Question What are the components of SAP Hana extended application services?
Answer SAP Hana XS engine contains 2 components-Hana Live App Content and SMART Business components with KPI modeler. Within Hana Live App Content VDM reuse content exist.
Question What is MVC?
Answer The Model-view-controller pattern defines domain modeling, GUI of application and input and actions based on devices. MVC approach defines in SAP UI5 has following points −
A bridge between view and data of the apps and it accepts the request from view and responds accordingly. It doesn’t depend on any of classes.
It manages the display of information (GUI of the application) and it depends on Model.
It concludes the input given by devices and communicates to model/view to take proper action. It also depends on model. View and Controller have 1:1 relationship. Controller entertains user requests received from View.
Question In UI5 data binding supports, what are the different model implementations?
Answer UI5 data binding supports three different model implementations −
JSON Model supports data in a JavaScript Object Notation format and It supports two-way binding.
XML model supports XML data and it supports two-way binding.
OData model supports OData compliant data. It creates OData requests and handles responses. It includes the open source library dataJS to handle OData requests and data. It supports two-way experimental binding.
Question What is use of OData protocol?
Answer OData is a protocol used to exchange data on web and was originally developed by Microsoft.It is based on Atom Publishing and Atom Syndication standards, which in turn, are based on XML and HTTPS(S).
The Atom publishing format doesn’t specify how Data should be encoded with in a feed therefore it fails to provide self-describing messages and fails to be fully RESTful. OData extends Atom by providing a metadata description of message.
OData provides definition for −
Simple types
Complex Types
Association as well as Navigation path between entries.
Custom behavior
OData also adds an alternative representation of data in the format of JSON.
Question In NetWeaver Gateway Central hub deployment, what are the different scenarios for development? Which one is preferred and when?
Answer Scenario A: Central Hub Deployment — Development in SAP Business Suite Backend System
It enables to reuse data stored in the SAP Business Suite system easily since development takes place in the system in which data is stored.
To enable communication between the SAP NetWeaver Gateway system and the SAP Business Suite backend system, you must install IW_BEP in the backend system.
The life cycle of SAP NetWeaver Gateway content is dictated by the frequency of updates in the SAP Business Suite backend system.
Requires separate NetWeaver Gateway system
Scenario B: Central Hub Deployment — Development in SAP NetWeaver Gateway System
Noninvasive deployment scenario for SAP Business Suite backend system.
The life cycle of SAP NetWeaver Gateway content is loosely coupled to the lifecycle of the SAP Business Suite backend system.
To enable external access and fulfill security requirements, you can locate the SAP NetWeaver Gateway system in a demilitarized zone (DMZ).
You need only a single installation of the SAP NetWeaver Gateway Add-Ons within the system landscape.
Requires separate NetWeaver Gateway system.
The SAP NetWeaver Gateway content implementation cannot use the majority of development objects in the SAP Business Suite backend system. Consequently we need to create copies of structures and data domains.
We must choose this deployment scenario if we cannot install the SAP NetWeaver Gateway Add-Ons in the SAP Business Suite backend system. We might not be able to install Add-Ons in the backend system for reasons of security, stability, or incompatibility (due to system release).
Question What is embedded hub Deployment and where it is used?
Answer Embedded hub Deployment — Development in SAP Business Suite Backend System
Easy reuse of content in SAP Business Suite backend system. We can reuse structures from the backend system and access local business logic.
Reduced total cost of ownership (TCO) as we do not require a separate SAP NetWeaver Gateway system.
The life cycle of SAP NetWeaver Gateway content is dictated by the frequency of updates in the SAP Business Suite backend system.
We must integrate the consuming application or infrastructure with the SAP Business Suite system on a point-by-point basis. Cross-system composition is not advisable.
Central SAP NetWeaver Gateway content is not available. Backend-specific content is used in the SAP Business Suite backend system.
If multiple SAP Business Suite systems are used Gateway would have to be configured multiple times.
Note – Embedded hub deployment is not recommended by SAP especially for a customer with multiple backend. This scenario is used for sandbox purposes only.
Question How do you identify a Workflow template in SAP Fiori?
Answer Workflow templates are prefixed with “WS”.
Question To diagnose workflow errors, which transaction do you use?
Answer SWI2_DIAG → to diagnose workflow errors.
Question What is the use of defining workflow scenarios in Workflow engine?
Answer Workflow scenario aggregates one or more workflow tasks in workflow engine and is represented by a single entry in the consumer application. The service /IWPGW/TASKPROOCESSING is provided in the standard.
Question Which service is used by SAP Fiori Launchpad designer to read and assign transport request?
Answer /UI2/TRANSPORT- Used by SAP Fiori Launchpad designer to read and assign transport request.
Question How data flow happens in SAP Fiori Launchpad? Explain the steps.
Answer Sequence of steps −
Launchpad Designer – Add a catalog, add a group
Target mapping – semantic object, action
Static/Dynamic Launcher
PFCG – Catalog, group
Question To expose our Gateway service to outside world, where do an entry must be created?
Answer In order to expose our Gateway service to outside world, we must create an entry in the Service Catalogue on which ever server is acting as the Gateway hub.
Question What are the different RFC authorization objects in SAP Fiori?
Answer Authorization Object S_RFCACL
Authorization check for RFC users, particularly for trusted systems
Defined Fields
This authorization object contains the following fields −
RFC_SYSID − ID of the calling system or the domain of the satellite system.
RFC_CLIENT − Client of the calling system.
RFC_USER − ID of the calling user.
RFC_EQUSER − Flag that indicates whether the user can be called by a user with the same ID (Y = Yes, N = No)
RFC_TCODE − Calling transaction code.
RFC_INFO − Additional information from the calling system (currently inactive).
ACTVT − Activity
Question Why do we need a system alias If GW_CORE and IW_BEP components are installed on the same ABAP system?
Answer You need to know the system alias of the ABAP system in which you developed and configured the Gateway Service. There are two possibilities here −
If the GW_CORE and IW_BEP components are installed on the same ABAP system, then the system alias will probably be “LOCAL”.
If they are installed on different systems, then although system aliases can be any name you like, they generally follow the naming convention of <SID>_<Client> So the system alias for connecting to client 200 of system C11 would generally be C11_200.
However this is only a convention, not a rule.
Question What is Launchpad designer tool? Why do we need it?
Answer We can use SAP Fiori Launchpad designer for configuring and creating groups and catalogs which can then be accessed from SAP Fiori Lauchpad which is a single entry point to all apps. We can search recently launched apps via search capability of Launchpad. Tiles which are available on Fiori Launchpad home page are configured using Launchpad Designer Tool.
Question What are the configuration tasks that need to be performed on Front End server as per different app types?
Answer We need to perform certain configuration tasks on front end server which are specific to app type. We need to Activate OData Services for transactional apps and Factsheets but not for Analytical apps. For analytical apps we need to configure access to SAP HANA data.
Question What are the different app launched tile types in SAP Fiori?
Answer Static − It shows predefined static content (text, icon).
Dynamic − It shows numbers that can be read dynamically.
News Tile − Flips through news messages according to the configuration of the tile.
KPI Tile − It displays KPI’s in real time.
Question What are the different OData services that are required for SAP Fiori Launchpad?
Answer OData services have to be enabled in SAP Net Weaver gateway to establish mapping between technical OData name and the corresponding back-end service. In order to setup SAP Fiori Launchpad and Launchpad designer, we have to activate 5 specific OData Services.
Question What are the different options in SAP Fiori Launchpad design?
Answer Configuration Layer − Contains all content as delivered to customers including translation.
Customization Layer − Customers adjust content for all users in the system. We can use CUST layer for testing or other reasons. Content is transportable through customizing requests by customers. After customization, content is decoupled from configuration layer and no automatic synchronization after changes to delivered layer.
Question What is the use of PFCG role SAP_UI2_USER_700?
Answer The Launchpad user must have the PFCG role SAP_UI2_USER_700 assigned. With this role the user can run the SAP Fiori Launchpad on the Personalization level and has authorization to execute the following OData services −
Question The add-on components in back end that require no down time for installation are known as?
Answer Product specific UI Add-Ons
ERP − UI for EHP 7 for SAP ERP 6.0
SRM − UI for EHP3 for SAP SRM 7.0
CRM − UI for EHP3 for SAP CRM 7.0
Question What is the use of SAP Solution Manager and Application Lifecycle Management?
Answer SAP Solution Manager is the standard platform for Application Lifecycle Management (ALM), and plays a decisive role within the ALM tools. Besides providing SAP functionality itself, SAP Solution Manager integrates the other tools to ensure a comprehensive approach.
Question What is the use of UI Theme Designer? What are the benefits?
Answer Using UI theme designer you can create your own themes to adapt the visual appearance of applications.
One single tool for theming and branding SAP’s key user interfaces −
Apply your corporate branding and look to applications built with SAP UI technologies. The UI theme designer is a browser-based tool for cross-theming scenarios.
The tool is targeted at different user groups, including developers, visual designers, and administrators.
Key Features and Benefits −
Browser-based, graphical WYSIWYG editor −
Change the values of theming parameters and immediately see how it affects the visualization of the selected preview page.
Build-in preview pages −
Select built-in preview pages to see what your custom theme will look like when it is applied to an application −
Application previews (for example, Purchase Order Approval, SAP Fiori Launchpad)
Control previews
Different levels of theming −
Quick theming (basic cross-technology theme settings)
Expert theming (technology-specific theme settings)
Manual LESS or CSS editing
Color palette for reuse −
Specify a set of parameters with the main color values defining your corporate branding.
Cross-technology theming −
Create one consistent theme that applies to various SAP UI clients and technologies −
SAPUI5 standard libraries (including SAP Fiori applications and SAP Fiori launchpad)
Unified Rendering technologies (such as Web Dynpro ABAP and Floorplan Manager)
SAP NetWeaver Business Client
Multiplatform and Multi UI technology support.
Low Total Cost of Ownership.
Question For write access to the UI Theme Designer (create, update, delete themes), which authorization object should be assigned?
Answer Authorization object: /UI5/THEME
ACTVT(Activity):02(Change) and
/UI5/THMID (Theme Id):* = all themes
Question To be able to use the UI Theme Designer, which Internet Communication Framework ICF nodes should be activated?
Answer To be able to use the UI Theme Designer, Activate the following Internet Communication Framework (ICF) service nodes −
To be able to use SAP UI5 and NWBC preview pages, following ICF services must be activated −
Question How can you download newly created themes that are published?
Answer You can use transaction /UI5/THEME_TOOL to download newly created theme and you will find css in one of those folders.
You can also transport themes from one system to another (Eg: from Test to Production system) using the tool for Customer Themes Maintenance.
Start the tool using transaction: /UI5/THEME_TOOL
Navigate to the theme you want to transport.
Select Transport and choose.
Question How do you extend an OData service (Gateway Content Layer) in SAP Gateway?
Answer Transaction code SE11 is ABAP dictionary. By using this transaction code, you can create, change and display table entries and structures. At the initial screen, you can put any tables or structures to view, edit or even create a new one. Transaction code SE11 is normally used a ABAP programmer.
SAP Gateway Service Builder (transaction SEGW)) is a design-time environment, which provides developers an easy-to-use set of tools for creating services. The Code-based OData Channel consumes it and supports developers throughout the development life cycle of a service.
SE80 – Object Navigator
SE 80 is a tool to develop and navigate programs and dd-obj.
SE80 Object Navigator → means all the objects will be available there. In se80 in addition to viewing the objects related to programming and classes, there are more privileges to view such as some other repositories such as mime, object repository, object browser and all.
Question Which components has to redefine while extending Gateway layer of SAP Fiori Application?
Answer IW_BEP on Business Suite
IW_FND on Gateway Layer
Question What is the use of component.js file in UI extensibility?
Answer The configuration is stored in the component.js file of the custom application. The component of the custom application needs to inherit from the main component of the original application. To make the location of the original application or component known to SAPUI5, it may be necessary to use register Module Path. The configuration in the customizing section contains the extension metadata and describes the objects that are replaced or extended.
Question What is a fragment and views in SAP UI5?
Answer Fragments are pieces of a UI without their own controller. The name of each view of fragment is important. A fragment must be named as <NAME>.fragment.xml and a view <NAME>.view.xml
SAPUI5 Views − Views are nothing but the application pages. We define our user interface by creating Views. Views is formed or created by using one or more Controls in it say Page,SimpleForm,Dialog,Label,Input etc. Every view has its own controller.
SAPUI5 Fragments − Fragments are the pieces of UI just like SAPUI5 Views. Whenever we need to use some similar UI parts many times in our application/views we create Fragments of those UI parts because Fragments are reusable and are light weight compared to VIews and Controls. Fragments are stored with in the application itself and can be used by that application only. Fragments are defined as View only and calling Views controller is shared with Fragment as Fragments are not having their own controllers.
Question If Customization doesn’t run properly, is it possible to disable all customization by providing a configuration?
Answer If a Customization doesn’t run properly, all customization can be disabled by providing a single configuration. In support situation, this can be done by setting a breakpoint early in sap-ui-core.js and then executing the following code in the Console −
-window[“sap-ui-config”]= window[“sap-ui-config”]||{};
-window[“sap-ui-config”][“xx-disableCustomizing”] = true;
For security reason this setting is not possible using a URL parameter.
To dump the complete extensibility data, use the following command in the browser Console −
As a result, an object is returned in the Console which contains the customizing configuration, structured by type of customization and view name.
Question To integrate factsheets with geographical maps, connection is set up between the ABAP back-end server and the map provider. What is communication channel?
Answer For fact sheets with integrated geographical maps, geographical coordinates and address data are transferred from the ABAP back-end server to the map provider using HTTP or HTTPS.
To ensure confidentiality and integrity of data, we strongly recommend protecting HTTP connections by using Transport Layer Security (TLS) or Secure Sockets Layer (SSL).
Question What is SAP HANA XS engine? How it is used for Business suite and KPI?
Answer For Analytical apps you need SAP Hana as underlying database, no exceptions. SAP Fiori leverages.
XS engine by using virtual data models. Within XS engine there are 2 components: the HANA Live App content for respective business suite and Smart business component with the KPI modeler. Within the HANA live content the VDM reuse content exists which can be modified.
In below Pic, you have ABAP front end server which contains the UI Add-Ons for respective products used, NetWeaver Gateway with OData enablement, the central UI add-on and the KPI framework. These front end components have read access to the backend data via a trusted RFC connection.
Question What is VDM in HANA Live? What are the different types of views in VDM?
Answer A virtual data model (VDM) is a structured representation of HANA database views used in SAP HANA Live for SAP Business Suite and follows consistent modeling rules.
It provides direct access to SAP business data using standard SQL or OData requests. Business data is exposed through well-defined database views, operating directly on the tables of the SAP Business Suite systems and transforming them into consistent and easily understandable views.
VDMs allow you to access data in one component and use it in another without having to persist the data a second time.
A Virtual data model consists of the following types of views −
Query views are designed for direct consumption by an analytical application (based on HTML5, for instance) or a generic analytical tool (for example, BusinessObjects tools). They are always the top view in a hierarchy of views and are not designed for reuse in other views. However, the virtual data model also includes query views to support (showcase) applications based on the virtual data model.The interface of the query views is kept stable. The name of a query view ends with Query and provides output fields in a format consumable by UIs.
Reuse views are the hearts of the virtual data model. They expose the business data in a well-structured, consistent and comprehensible way, covering all relevant business data in SAP Business Suite systems. They are designed for reuse by other views and must not be consumed directly by analytical tools.
Private views encapsulate certain SQL transformations on one or several database tables or even other views. They are not classified as reuse views, as they might not carry clear business semantics, but are rather intended to be reused in other views. They are comparable to subroutines or (private) methods in programming languages. A private view may be based on database tables, other private views, or on reuse views.
Value help views (VHVs) provide the value list for a specific business entity that is used in a value help in a query view. Relevant business entities are specified by an identifier or code. A maximum of one VHV is defined for each business entity per package. A VHV is included either in an underlying package to the business query views that make use of it, or in the same package. In SAP HANA, for each main package a specific VHV exists for a specific business entity.
Question Which routing rules has to be defined in SAP HANA studio to configure Web Dispatcher to use HTTPS request?
Answer Three routing rules need to be defined in SAP NWG system −
Two routing rules need to be defined in the HANA studio −
Question In SAP NetWeaver 7.31 ep1, which roles should be assigned to Fiori Launchpad administrator?
Answer The Launchpad administrator must have the PFCG role SAP_UI2_ADMIN assigned.
SAP_UI2_ADMIN is a composite role containing the following release-dependent roles −
SAP_UI2_ADMIN_700 for SAP NetWeaver 7.0
SAP_UI2_ADMIN_702 for SAP NetWeaver 7.0 enhancement package 2
SAP_UI2_ADMIN_731 for SAP NetWeaver 7.0 enhancement package 3 and SAP NetWeaver 7.3 enhancement package 1—- Register for free demo

SAP UI5 Interview Question and Answers

Q. What is SAPUI5?
Just like any other HTML5 client-side rendering library SAPUI5 is also one. SAPUI5 strictly follows RIA (Rich Internet Application) standards. It is based on JavaScript which provides a lightweight programming model for desktop as well as mobile applications.

Q. Why SAPUI5?
As HTML5 world is the new age front technology across all aspect of internet applications SAP was kind of trailing in this age because SAP was using age old WebDynpro for building SAP Web Applications which lacks in rich and user friendly UI. SAP identified this and came up with its own custom HTML5 library i.e. SAPUI5.

Q. Explain Navigation concept in SAPUI5.
SAPUI5 uses two mechanism for navigation in applications those are EventBus and Routing where latter supersedes since SAPUI5 1.16. sap.ui.core.routing is the class used for the routing.
We define routing in components metadata in “routing” key.

Q. What is Component?
Component or Component.js is the first point of our application or we can say bthat it serves as index which encapsulates all our applications details i.e. view names, routing details, main view, applications type(Full Screen or SplitApp), application service configuration etc..

Q. When and How to use formatter in SAPUI5?
We need to use formatter when we need to perform some changes on the back end property data on the front end.
we can use formatter while data  binding to a property like as follows:
oControl = new sap.ui.commons.TextField({
value : {path : “/path”, formatter : function(oEvent){
return “Value:”+oEvent;

Q. What all design patterns are recommended/available in SAPUI5?
SAP recommends following application design patterns keeping in mind design consistency of the applications:
1. Master – Detail
2. Master-Master-Detail
3. Full Screen
4. Full Screen-Full Screen-MasterDetail (Multi Flow)

Q. What all types of data models available in SAPUI5?
As SAPUI5 follows MVC(Model-View-Controller) there model plays crucial role in the framwork. SAPUI5 has following predefined four data models available:
JSON Model – Client-side model, supports two way binding.
XML Model – Client-side model and intended for small data sets this is very rarely used model.
Resource Model – This is also client side model used to maintain resource bundles, specially texts.
ODATA Model – This is most important model of the four provided. This is server side model, supports two way binding ODATA model currently supports ODATA version 2.0.

Q. What all types of views are available in SAPUI5?
There are following predefined three types of view available in SAPUI5:
1. JSON view
2. JavaScript View(JS View)
3. HTML View

Q. What are the Lifecycle methods of SAPUI5 views controller?
There 4 four Lifecycle methods available in every SAPUI5 views controller. These are onInit(), onExit(), onAfterRendering(), onBeforeRendering(). onInit is called when a view is instantiated and its controls (if available) have already been created; onExit is called when the view is destroyed; used to free resources and finalize activities; onAfterRendering when the view has been rendered and, therefore, its HTML is part of the document; onBeforeRendering is called before the controller view is re-rendered and not before the first rendering.

Q. What is the main difference between OData Model and JSON Model?
The JSON model is a client-side model and, therefore, intended for small datasets, which are completely available on the client.The OData model is a server-side model: the dataset is only available on the server and the client only knows the currently visible rows and fields.

Q. What are SAPUI5 Fragments?
Fragments are very light weight UI controls and part of another UI. Fragments are not completely like views but they act like a view. Fragments are defined similar like views and are names like “myFragment.fragment.xml“.

Q. Does Fragment have its own controller?
Fragments are created without controllers, they don’t have their own controllers they share controller of the view which is invoking it.

Q. In how many ways you can bind data to your controls?
We can bind data to any controls using three methods, Property, Element and Aggregation binding.

Q. What is SAPUI5 Bootstrapping?
SAPUI5 Bootstrapping means loading and initializing SAPUI5 in any HTML page. The most important library or resource loaded in SAPUI5 bootstrap is “sap-ui-core.js”. Apart from this theme for the application, SAPUI5 libraries etc are declared in the bootstrapping.

Q17. How do you create/assign dynamic unique ID’s to controls?
A.There is way we can use dynamic unique ID’s to control. Using this.createId(“prefixIDString”) we can create a unique ID which will have given prefix.
For example suppose we have assigned Id to a button using this.createId(“myButton”), in this scenario out button will have string “myButton” in its ID declaration and it will throw duplicate ID error.

Q18. What is Semantic Page?
A. Semantic Page is sort of more enhanced and advanced version of As name suggests semantic page follows certains rules in terms of control placements on the page. For example if you add a positive actions to a semantic page it will always be positioned on the right side of the page.

Q19. How do you apply your own custom CSS to a control?
A. We can add/apply our own CSS to any control using addStyleClass(‘classname’) method of the control. For this we need to create a css class on our style.css file and apply it using below code:

Q20. What is shell?
A. control is sort of parent control to our entire SAPUI5 application. It can contain an, sap.m.splitapp or even a component container. It will provide a frame around the application.

Q22. How do you get the current language in SAPUI5?
A. sap.ui.core.Configuration api has a method using which we can get to know the current language. We can use below code to detect the current language
var sCurrentLanguage = sap.ui.getCore().getConfiguration().getLanguage();

Ques 4. What is MVC?
Ans.- MVC stands for model view controller; it’s an architecture to design UI based applications to achieve maximum reusability and extensibility of the application for future changes. Model is the representation of data in form of object, View defines the UI and Controller contains all the logic to drive as well connects view with model.

Ques 5. What is required to start UI5 development in eclipse?
Ans.- We need to import SAP UI5 toolkit from HANA service marketplace. Also, we need SAP UI5 ABAP Repository connector to deploy the project in ABAP System.

Ques 6. Which control libraries are used for UI5 application development?
Ans.- sap.ui.commons, sap.ui.table and sap.suite.ui libraries for desktop application development and sap.m library along with sap.ui.layout for Fiori application development.

Ques 7. What is the syntax to define a control in UI5?
Ans.- var obj_name = new sap.m.ControlName(“id of control”,{ properties, events, aggregations });

Ques 9. What is Responsive Web Design?
Ans.- A web application which gives the same look and feel to the user in desktops and mobile devices.

Ques 11. What are the types of Components?
There are two types of components:
Faceless components: Mainly without UIs, Used for business logic and helper methods e.g. Formatters.
UI Component: typically component.js file which is made by extending sap.ui.core.UIComponent class.
We can use formatter while data binding to a property like as follows:
oControl = new sap.ui.commons.TextField({
value : {path : “/path”, formatter : function(oEvent){
return “Value:”+oEvent;
3. Resource Model – This is also client side model used to maintain resource bundles, specially texts.
4. ODATA Model – This is most important model of the four provided. This is server side model, supports two way binding ODATA model currently supports ODATA version 2.0.

Ques 16. Can we add our own controls to UI5?
Ans.- Yes, we can add custom controls by creating definition of it from scratch. To define a custom control we use sap.ui.control.extend and to enhance a standard SAP UI5 control we use sap.ui.commons.controlname.extend.

Ques 24. What is SAP Fiori?
Ans.- SAPUI5 is client side HTML5 rendering framework or library and SAP FIORI is collection of and released as waves of applications which are completely based on SAPUI5 framework. It means we can create applications using SAPUI5 framework and SAP FIORI is final product i.e. application.

Ques 25. What are all the types of Fiori Apps?
Ans.- There are 3 types of apps Transactional, Analytical, Fact Sheets.

Ques 26. Difference between SAP UI5 and SAP FIORI?
Ans.- SAP FIORI is collection of standard applications based on SAPUI5 library provided by SAP. SAP FIORI applications share some standard design guidelines and way in which these application are developed.

Ques 27. What is FIORI Launchpad and Explain it?
Ans.- As we know there are more than 500 FIORI applications, SAP has provided a Shell or single point place from where we can access the all the applications. This serves as a home page for all the FIORI applications provided to. This shows tile based UI where every UI redirects to assigned FIORI application. This Launchpad is fully customizable according to your needs like theming and all.

Ques 28. How to know that device is Touch Screen or not?
Ans.- SAPUI5 library provides a special API “sap.ui.Device“ which can be used to for device and its feature detection. This API has a flag “sap.ui.Device.touch” which returns true if device is a touch screen otherwise false.

Ques 29. How to know the web browser of the client on which SAP Fiori application is running using SAP UI5?
Ans.- SAP UI5 library provides a special API “sap.ui.Device“ which can be used to for device and its feature detection. This API provides flags like “chrome”, “firefox”, “mozilla”, “edge” etc. in “sap.ui.Device.browser” API which returns boolean values.

Ques 30. What are Fiori Design Principles?
Ans.-There are 5 design principles we need to keep in mind while designing SAP Fiori applications. Role-Based, Delightful, Simple, Responsive and Coherent.

Register today to complete certification