SAP HANA Administration – Overview

(Read This Article on skillstek.com)


If you are keen enough to learn about SAP or SAP HANA and further its important modules, you surely would have understood by this time, what is sap HANA actually.

What is SAP HANA?

SAP HANA is an in-memory database, which works on the cloud platform, introduced for high-end application development and real-time data analysis.

What is SAP HANA Administration?

In general, the administration means to manage the overall working system and environment of the concerned assignment or application.

In a similar way, SAP HANA Administration manages the overall SAP HANA System in a single and distributed system environment.

The responsibilities of SAP HANA Administration:

• Upkeep and maintenance of SAP HANA System
• Optimizing performance of the application and all servers
• Management tasks of each server
• Ensuring security under the SAP HANA system installed
• Ensuring smooth functioning and continuity of the business and processes
• Timely diagnosis of any issue or problem and resolving it in a systemic and timely manner
• SAP HANA Lifecycle Management

SAP HANA Architecture

SAP HANA Architecture

SAP HANA Application Servers

SAP HANA system consists of all servers of SAP HANA application installed in an organization. There are multiple servers in HANA. The most important one is called as Index server.

Index Server

Index server is responsible for processing SQL/MDX statement using engines in the Index server. It contains the actual data stores. It also contains Session and Transaction Manager to keep track of completed and running transactions.

Name Server

Name server maintains the topology of the SAP HANA system. It manages all the running components and data stored in each component. In a distributed system with instances of the SAP HANA database on multiple hosts, the name server knows where the components are running and which data is located on which server.

Compile server

As the name suggests, this server is used to compile stored procedures and programs. SQL procedures are one of the main of them. It runs on every host and does not keep any data.

Preprocessor

The preprocessor is used to analyze the text data. It extracts the information and performs search capabilities. These are used by index servers

Web Dispatcher
Web Dispatcher processes HTTP or HTTPS requests for HANA XS engine. It consists of one or more NetWeaver application servers. It ensures the security into servers by accepting or denying the connections coming in and by evenly distributing incoming requests to across all servers.

Property Layers in SAP HANA Administration

Property Layers in SAP HANA

Multitenant Database Containers

Since SAP HANA supports multiple isolated databases in a single SAP HANA system, we can install the SAP HANA system in multiple container modes. This is known as Multitenant database containers.

All the databases in a multiple-container system share the same installation of database system software and each database runs on the same infrastructure and uses the same computing resources.

Each database consists of the following components −

• Database Users
• Repository
• Database Catalog
• Backups
• Traces and Logs
• Persistence

Concept of Product Cost Planning in SAP Product Costing

(View This Article on skillstek.com)

What is Product Cost Planning in SAP Controlling

Product Cost Planning is an area within SAP Product Cost Controlling, where the companies can plan cost for materials without referring to Production Orders, and other cost controlling objects.

We can use Product Cost Planning to distribute the costs of the company’s products, such as

Manufactured materials
Services
Other intangible goods

Product cost planning helps us to analyze the cost of material and resolving various queries such as:

• In the production process, what is value addition at a particular point?
• What proportion of that added value can be attributed to a particular unit of the organization?
• To know the Cost of Material, cost of production and overhead costs in the production process.
• What measures can be taken to improve the overall efficiency of the production?
• Is it possible to sell the product at a competitive and profitable price in the market?

I hope, now you would be able to understand what is actually the product cost planning and what is its importance in the SAP ERP application of an organization. Now let us know the main components of this area of SAP Product Costing.

Components of Product Cost Planning

Material Cost Estimate with Quantity Structure

Here, we can calculate the Cost of Materials on the basis of a quantity structure in Production planning. In this component, we integrate Controlling with Production Planning (PP) module.

Material Cost Estimate without Quantity Structure

In this component, we can calculate the Cost of Materials is calculated without a quantity structure in Production Planning.

Price Update

In this component, we can transfer the results of material cost estimates to the Material Master.

In any organizational structure, each company code needs to be assigned to the controlling area. Materials are evaluated at Valuation area level (normally it is Plant) therefore we need to define the plant as the valuation level.

Organizational Hierarchy in SAP Product Cost Controlling

Please note that for Product Cost Planning, we need to create master data such as BOM, Routings and work Centres in other modules of SAP like Production Planning (PP Module).

We also need to create Master data such as cost centers, activity types and business process in Overhead cost controlling module.

Types of Cost of Production calculation under standard costing

Automatic Costing

The quantity structure (BOM & Routing) for the material is automatically determined and calculated from the PP module.

Unit Costing

Here the Cost of Production is calculated without accessing BOM & routings from the PP module. (Cost of Production could either be the additive cost estimate with quantity structure or material cost estimate without Quantity structure).

Multilevel Unit Costing

Here also the cost estimate (taken without the Quantity structure) is calculated without accessing BOM and routing in PP module. In this costing method, we will enter the cost components or cost line items manually.

SAP ABAP on HANA and its Key Programming Techniques

(Read This Article on skillstek.com)

Introduction to SAP ABAP on HANA

Since SAP has introduced ABAP on HANA, it is required for all ABAP developers to start implementing new coding techniques and transitioning ABAP codes on new HANA platform.

SAP ABAP is not new. It has evolved over years. However, after the introduction of HANA, this programming application has taken a leap ahead in terms of modernization, functionality, user experience and productivity.

Traditional SAP ABAP vs SAP ABAP on HANA

The traditional approach of SAP ABAP used to follow the traditional process of bringing data from the database to the presentation server, doing the bring calculations & filtering and then presenting the filtered data to the user.

While, in HANA, filtering is done inside the database, as the codes do the calculation at the database layer itself. They bring out only those records to the presentation server which are relevant.

Key programming techniques of SAP ABAP on HANA

Open SQL Programming

Open SQL is the first abstraction layer in the ABAP platform. It defines the syntax and semantics used for accessing all relational database systems supported by SAP. Thus, allowing ABAP developers to work in a database-agnostic manner – unless making explicitly use of DB-specific features. With Open SQL programming, you can write open SQL syntax in your ABAP code. 

Core Data Services Views

CDS represents SAP’s next generation of data definition and access for database-centric applications. Technically, CDS uses and extends SQL to capture the business intent.

With CDS, data models are defined and utilized at the database server rather than on the application server. Hence the table result view is created at the database level.

Another good feature is the compatibility of CDS with Open SQL. Developers can write CDS using Eclipse Oxizen and some other ABAP development tools easily .

ABAP Management Database Procedures (AMDP)

AMDP is directly written in ABAP using AMDP classes and is run on the database directly.

It provides a class-based framework for creating and calling SAP HANA database procedures and functions from the ABAP environment – i.e. AMDP procedures and AMDP functions. ABAP platform is the sole master regarding the lifecycle management (creation, update, deletion, and transport) of such SAP HANA entities.

What’s New in SAP S/4HANA Logistics

(Read This Article on skillstek.com)

A brief on SAP HANA

SAP was earlier dependent on other vendors like Oracle, Microsoft, for its database management, which usually led to many associated drawbacks as well. Thus, there was a requirement of an in-house database management system, for which SAP developed and launched HANA which is an in-memory database works on the cloud platform.

There are many superior features of SAP HANA which made it highly popular and demanding such as an automatic mechanism for failover, high performance, great user experience and more.

In near time, many organizations have migrated to SAP HANA which were earlier running on ECC platform. Since SAP has announced that to work on S/4, one surely needs HANA as its database. Thus, SAP S/4HANA is gaining popularity rapidly.

Key Features of SAP S/4HANA Logistics

Master Data

For better performance and large scale processing, HANA is the best platform, with which Master Data is directly associated.

Customer Master

Many transactional codes which were in working order previously have been redundant now such as XK01, XK02, XD03 and MK01, MK02 and MK03, XD01, XD02, XD03 or VD01, VD02, VD03 and more. The idea is to utilize the business partner approach. Hence, an organization migrating to S/4 platform needs to ensure that it is properly analyzed and that SAP S/4HANA conversion process is carried out in their entirety.

Material Master

One of the major change in HANA is the length of characters in Material Master Field. In ECC, the material master field had 18 characters, while in HANA it has been increased to 40 characters now. Another change is in the foreign trade fields in Mater Data, which are unattainable now.

Business Suite Modules

The most promising feature in SAP S/4HANA Logistics is that it combines SAP Supplier Relationship Management, Customer Relationship Management as well as Supply Chain Management into one business suite.

SAP S/4HANA enterprise management is also available on premise as well as in the Cloud with nearly equal efficiency. The SAP S/4HANA solution can be a Cloud solution or can also be implemented as an on-premise system such as SAP ERP.

S/4HANA enterprise management functionality is such that if an organization wants to migrate S/4HANA it will have to abandon the pre-existing business suite in order to gain upgraded performance. But this does not have to be the case and migration can be a gradual process, continuing certain elements of legacy systems.

Conclusion

SAP S/4HANA Logistics (previously called Simple Logistics) is also called SAP S/4HANA Enterprise Management. This module is a complete package of some very useful SAP modules in terms of stock and material data. These are Material Management, Supply Chain, Sourcing and Procurement, Demand Planning, Contract Management, and Manufacturing.

We can conclude that SAP S/4HANA Logistics is a complete package for dealing all stock and sales related processes.

Therefore, those manufacturing organizations which have still not opted for SAP as its ERP application system must do it today as SAP’s products are just excellent. Those which are still running on ECC, need to migrate to HANA platform so as to get full benefits of SAP application and bring better user experience and flexibility to their business.

SAP Lumira – Data Visualization Software

(Read This Article on skillstek.com)

SAP Lumira Introduction

SAP Lumira is an analytic and data visualization software which meets the self-service needs of business users for data visualization and analysis. It also enables power users to develop a more sophisticated analytic application. It allows business to combine data resources and formulate holistic insights.

SAP Lumira is capable to provide real-time analysis with improved efficiency, better risk assessment and exploring new business opportunities.

SAP Lumira Features

The SAP Lumira has been designed in such a way so as to inculcate good collaboration between power users and business users to boost content delivery.

It happens in this way. Business users can work on the self-service mode by working in easy to use discovery edition or they can even transfer their requests to power users who can use designer edition to write scripts and actions.

With SAP Lumira best visualization features, power users can turn predictions and visualizations into analytic applications.

One of the unique features of SAP Lumira is that it can work both ways i.e. in conjunction with SAP HANA which is an in-memory platform or even without it.

SAP Lumira runs on the SAP BusinessObjects BI platform that provides analyzed information to business users with which they can take reliable decision really quick.

The requirement of SAP Business Intelligence

Data is the most useful thing to understand customer requirements. Successful businesses work hard on data analysis and processing to take the right decisions.

Analyzing customer information reveals market patterns and trends that help optimize business operations, creating the competitive advantage that drives revenue and propels marketing campaigns

Business Intelligence tools can provide historical, current and future insight of business operations, helping business users gain insights into business and thus, make better decisions.

Business intelligence tools combine business database extracted from applications and software, into one platform for the purpose of visualization. BI platforms like SAP Lumira are designed to be implemented across all business industries, making it a highly sought after BI platform.

What Makes SAP Lumira the Smartest BI System?

Since SAP Lumira has the capabilities to deliver real-time analysis that improves efficiency, assesses risk, and identifies new business opportunities.

Lumira tools are well advanced and intelligent. As mentioned above, they can combine self-service Business Intelligence discovery and data visualization with interactive analytical applications, cutting-edge charts, storyboards, and dashboards which actually generate holistic insight across an entire organization.

From SAP BW to SAP BW/4HANA

(View This Article on skillstek.com)

SAP BW- Business Warehouse

SAP BW, before coming under HANA platform was having many pitfalls. One of the major ones is that it has multiple layers of redundant data and transforming data which slow done the data processing work. It took much time for data to reach the final destination of the reporting layer from source as it has to pass from multiple layers. Of-course the job would be completed but not fast.

SAP BW to SAP BW/4HANA – Major difference and Updates

After having many downsides of SAP BW, SAP launched HANA. It is a revolutionary database works on the cloud platform. SAP put BW on HANA platform putting off from the traditional database, resulting in redesigning of BW development.

This is called as SAP BW on HANA.  The initial version of SAP BW on HANA 7.3 was mainly focused on reducing the layers and speeding up the load time. Though these improvements helped a lot, there were still many issues which were required to deal with. Later version 7.4 tried to reduce complexities by reducing the number of development objects. The data model too started to be moved from traditional GUI to HANA studio environment.

Then came version 7.5 which stands out to be the most updated version till this point. SAP BW on HANA 7.5 has stronger and more efficient architecture and provides the base for the development of SAP BW/4HANA. SAP BW/4HANA looks almost similar to SAP BW on HANA however Sap BW/4HANA stands out to be more efficient than SAP BW on HANA.

Difference between SAP BW on HANA 7.5 and SAP BW/4HANA

The primary difference between BW on HANA and BW/4HANA is that BW/4HANA no longer supports those old objects like InfoCubes and DSOs. If a customer wishes to move to BW/4HANA, they need to convert all such legacy objects into newer BW/4HANA objects. SAP provides programs that can do this conversion but there will be some pre-migration effort to clean up everything that is no longer supported before moving to BW/4HANA.

Another difference is that SAP VW has been shifted from traditional GUI to HANA studio and now the data modeling is taken place in HANA studio. Though this migration has been started from SAP BW 7.4, it is almost at its completion in SAP BW/4HANA.

One of the downsides of SAP BW/4HANA is that it doesn’t support planning applications due to which customers need to wait for future updates for migration.

BW Perspectives in HANA Studio

SAP HANA Studio consists of different perspectives one of them is BW perspective which allows users to use HANA studio for development instead of SAP GUI. BW Perspectives is the same tool which we use for developing native HANA information view like calculation views.

SAP SuccessFactors – Best HRM Solution

(View This Article on skillstek.com)

Why companies are choosing SAP SuccessFactors

One-liner answer to this question is SAP SuccessFactors is highly user-friendly.

Introduction to SAP SuccessFactors

SuccessFators is a cloud-based Human Resource Management solution. After SAP acquire SuccessFactors, many organizations have look forward to choose it as their HRM solution. Also, those who were already having SAP ERP HCM solutions also got interested to learn the new added features and functionalities brought in by SuccessFactors. Curiosity also aroused over whether and how this new cloud-based technology can be integrated into their current on-premise SAP HCM ERP.

Earlier it was too common when companies need to have extensive customizations of their software or application. Due to extended responsibilities often deadlines got extended.  An organization needs to hire additional staff and build teams to support the solution. They need to carefully maintain the applications or the infrastructures implemented. SAP SuccessFactors is very user-friendly. It is hassle-free and does not require maintenance.

To the best of it, SAP SuccessFactors is so user-friendly that even the end user can perform many functions themselves such as setting passwords. With sufficient training, they can even maintain the solution and related administration of the application.

Pre-Requisite to get full benefits of SuccessFactors

I am sure you would have got carried away seeing the amazing features of this highly advanced software. However, In order to get complete benefits of SAP Succfactors, it is mandatory to attain good knowledge of all its features, functionalities and what modules it offers in its package.

Another import thing required to lean is the integration of SAP SuccessFcators with their on-premise solutions.

What is Business Execution – BizX

Business Execution (BizX) is the SAP HCM suite offered by SuccessFactors. It is a cloud-based, software-as-a-service (SaaS) solution. BizX can be implemented either as a single-tenant or a multi-tenant solution> In other words a company can opt for single user cloud-based functionality, to be the sole user, or can take sharing option where they share it with other companies.

 Modules available in the SuccessFactors BizX suite:

Employee Central – SuccessFactors’ core HR system
Compensation Management – Used in compensation planning and compensation administration
Talent Management  – Used in succession planning and talent management
Recruiting Management – Used in recruiting
Learning – Used as a learning management system
Workforce Planning – Used to understand how organizational changes impact business execution and to identify the right workforce strategies
Workforce Analytics – Provides HR dashboards and analytics
Jam for Social Learning – Used as a social collaboration platform
On-Premise Vs. Cloud
On-Premise

In On-premise, SAP server is maintained at own data center.

Disadvantages of On-Premise

Investment is required on capital expenditure like hardware, network device, server room building etc.

Investment is required on Operating Expenses like maintaining own IT Team, Purchasing SAP license, Maintaining Bandwidth etc.

User can connect to server from Desktop or Laptop through VPN connection only.

Cloud

 All application will run on Public or Private cloud through FIORI apps. Customers will pay the subscription cost only. All applications can be accessed from any device like Laptop, Tablet or Mobile.

However, there is a downside to the cloud. Data is not as secured as in On-premise as the cloud is shared by multiple companies. A solution to this issue is private cloud, which is better than the public cloud as it is maintained with a dedicated Firewall. Please Note that all configuration or Development in cloud platform is handled by SAP only. Customers are only responsible for user roles.

Solution to this is Hybrid System

This is the best available option on the HANA Platform. It is a combination of On-premise & Cloud. Here customers can do their configuration through own development team. However, if required, specific users can have access to the cloud for flexible operation.

Key Features of SAP S/4HANA Finance

(View This Article on skillstek.com)

Before pointing on the key features of SAP S4 HANA Finance, let me first briefly elaborate what is actually SAP S/4HANA Finance and which one is the latest and in-demand version of this application in the present time. So read on further.

What is SAP S/4HANA Finance?

SAP S/4HANA Finance is an updated version of SAP Simple Finance which includes many new features in addition to what was offered in SAP Simple Finance. To name a few are Universal Journal, streamlined design, and real-time analytics.  If asked why SAP launched SAP S/4HANA, then the answer would be that it is mainly done to upgrade transactional, analytics and planning systems enabling them to provide faster and quick insights and mobility on analysis at all levels of financial data. S/4HANA Finance is available as both on-premise and cloud versions.

SAP S/4HANA Finance 1809

The latest one among all SAP S/4HANA versions is SAP S/4HANA Finance 1809, which is based on the most updated cloud technology and carries the best of functionalities of S/4HANA platform in Financial Management.

Now let us know the key Features of SAP S/4HANA Finance.

New GL concept

In New GL client, there is one Leading Ledger for each client which is valid for all company codes. We need to decide and choose which accounting standard should be used for Leading Ledger. The assignment can’t be deactivated once it is defined. Leading Ledger normally follows the same accounting standard which is used to draw up consolidated Financial Statement. Leading ledger is integrated with all subsidiary Ledgers. Non-Leading Ledger is used parallel to Leading Ledger. Just like Leading Ledger, Non-Leading Ledger also must be activated for each company code.

Extension Ledger

Extension Ledger (Appendix Ledger) concept was introduced in SFIN 2.0. It is an extension to another ledger that can be used for adjustment or consolidation purposes for closed periods or entries which companies use in Extension Ledger. It reduces the usage of Non-Leading Ledger, however, it cannot be considered as a replacement of Non-Leading Ledger. Extension Ledger is available in S4HANA only, which helps to save space in the database. We can use it avoid duplication of Journal Entries.

Cost Element included in Ledger Account

Earlier in ECC, to create Primary Cost Element, it was mandatory to create one GL account which can then be extended as Primary Cost Element under controlling Area. Now in S4 HANA Finance, one GL account can be created directly with the required cost element category.

Secondary Cost Element

When there was no direct determination of cost, we had to use the Secondary Cost element for cost allocation. Creation of secondary cost element and posting of transactions always required to be performed within the Controlling Area only. But in S4 HANA Finance, Secondary cost element also is a part of Universal Journal (Finance) and it can be created as General Ledger Master.

Business Partner Concept

Now we can create & manage our Customers & Vendors centrally as our Business Partners and assign their roles. For example, customers can be created as a Business Partner (BP) with different roles like FI, Customer, Credit Management or Collection Management etc. Business Partners can be a person, an Organisation, a group of persons, Group of organizations etc.

Receivable Management (Credit Management, Collection & Dispute Management)
As per the new simplification list, S4 HANA Finance 1610 the traditional credit control area is not applicable for Accounts Receivable. We have to use the FSCM-Credit Management functions for defining the credit score, credit rating under credit Procedure of Credit Management functionalities.

Cash Management

SAP S/4HANA Finance for cash management enables group treasury or the cash department to manage cash and liquidity centrally. It includes Bank Account Management and Cash Management.


A close companion of SAP S/4HANA Finance (Financial Accounting) is SAP Product Costing on HANA (Management Accounting) which if understood and learned with or after SAP S4 HANA Finance makes you a perfect SAP HANA Finance and Controlling consultant enabling you to work on any SAP project having requirement of financial accounting and management accounting applications.

Difference between SAP S/4HANA Finance and SAP Simple Finance

(View This Article on skillstek.com)

Even today, there are many people who are still searching for the term SAP Simple Finance while
having questions and issues on SAP S/4HANA Finance.

One who wants to become SAP S/4HANA Finance consultant needs to learn SAP S/4HANA Finance from an expert SAP HANA Finance trainer having a deep knowledge of its full configuration and implementation process. Having said that, choosing to take SAP S/4HANA Finance 1809 training would be the right decision at this moment. Though SAP S4HANA Finance 1709 is still much popular and in demand, however, 1809 being the latest version, learning this would be the best decision if taken earliest. On the other side SAP Simple Finance is an older term used by SAP before the launch of S/4HANA.

Let us start learning the difference between them by having a basic introduction of the both.

What is SAP S/4HANA Finance?

After successful execution of SAP Simple Finance, SAP introduced S4 HANA Business Suit, which not only includes Finance functions but also the Logistics functions on HANA platform. SAP S4 HANA Finance is one Business application for Finance which includes –SAP Accounting, SAP Treasury & Cash Management, and SAP BPC.

Key Features of SAP S/4HANA Finance

• New GL concept
• Extension Ledger
• Cost Element included in Ledger Account
• Secondary Cost Element
• Business Partner Concept
• Receivable Management (Credit Management, Collection & Dispute Management)
• Cash Management

What is SAP Simple Finance?

SAP Simple Finance is the first Business application developed for financial functions on HANA Platform. We can say, this was the pilot product from SAP on HANA platform for Finance Business solutions. Also, it is known as Add On functions on EHP 7. It includes multiple functions both for Finance & Management Accounting.

SAP Simple Finance Key Features

SAP Simple Finance was designed to remove issues like transactional ( OLTP) and analytical (OLAP) and planning system to provide instant insights and calculation on- the -fly.
SAP introduced Principle of One, which is also called Universal Journal (ACDOCA table which can remove multiple Index, Aggregate, Total Tables related to Finance & Controlling Module.
Finance Risk Management id one of the important feature of SAP Simple Finance
Risk and Compliance Management is another one being called as a key feature of Simple Finance.
The earlier SAP releases like 1503, 1506 support SAP Simple Finance Module.
What is the basic difference between SAP Simple Finance and SAP S/4HANA Finance?
The answer to this question is, SAP simple finance carries some add-on features on EHP 7 whereas SAP S4 HANA is a complete Finance Business solutions.

Why People still use term SAP Simple Finance while they are actually looking for SAP S/4HANA financed only?

SAP Simple Finance was highly marketed by SAP for a while, for which it gained much popularity among its industry and users. Though SAP S/4HANA Finance has already replaced SAP Simple Finance, however, due to its popularity, people still use term SAP Simple Finance.

Different versions of SAP HANA Finance

Since the launch of the HANA technology, there are total six versions launched by SAP till date. The first three versions were observed under Simple Finance while the later three launched under S/4.

SAP Simple Finance 1503
SAP Simple Finance 1506
SAP Simple Finance 1511
SAP S/4HANA Finance 1610
SAP S/4HANA Finance 1709
SAP S/4HANA Finance 1809

Out of these six versions, the latest ones are:

SAP S/4HANA Finance 1709 and
SAP S/4HANA Finance 1809

I am sure, by the end of this article I would have cleared your doubt on the difference between SAP Simple Finance and SAP S/4HANA Finance and why you should use the term SAP S/4HANA Finance instead of SAP Simple Finance or just HANA Finance. To go into more deeper knowledge you can see other related articles in this blog.

SAP BW on HANA Online Training

About SAP BW on HANA Course

Our SAP BW on HANA online training is based on the latest developments and updates. It uses the latest SAP BW 7.5 on HANA. After the training, you would be able to do real-time data integration in SAP BW on HANA and would get expertise in complete BW enterprise Data Warehousing and all its application.
We at Skillstek, provide certification oriented SAP BW on HANA online training which would enable you to prepare for the certification exam and clear it successfully.
The training covers in-depth concepts of SAP BW on HANA and live configuration step by step.
Our trainers are real-time consultants thus provide 100% practical oriented online training on SAP BW on HANA.

Curriculum
Unit 1: Introduction to SAP HANA Studio

• 1. Introduction to SAP HANA
  2. History of SAP HANA
  3. Overview of SAP HANA Studio
  4. SAP HANA Technology Innovations

Unit 2: SAP HANA Architecture

• 1. SAP HANA Architecture
  2. Index Server
  3. Persistence Layer

Unit 3: Data Provision Methods

• 1. Overview of Data Provision Methods
  2. Flat file Uploading
  3. How to get multidimensional Sales Report
  4. Overview of Business Objects Data Services using ETL-based approach

Unit 4: Accounts Payable

• 1. Introduction to SAP HANA Information Models
  2. Analytical View for COPA Plan using Attribute views and COPA Actual
  3. How to use join operators in building Calculation view
  4. Methods to create Calculation view

Unit 5: Overview of SAP BW 7.5 on HANA 1.0

• 1. Overview of SAP BW 7.5 on HANA 1.0
  2. Data Warehousing Workbench

Unit 6: InfoObjects and DataStore Objects

• 1. Overview of InfoObjects
  2. Creating Characteristics under Catalog
  3. InfoObjects Characteristics and Key Figures
  4. Classification of Master Data
  5. Creating Characteristics
  6. Overview of Key Figures and Data Flow
     1. Overview of DataStore Objects
  7. How to load transactional data to DataStore Objects
  8. SAP HANA Optimized DSO
  9. Lookups on Active data DSO

Unit 7: SAP HANA InfoSource and Transformations

• 1. Explaining Transformations Framework and Expert Routines using Scenario based example
  2. Mapping One Source Field to Target Field
  3. Working with Expert Routines
  4. Writing Expert Routines Code in ABAP
  5. Introduction to InfoSource and Execution of two transformations before executing multiple transformations
  6. InfoSource as a uniform source for several targets as targets from different sources
  7. Return Tables using Transformation
  8. Creating Dataflow using GUI Data flow in SAP BW on HANA and BW Oracle

Unit 8: InfoCube

• 1. DTP and its role in loading data to InfoCube in Extraction mode
  2. Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

Unit 9: SLT Configuration, MultiProviders and Extractions

• 1. Steps for performing SLT Configuration
  2. Explaining the three scenarios to implement in SLT
  3. Introduction to MultiProvider and Creating MultiProvider in SAP BW 7.5
  4. How are MultiProviders and InfoSets similar?
  5. Mixed Models
  6. ECC Extractions
  7. Different Extractor types
  8. Steps for Data Extraction method from Non-SAP Source systems
  9. ECC Extractor using Business Content Extractors for Accounts Receivable
  10. Loading data for characteristics, Master data using Business Content Extractors

Unit 10: BW Reporting

• 1. Introduction to BW Reporting - BEx Reporting Suit
  2. Important Business Explorer Designers
  3. BEx Query Navigation Options in WebQuery
  4. Creating KeyFigure at InfoProvider and query level

SAP HANA Administration Online Training

About SAP HANA Administration Course

Our SAP S4HANA Administration Online Training would help you to learn and understand SAP HANA Landscape, information sources and rapid deployment solutions RDS).

We at Skillstek, are associated with real-time consultants who bring their real-time issues and scenarios as case studies into the training which would help you to learn the actual things and leads to effective learning.

Curriculum

Unit-1-SAP HANA Landscape

• What is SAP HANA
• SAP HANA Components
• SAP HANA Scenarios
• Rapid Deployment Solutions RDS
• SAP HANA Information Sources

Unit-2-SAP HANA Architecture

• SAP HANA Persistence
• Sizing SAP HANA
• SAP HANA Scale Out

Unit-3-SAP HANA Tool Overview

• SAP HANA Studio
• DBA Cockpit
• HDBSQL Command Line Tool

Unit-4-SAP HANA Pre & Post Installation

• Preparing SAP HANA Installation
• Review SAP HANA Installation
• Post Installation Steps

Unit-5-SAP HANA Operations

• Staring & Stopping SAP HANA
• Configuring SAP HANA
• Periodic Manual Tasks

Unit-6-Bacup & Recovery

• Concept of Backup & Recovery
• Data Area Backup
• Log Area Backup
• Backup of Configuration Files & Backup Catalog
• Recovery
• Database Copy
• High Availability

Unit-7-Maintaining Users And Authorizations

• User Management
• Types of Privileges
• Standard Roles
• Administrative Tasks
• Authentication Methods
• Information Sources for Administrators and Auditing

Unit-8- Data Provisioning Using SLT

• Positioning & Key Concepts
• Landscape Strategy & Sizing Aspects
• Installation Procedure
• Configuration Aspects
• Data Replication at a Glance
• Monitoring of Replication
• Other Operation Aspects

Unit-9-Data Provisioning Using SAP DATA Services

• SAP DATA Services & SAP HANA
• Configure SAP Data Services
• Configure SAP HANA Studio
• Load Data into SAP HANA

Unit-10-Data Provisioning Using Direct Extraction Connector

• Introduction of SAP HANA Direct Extractor Connection ( DXC)
• SAP HANA Direct Extractor Connection Setup & Configuration

Unit-11-Monitoring & Troubleshooting

• Monitoring with SAP HANA Studio
• Monitoring with DBA Cockpit
• Monitoring with SOLMAN(in Theory)
• Remote Support
• SAP Early Watch Alert

Unit-12-Software Life Cycle Management

• Transport Changes
• Updating SAP HANA

Unit-13-Replication

• Configure System Replication for System
• Enable System Replication
• Registering Secondary System
• Unregistering Secondary System
• Perform Takeover

Unit-14-Highlights

• Install & Upgrade SAP HANA System
• Do SAP HANA Sizing for Customer Specific Scenarios
• Operate & Administrate an SAP HANA System Landscape
• DMO (SAP BW to SAP HANA Migration)
• Certification Training on HA100, HA200, HA240, HA215
• Certification Exam Preparation & Providing the Certification Materials

SAP Lumira Online Training

About SAP Lumira Course

Our SAP Lumira Online Training program would help you to understand the key components of SAP Lumira. Not just we help you to gain the subject knowledge but it will also enhance your income potential.

At Skillstek, We have designed our training as per certification requirements thus, it would also help you to prepare for the certification exam and pass it successfully. You can also work as an expert SAP Lumira Consultant for related industry.

Curriculum

Unit-1-Introduction To The SAP Lumira Suite

• Self-Service Business Intelligence with SAP Lumira
• Beautiful and Customizable Visualizations
• Changing Requirements and SAP Lumira

Unit-2-Installations And Configuration Of SAP Lumira Desktop

• Downloading SAP Lumira Desktop
• Installing SAP Lumira Desktop
• SAP Lumira Registration
• SAP Lumira File Format

Unit-3-Data Acquisition

• Data Acquisition Overview
• Supported Data Sources
• New Dataset Creation
• Microsoft Excel,Text Files,SAP HANA, Universes,Retrieving Data From SAP BW

Unit-4-Data Manipulation

• Working Modes
• Objects in SAP Lumira
• Calculated Objects
• Data Actions, Filtering and Sorting Data, Multiple Datasets
• Hands-on for the Data Manipulations

Unit-5-Data Visualization

• Building charts in SAP Lumira
• Charts Types in SAP Lumira
• Filters in Charts, Visualization Gallery
• Navigating through data in a visual way using charts
• Advanced chart features for multidimensional data
• Creating your own data
• Using Predictive calculations
• Using Predictive calculations
• Using Run-Time Calculation of Data
• Using Advanced Chart Properties in Lumira
• Using runtime Calculation in Charts
• Creating Reference Line in Lumira charts
• Using Geographical Charts
• Using Animation in Charts
• Hands-on for different charts

Unit-6-Story Compositions In SAP Lumira

• Creating a Story, Compose Room Organization, Infographics
• Charts Types in SAP Lumira
• Creating Static Filters
• Linking filters to the charts
• Add pictures, pictograms, shapes, and text to a story
• Working with Different Storyboards
• Adding pages in storyboards
• Setting the layout of storyboards
• Setting the layout of the filter and display data
• Add dynamic text to a story
• Create a hyperlink in a story
• Hands-on for different Storyboards

Unit-7-Sharing In SAP Lumira

• Different Methods of publishing the data
• Publishing data to HANA
• Refresh an SAP Lumira document
• Hands-on

Unit-8-SAP Lumira Server For BI Platform

• Publishing data to BOE
• Opening the Storyboard in BOE
• Refresh an SAP Lumira document based directly on a database and stored on the SAP Business Intelligence (BI) Platform
• Set a schedule for an SAP Lumira document stored on the SAP Business Intelligence (BI) Platform
• Run a scheduled SAP Lumira document on the SAP Business Intelligence (BI) Platform.

SAP S/4HANA Logistics Online Training

About SAP S/4HANA Logistics Course

SAP S/4HANA Logistics online training you will learn the complete configuration of SAP Logistics process into the system. The trainer is highly experienced and knowledgeable enough to teach you full project implementation in the training so that you would be able to work as an independent SAP S/4HANA Logistics Consultant for any SAP project.

At Skillstek, we would also provide you with after-class support by addressing your problems and queries by your trainer himself. You would be fully assisted during and after the class for all your subject related issues.

Curriculum

Part-1 Introduction to SAP HANA
This topic will prepare you to have a basic idea about the capabilities of SAP HANA, how SAP HANA is better than traditional databases.

• Introduction to SAP HANA
• SAP In-Memory Strategy
• Architecture Overview
• IMCE and Surroundings
• Row Store
• Column Store
• Attribute Views
• Analytic Views
• Calculation Views

Part-2 SAP S/4 HANA
This topic will give you the complete idea about motivation of SAP S/4 HANA, how it will remove the challenges of SAP ERP 6.0 or earlier versions and what are the key pillars of SAP S/4 HANA

• S/4 HANA Roadmap
• Key Pillars of S/4
• Simplified Processes
• SAP Fiori
• Principle of One
• Benefits of S/4 HANA from business perspective
• Benefits of SAP S/4 from IT perspective
• Ways from Business Suite to S/4 HANA
• Deployment Options (On Premise, Cloud and Hybrid)

Part-3 Introduction to SAP Activate Methodology
Now, once you know the motivation of SAP S/4 HANA, this topic will tell you how to implement or migrate to SAP S/4 HANA

• Different Scenarios of Migration
• System Conversion
• Landscape transformation
• New implementation
• Phases in Activate Methodology

Part-4 SAP HANA Cloud Solutions
This topic will help you understand HANA’s Cloud offerings

• SAP Strategy for Cloud and SAP HANA
• SAP Cloud Data Centres
• SAP HANA Enterprise Cloud
• SAP HANA Enterprise Cloud Use Cases
• Examples of On-Premise to Cloud Integration

Part-5 Key Innovations of SAP Simple Logistics

• Inventory Management
• Material Requirement Planning
• Material Valuation
• Order Management & Billing
• Procurement

Part-6 Changes in SAP Simple Logistics Processes

• Overview of New Functionalities in SAP Simple Logistics
• Overview of SAP Fiori Apps related to Logistics/ Supply Chain
• Architectural changes for Product Master & Supplier Information
• Architectural Changes/ Configurations related to Sourcing & Procurement
• Architectural Changes/ Configurations related to Supply Chain
• Architectural Changes/ Configurations related to Manufacturing
• Architectural Changes/ Configurations related to Sales

Part-7 Industry Specific Solutions for Logistics functions for

• Engineering & Construction
• Aerospace & Defence
• Mill Industry
• Automotive

Part-8 Migration to SAP S/4 HANA

• For New Installation
• Customers already using SAP Business Suite
• Customers who want to consolidate their landscape
• Customers who want to Carve out selected entities or processes

SAP ABAP on HANA Online Training

About SAP ABAP on HANA Course

We offer best SAP ABAP on HANA online training. Our trainers are real-time SAP consultants, who are experts in their domain sector. You will also get career guidance on ABAP on HANA which would help you to beg your dream job.

At Skillstek, we assure to provide the best SAP HANA Training with lots of attractive features such as free study material, Practice support, Self-paced videos & more.

Curriculum

Onboarding and introduction to ABAP HANA
ABAP Meets SAP HANA

• SAP HANA Ambitions
• Hardware Technology innovations
• SAP Software Technology innovations
• SAP HANA Goals
• Evolution of ABAP for SAP HANA
• Possible Type of SAP HANA Based Applications
• Highlights of SAP Netweaver Application server ABAP 7.4

What we need to know

• Row store
• Column store
• When to use columnar storage
• When to use row storage
• Demo
• Column store dictionary compression

Code to data Paradigm

• Implications of an in memory data base
• Over view code to data capabilities
• Performance improvement vs code adjustments

Your Development Tools

• System Demo to write “Hello World”
• Short cuts

Existing code is still valid

• Migration to SAP HANA
• Code Continuity
• Mandatory Adaptations
• ABAP Test cockpit
• Runtime check Monitor

SQL Footprints in your productive System

• Example of productive ERP System
• SQL Monitor
• Architecture
• Administration of the SQL Monitor
• Analysis of SQL Monitor Data
• Demo

Guided Performance Analysis

• Combination of code check results
• SQL Performance Tuning Work list demo
• Recommended procedure

Optimized ALV and Other Improvements

• Transparent Optimization
• ALV Integrated Data Access demo
• ALV integrated data access
• Search help
• Demo on search help

Recent Open SQL Enhancements

• EPM
• What is Open SQL
• Demo
• What’s new in Open SQL
• Literal Value and generic existence check
• Expressions
• Demo
• Conditional Expression
• Expressions in Group by having clauses
• Automatic client handling

Core Data Services

• Introduction to CDS services
• CDS in ABAP
• Demo
• Simple CDS View and Open SQL Consumption
• CDS views vs. Open SQL

Core Data Services : View Definition

• Demo
• Projection list
• View-on-view concept
• CDS View Extensions
• CDS view with input parameters

Core Data Services : Associations

• Demo
• UNION & UNION ALL Statements
• Join statements
• Simple association
• Association types
• Filter associations

Native SAP HANA Using in ABAP

• ADBC
• DEMO
• ABAP Database Connectivity : Typical code
• Native SQL Pitfalls
• Consumption of an SAP HANA Database procedure with ADBC
• Consumption of an ABAP Managed Database Procedure

ABAP Managed DBMS

• Introduction of AMDPs
• Demo
• Class definition
• Class implementation
• Consumption and artifact creation
• Exception Handling
• AMDP Exception Hierarchy
• AMDP BAD

Domain Specific Usage of CDS

• CDS Annotation Concept
• Demo
• Consumption of CDS View in SAP Gateway
• Demo

SAP SuccessFactors Online Training

About SAP SuccessFactors Course

SAP SuccessFactors Online Training would guide you to work on the process of Human Capital Management by using SAP HCM Cloud Software. The course structure would enable you to understand and work on the concepts of Talent Management, Human resource core capabilities, and HR analytics.
At Skillstek, we are associated with the industry's best trainers, we can assure to get expert training and career guidance. The training is also certification oriented thus, would help you to prepare for the certification exam and pass it successfully.

Curriculum

Introduction to Mastery.
Module-1: Mastery- Introduction

• Learn the products
• Instance, Provisioning explanation
• SAP JAM
• Basic company settings in Provisioning
• Creating administrators.
• Instance basic settings – Passwords, Home Page, Welcome Menu, Company info, Employee files
• Administrator tools
• Bizxpert Methodology – Implementation Methodology.
• Commonly used terms
• Admin Privileges
• Setting up company Logos
• Manage Data User Records
• Employee Data File
• Permissions
• Password Policies
• Email Notifications
• Change engine configuration
• Text Customization in Instance
• Rating Scales
• Route Maps
• Launching forms
• Employee Profile
• XML and Data models
• Pick lists
• Role Based Permission
• Reporting
• Set up process dashboards
• Rating Scale Dashboards
• Create Interactive Dashboards
• Reporting Admin
• Manage Report Permissions
• List view reports
• Spotlight view reports
• Spread sheet reports
• Classic reports
• Adhoc reports
• Final Exercise.

Module-2: Employee Central Mastery – Core HCM Module

• Introduction and basic provisioning set up exercises
• Data models and DTDs
• Employee Central Structure
• Data model Management
• Data model Associations
• Enable employee central and RBP
• Update employee details
• ESS/MSS functionality
• Understanding security
• Managing security with RBP
• EC as a system of record
• EC Customizing and Populating Basic Foundation data
• Customizing Country specific files in Foundation tables
• Creating and modifying associations
• Propagations
• Importing users and data
• Mass Changes
• Customizing employee files
• Customizing CSF for employee files
• Position Management
• Employee Central Reporting and Integration
• EC Payroll Integration
• MDF Overview
• MDF Objects creation
• Rules setup
• Final Exercise.

Module-3: Recruitment Management.

• Introduction to Recruitment
• Instance Setup
• Applicant Status
• Recruiting Operators
• Recruiting Resources
• Enable Job Requisition
• Create job Requisition
• Configure Job Requisition Template
• Requisition Field Permissions
• Configure Job Search Fields
• Requisition Picklists
• Requisition Headers & Footers
• Candidate Profile
• Candidate Screening Questions
• Offer Approval Template
• Offer Letter Template
• Generate Offer
• Setting up Agencies
• Email Templates
• Final Exercise

SAP S/4HANA Finance 1809 Demo - By Best SAP HANA Finance & Controlling T...