topic Re: SQL Tool for ABAP Programmers in Application Development and Automation Discussions

SQL Tool for ABAP Programmers

Former Member — Tue, 30 Jan 2007 02:21:03 GMT

Hi,

I found a tool at SDN's Downloads > Web AS > SQL Tool for ABAP Programmers . I can not able to create the screen from the screen_0100.txt file. Please let me know how to create the screen from this data.

Thank you,

Surya.

Re: SQL Tool for ABAP Programmers

Former Member — Tue, 30 Jan 2007 08:29:09 GMT

Hi Surya,

this file look like file for screen upload (in ScreenPainter Utilities->upload/download->upload). But, I have try to load it in 4.6c and 4.7c and I have got a message "File does not contain a screen". Try it by your system.

Regards

Bogdan

Re: SQL Tool for ABAP Programmers

Former Member — Tue, 30 Jan 2007 14:32:33 GMT

Hi Bogdan,

Even I am receiving the same error message 'File does not contain a screen'. Mine is ECC 5.0. Looking into it, if you find anything on this let me know.

Thank you,

Surya.

Re: SQL Tool for ABAP Programmers

Former Member — Tue, 30 Jan 2007 14:39:40 GMT

normally in SE51 u have a screen and associated code. now when ur using the same may be the screen is missing...when u download normally the code gets downloaded and not the screen.

so, it is advisable to go to SE51 and create the screen and then use the associated code.

Re: SQL Tool for ABAP Programmers

Former Member — Fri, 02 Feb 2007 15:35:50 GMT

How to read the entries in the file screen_0100.txt ? So that we can create the screen manually. Any help is appriciated.

thanks,

surya

Re: SQL Tool for ABAP Programmers

Former Member — Fri, 02 Feb 2007 16:07:27 GMT

hi Surya,

From the txt file, it seems we need to create a screen with the following elements.

1 input field of type INT4. (name - ROWS)

1 checkbox (or single char input field) (name - ISOPEN)

1 Container Control (name- MYEDIT)

The rest are either descriptions or labels (these are textfields/labels %#AUTOTEXT001, %#AUTOTEXT002, %#AUTOTEXT003).

So i think you can now create this screen..0100.

Hope this helps,

Sajan Joseph.

<b>Also, you need to name the ok_code field as G_OK_CODE .</b>

Message was edited by:

Sajan Joseph

Re: SQL Tool for ABAP Programmers

Former Member — Fri, 02 Feb 2007 23:42:03 GMT

Hi,

Very easy and simple to download and upload.

We have done this in our project to download from 4.6C and upload to ECC6.0. Now, open the screen which you want to download in edit mode.

If the Modification Assistant is set on, switch off that by going to the 'Edit' Menu-> Modification Operations.

Now go to Utilities->Upload/Download -> select Download. Save the contents as a text file on your desktop.

For upload:

SE51 -> enter program name and enter a new screen no. -> enter a title.

Again from Utilities ->Upload/Download->Select upload and select the text file to be uploaded.

Now you have the screen, save and activate.

You have to create your own GUI Status and GUI title. There is no way to copy these from system to system.

Regards

Subramanian

Re: SQL Tool for ABAP Programmers

Former Member — Mon, 05 Feb 2007 18:53:44 GMT

Subramanian,

I have done the same way as you described for uploading the text file. But I am receiving an error saying 'File does not contain a screen'. Following is the txt file I am trying to upload. Please verify and let me know if any changes required.

****************************************************************

SCREEN 100

****************************************************************

%_DYNPRO

ZYES4SQL

0100

640

%_HEADER

ZYES4SQL 0100 0100 0 0192 36 0 0 27120 0G E 20070130142221

%_DESCRIPTION

ScreenYes4SQL

%_FIELDS

%#AUTOTEXT001 0 CHAR 9 00 00 00 30 00 1 3 0 0 0 0 0 0 Row Count X

ROWS X INT4 6 80 00 80 00 00 1 13 0 0 0 0 0 0 ______

%#AUTOTEXT002 0 CHAR 8 00 00 00 30 00 1 22 0 0 0 0 0 0 Open SQL

ISOPEN C CHAR 1 80 00 80 00 00 1 31 0 0 0 0 C 0 0 101

%#AUTOTEXT003 0 CHAR 20 00 00 00 30 00 1 36 0 0 0 0 0 0 Untick if Native SQL

MYEDIT 74 00 00 00 30 00 2 3 0 0 0 20 U 1 1 102

G_OK_CODE CHAR 20 80 10 00 00 00 255 1 O 0 0 0 0 0 0 ____________________

%_FLOWLOGIC

PROCESS BEFORE OUTPUT.

MODULE PBO.

PROCESS AFTER INPUT.

MODULE PAI.

thank you,

Surya.

Message was edited by:

Surya

Re: SQL Tool for ABAP Programmers

Former Member — Mon, 05 Feb 2007 22:22:59 GMT

Hi,

I could able to create the screen by using Sajan's help. But How to create Execute SQL and Exit buttons ?

Thank you,

Surya.