ABAP Custom code generator dynamic pattern: ZCODEGEN

Posted by -

 In My last post about ABAP editor custom dynamic patterns. I talked about how to create new custom patterns to help you speed up various aspects of your day to day development.

Today I wanted to share with you a Custom dynamic pattern Utility that I built.

Here is what it looks like:

Starting the pattern:

ABAP Editor Custom Dynamic pattern ZCODEGEN

The UI:

ABAP Editor Custom Dynamic pattern ZCODEGEN UI

Features:

You can declare:
 Types - With auto data declarations(Global/Local) 
 Data 
 Selection Screen - with Validation
 Basic SQL queries
 Setup Config to change prefixes of generated code.

Here is an example of generating a simple report to fetch data based on MATNR from MARA.
Declare Types:

ABAP Editor Custom Dynamic pattern ZCODEGEN Declare Types

Press the get fields button:
ABAP Editor Custom Dynamic pattern ZCODEGEN Get fields




Select field and copy:
ABAP Editor Custom Dynamic pattern ZCODEGEN SElect fields



Set data declaration checkboxes
ABAP Editor Custom Dynamic pattern ZCODEGEN set auto declaration


Move on to the selection screen tab.
ABAP Editor Custom Dynamic pattern ZCODEGEN Selection Screen Tab


Get fields to choose from as a selection screen.
ABAP Editor Custom Dynamic pattern ZCODEGEN choose selection screen Fields


Select field and copy and set obligatory and check table.
ABAP Editor Custom Dynamic pattern ZCODEGEN Copy Selection Screen Fields




Move to the SQL tab.
ABAP Editor Custom Dynamic pattern ZCODEGEN SQLTAB


Select fields for queries either directly or from local declared types, some for where condition and other semantics.

ABAP Editor Custom Dynamic pattern ZCODEGEN SQLTAB add fields


Hit OK.

ABAP Editor Custom Dynamic pattern ZCODEGEN Generated Code


This is just a small example of how to use the utility. 

Here is the link to the source. ZCODEGEN

Use it as it is or modify it to suit your needs.

As Always, Hope you like the post and use this information in your day to day work.

Popular posts from this blog

ABAP convert internal table to excel (.xlsx) format and Send email or download

Posted by -
Reporting is incomplete without file interfacing. Sometimes the requirement is to send a file via email or download it to a PC. but what to do when the user requests the file in XLSX format? In today's post, I am sharing how to convert an internal table to .xlsx format and then send it to a PC or email. One of the quickest ways I found it been done is using SALV classes. Below is the Code snippet Now once you have the xstring with you, simply pass it to relevant libraries to handle the output. Downloading to PC: Sending via Email It's that simple. Hope you like the post and use it in your day to day work.
Read more

ABAP read excel(.XLSX) file to internal table in ABAP using CL_FDT_XL_SPREADSHEET

Posted by -
You are given a requirement to upload data to a custom DB table where the user provides you with the file path of the excel on his PC and the report loads the data from it to the Custom table. For experienced Abapers, the requirement is quite straightforward, except that the user wants to upload an XLSX file. There are not many options to read data from XLSX/XLS file. The TEXT_CONVERT_XLS_TO_SAP  function module is one of them but is a performance killer and uses OLE. In this post, I wanted to showcase How we can read data from the XLSX files using CL_FDT_SPOREADSHEET class. Let's start with uploading the file. Now that we have the file in xstring table, let's pass it to CL_FDT_XL_SPREADSHEET to get its object reference. From the object reference, we can retrieve each worksheet data. The data is returned in the form of an anonymous data object which can be dereferenced into a field symbol and passed to the target internal table. Below is the cod
Read more

Application Logging in ABAP

Posted by -
Image
Whether you are working with integration or a critical application or a complex report, logging becomes an obvious choice and activity.  Traditionally, Abapers have been logging information using a custom DB table defined specifically for a particular application. While useful, The approach has some flaws,      - Every application needs to have its own logging table      - Record purging/archiving needs to be set up in order to make sure old records are either deleted         or archived.      - There is no reusability of either the setup or the logic to log. With the introduction of Application Logging from SAP, the traditional approach can be left out.  In this post, I will be talking about how we can leverage the SAP application Logging Library to make logging easy. What is an application log? An application log is a rich type log. It contains information like User, Time, Expiry date of the log along with the actual message raised by the
Read more