Author - admin

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

SAP BI Online Training India | Course Objectives

Course Objectives;

  • Describe the architecture of SAP NetWeaver and BI/BW 7.3 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
BizX Platform - Success Factors Online Training

SAP Success Factors Online Course | SAP SF Online Training

Using SAP SF ( Success Factors)

  1. Increase growth, lower operating costs and expand profit margins.
  2. Align workforce with strategy and get people working on the right tasks.
  3. Optimize performance across organization find the right people and make the great.
  4. Accelerate business results with the insight need to run your business better.
  5. Improve Strategic Alignment: When you close the gap between strategy and execution, you can see a 5.5 Percent increase in time spent on strategic priorities.
  6. Increase efficiency and Productivity: An optimised workforce can lead to a 14% increase in project completion, a more than 5% increase in productivity and 4.9 % increase in high performers – numbers that go straight to organization bottom line.
  7. Accelerate business results: Want better business results? On average SAP SF added 1 Percent of revenue book to profit.

Cloud – in SAP Success Factors 

  1. No Need to buy or maintain expensive hardware
  2. Lower, predictable monthly cost
  3. Faster time to value
  4. SF Will deliver continual innovations with four releases a year and automatic upgrades. It’s more flexible, scalable and secure and it’s faster than traditional software.
  5. Platform; Success Factors contains a core set of functionality that is common across the entire software suite, whether you deploy the full suite or just one part of it.
  6. Mobile: With smartphones and tablet computers you can take advantage of the power of success factors, anytime, anywhere.

What is On Premise;

  1. On-Premise ERP Solutions are installed locally on your company’s hardware and servers.
  2. Managed by in- house IT Staff.
  3. Cost – Require large upfront and ongoing investments to purchase and manage the software and the related hardware, servers and facilities necessary to run it.
  4. System upgrades and Enhancements- by IT Staff.


  1. CLOUD ERP (or SaS, Software – as – a Service) is provided as a service and hosted on a secure server online.
  2. No need of internal IT Support
  3. Cost – typically much lower because you simple implement the software to your requirements and access it through your computer’s using internet connection.
  4. System Upgrades and Enhancements from SAP – AUTOMATICALLY.

Improved system performance and accessibility Deployment speed.



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


SAS BI Certification Online Training from India

What is SAS BI:

SAS BI – called Business Intelligence is a bundle of applications that helps in allowing and displaying data for the enterprises. An overview of what can be learned in SAS BI

  • Prepare Data
  • Display Data
  • Helpers
  • Administration

Prepare Data – Preparation of data to view it in Bi tool. This is usually done because raw data exists in relational databases like oracle, mysql etc. Then it is placed in OLAP cubes or information maps to view it.

  • SAS OLAP cubes – This helps in summarization of huge data to make it easy for viewing and drilling down information.
  • SAS information Map Studios – The original purpose of these information maps is to join data, rename variable and make it into a business friendly data.

Display Data – Once the data is prepared, there are many tools to display it, such as:

  • SAS Web report studio – Creates reports from OLAP cubes, Info maps, SAS datasets.
  • SAS Add-In for Microsoft Office
  • SAS BI Dashboard
  • SAS information delivery portal

Helpers –  It involves the following:

  • SAS Enterprise guide
  • SAS prompt framework
  • SAS stored Processes

Administration – Thiswill basically allow users to administrate system and control data access. Understand more about this here by signing up for a free demo.

Data Integration Studio in SAS :

SAS Data Integration Studio (SAS DI) is a GUI (Graphical User Interface) for generating and managing SAS codes. SAS Data Integration Studio (SAS DI) is used in building, implementing and managing data integration process as it is a most powerful tool with user friendly visual design, irrespective of the data sources. This also automates and supports integration and running of large enterprise projects in spite of the repeatable processes. Also the changes made across data integration process will change the impact analysis after creation and management of data and meta data. SAS Data integration also helps users to fine tune data integration by editing and changing, this also helps users to capture and manage standardized metadata from any source and also to understand enterprise metadata and data integration process for easy display and visualization. One most advantageous feature with SAS DI is that it enables programmers to write and blend tailor made code into the process for reusable purposes as well.

Following are different versions of SAS DI:

SAS DI studio was earlier called as SAS ETL studio. Being SAS 9.4 the recent version with compatibility to Versions 4.7 & 4.9, there are versions from 3.3 that compatible with SAS 9.1.

Learn more about SAS DI here.