archive

Two Methods to Procure Third-Party Services in SAP EAM

Organizations sometimes seek services from external agencies for maintenance functions. Learn how materials management and plant maintenance functions integrate for handling those external services in Enterprise Asset Management. Key Concept You can generate a single purchase order per breakdown occurrence or preventative maintenance requirement with external services. For periodical services, you can settle each service...

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»



Configure SLAs for Firefighter Audit Log Workflow Review

It is important for organizations to act on requests when they are due, especially when working with a compliance tool such as SAP Access Control 10.0. See how to configure emergency access management service level agreements for the review of firefighter audit logs. Key Concept A service level agreement (SLA) is an agreed upon delivery…...

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»

MEET THE EXPERTS

Kehinde Eseyin
Read More

Kehinde Eseyin is a security architect. He holds a bachelor’s degree in computer science. He has about 12 years of IT security, governance framework, IS risk, and compliance experience gained by working in numerous global organizations. Over the years, he has demonstrated competencies in security design, information assurance, cyber security, data privacy, threat and vulnerability management, penetration testing, business architecture, project management, IT audit, IS controls framework, and identity and access management.



Best Practices for Implementing Sales and Operations Planning

The sales and operations planning (S&OP) process can bring about substantial improvements in the way a company manages its supply chain. Learn the building blocks of the S&OP process, what it needs in terms of technology, and how this is supported in different SAP solutions. Key Concept Sales and operations planning (S&OP) is the process…...

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»



Use the PRATE Function to Perform a Simple Wage Type Proration Based on Infotype Record Validity

Automatically prorate your split infotype wage types using the PRATE operation. With a few configuration steps see how easy it is to set up this functionality in your payroll rules. Key Concept Wage type splits are a common occurrence during payroll runs; however, they do not always behave the way you would like by default…....

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»



Many experienced developers are not aware that moving BW to HANA can in some cases result in slower transformations during data loads. Thankfully, SAP is providing a tool to identify areas in your ABAP code that may benefit from an optimization. In this blog we take a quick look at this valuable tool.

By Dr. Berg

Background

During development of SAP BW Extract Transforms and data Load (ETL) there are many options to create transformations in DTPs in BW 7.x and in older Update and Transfer rules in BW 3.x. Unfortunately, depending on your developers, some of the custom transforms may have sub-optimal ABAP coding can have impacts on how SAP BW ETL performs after the migration to HANA.

Thankfully, SAP’s talented developer Marc Bernard provides an automated tool to help you identify potential coding issues. This program is called the “SAP NetWeaver BW ABAP Routine Analyzer”, or technically ZBW_ABAP_ANALYZER.

 

Figure 1: Input Screen for SAP NetWeaver BW ABAP Routine Analyzer

Overall, the tool looks for and suggests the following fixes:

  • a. Select for all entries (SFAE) statements without HANA DB hints –> add hints
  • b. Select * –> specify fields to select
  • c. Database access in the field routines –> move to start routine
  • d. Loops which do no t assign field symbols –> use field symbols
  • e. Selects from master data tables –> Use the read master data rule
  • f. Selects from DSOs –> Use the read DSO rule
  • g. Direct updates to BW object tables –> Do not update tables directly
  • h. and many more areas…

You can run this program either as on-line, or as a background job. If you run the program on-line (only recommended for a small selection), you can click a link in the output to edit the transformation, transfer rule or update rule.  

Figure 2: On-Line Output for SAP NetWeaver BW ABAP Routine Analyzer

If you run in the background, you can save a log to SLG1 and also create a spool list for further analysis.

 

Figure 3: SAP NetWeaver BW ABAP Routine Analyzer – On-Line Spool list

For organizations that have slow data loads where most of the time is used on transforms and loads, this is a key program that should be run as part of the BW HANA migration planning. The tool should be available for general access in April this year.

Some Observations

The last six weeks in this HANA blog series we have look ed at many of the HANA migration tools that Marc and SAP has provided, and I continue to be amazed at both the quality and the speed at which SAP is rolling out tools to make any HANA migration as easy as possible.

In the next blog we will look an in-depth look at some of the ways you can balance the load on the nodes in a HANA system when working with a scale out environment.

Thanks,

Dr. Berg




Implementation Considerations for Creating SAP InfoSets to Streamline SAP Reporting

Learn the details on how you can leverage InfoSets within SAP ERP HCM to create your own specific HR transaction reports without having to create custom reports through programming. SAP InfoSets are used within SAP ERP HCM through the SAP-delivered ad-hoc query tool and can be a great option for power users. Follow this process…...

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»



Use Ledger-Specific Clearing Functionality to Improve Parallel Ledger Accounting Processes

From SAP ERP 5.0, SAP offers a parallel ledger solution to enable you to comply with multiple accounting standards. However, there was one inherent limitation: You could not post journal entries for open item managed GL accounts to any specific ledger. With SAP ERP 6.0 enhancement package 3, SAP has provided Clearing Specific to Ledger…...

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»



Learn How to Use New Generic UI Building Blocks in the Floorplan Manager

Learn about the User Interface Framework of SAP Business Suite, the Floorplan Manager (FPM) with a focus on generic UI building blocks. See how to deal with generic UI building blocks and prepare new applications with rich content features. Key Concept The Floorplan Manager (FPM) as a User Interface (UI) Framework provides generic user interface…...

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»



Maximize the Functionality of Saved Searches

Learn how to create a saved search in the CRM WebClient UI and make it available to a group of users. See how you can transport a predefined saved search from your development system into other environments, and expand the functionality of saved searches to make dynamic parameters. Discover how, with SAP’s new Central Sharing…...

This content is available to SAPinsider Premium Members.
Please click below to log in or create an account

Login Now »

Create Acount»