SAP - Selecting Columns - (Moved)

[djchaney3 0]

Hello all,

I am new to Autoit, I have been coding in VBA for a while now and now I am trying to do some .exe files. 

I am trying to write a program to do the following:

• open SAP
• Go to a company TCODE
• Once in the TCODE I need to hide Columns and Filter by one column

I am not sure how to select a column and hide it, or how to select it and apply a filter.

Here is my current code (I blocked out company data)

expandcollapse popup

#include <Constants.au3>
#include <SAP.au3>
;
; AutoIt Version: 3.0
; Language:       English
; Platform:       Win10
; Author:         
;
; Script Function:
;   Opens TCODE ZFAS within SAP.
;

;-Begin-----------------------------------------------------------------

; Open SAP
Run("C:\Program Files (x86)\SAP\FrontEnd\SAPgui\sapgui.exe /H/saperp.xxxxxxx.com")

; Wait 1 second to allow SAP to open
WinWaitActive ("[CLASS:SAP_FRONTEND_SESSION]","SAP",1)

Send ("UserName") 
Send ("{TAB}")
Send ("Password") 
Send ("{ENTER}")

; Attach to the session window
_SAPSessAttach("[CLASS:SAP_FRONTEND_SESSION]")

; Put the value "/nZFAS" into the command field.
_SAPObjValueSet("tbar[0]/okcd", "/nZFAS")
_SAPVKeysSend("Enter")

; Press the Multiple Selection button.
_SAPObjSelect("usr/btn%_PARBPL_%_APP_%-VALU_PUSH")

; Attach to the selection window
_SAPSessAttach("Multiple Selection for Work center")

; Put the Work Center into the lower and upper field.
_SAPObjValueSet("usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL_255-SLOW_I[1,0]","76")
_SAPObjValueSet("usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL_255-SLOW_I[1,1]","76R")

_SAPVKeysSend("F8")

; Attach to the session window
_SAPSessAttach("[CLASS:SAP_FRONTEND_SESSION]")

_SAPVKeysSend("F8")

Sleep (5000)

_SAPObjSelect

 

Any help would be appreciated.

[djchaney3 0]

1 hour ago, djchaney3 said:

Hello all,

I am new to Autoit, I have been coding in VBA for a while now and now I am trying to do some .exe files. 

I am trying to write a program to do the following:

• open SAP
• Go to a company TCODE
• Once in the TCODE I need to hide Columns and Filter by one column

I am not sure how to select a column and hide it, or how to select it and apply a filter.

Here is my current code (I blocked out company data)

expandcollapse popup

#include <Constants.au3>
#include <SAP.au3>
;
; AutoIt Version: 3.0
; Language:       English
; Platform:       Win10
; Author:         
;
; Script Function:
;   Opens TCODE ZFAS within SAP.
;

;-Begin-----------------------------------------------------------------

; Open SAP
Run("C:\Program Files (x86)\SAP\FrontEnd\SAPgui\sapgui.exe /H/saperp.xxxxxxx.com")

; Wait 1 second to allow SAP to open
WinWaitActive ("[CLASS:SAP_FRONTEND_SESSION]","SAP",1)

Send ("UserName") 
Send ("{TAB}")
Send ("Password") 
Send ("{ENTER}")

; Attach to the session window
_SAPSessAttach("[CLASS:SAP_FRONTEND_SESSION]")

; Put the value "/nZFAS" into the command field.
_SAPObjValueSet("tbar[0]/okcd", "/nZFAS")
_SAPVKeysSend("Enter")

; Press the Multiple Selection button.
_SAPObjSelect("usr/btn%_PARBPL_%_APP_%-VALU_PUSH")

; Attach to the selection window
_SAPSessAttach("Multiple Selection for Work center")

; Put the Work Center into the lower and upper field.
_SAPObjValueSet("usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL_255-SLOW_I[1,0]","76")
_SAPObjValueSet("usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL_255-SLOW_I[1,1]","76R")

_SAPVKeysSend("F8")

; Attach to the session window
_SAPSessAttach("[CLASS:SAP_FRONTEND_SESSION]")

_SAPVKeysSend("F8")

Sleep (5000)

_SAPObjSelect

 

Any help would be appreciated.

 

[djchaney3 0]

Did not mean to double post...

Meant to say I figured out the Filter, but not how to hide the other columns.

[JLogan3o13 1,637]

Moved to the appropriate forum, as the Developer General Discussion forum very clearly states:

Quote

General development and scripting discussions. If it's super geeky and you don't know where to put it - it's probably here.

---

Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums.

Moderation Team

[water 2,387]

Did you have a look at the SAP UDF to automate the SAP GUI?

[djchaney3 0]

Yes, I am trying to figure it all out.