cancel
Showing results for 
Search instead for 
Did you mean: 

Ho to automate data extraction from KSB1 and GR55 transaction code

Former Member
0 Kudos

Hi All,

Can you please let me know if their is a way to automate data extraction from transaction code KSB1 and GR55. I have to extract data from 5 different servers .i.e different server for each region and again i have different controlling area codes in each region. Following are the details which i use to extract the data. It takes too long for me to extract data from all this regions and controlling area codes using my parameters. It's very time consuming so i want to automate this process. I am end user so i don't have any admin rights. Please let me know any workable solution asap.

Production areas : PNA for Americas, PSI for Asia Pacific and Japan, PGY for Germany, PIT for Italy and PEU for Europe

Controlling area codes in PNA : CAR for Argentina, CBR for Brazil, CMX for Mexico and CUS for USA. Same way there so may other controlling area codes for all other production areas

Period From 1 to 12

Fiscal Year : 2009

Cost Centre Group : G_6284

Cost Element Group : 1742000000

Please let me know in case you need more details.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

There are two possibilities.

1. Write e-catt code. i.e. record the steps in transaction SECATT and execute it. An example, [thread|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/9159] [original link is broken] [original link is broken] [original link is broken];

2. Write Query in SQVI, and execute.

You can ask your key user / development team to create these for you.

Regards,

Gowrinadh

Former Member
0 Kudos

Hi Gowrinadh,

I am unable to execute the transaction SECATT and SQVI from my end. I get a message that I do not have the authorization to execute the same. Please let me know a transaction code which can be used by an end user like me. I don't want to involve development team in this because they sit in a different location and usually they are not willing to entertain any such requests without a senior management approval and I don't want to get into all those things because it usually takes too long. for getting approvals or development team to work on such request. I have experienced this thing in past they took 1 and half to create only one transaction code. Is there any way i can automate the subject transaction codes for data extraction using a some others ways.

script_man
Active Contributor
0 Kudos

Hi abhay_547,

Maybe will help further the following link:

http://www.synactive.com/download/sap%20gui%20scripting/sap%20gui%20scripting%20userguide.pdf

Regards,

ScriptMan

Former Member
0 Kudos

Hi,

I am able to see the option script recording and playback in my SAP custom menu but it's freezed. I can't click on it. Can you please let me know what should i do in order to activate the same. Do I need to approach development team for this or it an installation issue.

script_man
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi,

I have read the scripting guide and I came across the below in the same.

"If the administrator has enabled scripting for end users, a given user can still disable it by setting the registry value UserScripting in key HKCU\SOFTWARE\SAP\SAPGUI Front\SAP Frontend Server\Security to 0. To enable scripting the user can set the key back to 1, which is also the default."

I have checked in the registry editer and by default the value of security is set to 1, which means the scripting recording and playback option should be active but still it's freezed. Please expedite.

script_man
Active Contributor
0 Kudos

Hi,

Here follows a translation from German:

SAP GUI (client) for Windows enable

Start SAP Logon and log on to the SAP server.

Click the button on the toolbar to adjust for Local Layout.

Click Options and then click the tab for the scripting.

Select the Enable checkbox for scripting.

Disable the checkbox for Notify when a script is assigned to an active GUI and the checkbox for Notify when a script opens a connection.

Save the settings and restart the SAP GUI again.

SAP-server enable

With the following procedure, you can enable scripting by the SAP client temporarily. The specified value in this way is lost when you restart the server.

Start SAP Logon and log on to the SAP server.

Start a transaction RZ11.

Enter sapgui / user_scripting in the window to manage the profile parameters.

Click on ads.

Click in the window to display the profile parameter attributes to change value.

Enter TRUE in the field for a new value.

Save the settings and log out from the SAP GUI.

Quit the SAP Logon.

Note:

If the server administrator edited the application server profile of the SAP system to sapgui / user_scripting = TRUE to include the scripting is enabled when you restart the server by default.

SAP provides an option to change the network connection mode at any server. The following two connection modes are available: high-speed connection (LAN) and connecting with a slow speed. Although Functional Tester works in both modes, the high-speed connection with a recorded script is played only in this mode. This also applies to other modes. They must reflect your SAP script in the same network connection mode, with which the script was recorded. It is recommended that the mode of "high-speed connection, as it offers a greater number of valid recognition properties.

Regards,

ScriptMan

Edited by: ScriptMan on Apr 13, 2010 12:32 PM

Former Member
0 Kudos

Hi,

Following are the things which I have done.

SAP GUI (client) for Windows enable : Done as mentioned in your post.

SAP-server enable : RZ11 Unable to execute this transaction code in SAP. I get an No authorization error.

Please expedite

script_man
Active Contributor
0 Kudos

Hi abhay_547,

I woud be try the script recording and playback (ALT / F12). The recorded script is for example under %userprofile% \ sapworkdir \ script1.vbs and can be started by double clicking from Windows Explorer. It is important to note that this script can be run without further only in the first mode.

Regards,

ScriptMan

Former Member
0 Kudos

Hi Friend,

Can you please let me know how to record the script and where exactly does it get saved. You have mentioned in the post to use ALT / F12 where should i use this key combination in SAP or in Windows. Can you please elaborate it for me step by step.