SAP IRPA not all Sapscripts librery methods are available

[former_member627843]

I want to enter data into an FB60 transaction based on the data saved in the excel file.

How to capturethis transaction screen so that the SAPLFSKBTABLE object can then be seen as a table ?

How to enter data in the corresponding cells if the number of entries is dynamically variable.

Currently, I cannot use any of the Sapscripts methods for the table, e.g. recognized table, for table recognition, setCell, getRowCount etc.

[former_member282770]

Hi,

Were you not able to capture the screen in Studio?

Could you please give us more details. Please mention series steps (from beginning) you did for capturing, recognizing & defining the workflow so that i can reproduce and visualize the exact issue.

Regards,

Vinay

[former_member627843]

Hi

Due to lack of time, I had to abandon that project, but now I stopped at a similar one. how to click on a specific cell in the attached screen :

for example i must select row with ROBOT1_1000 Wariant.

[former_member627843]

I often have a problem with scrambling the screens in SAP GUI. One of them below. This is the screen for selecting the variant in the FBL5N transaction. the screen appears after clicking the tbar [1] / btn [17] button. IrpA does not recognize individual elements of this screen, it only sees the selected area of GuiCtrlGridView. I need to select (by clicking) one specific row in this table.image1.png

[stefan_schnell]

Hello Slawomir,

you can use SAP GUI Scripting seamlessly inside IRPA. It is a bit weird for an RPA solution, but it works. Record your activities as VBScript and use it inside IRPA, as I described here.

//-Begin----------------------------------------------------------------
		
var VBSCode = '                                                                            \n\
Sub SAPGUIScripting()                                                                      \n\
  Set SapGuiAuto = GetObject("SAPGUI")                                                     \n\
  Set application = SapGuiAuto.GetScriptingEngine                                          \n\
  Set connection = application.Children(0)                                                 \n\
  Set session = connection.Children(0)                                                     \n\
  session.findById("wnd[0]/titl/shellcont/shell").pressContextButton "%GOS_TOOLBOX"        \n\
  session.findById("wnd[0]/titl/shellcont/shell").selectContextMenuItem "%GOS_PCATTA_CREA" \n\
  session.findById("wnd[1]/tbar[0]/btn[12]").press                                         \n\
End Sub';


var MSScrCtrl =  ctx.activeX.create("MSScriptControl.ScriptControl");
MSScrCtrl.AllowUI = 1;
MSScrCtrl.Language = 'VBScript';
MSScrCtrl.AddCode(VBSCode);
MSScrCtrl.Run('SAPGUIScripting');


//-End------------------------------------------------------------------

This is an example how to use Generic Object Services (GOS), which also can not be automated with IRPA.

Best regards
Stefan