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.

Credit Exposure Update Process at FSCM by Web Methods

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.

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.

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.

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

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.

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.