WebDynpro 4 ABAP – Open Excel sheet from DMS

SAPIn this article I’ll show you how to retrieve an Excel sheet from SAP DMS (Document management System) where it is stored as “original” in a Document container. Continue reading

ABAP – NO-BREAK space (U+00A0)

SAPThis is just a note that you should be aware of using different kind of space character.
The classical space – you can type it by pressing spacebar – has unicode number U+0020.
The NO-BREAK space character is different – you can type it by pressing ALT+255 – this character will look the same like normal space but in unicode it will have number U+00A0. Continue reading

ABAP – Using dynamic variables in program selection screen variants

SAPI believe you once had to solve a requirement (if not, you’ll definitely receive one in future) where you had to design a SELECTION-SCREEN parameters which value has to be dynamically updated according to results of the program – eg. last processed IDOC number, Purchase/Sales Order number or just the last date when the report was executed. Continue reading

ABAP – CALL TRANSFORMATION to and from Excel using XLST

SAPThis article is here to show you how to export data from ABAP internal table to XML accepted by MS Excel using XSLT transformation. In second part I’ll show the backwards transformation – Excel to ABAP internal table.

Continue reading

Design Patterns in ABAP – Observer

SAPObserver design pattern can be easily demonstrated on a chat service where you have a server and several clients (observers). Once a client sends a message, server receives it and RAISES an EVENT (eg NEW_MESSAGE_RECEIVED) which is OBSERVED by all connected clients (observers) and such message is subsequently displayed in message dialog on all clients. Continue reading

ABAP – ITAB and CLEAR vs REFRESH vs FREE

SAPI experienced lot of confusion when I faced internal tables with header lines during my professional life. Therefore I strongly advice NOT to use internal tables with header lines. But they are heavily used in older programs so it’s good to know what is the difference between how to clear the header line and how to clear the itab contents and how it is different from internal tables WITHOUT header line. Continue reading