Wednesday 29 July 2020

Turbocharging SAP Queries & Standard ABAP Reports

Introduction


Many SAP queries and ABAP reports do not perform well when retrieving large volume of data from traditional databases using complex SELECT – JOIN SQL statements often on 10 or more tables containing millions of records.

If these ABAP reports are standard SAP programs or ABAP programs generated by SAP in applications like, e.g., SAP SQ01 Query, they should not be modified by programmers. However, using them is frustrating because of poor performance and timeouts they cause for broad selection screen criteria.

Friday 24 July 2020

How-to load a CSV file into SAP BW/4HANA using the Planning function type 0RSPL_FILE_UPLOAD_AO

Introduction


The requirement to upload a CSV file into a SAP BW system is something a lot of people have come a across every once and a while. There the well-known solution by Marc Bernard  is provided. In SAP Note 2053696 it is now stated that this How-to Paper is obsolete and should not be used anymore. Therefore, the new Planning Function type File Upload from AO, 0RSPL_FILE_UPLOAD_AO was introduced.

Wednesday 22 July 2020

How to Add Payment Amount Field in FBL1N Transaction Code and how to Display the Technical Field name in Layout for better Search Capability?

All of my Friends who deals with SAP Vendor Payments and Outstanding Payment FBL1N transaction code is a must. It would be great if you can get to know the Payment amount also in the Layout and now if you can get this without any coding it would be a great win. This blog will cover

1. Add Payment Amount in FBL1N layout to be Displayed with Value.

2. How to get to know the Technical Field name in FBL1N, FBL3N FBL5N and FAGLL03.

This blog can also be used for bath SAP ECC and SAP S/4 HANA also.

Monday 20 July 2020

Update Variant Characteristic Values Using FM

Introduction:


Updating VC characteristic values is some what tricky in this case BAPI_OBJCL_CHANGE  BAPI will not support .In this blog i will explain how to update VC characterist values Using Function Modules step by step.

Below Function Modules used to Update the Variant Characteristic Values.

Friday 17 July 2020

Table Function – SAP Cloud Platform

It is a type of CDS which allow developers to write database procedures They support the HANA platform code pushdown capabilities in ABAP CDS.

For creating a table function two components are required

◉ CDS entity of the table function
◉ CDS table function implementation

Wednesday 15 July 2020

Customized fields at Case management of FSCM

It’s very common to add customized fields to more closely align with your own business needs. In this article, you will find the method to add customized fields for Documented Credit Decision (DCD) as well as enable it at the SCASE search screen.

Monday 13 July 2020

Start writing a Unit Test

I will give an example how to start with ABAP unit test. I start with a simple migration ABAP migration report. The report reads and change data on the database. So the unit test has to cope with external dependency. Code without external dependency is rare in real life. So I show how I write unit tests when external dependencies are an issue. This is in at least 95% of all code I write the case.

I will sometime deviate from common conventions. I do this because I show how I code in my daily work.

Saturday 11 July 2020

Native SQL in S4, replace EXEC SQL statement with this method

Today we are going to discuss about executing Native SQL statements from Report program , there are many instances which I come across during my ABAP journey where we dont get access to development in Hana studio/Hana DB access . So, for executing the Native SQL statements from our report program first we establish connection via EXEC SQL statement.

Friday 10 July 2020

RAP( Restful ABAP programming) for OnPrem S4HANA

The purpose of this document is to show the capabilities of RAP with on Premise setup and see how exactly this is different than BOPF.

Basically there are 3 implementation scenarios possible for RAP

◉ Managed ( Green field development )

1. Managed Scenarios are more like BOPF where you define what tables will be updated at end of the process.
2. We have options for implementing actions, determination and validations
3. Only available on S4HANA cloud

Wednesday 8 July 2020

Cheaper Unit Tests with less Mock Logic

Automated tests have become an important part in my professional life as a software developer. However, you cannot always avoid external dependencies of individual methods you want to test. The more dependencies you have, the more cumbersome testing gets.

Different Approaches to automated testing


The standard advice is to mock any logic that is called by the code under test.

Monday 6 July 2020

Custom Entities – SAP Cloud Platform

Custom entities are data definitions, which does not have a select statement on data source but we define return fields and their types. In case of custom entities their data model is invoked manually at runtime. The logic is defined in a class, we could not only retrieve data using custom entities but also do some other useful and awesome stuff with these good little tools.

Friday 3 July 2020

SAP ABAP Programming Model for FIORI- List Report Application (Part 3)

This is third and final blog of this series. If you directly landed here I will suggest you to refer the first two blogs before starting with this.

SAP ABAP Programming Model for FIORI- List Report Application (Part 1)

SAP ABAP Programming Model for FIORI- List Report Application (Part 2)

So now we are at final step and I know you all are excited to see the Final Fiori App so let’s quickly start with it.

Wednesday 1 July 2020

Practical use of BRF+ Application to design the Rules in SAP

What is BRF+ and the importance in S/4HANA?


BRF+ is an ABAP based framework and part of the NetWeaver stack. BRF+ stands for Business Rule Framework Plus and it provides a comprehensive application programming interface and user interface for defining business rules. It enables you to define business rules without the need of wiring ABAP code. The generated Business Rules can be incorporated into other SAP programs or Substitution/Validation rules.