ZQUERY

Open SQL executing/testing application on SAP AS ABAP

Installation

Using saplink

Use NUGG_zquery.nugg

Manual

Upload files and screens to your system and add GUI status manually by following below provided instructions( SAP doesnt directly allow download/upload interface for GUI-statuses,you will abapgit or SAPLINK to download and upload them ).

GUI_STATUS

Adding GUI-statuses

Right click on program name and choose create -> Gui Status 

Adding STATUS (Example)

Create status 

You will be presented with the status screen,

add item to application toolbar, Add Fuction code to first Input: NEW select OK. Double click and select F5 or any function key of your choice and select OK.

fill relavant Info and save.

Below table contains list of Statuses/Items to be added:

Status Name	Short Text	Status Type
PF_9000	Main Status	Normal Screen
PF_9100	Query Wizard	Dialog Box
PF_9200	Setting	Dialog Box
STATUS9300	Save Option	Dialog Box

PF_9000

Application toolbar items

Function Code	Type	Function Text	Icon Name	Icon Text	Info.Text	Field Name
NEW	Static Text	NEW	ICON_ADD_ROW		New Tab
DEL_TAB	Static Text	DEL TAB	ICON_REMOVE_ROW		Delete Tab
separator Line
QWIZ	Static Text	Query Wizard	ICON_WIZARD		Query Wizard
separator Line
CHECK	Static Text	Execute	ICON_CHECK	Check
EXECUTE	Static Text	Execute	ICON_EXECUTE_OBJECT	Execute
EXEC2PC	Static Text	Execute to PC	ICON_WRITE_FILE	Execute to Local File
EXEC2BG	Static Text	Execute as Job	ICON_SYM_SPOOL_SERVER	Execute as a Background Job
separator Line
SETTING	Static Text	Settings	ICON_SETTINGS	Settings
EXP	Static Text	COL/EXP	ICON_VIEW_EXPAND_HORIZONTAL
separator Line
MAX_ROW			L			W-MAX_ROW

Create Separator line by right clicking on item Add Function keys as shown in image

PF_9100

Function Code	Type	Function Text	Icon Name	Icon Text	Info.Text	Field Name
OK_QWIZ	Static Text	Close	ICON_OKAY
CLOSE_QWIZ	Static Text	Cancel	ICON_CANCEL

PF_9200

Function Code	Type	Function Text	Icon Name	Icon Text	Info.Text	Field Name
OK_SET	Static Text	Continue	ICON_OKAY
CLOSE_SET	Static Text	Close	ICON_CANCEL

Table

create a new table to hold saved queries.

ZTQUERY

Field	Key	Initial Values	Data Element	Data Type	Length
MANDT	X	X	MANDT
QUERYID	X	X	GUID_32
OWNER			syuname
TIMESTAMP			TIMESTAMP
VISIBILITY			CHAR1
VISIBILITY_USERS				CHAR	400
VISIBILITY_GROUP			CHAR200
TEXT			CHAR40
QUERY					string

Create a TCODE in se93 to call ZQUERY program screen 1000