Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

yes4sql

Hello,

I think you know the yes4sql program from the downloads section.

For those who don't know what I am talking about, here is a short description:

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

As there is no SQL interface in standard SAP that supports JOINS, this ABAP utility was developed to enable you to see JOINS within SAP to confirm or discover relationships and to see data side by side. The SQL interface brings out the linkages. The data is collected in an ALV grid. The file fewSampleSQLs.txt that is included in the download package provides examples.

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

So, I am trying to create this program in my system, I have copied the source code, but now I have to create a screen from a text file that looks like this:

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

  • SCREEN 100

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

%_DYNPRO

YES4SQL

0100

620

40

%_HEADER

YES4SQL 0100 0100 1 54192 36 0 0 27120 0G E 20040930020857

%_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.

I have created the screen, but I don't know how to import the source above. I tried the Upload\download utility, but it says that the file does not countain a screen.

How should I do it?

Thanks.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question