SAP

Conducting Fit-to-Standard Workshop with Cloud Mindset – Mindset Shift to Cloud

Conducting Fit-to-Standard Workshop with Cloud Mindset – Mindset Shift to Cloud

To make an SAP S/4HANA Cloud implementation successful, we need to move away from the traditional "Fit-Gap" on-premise mindset to the Fit-to-Standard Cloud mindset. The purpose of the Fit-to-Standard Analysis workshops is to confirm the scope identified in the Digital Discovery Assessment and gather configuration and customization requirements. To do this, implementation consultants demonstrate the SAP S/4HANA Cloud business processes to customer experts from each line of business.

10 Skills You Should Master as an SAP Consultant

In our last article, we defined SAP Consulting as the activities, processes, and tasks SAP consultants undertake to help SAP customers manage and optimize their business operations. While SAP consulting comes in various forms and flavors, a successful SAP consultant typically excels in certain aspects and qualities, irrespective of his or her domain. In this article, we will cover ten basic skills every SAP consultant needs to be successful and why.

Basics of SAP for Young Professionals

Written By: Ndz Anthony Business Intelligence Expert

SAP, commonly pronounced as 'sæp' or S-A-P (System, Application, and Products In Data Processing), is a software company that offers transformative enterprise management solutions to businesses around the globe. 

The SAP company is a leader in ERP technology and business solutions.

SAP ranks amongst the Fortune 500 as the third-largest publicly-traded company(by revenue) globally. 

One reason for these statistics is their top-tier customer base. SAP solutions are frequently expensive, closed source, and require professionals to implement.

Here at ERP Fixers, we know too well how challenging implementing SAP software can be, hence the need for trained SAP experts, typically known as SAP consultants in the SAP Ecosystem.

This article will discuss SAP Consulting, the types of SAP Consulting, how to become an SAP consultant, and finally, the prospects of SAP consulting.

What is SAP Consulting?

We can define SAP Consulting as the activities, processes, and tasks. SAP consultants undertake to help SAP customers manage and optimize their business operations.

Types of SAP Consulting

There are numerous SAP consultant types; as a matter of fact, there are as many SAP Consultants as SAP Products.

However, we can group sap consultants into two main categories, functional consultants and technical consultants.

Who is a Functional SAP Consultant? 

This category of SAP consultants works closely with the domain experts and developers to set up and enable the use of functional SAP modules deployed within user departments. 

The Key roles & Duties of a Functional SAP Consultant include:

  • Liaising with Heads of Departments during business process design and implementation phases.

  • Liaising extensively with heads of departments and "super users" to understand their SAP requirements and provide solutions to business needs. Enforcement of internal controls within SAP and other business systems.

  • Provide user manuals and training to users of enterprise systems.

  • Provide operational and periodic ad-hoc reports to administration to aid decision-making on SAP and SAP-related Systems.

Examples of functional SAP consultant roles are SAP MM Consultant, SAP PaPm Consultant, SAP HCM consultant, etc.

Technical Consultants:

These categories of SAP consultants are more tech-savvy and work closely with the functional consultants to implement, modify or enhance the existing SAP system.

Their Key roles & Responsibilities include:

  • Based on approval, work together with functional consultants to proactively implement new features, introduce new systems and modify existing business processes to improve efficiency.

  • Oversee and manage projects to modify, enhance, or implement new functionality on SAP and other related products.

  •  Support users on change control and management.

Examples of technical SAP consultant roles are SAP ABAP Developer, SAP BW Consultant, SAP Basis consultant, etc.

How to Become An SAP Consultant

We have found two significant routes to commence your career as an SAP Consultant.

1. The SAP YPP Program

The SAP Young Professional Program is an initiative by SAP Digital Skills Center created to bridge the digital gap existing in today's workforce.

The program is designed to:

  • Sieve top graduates and subsequently equip them with soft skills, accredited SAP certifications, and a sense of belonging within the SAP Community.

  • Set a stage for career growth within the SAP Ecosystem as potential SAP consultants.

  • Balance the demand for SAP consultants across the SAP Ecosystem.

If you are interested in an SAP career and a B.s.c in  Business Administration, Management Information Systems, Engineering, or a related field, you should consider applying.

2. SAP Certification and Training

Suppose you already have some experience working with SAP, maybe as a superuser in your company. In that case, you might want to consider this path.

  • Pick your preferred SAP module.

  • Invest in the training course for that module

  • Write certification exam

  • Intern or Volunteer to join up with an SAP Consulting firm to gain experience.

With this route, your credibility and experience will be evident to potential employers. You stand a higher chance of being considered for SAP Consultant roles.

Prospects of SAP Consulting

SAP is an in-demand profession, and there are many possibilities within the sap consulting space.

In this section, I will outline a few prospects for sap consulting.

1. High Earnings

SAP software is to the ERP ecosystem what Apple products are to the tech-gadget industry. SAP software is relatively expensive and usually deployed by enterprises with high budgets and large-scale businesses. Hence, the reason for top-notch earnings in the industry. The compensation for SAP consultants ranks among the highest, with opportunities for job growth prospects, salary, quality of life, and other benefits. PayScale estimates an average SAP Consultant salary at $89,129k per year.

2. In-demand Profession

According to most recent articles and employment agencies, jobs in SAP consulting are high in demand. Due to the increased demand for technology solutions, they will continually rise.

3. Top-Tier Firm

According to Glassdoor, SAP ranks as the "best places to work in 2022". Due to its success as an international brand, SAP consultants are highly regarded and respected in the corporate world.

Cost Flows in SAP Controlling


One of the most misunderstood aspects in all of SAP is how to analyze production variances. This is partly because SAP’s method of Product Cost Controlling is different from other accounting software systems, in that production costs are passed through the P&L as well as the Balance Sheet. And also, because production activity (Labor, Machine Time, Overhead) is tracked using Secondary Cost Elements, which are not part of your typical Financial Statements. Even some of the most seasoned cost accountants are flummoxed with how the manufacturing information is represented in Financial and Management Accounting, and how to measure price and efficiency variances. To put it simply, Production Variance Analysis involves three steps:

Creating a standard cost estimate, which calculates the expected cost to manufacture an assembly.
Collecting the Actual manufacturing costs on a manufacturing order (production order/process order /product cost collector).
Calculating the Variance, which is the difference between:
actual costs: components, labor, overhead
actual credits: value of finished goods manufactured.

SAP Product Costing Controlling Configuration and Beyond

- Look into the design aspects that are jointly owned by CO, MM and PP teams. (e.g. Resource / Work Center and their Standard Value Keys, Formulae for Activity Types).
- Review options to add freight, other incidental costs in the standard cost estimates and track actuals (e.g. Costing Sheet, Additive Costs, User exit for material valuation, Accrual pricing conditions in Purchase Order, etc.)
- Understand how to investigate and rectify messages encountered during product costing
- Deep dive into movement types and account determination, analyze MM-FI accounting flow

Variance Analysis in SAP Controlling


One of the most misunderstood aspects in all of SAP is how to analyze production variances. This is partly because SAP’s method of Product Cost Controlling is different from other accounting software systems, in that production costs are passed through the P&L as well as the Balance Sheet. And also, because production activity (Labor, Machine Time, Overhead) is tracked using Secondary Cost Elements, which are not part of your typical Financial Statements. Even some of the most seasoned cost accountants are flummoxed with how the manufacturing information is represented in Financial and Management Accounting, and how to measure price and efficiency variances. To put it simply, Production Variance Analysis involves three steps:

Creating a standard cost estimate, which calculates the expected cost to manufacture an assembly.
Collecting the Actual manufacturing costs on a manufacturing order (production order/process order /product cost collector).
Calculating the Variance, which is the difference between:
actual costs: components, labor, overhead
actual credits: value of finished goods manufactured.

Gain better Visibility of Inventory Costs within your ERP System

In the standard ERP system (and even S/4HANA) it is difficult to find reports that give you a multidimensional view of your inventory costs. Many customers download the information to Microsoft Excel or use external reporting tools such as BI to do the analysis. There is nothing wrong with these options, but sometimes they lead to reconciliation errors (in the case of Excel) or realtime update issues (in the case of BI). With the Material Ledger Activated and by utilizing an enhanced report, there are several reporting options that will give you a more granular view of your inventory values.

Recording Stock-in-Transit in Accounting and Logistics Transactions

Stock-in-Transit can occur when goods transferred between two entities have left the sending entity, but ownership has not yet been transferred to the receiving entity. In traditional SAP the Stock-in-Transit of Inventory can be identified in Inventory Management reports, but this is not reflected in Accounting. With the Business Function LOG_MM_SIT, which is available in ECC (from Enhancement Pack 5) and also in S/4HANA (switched on by default), you can reflect the Stock-in-Transit in dedicated G/L Accounts.

Reorganizing Profit Centers in SAP


As of ECC 6 EHP 5, SAP rolled out a functionality which allows for reorganization of the profit center on the core SAP objects in the Logistics and Accounting functions.

This includes changing profit centers on Materials, Sales Orders, Cost Centers, Orders, Projects, AR, AP, and GL Open Items. With this functionality companies can update the core data in their SAP ERP systems to enable financial reporting which better aligns with how they manage their business today versus 10-15 years ago when they first implemented SAP. Learn how SPX Flow used this functionality to transform their financial reporting and enable full financial statements which align with a new management structure.

“Professionalized Business Case” is the first step of SAP S/4HANA Journey!

“Professionalized Business Case” is the first step of SAP S/4HANA Journey!

SAP provides mainstream maintenance for core applications of SAP Business Suite 7 software including SAP ERP 6.0, SAP Customer Relationship Management 7.0, SAP Supply Chain Management 7.0, and SAP Supplier Relationship Management 7.0 applications and SAP Business Suite powered by SAP HANA on the respective latest three Enhancement Packages (EhPs) until December 31, 2027. From January 1, 2028, all SAP Business Suite 7 core applications and respective SAP Business Suite 7 add-on products will enter the customer-specific maintenance (CSM) phase. SAP offers an optional extended maintenance phase from January 1, 2028, until December 31, 2030. This three-year phase comes at an additional fee on top of the maintenance fee. Details outlined in SAP Note 2881788.

Universal Allocations in S/4HANA

Cost Allocation within the Overhead Cost Controlling module enables business users to periodically allocate posted amounts and quantities from sender cost objects to receiver cost objects based on a Cycle Structure. Some challenges exist with the current ECC functionality such as the ability of users to easily understand their allocation processes and the ability to simulate the results from allocations. Also, several other modules such as General Ledger, Profit Center Account, and Profitability Analysis also contain allocation functionality, but it is difficult to keep track of all the allocations, as they are not stored in the same area of the system. In S/4HANA 1809, Universal Allocations were introduced to handle most of these issues as well as provide new functionality.

SAP's RE-FX Contract Lease Management Solution

WALK AWAY FROM THIS SESSION WITH AN UNDERSTANDING OF SAP's RE-FX Contract Lease Management Solution

The FASB released new lease accounting standards taking effect:
- After December 15, 2018 for US public companies and
- Delayed to December 15, 2021 for US private and nonprofit companies*
- Lease contracts move from a footnote in financial statements to the balance sheet as right-to-use (ROU) assets
- SAP's existing Real Estate module (RE-FX) incorporates the new process and reporting requirements
- This webinar informs you of 5 things you may not know, but should, about implementing the new lease accounting standard and SAP's RE-FX solution:
- Things to do before your implementation
- Things to avoid that complicated public company
implementations
- S/4HANA versus ECC6 and on- premise versus
cloud
- Things to remember about SAP's RE-FX
configuration

Finance Reports in SAP S/4HANA (Embedded & Strategic Analytics in SAP S/4HANA)

The Embedded Analytical tools may be divided based on usage. CDS Views are the foundation for all analytical applications. Programmers create a virtual data model using CDS views. In comparison, the key user uses CDS views to create dashboards. "Custom Analytical Queries" will be used to develop customer queries. Finance and Logistics end users. Use reports and dashboards created by the key user. Functional users will use SAP Smart Business Cockpits with predefined content for different multidimensional reports across all business lines.

 Some multidimensional reports provide to end-users through SAP Fiori. They have flexible slice-and-dice navigation features. "Query Browser" will help end-users for analytic queries that allow them with flexible slice and dice reporting. "View Browser" is another tool to check the delivered CDS Views and Queries. These tools help the Functional team ( Finance, Logistics, ………… users) to get reports with no latency, no data duplication, excellent performance for all types of reports, Integration scenarios with SAP BW, and also Support for SAP ERP authorizations.

 1. Report Design Modeler — Apps

*See picture 1 labeled below  

The Report Design Modeler apps are a set of SAP Fiori apps that customers can use to create and manage Financial or Logistics or any other reports. When created an evaluation, we choose a tile to visualize the reports in the Publish Report app.

 *See picture 2 labeled below

You define this using the Configure Report Drill-Down app.

 *See picture 3 labeled below

Business knowledge helps to configure the drill-down views. Configure Report Drill-Down app is used by power users who can see data in Graphs IT administrative knowledge is needed to authorize users to get access to these reports

You may use this capability for all most all Finance reports like:

Analyze Actual Cash Flow, Liquidity Forecast, Budget Alerts, Contract Expiry, Aging Analysis,

Analyze Change Impact, Analyze Collections Success, Analyze Collections Volume, Analyze Credit Exposure, Analyze Open Credits, Analyze Overdue Items / Overdue Item Analysis, Analyze Payment Locks, Analyze Payment Run Exceptions, Cash Discount Utilization, Cash Discount Forecast, Cash Collection Tracker - Accounts Receivable, Cash Position, Analyze Returns, Operational Supplier Evaluation / Supplier Evaluation, Payment Statistics, Credit Limit Utilization, Days Payable Outstanding Analysis,

Days Sales Outstanding, Detect MRP Situations, Future Receivables, Future Payables……….Etc.

2. Overview of View Browser and Query Browser

The View Browser

View browser allows Power users from all business lines to explore thousands of VDM views without any technical skills. So, it helps Business Users to draw meaningful reports for their business requirements. You can find suitable views based on your need and display its content for analytical queries in Design Studio. Using View Browser, we can explore standard Core Data Service views (Composite and Consumption) and create developers.

+

 *See picture 4 labeled below

The Query Browser

The Query Browser is a default Design Studio app that is available in the standard SAP Fiori Library.

The Query Browser is not part of the SAP Fiori launchpad's default view and is added to the My Home group. The Query Browser will show consumption views that were annotated as Analytical Query and therefore act as a source for KPIs. Users can select an Analytical Query and perform on-demand reporting on it.

The Query Browser is a default Design Studio app available in the standard SAP Fiori Library. No additional installation is required.

In the Query Browser, you can see many analytical queries.

 *See picture 5 labeled below

Business catalog SAP_CA_BC_VDM is to assigned to the user.

3.   Custom Analytical Queries app

For creating Financial or Logistics or a report that is needed from any business line, from scratch, SAP provides the built-in, easy-to-use, Custom Analytical Queries app. It is aimed at key users, rather than end-users. An advantage of it is that you don't have to understand the query language to build a query.

 *See picture 6 labeled below

 Required Business Role: SAP_BR_ANALYTICS_SPECIALIST

Required Technical Catalog: SAP_BASIS_TCR_T

Activated ICF node: ANA_QDESIGN_MAN (ICF path /sap/bc/ui5_ui5/sap/ana_qdesign_man)

 Example: Power-user wants a report from Cost Center Module.

Customers can create a Custom Analytical Query to report in Cost Center Module on Actual Vs. Plan data. We can also have a drill-down facility

 *See picture 7 labeled below

4.   The Report Designer Modeling apps

The Report Designer Modeling apps are a set of SAP Fiori apps that a key user uses to define or manage reports.

*See picture 8 labeled below  

These Reports are based on the Analytical List Page Smart Template.

Customers can Create Reports using create report app based on measures of the related Analytical Query.

Just enter the relevant data source details such as the Core Data Services (CDS) view, the OData service path, and the entity set that corresponds to the CDS view.

 *See picture 9 labeled below

Choose Activate and Add Evaluation.

5.   The KPI designer - Smart Business Framework

SAP Fiori Smart Business helps customers create their analytical apps based on Key Performance Indicators (KPIs).

 *See picture 10 labeled below

Smart Business Cockpits can be personalized. They bring analytics into the business process when the user needs it. Customers can develop an Analytical Query to analyze business data using the KPI Designer tool.

You can create a KPI, in the following order:

·   Create KPI

·   Create Evaluation

·   Create Tile

·   Configure Drill-Down

·   Manage KPI Associations (optional)

6. SAP Analytics UIs

SAP Analysis for Microsoft Office is a Microsoft Office Add-In that allows multidimensional Analysis When you install Analysis for Microsoft Office on your local machine; you can connect directly to the following:

SAP Business Warehouse (BW) system

SAP Business Objects Business Intelligence (BI) Platform

SAP HANA

Using Analysis for Office, you can also access Core Data Services view based queries and view the report.

7. SAP delivers several standard reports.

You can find these reports at various locations under the Information System in the SAP Easy Access menu.

 *See picture 11 labeled below

Almost every application in the system has an Information System menu option, which contains the reports predefined by SAP. You can also display thru SE43.

 *See picture 12 labeled below

You can search standard reports in SE38, by the letters they contain. For example,

Vendor related reports can are found by RFK*

Customer-related Reports can be searched by letter RFD*

General ledger RFS*

Document Reports: RFB*

Screen prints.jpg
Screen prints.jpg
Picture 5Picture 6Picture 7
Screen prints.jpg
Screen prints.jpg
Picture 12

S/4 HANA: Costing for Manufacturing Orders

WALK AWAY FROM THIS SESSION WITH AN UNDERSTANDING OF DISTRIBUTING COSTS DURING PERIODS OF IRREGULAR PRODUCTION ACTIVITY


There are certain scenarios where the activities of a business are not aligned with the period when the costs for those activities are incurred. This occurrence is typical with companies with seasonal production cycles, such as those in the Agribusiness industry, whose investments in land or other resources, do not always coincide with when the utilization of those resources occurs. In those cases, a cost model is set up so that the original cost is spread through the periods of the production cycle, when the actual cultivation of the land takes place.

In these times, where disruption due to COVID 19 has impacted many industries and hence production activities, the model described above could also be useful. During periods of Production Downturn which leads to minimal or no activity, how do you reflect that in a cost structure that had assumed that production will take place? Hear from Rogerio Faleiros, SAP Controlling Expert and Author, who will take you through the following:
- Using Assessments between Cost Centers and Internal
- Orders for Operational Expenses
- Using Internal Order Settlement to transfer Costs to AUCs
- Setting up Depreciation Rules to reflect periods of Uneven
Production
- Using the Allocation Structure to Distinguish Between
- Different Types of Costs

S/4HANA Central Finance Implementation Dummy Initial Load

S/4HANA Central Finance Implementation Dummy Initial Load

SAP Central Finance (CFIN), every large organization is thinking/talking about it is one or another way! It quickly gives the S/4HANA value benefits without necessarily disrupting existing processes. In such CFIN projects, there is a mandatory step for the initial load, even if you do not want to migrate the historical data from the legacy system to the SAP Central Finance system.

Asset Accounting in SAP S/4HANA

SAP S/4HANA has brought about a number of improvements in Asset Accounting. There is a tighter integration with Finance, and postings are now real-time, updating all ledgers at the same time as the asset, allowing a smoother period end and an easier migration.

This is a new webcast, to update the original “Ask a Fixer: What You Should Know About New Asset Accounting with SAP S/4HANA” created in 2017. It explains the previous material in a new way, and in addition, covers new transactions for closing and migration. It also introduces the new Fiori “experience”, which brings additional functionality such as the asset accounting overview and embedded analytics.

Executing the Steps for Migrating to S/4HANA Finance

One of the key tasks when migrating to S/4HANA is to convert your Financial data from the old tables in ECC to the new tables (particularly the Universal journal) in S/4HANA. This process usually takes place after the technical upgrade from ECC to S/4 and is done during a downtime period. It involves a series of transactional steps that are executed in sequence, with progression to the next step only possible when a previous step has been executed successfully or confirmed. Several iterations of a Finance Migration need to be done in a Sandbox (or test) system in order to resolve any issues that arise. This will therefore make the eventual Production migration smoother and easier to accomplish during the downtime window. It is therefore important to know what steps are carried out and the types of errors that could occur.