appendfile appendrow applyguiscript box boxsize breakpoint buttonsize cachefile call calljs calljsasync callvb callvbasync callvbs callvbsasync checkbox checkdate clear clearcallcache closecontrol closefile column columnheader columnorder columnsize columnwidth comment comparetext compress connecthtml control converttext copyfile copytext createstructure createtable

decimalseparator decrypt default del deleterow deletestructure deletetable disable dropdownlist encrypt enter fieldsize file gettableattribute getfieldattribute getgridvalues globaltextreplace goto / label historyupdate

icon if/else/endif ignorewarning image include inputfield insertrow leave link listimage localvaluehelp mark message noarearesize nodropdownlist noinput nogroupbox noleadingzeros noscrollbar notypeaheadsearch numerical

offset on openfile parameter playsound pos process processingoption pushbutton radiobutton radiobutton (IA) readfile readrow removefile renamefile replacetext required retry_on_error return returnvalues rfcconnect

savecontrol searchhelp selectdirectory selectfile screen set setactivetab setcursor setlefttab sort start statusmessage stop

tab table tablewidth text terminateprocess textbox textreplace tip title titleprefix titlesuffix using updaterow uppercase versionnumber webview windowposition windowsize

1 Change screen layout 2 Pushbuttons 3 Support data entry 4 Change and add texts 5 Add tips 6 Add images

1 Create InputScript 2 Test InputScript 3 Parameters and input fields 4 Fields on tab controls 5 Adding columns 6 Adding tables 7 Single-screen transactions 8 BAPI calls

1 Calling a VB.NET function 2 Debugging VB.NET 3 Display a Windows form 4 Embed ActiveX controls 5 Translating texts 6 Creating diagrams and charts 7 Communicate with external controls 8 Read cells of a grid control 9 Read data from an Excel worksheet 10 Reading and processing textfiles 11 Sending e-mails 12 Embedding Windows Forms

1 Call JavaScript 2 Debug JavaScript 3 Communication JavaScript / GuiXT

1 Call a VBScript function 2 Debug VBScript 3 External Controls: Word 4 Embed HTML 5 Reading grid cells 6 Javascript instead of VBScript

1 Display SAP data 2 Use derived values 3 Change SAP data 4 Check user input 5 Entry tables 6 Tabs 7 Navigation 8 Dialogs in the ABAP class library 9 Display and upload documents 10 Tables in the expanded detail area 11 Display tables separately 12 Typical extensions

Customizing SAP Screens

Adding columns (14 min.) Merging screens (1) (23 min.) Merging screens (2) (21 min.) Display tabular data (33 min.) Using SAP Query for data retrieval (19 min.) Single Screen Mode for MM01 (50s min.)

Using Excel VBA and Charts (46 min.)

Introduction (12 min.) WYSIWYG Mode (10 min.)

Introduction (5 min.) UI process comparison (5 min.) User menu generation (5 min.)

Overview (5 min.) Introduction (51 min.) Fiori Launchpad (05 min.) ABAP Debugging (08 min.)

Simplify a selection screen Toggle between 'simplified' and 'standard' Read the content of an ABAP list Read and write strings in a list Submit a report and read the output Use SAP Query for data retrieval

Use the text edit control Create tabs Capture a screenshot of a control Provide drag&drop functionality Create wrapper for controls Using the DataGridView Create and embed barcodes Handling Keyboard inputs in own control

Get current date and time Get server date and time Get UTC date and time Check that a string is a valid date Date calculations Calculate beginning and end of month Convert a date to format YYYYMMDD Convert a date from format YYYYMMDD Check that a date is in the past Check that a date is a working day Check that a date is a factory working day Determine the week for a given date Next working day Add or subtract working days Calculate a time difference Next factory working day Verbose date format Verbose date format via VB Date input

Dynamic screens and menus Using dynamic coordinates Suppress superfluous columns in a table Dependent drop down lists (GuiXT) Dependent drop down lists (VB.NET)

Send an e-mail with callVB

Embed an HTML menu Embed an HTML dialog HTML files from SAP Repository Use variables in a URL Visualize data with WebGL Refresh a screen automatically Draw charts with javaScript frameworks Embed Fiori Apps

Create a temporary file Read file properties Delete a folder Copy files to the clipboard Print a document Read a zip file Read a random line of a text file Fetch files from an SFTP server Transfer a binary file

Clear variables at start of transaction Show own popup screen Execute OK-Code with field values Change the title during processing Using 'Enter' in a GuiXT script Display a processing message

Activation of GuiXT in SAP GUI Silent installation of GuiXT Silent installation of Script Editor Pro GuiXT Version bundled with SAP GUI Install the GuiXT utilities Use WebDAV for MIME Repository

JavaScript, VBScript or VB.NET? Testing after source code changes Reading a registry value Converting a floating point number Returning a function result Using JavaScript frameworks Arithmetic with GuiXT variables Calling VB.NET from JavaScript Calling VBScript from JavaScript Create a bar char Convert GuiXT table to array

Asynchronous Google Maps API Calculate distance between addresses Google Places Autocomplete

Check whether Excel is installed Read an Excel file Read and write Excel interactively Export table to Excel via .csv file Generate multiple Excel worksheets Embed Excel diagram Start an InputScript from Excel Read Excel as OLE Database

Generate an Outlook email

Generate a Word document Generate a Word document, multiple parts Word Automation via JavaScript

Export data to MS Project Import data from MS Project

Background information Built-in functions for the Grid Control Built-in functions for the Tree Control Built-in functions for the Toolbar Control Built-in functions for the Text Control Built-in functions for special screens Select a grid row Query selected grid rows Read a whole grid Trace the grid loading Select a tree node Read a whole tree

Consuming a simple OData service

Background information External and internal data formats Call \"bapi_salesorder_getdetailbos\" Call \"bapi_salesorder_simulate\" Call \"measurem_docum_read_last\" Call \"sd_shipment_delivery_view\" Call \"read_text\" and \"save_text\" Bundling calls Parallel processing Remote method call

Suppress the horizontal scrollbar Display sort indicator in table column Display status icons in a table column Drop-down list for a table column Saving the user settings

Display a PDF via a pushbutton Embed a PDF via a pushbutton Generate a PDF

Read data from a HANA database

Read an SAP table Read an SAP table via 'rfc_read_table' Use an outer join Use a CDS view Using the Open Call interface Using built-in SQL functions Reading searchhelp values Using complex selection criteria

RFC Security Checking the RFC configuration Configuration for SSO and SNC Central guixt.ini from SAPMR Implement your own function module Start a transaction in another system

Find the internal name of a column Read an ALV grid Upload Excel data to an ALV grid

Overview Read a grid control with ApplyGuiScript Upload Excel to an SAP grid control

Read data from an HTML viewer control

Scroll through a table Upload a CSV file Process all table columns Upload Excel interactively

Optimize the toolbar in Fiori theme Texts with fonts and colors Left-aligned pushbutton texts Drop down list with label Delete the active tab Enlarging an image Company logo in the SAP GUI title bar Images on pushbuttons Make a message more noticeable Multiselection

Additional selection criteria

Own function key assignment

Add leading zeros to a string Add leading zeros if numeric Delete leading zeros from a string Convert to uppercase/lowercase Split a string into two parts Remove trailing characters Remove leading characters Inverted commas in strings Search a substring

SSO logon Safety checks at logon Generate an Excel file Generate a Word document Dynamic tooltips Dynamic document title Transport table layouts

Table variable techniques Reading a .csv file Selecting rows of a table variable Row selection with regular expressions

Automated screenshots Transfer files to/from the SAP Web Repository Capture screen areas with GuiXT

Enhancing generated transactions Understanding the generated scripts Adding your own input data checks Restricting dropdown lists dynamically Enable or disable the UI logging onscreen

Translation of long texts

Consume a web service (via VB) Consume a web service (via JavaScript) Consume a web service (via CopyText) Recognize a form with Azure Integrate Watson Assistant

Position a control window at the edge Transparent background Reload a web page Hide scrollbars via JavaScript

GuiXT basics Screen elements and positions Scripts GuiXT window and editor GuiXT Profile Location of profile License file Scripts in SAP Web Repository Scripts in SAP MIME Repository Installation and Update Installation for numerous users User statistics User catalog Role specific user interface Multi language support RFC (Remote Function Call) Table handling Transaction variants Variables Deleting menu items Error analysis Generate a GuiXT system trace

InputScripts InputScript Debugger Input Recording Variables, Calculations, Comparisons System variables Search help for input fields Foreign key check and text display Function module /guixt/dbselect Function module /guixt/submitreport File handling in InputScripts Text handling Using tables in function calls

Input history Generating local value help Input Sets

Basics Control WebView CallVB CallVBasync CallVbs CallVbsAsync CallJS CallJSasync Class 'guixt' in VB Object 'guixt' in JavaScript and VBScript GUI Scripting in VB

Overview Installation ANSI- and UTF-8 codepages Insert Command WYSIWYG Editor Debugger Own code blocks for the ic menu GuiXT help for a keyword Display options for a keyword Display an include or a process= file Working with several files Pin window Further functions

Choose a font Choose colors Coloring presets Select/deselect backup feature Display line numbering Always save as ansi/unicode Remember windowsize and -position

Syntaxcheck Insert an SAP icon List included scripts Used variables in current path Display ActiveX Controls Compare files Show tree of elements Find in all scripts Screen elements Syntaxcheck all scripts in directory

Overview Installation Projects Transaction overview Single screen transactions Input value analysis Menu path analysis Error message analysis Search help analysis InputScript analysis Detailed list Technical list Administration

Functions Technology

Prerequisites Installation Guide Using the SAP Web Dispatcher

Introduction System Requirements Data Model Comparison Technical Migration Steps Data migration: CIS visit reports Changes in Customizing Objects Testing and Validation Best Practices & Recommendations Developer Notes CIS mobile Adaptations Reference & Technical Appendix

Performance Overview Customer Lists

General Company address and logo Logon screen Logon tickets Administrators Defining 'My customers' Product images Price conditions GUI Layout

SAP RFC Connection SAP GUI Logon SMTP Server Exchange Server

Sales Area Company Code Credit Control Area Dunning Area Holiday Calendar Report for Conditions Order/Offer Types Partner and Relations Notification Type Archive Country and Language Preselections Customer Hierarchy SAP Standard Text Length Material Number

Activities Contact Person

Defining Campaigns

Overview & functions Settings and system integration

Plants Work Center Planning Board Order Types User Status Language Selection E-Mail Adress Activity Types Storage Locations Movement Types Contact Person

Selection of Tabs Page Layout Sales Statistics Default Search Values Length of List Parameters for Selections CSS Stylesheets

General SAP authorizations Server Id

General CIS ABAP interface RFC Select interface BAPI and function units SAP GUI scripting ABAP reports

General Example Product text Example Production order Example Complaints Example Stock overview Example Logon tickets

General Example Sales Example Sales Chart Example Pricing Example Credit Overview Example Changes Example Expiring Offers Example Complaints Example Billing Due List

General Status Trace and Tuning

Overview

Server setup Development environment Local development Authorizations Useful SAP transactions

Pushbuttons Inputfields Outputfields Dropdowns Tabs Tables iFrames Hidden inputfields Statusmessages VS Code Snippets

Enter and sign measured values Release purchase requisitions

Quickstart Generating application parts Data binding Pushbuttons Search helps Tables Update on tables Layouts and filters Responsive web design Tabs Dropdown lists Multiple selection Charts and diagrams Speech output Build methods Validate methods Range tables Inline frames Barcode reader Static Fiori Tiles Dynamic Fiori Tiles

s10actionparameter s10addcss s10applicationlog s10build s10buildcolumns s10buildcsv s10classname s10clear s10columnheader s10confirmation s10contextinfo s10copy s10databaseread s10databaseselect s10delta s10dialog s10dropdownlist s10errormessage s10exitdialog s10fieldhelp s10fieldlabel s10folderlist s10fromcontextinfo s10getddic4text s10getuservalue s10getvalue s10historyid s10infomessage s10init s10link s10localize s10logerror s10loginfo s10logwarning s10messagetext s10nextscreen s10objectbyname s10readcss s10readhistory s10rebuild s10removecss s10setfocus s10setlicense s10setuservalue s10sort s10standardname s10userinput s10validate s10writehistory s10writestring

S10ActivateTab S10Apply S10Busy S10DownloadTable S10DropdownSelectAll S10Enter S10ErrorMessage S10FilterTable S10InfoMessage S10Language S10Logon S10Logoff S10Path S10SetColorscheme S10SSO S10ToggleDetail S10Upload S10UploadData