In Cadaxo SQL Cockpit Version 3.8 (Releaseinfos), it is now possible to generate an SAP® Gateway OData Service out of an ABAP Open-SQL Select Statement. Due to the newly added /CADAXO/ODATA Template, which is from now on available in Select Template wizard, the user can generate the OData Service based on the Select Statement, which the user previously displayed in the Cockpit. In the next steps, the User is guided through OData Template Wizard. In […]
Weiter lesenKategorie-Archive: SQL Cockpit – EN
SQL Cockpit Results Comparison with toggle feature (Cockpit version 3.7 onwards!)
Cadaxo’s SQL Cockpit already had a feature to compare outputs of the queries. This can be accessed as shown below Clicking on the highlighted button #2 above will direct us to the following „Data Compare – Mapping“ wizard After selecting desired mapping, click on Start comparison button. As shown in the following screenshot, we now have a new button (v3.7 onwards) on the menubar, „Toggle ALV Output“ Upon clicking this button, entries from the […]
Weiter lesenCadaxo SQL Cockpit Report Generation
One important (and cool) feature of SQL Cockpit is an ability to auto-generate ABAP reports directly from the SQL query entered in the cockpit. We illustrate below, one example of how this may be utilised As you can see from the code snippet and screenshot below, suppose we want to generate a report output that executes a relatively complex select query :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
SELECT but000~partner, but000~type, but000~bpkind, but000~bu_group, but000~bpext, but000~bu_sort1, but000~bu_sort2, but000~source, but000~xdele, but000~xblck, but020~xdfadr, but020~adext, but020~guid, but020~move_addr, but020~date_from, but020~address_guid, but020~addr_valid_from, but020~addr_valid_to, but020~addr_move_date, adrc~addrnumber, adrc~nation, adrc~title, adrc~name1, adrc~name2, adrc~name3, adrc~name4, adrc~name_text, adrc~name_co, adrc~city1, adrc~city2, adrc~city_code, adrc~cityp_code FROM but000 INNER JOIN but020 ON but000~partner = but020~partner LEFT OUTER JOIN adrc ON but020~addrnumber = adrc~addrnumber WHERE but000~partner IN &PARTNER& AND but000~type = '1' AND but000~bpkind = '' and but020~addr_valid_to = '99991231235959' AND but020~nation = '' AND adrc~title = '' AND adrc~name1 = '' AND adrc~city1 = 'Wien' . |
If you want to generate SAP report that executes this query, it […]
Weiter lesenLIKE & ESCAPE Feature in SQL Cockpit
Should wildcard characters be part of the search term? What should I do? The solution is very easy in our SQL Cockpit, LIKE statement must be told that for example ‘%‘ is understood as a simple character instead of wildcard character. This is done by placing a special character in front of it and specifying this character as an „ESCAPE character“ at the end of command. Example User wants to select the table line(s) which […]
Weiter lesenDomain Text Feature in SQL Cockpit
I don’t see the domain description in the result SQL statement screen? What should I do? The solution is very easy in our SQL Cockpit, there is an user setting with which the user can see not only the fixed value, but the description of the value itself. There is no need to manual check the description, in case it exists it is displayed in the result screen. Example The “Business partner category“ domain contains […]
Weiter lesenCode Completion und Elementinfo im SQL Cockpit
Heute habe ich beim Testen ein für mich völlig unbekanntes Feature im SQL Cockpit entdeckt. Und das soll was heißen, bin ich doch einer der Entwickler hinter dem Tool und glaubte eigentlich alle Features zu kennen. Jedenfalls gibt es im SQL Cockpit eine sogenannte Elementinfo. In dieser sieht man einfach die Struktur zu einer Datenbanktabelle oder einem CDS View. Die Elementinfo wird automatisch ermittelt, sobald man mit dem Cursor für knapp eine Sekunde auf einer […]
Weiter lesen