Found 1044 Articles for SAP

Setting up a JDBC connection to remote SAP HANA system

Manikanth Mani
Updated on 05-Dec-2019 09:36:57

752 Views

You are using the correct Port number for instance number “00”. Port number 300315, here 00 represents instance number of your HANA system.Try using HANA client jar file ngdbc.jar instead of SAP Jar file.try {    Class.forName("com.sap.db.jdbc.Driver");    String url ="jdbc:sap://xx.x.x.xxx:30015/DBNAME"; //IP Address of HANAsystem followed by Port number    String user ="user";    String password = "password";    Connection cn = java.sql.DriverManager.getConnection(url, user, password);    ResultSet rs = cn.createStatement().executeQuery("CALL Test.STORED_PROC");    // ...Enter the action here } catch(Exception e) {    e.printStackTrace(); }

Changing Parameters on the screen in SAP

Arjun Thakur
Updated on 30-Jul-2019 22:30:20

308 Views

You can do this by going to Menu.Navigate to Goto->Text Elements->Selection Text

Handling errors in SAP GUI Scripting code

Ayyan
Updated on 12-Jun-2020 13:58:32

1K+ Views

You can take reference from GUI Scripting help section and it can explain things in detail.It provides you default property types as per requirement. If you want to perform next step, stop or abort user step, you can use the following properties.ValueDescriptionSSuccessWWarningEErrorA Abort I  InformationSee the below code that uses above property type to display different messages −Public Sub get_status_bar_value_exit_if_Error()    Dim usr_resp AsString    If(session.findById("wnd[0]/sbar").messagetype = "E"Or       session.findById("wnd[0]/sbar").messagetype= "W") Then    usr_resp =MsgBox(session.findById("wnd[0]/sbar").Text & Chr(13) &"Show the Error in SAP ?", vbYesNo)     If usr_resp =vbYes Then  Else     Callgo_to_Sap_home  End If  End  End If End ... Read More

Incrementing an integer inside loop in an ABAP program

Fendadis John
Updated on 30-Jul-2019 22:30:20

574 Views

You need to use the following:You are missing spaces between ls_id+1. You can also use Add 1 to ls_idIn case you are using internal tables, you can directly use SY-TABIX and SY-Index depending upon whether the loop is nested or not.

I am getting GUID Key columns truncated while using proxy ERP tables to query SAP tables

Alankritha Ammu
Updated on 06-Dec-2019 11:12:59

120 Views

I think there is a restriction in SAPand when you use default functional module it only shows 16characters.To overcome this you should install Z module in SAP system and you can activate it by entering the name of LINQ table.Custom function "Z_XTRACT_IS_TABLE"

How to check all objects belong to list of TR’s in SAP system

varma
Updated on 10-Dec-2019 08:33:06

5K+ Views

SAP provides standard tables that you can use to get the detail about Transport objects.E070: Change & Transport System: Header of Requests/TasksE070T: Change & Transport System: Short Texts for Requests/TasksE071: Change & Transport System: Object Entries of Requests/Tasks (This table provides you details of transport objects).E070A: Change & Transport System: Attributes of a RequestE070C: CTS: Source/Target Client of Requests/TasksTo open any of the table, you can T-code: SE11 Enter table E071. You can group result in Grid Display by PGMID, OBJECT, and OBJ_NAME.

Using Breakpoint in SAP system

Jai Janardhan
Updated on 14-Feb-2020 05:36:30

138 Views

There is a problem with your code. Here is the correct syntaxSyntaxBREAK username.If you want to implement it for all the users you can just codeBREAK-POINT.

Checking active process in SAP system and which code is running

George John
Updated on 30-Jul-2019 22:30:20

2K+ Views

There are a couple of Transactions- SM66 and SM50 that can be used for your requirement. The transaction SM66 is used to see all the active processes on the current system. You can choose a particular process you want to monitor by clicking on “process” and then click the “debugging” button. The Transaction SM50 shows only the process running on a current application server in which you are logged. To monitor your program, select “Administration”, then “program” and then debugging option. You would require finding out the process in which your program is running. This can be done by ... Read More

Concatenate 2 strings in ABAP without using CONCATENATE function

Moumita
Updated on 14-Feb-2020 05:32:25

3K+ Views

In ABAP you can use && sign to concatenate variables as belowDatahello TYPE string, world TYPE string, helloworld TYPE string. hello = 'hello'. world = 'world'. helloworld = hello && world.If you want to concatenate strings directly, you can usehelloworld = 'hello' && 'world'.If you want to keep space in between, you would require ` symbol as belowhelloworld = hello && ` and ` && world

Assigning debug roles to few users of SAP ABAP program

Anjana
Updated on 06-Dec-2019 11:14:34

589 Views

Hope the role that you have added contains only one permission:Object S_DEVELOP    ACTVT = 03    DEVCLASS = *    OBJNAME = *    OBJTYPE = DEBUG    P_GROUP = *Try to perform a permission trace usingTransaction ST01If you still don’t find a check for the permission, there might be a problem in generating roles in the system. Sometimes when you add a role, it might add a different set of roles to such users.There might be a different program written for Debugging. This can be checked using Transaction SU53 in the system. This can be used to display authorization data for user:

Advertisements