ABAP – APO Planning book macros on aggregated levels

SAPHere I’d like to present my solution of a problem in APO planning books where it was necessary to load multiple products and locations at the same time into the planning view and execute some Default macros on all of them. Continue reading

ABAP – Convert numbers on input and output

SAPI’m affraid there might be a standard function module already available to achieve the same what I’m going to write myself, but I believe it is good to know that the number format can be different when different user settings is used in SAP.
If you forget about this during your development you might start fighting serious problems in the future.
Therefore I’ve written two short code snippets for numbers conversion for INPUT (save to database) and OUTPUT (display to the user) Continue reading

ABAP – How to declare a variable dynamically

SAPIn case you need to create a variable dynamically during runtime with different type, length or precision, you can use the following piece of code to achieve the same – the variable is created dynamically based on given type, length and number of decimals. Continue reading

ABAP – How to search across Web Dynpro methods

SAPThere’s no direct way how to search for a string across all methods of a Web Dynpro, it is always possible to search in just one method only. Using the approach I’m going to present it is possible to find the SAP internal name of the impementing class and then search across the whole class in classic SE24 transaction for editing classes. Continue reading

Excel – Ignore blanks and duplicates in Validation list

I faced a problem where I had a worksheet where in column A there were items I wanted to use as source for validation list in another column. But these items were not unique, therefore they appeared in the validation list not just once. So I used the solution presented below to automatically create a unique list in a spare column and assign that list as the source of data validation drop down list for a specified cell range Continue reading

ABAP – Advanced debugging

SAPI believe that most of you know how to debug the basic report or class methods etc.

But things can become complicated when debugging is needed for a backround job, RFC function module or even some user-exit which is being triggered in an update task. E.g. when you update material master in ECC using MM02, you can’t easily debug all user-exits because they’re triggered in separate process independent on session you are currently running.

In this article I’d like to present several useful debugging tricks you can use in your more complex scenarios. Continue reading

ABAP – Currency conversions

SAPIn this article I’d like to show an easy approach on how to convert an amount given in one currency to another currency. Continue reading

ABAP – Debug CIF interface from ECC to APO

SAPIt it (almost) impossible to debug CIF interface on inbound side because the data being sent from ECC to APO is passed via RFC enabled functions which are called “remotely” from ECC. Therefore it is not possible to just put break point in target (APO) system and expect that debugger will start when you send data from source (ECC) system. Continue reading

ABAP – Treating different number formats

SAPYou might face a problem when users have number format set differently in their user profiles (TCode SU01, table USR01). By default there are 3 formats available and this can cause troubles when processing user entered data and converting it into internal SAP DB format. Continue reading

ABAP – Export Transport request to local file system

SAPAll development or customizing in SAP is written into a transport request unless it is a local object not intended to be transported ($TMP package). Sometimes it might be useful to backup your development but in SAP this task is quite complicated to export all programs, classes, standard texts, …

Therefore there is an option to export the whole development encapsulated on a transport request level. And that’s what this article is about – exporting development encapsulated in a transport request to local file system. Continue reading