Sunday, July 26, 2020

Uipath Auto SAP login and access Tcode


The following is the step by step guide how to use UiPath to auto run SAP GUI, login in and run Tcode VA01.


Open UiPath, create a "Sequence". Drag the "SAP Logon" (under UI Automation -> SAP) to the Sequence"




Copy the connection description to "Connection Name"



Drag and drop "Get Secure Credential" step before the SAP Login



Type in the "Windows Credential" Name. Under User ID, press "Control+K" to create variable, name as "SAP_UID".  Under Password, press "Control+K" to create variable, name as "SAP_Pass"



Drag and drop "SAP Login"




Click on "Indicate on screen", then click on "SAP GUI" screen




1: Client : in your client ID (in my case is 100)
2: Username: press "Ctrl + Space" then choose variable "SAP_UID"
3: Choose "Secure"
4: Password: press "Ctrl + Space" then choose variable "SAP_Pass"
5: Language: "EN" for english



Note: this setting reflect the option for multiple login in SAP GUI





Click "Indicate on screen", then click SAP GUI




Drag "Call Transaction" to the design panel




1: Input the Transaction Code "VA01"
2: Click to open Option Menu
3: Choose "Edit Selector"



1: Un-check "title"
2: Click "Validate"
3: Click "OK"




Finally, press run. This will auto run SAP GUI, login in and run Tcode VA01


This is originated from UiPath Academy, SAP Automation. I strongly encourage you to sign up for UiPath Academy to know more detail.

Saturday, July 18, 2020

Loan Calculator : calculate monthly repayment and total interest to pay


Want to know how much you need to pay every month if you take up a loan? How much interest you need too pay in total for the whole loan period? You can use this loan calculator

Loan Calculator v1