Hello,
I'm facing problem when try to copy data from excel. As it is a large data in column "A" I need to use the clipboard option in transaction FBL3N. Unfortunately it does not work. I know that Copy Past in SAP does not work. However I do not know how to insert values (existing in Excel) to SAP.
Here is my SAP script
Session.findById("wnd[0]/usr/ctxtSO_BUDAT-HIGH").SetFocus
Session.findById("wnd[0]/usr/ctxtSO_BUDAT-HIGH").caretPosition = 10
Session.findById("wnd[0]/tbar[1]/btn[16]").press
Session.findById("wnd[0]/usr/ssub%_SUBSCREEN_%_SUB%_CONTAINER:SAPLSSEL:2001/ssubSUBSCREEN_CONTAINER2:SAPLSSEL:2000/ssubSUBSCREEN_CONTAINER:SAPLSSEL:1106/btn%_%%DYN007_%_APP_%-VALU_PUSH").press
Session.findById("wnd[1]/tbar[0]/btn[16]").press
Session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/txtRSCSEL_255-SLOW_I[1,0]").Text = "1000" - there should be a list of docs
Session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/txtRSCSEL_255-SLOW_I[1,0]").caretPosition = 10
Session.findById("wnd[1]/tbar[0]/btn[8]").press
Please help
I'm facing problem when try to copy data from excel. As it is a large data in column "A" I need to use the clipboard option in transaction FBL3N. Unfortunately it does not work. I know that Copy Past in SAP does not work. However I do not know how to insert values (existing in Excel) to SAP.
Here is my SAP script
Session.findById("wnd[0]/usr/ctxtSO_BUDAT-HIGH").SetFocus
Session.findById("wnd[0]/usr/ctxtSO_BUDAT-HIGH").caretPosition = 10
Session.findById("wnd[0]/tbar[1]/btn[16]").press
Session.findById("wnd[0]/usr/ssub%_SUBSCREEN_%_SUB%_CONTAINER:SAPLSSEL:2001/ssubSUBSCREEN_CONTAINER2:SAPLSSEL:2000/ssubSUBSCREEN_CONTAINER:SAPLSSEL:1106/btn%_%%DYN007_%_APP_%-VALU_PUSH").press
Session.findById("wnd[1]/tbar[0]/btn[16]").press
Session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/txtRSCSEL_255-SLOW_I[1,0]").Text = "1000" - there should be a list of docs
Session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/txtRSCSEL_255-SLOW_I[1,0]").caretPosition = 10
Session.findById("wnd[1]/tbar[0]/btn[8]").press
Please help