Home
What is ZQWKIGEN?
My whole life in programming was to make it easier to write programs in a relative quick way and error free compilation. I figured that most reports are identical and the only difference is the control breaks. My initial so called Cobol Program Code Generator consists of a top down skeleton program with control breaks named major, intermediate, and minor. I will do a global change of the breaks such as company for major, division for intermediate and department for minor. With little changes I can write an error free program in minutes without errors.
Pretty soon I graduated by just putting the element names to create a Cobol Program Generator. Needless to say it was a great tool, especially when you are press for time in finishing a project. I remember outbidding rival contractors or companies to do a system due to my low overhead.
ZQWKIGEN is an ABAP Program Code Generator that is used for AD HOC reporting. It will produce a no-frill report in seconds and download data to either an Application server or a Presentation server in ASCII format. COBOL and ABAP programmers will find that the structurally created ABAP source program helpful in understanding this 4th Generation Language.
ZQWKIGEN can handle up to three input tables. Tables can be a SAP, an Application server or a Presentation server.
ZQWKIGEN is composed of three (3) screens: a) The Table screen b) The Structure screen and c) The Logic screen.
The Table screen is the first screen that will appear when you execute the transaction. It is the screen that defines the tables to be processed. Tables could either be a SAP table, an Application server or a Presentation server. After you enter the table’s name and press F8, the Structure screen will display.
The Structure screen displays the checkboxes, fieldnames and short headings of the fieldnames. Just click the check boxes of the fieldnames to be processed. This screen passes the properties to the Logic screen.
The Logic screen is the heart of the program. You can still modify the screen here if you need to change how the sequence of the report looks, change the headings or adding another field not defined on the table (i.e. computations).
A GRAND TOTAL will be automatically produced for packed field types or if there is a “T” in the TOTAL FIELD column.
Packed fields coming from the Legacy system has to be converted to numeric first in order to be processed for arithmetic operation.
Remember that the control break that is being used here is ‘AT END”.
Make sure the keys used for Total Breaks are contiguous beginning with the first field. Example: 1st key – major 2nd key – intermediate 3rd key – minor These three (3) keys must be the first fields in the record. Otherwise you will get weird Total Breaks. This program will automatically arrange the keys so that the major will be the first key, etc.
Sometimes you will see a different format for currency in the examples. SAP is used internationally and the currency is displayed in the country’s appropriate format. SAP table TCURX defines the currency format. The program is capable of changing the currency by modifying the Language in the Logic Screen.
To summarize, ZQWKIGEN:
Generates simple, straight forward codes that are easily understood and modified.
Code generated program is based on Cobol Hierarchical structure and convention.
Can handle multiple input sources
Can adapt to the Country Currency Format
Has Arithmetic Calculation capabilities
Produces Pristine Formatting abilities
Has Totaling capabilities
Can download files to text or Excel format
Has the ability to access Application or Presentation Servers
Can access up to three Tables
Has Conditional Record Selections
Has the ability to change the Print Layout and Heading Titles
To see the Table screens and report go to: Screens
To see the demo screen go to: Demo