Git Product home page Git Product logo

zquery's Introduction

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 ![image](https://user-images.githubusercontent.com/43263062/173181509-a89a329a-91c3-472f-b6c8-1e03d5a8970c.png)

Adding STATUS (Example)

Create status ![image](https://user-images.githubusercontent.com/43263062/173181999-c036f6f3-d361-475e-bb1a-0a7428fb585d.png)

You will be presented with the status screen, image

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

fill relavant Info and save. image

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

Status NameShort TextStatus Type
PF_9000Main StatusNormal Screen
PF_9100Query WizardDialog Box
PF_9200SettingDialog Box
STATUS9300Save OptionDialog Box

PF_9000

Application toolbar items
Function CodeTypeFunction TextIcon NameIcon TextInfo.TextField Name
NEWStatic TextNEWICON_ADD_ROWNew Tab
DEL_TABStatic TextDEL TABICON_REMOVE_ROWDelete Tab
separator Line
QWIZStatic TextQuery WizardICON_WIZARDQuery Wizard
separator Line
CHECKStatic TextExecuteICON_CHECKCheck
EXECUTEStatic TextExecuteICON_EXECUTE_OBJECTExecute
EXEC2PCStatic TextExecute to PCICON_WRITE_FILEExecute to Local File
EXEC2BGStatic TextExecute as JobICON_SYM_SPOOL_SERVERExecute as a Background Job
separator Line
SETTINGStatic TextSettingsICON_SETTINGSSettings
EXPStatic TextCOL/EXPICON_VIEW_EXPAND_HORIZONTAL
separator Line
MAX_ROW LW-MAX_ROW

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

PF_9100

Function CodeTypeFunction TextIcon NameIcon TextInfo.TextField Name
OK_QWIZStatic TextCloseICON_OKAY
CLOSE_QWIZStatic TextCancelICON_CANCEL

PF_9200

Function CodeTypeFunction TextIcon NameIcon TextInfo.TextField Name
OK_SETStatic TextContinueICON_OKAY
CLOSE_SETStatic TextCloseICON_CANCEL

Table

create a new table to hold saved queries.

ZTQUERY

FieldKeyInitial ValuesData ElementData TypeLength
MANDTXXMANDT
QUERYIDXXGUID_32
OWNERsyuname
TIMESTAMPTIMESTAMP
VISIBILITYCHAR1
VISIBILITY_USERSCHAR400
VISIBILITY_GROUPCHAR200
TEXTCHAR40
QUERYstring
Create a TCODE in se93 to call ZQUERY program screen 1000

zquery's People

Contributors

dwivedirahul44 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.