Downloading Exchange Rates from Central Bank of Turkey

Tags: BAPI_EXCHANGERATE_CREATE , CL_HTTP_CLIENT , CALL TRANSFORMATION

One of the standard requests that comes with every SAP implementation is automatic download of exchange rates to your system. Today I will show you on an example of Central Bank Of Turkey, how to transform XML from bank site into internal table, which can be then used inside your code to populate values of BAPI_EXCHANGERATE_CREATE FM.

There are few ways to download the XML to your ABAP code, I prefer to create an RFC destination (lets call it here Z_DESTINATION_TO_TCMB), as on many servers you need to provide credentials for PROXY and it is safer to keep it saved inside RFC destination, than in your ABAP code in plain text.

So lets assume you have an RFC destination that points to https://tcmb.gov.tr/kurlar/today.xml. It will look like this:

Add a comment

Downloading Exchange Rates from NBP (National Bank of Poland)

Tags: BAPI_EXCHANGERATE_CREATE , CL_HTTP_CLIENT , CALL TRANSFORMATION

Following the example of downloading exchange rates from Central Bank Of Turkey using transformations, please find bellow the same way for National Bank of Poland.

Again, lets create an RFC destination (lets call it here Z_DESTINATION_TO_NBP) tha will point to https://www.nbp.pl/kursy/xml/lasta.xml, where the last exchange rates are posted.

Add a comment

ABAP Extensions - Automatic Logon

Tags: ECLIPSE , ADT , PLUGIN , ABAP EXTENSIONS , AUTOMATIC LOGON

Yesterday I've announced that I'm working on automatic logon to SAP systems on Eclipse. Today the changes in the plugin ABAP Extensions for Eclipse are published and you can use the first version of the automatic logon on your installations.

ABAP Extensions plugin you can find in Eclipse Marketplace or by doing direct installation from this link http://abapblog.com/eclipse/plugin/ABAPFavorites/ or by using the install button which you can find on the right side of this page.

After installation of update will be able to set the preference if you want to do automatic logon at start of Eclipse and if you want to logon automatically only to the systems, for which you have stored the password already. These are also default settings for the plugin. The logon happens in the background job. So if you have several systems in your workspace, it will take a while to logon to all the systems. The progress you can follow in the Progress View.

Add a comment

ZCL_CMD_CUSTOMER -> Wrapper for CMD_EI_API classes

Tags: CMD_EI_API , CMD_EI_API_EXTRACT , ZCL_CMD_CUSTOMER

If you know CMD_EI_API class, you are aware of its power. It's very helpful for the manipulation of customer master data, all master data including contacts. I have played with this class many times and although I got use to the structure of it, I thought one day that it would be handy to have a wrapper or framework to use it. So I've started to build it.

As a result I have now more handy (but not perfect) class to handle the creation or update of customer master data with CMD_EI_API=>MAINTAIN_BAPI method.

The whole source code is available as current version on Github, from where you can instal this class (and all supporting ones) with abapGit https://github.com/fidley/Customers.

As there is no much documentation about this class yet, I will extend this article in future with more details, for now just the basics information how to start with it.

Add a comment

SAP Fiori - HTTP request failed403,,CSRF token validation failed

Tags: FIORI , CSRF Token , SAP WebIDE

I've started some time ago a journey with SAP Fiori and first Fiori apps. It was not that smooth as I've expected, but now with experience received during that period I feel more and more comfortable with it. That's why when I've heard that I need to create an simple app in Fiori to create new incident in our helpdesk system.

Normally it looks very simple both from backend and UI point of view, but the issue was that I had to make the possible to use the app without the logon to SAP.

SSO is not possible yet in my company so I've setup the SICF node of the application to use specific credentials for logon, and here the surprise started :)

HTTP request failed403,,CSRF token validation failed error appear when I was calling oModel.create method......

Add a comment

Speed-up your Eclipse installation

Tags: ECLIPSE , ADT , ABAP IN ECLIPSE

I was many times disappointed about the time Eclipse needs to start, but I thought that's the way it should be, especially that my previous PCs were not the fastest one and with small amount of RAM-memory. I was cleaning the installations each time I was installing new version of IDE by removing not needed plug-ins, especially that I'm working in Eclipse mainly with ABAP and ADT tools. But even if the installation looks quite clean, still on my new PC which has lots of RAM and very nice processor the starting time of Eclipse was horrible. Also sometimes I've felt that the performance of the editor is not the best ( even if the connection to SAP backend was fast).

Add a comment

Creating ABAP type definition from JSON structure (JSON2ABAPtype)

Tags: /UI2/CL_JSON , JSON , JSON2ABAPtype

I'm playing lately with TFS web services in ABAP and as I'm lazy guy I wanted to make my life a bit easier while working with the JSON results.

There is already a nice class /UI2/CL_JSON available which can deserialize JSON and also it can generate a dynamic structure from JSON file but at the end to make programming easier you need to create local or global structure that will be matching the structure of JSON.

Instead of spending time on creating manually all needed types, I've decided to create a small report that will do the work for me. Once done it will serve for long time.

The prerequisites for this program is to have class /UI2/CL_JSON in latest version that have a method GENERATE in the first place. On the server in which I was developing this program I had to implement two SAPNotes (2526405 ,2629179) in order to get correct results from the mentioned method. Once done the rest was quite easy.

Add a comment

Retro ASCII symbols in ALV Grid table

Tags: CL_GUI_ALV_GRID , CL_GUI_DOCKING_CONTAINER , SYM

The ALV Grid hides inside itself possibility to use ASCII symbols. All you need to do is to mark the one of fields in field-catalog as symbol and then use constants defined in TYPE-POOL SYM in order to display one of them. The image bellow shows few of them, of course they are not that nice like the ICONS, there is also not many of them, but it's good to know that such symbols exists, although I so far I've not used them at work.