BW Data Staging (WHM)

Background Information With the migration to SAP BW/4HANA, source system of type “Web Service” is not available. And here comes a new capability “Write Interface” for DataStore Objects allowing to push data into inbound queue tables of... Read More »

Summary: Hierarchies are one of the most important elements in SAP BW which provides the Business users flexibility to navigate the hierarchy structure in the Frontend Reports. At times, a need arises where we need to flatten the hierarchy structure... Read More »

This blog post will explain a method to implement expert routine for column to row transpose on a table with huge number of columns. In a recent project I had a requirement to load a excel placed in SharePoint location to BW on HANA system. The data... Read More »

What Every BW/BI Developer Needs to Know About ABAP in BW Over time every BW developer needs to write ABAP in SAP NetWeaver BW to be able to meet user requirements. ABAP might be required in a start routine, end routine, expert routine, InfoPackage,... Read More »

Introduction: In past we did some fun exercise, where we tried to automate BW extraction via process chain and extractor under consideration only supported full extract. Goal was to figure out a way to extract delta only records without implementing... Read More »

Introduction: Invalid characters in BW data feed is quite common. Some time BW extracted data consist of special characters (!@#$%^&*()+_|}{“:;) etc. Some time business need to as part of text field so BW allow them by allowing special... Read More »

In this blog post we’ll see how to find if there’s lookup on any Infoprovider with just 5 simple steps. 1.Go to transaction SE16, give table name RSAABAP and hit enter. In the field EDIC: Program editor line enter your infoprovder name... Read More »

Excellent short video by Dearbhla Keenan on the different modes for the BW/4HANA starter add-on.  

Excellent short video by Dearbhla Keenan on migrating a BW to BW/4HANA dataflow in 5 mins.  

Introduction   Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. System must add buffer to timestamp because of the document saving time consuming. But it is not easy to find out how... Read More »