Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Amit Sharma
Page 3 of 3
Using VBA macro to call an ABAP code
Please try using below script −Dim sapConn As Object \Declaring a connection object Set sapConn = CreateObject("SAP.Functions") \Creating an ActiveX object sapConn.Connection.user = "username" sapConn.Connection.Password = "xxxx" sapConn.Connection.client = "client#" sapConn.Connection.ApplicationServer = "Application Server” sapConn.Connection.Language = "PT" If sapConn.Connection.Logon(0, True) True Then //Checking connection here MsgBox "Not able to login to SAP" Else MsgBox "Login Successful !!" End If Dim rfcAcctDocCheck As Object Dim oAcctHeader As Object Dim otAcctAR, otAcctGL, otAcctAP, otAcctAMT, otReturn As Object Set rfcAcctDocCheck = sapConn.Add("BAPI_ACC_DOCUMENT_CHECK") Set oAcctHeader = rfcAcctDocCheck.Exports("DOCUMENTHEADER") Set otAcctGL = rfcAcctDocCheck.Tables("ACCOUNTGL") Set otAcctAR = ...
Read MoreOpen a Workbook require loading SAPBEX.xla file
Copy the below code in PERSONAL.XLSM module of your workbook and then refresh −Private WithEvents App As Application Private Sub Workbook_Open() Set App = Application End Sub Try adding below code, in your module: Private Sub App_WorkbookOpen(ByVal Wb As Workbook) MsgBox "New Workbook: " & Wb.Name End Sub
Read MoreGetting a carriage return of report field in SAP Crystal Report
You can make use of split as below −// To split the text on carriageLocal Stringvar Array lines: = Split( {table.field}, Chr(20) );// To return carriage 1 less than the number of linesLocal Numbervar delimiters := Ubound(lines)-1;Let us see one more example, how to use split to divide a string in different lines.stringvar array x := split({table.fullname}," "); x[1] stringvar array x := split({table.fullname}," "); if ubound(x) >= 2 then x[2] stringvar array x := split({table.fullname}," "); if ubound(x) >= 3 then x[3]This will split a string in 3 different lines like“Mr”“John”“Harper”
Read MoreControlling close events in SAP Business One Screen Painter
You can make use of SP_TransactionNotification, which is one of the most common way of receiving notification of data-driven events. With the use of SP_TransactionNotification, you can edit error code returned by Transaction notification, and also prevent transaction to committed.This shows how to prevent a purchase order from adding when the base document is not provided. You can make use of SBO_SP_TransactionNotification for Screen Painter forms in SBO to avoid null values.
Read MoreExporting test variant in Transaction SE37 in SAP R/3
Try using Table EUFUNC or also check Function Module: RS_TESTDATA_GET. When you save test data in SE37 it's going to be saved in test data directory.
Read MoreCan't create a Dictionary Object: View by adding two db tables
When you create a view, it is created on top of multiple database tables using an inner join. Note that basis table of database views should be transparent tables.To create a view on 2 tables, you have to enter the primary table you want to maintain and place the cursor in that field and click on the button below the list of tables and select the other table to add the view. If you are not getting this option, it means Relationship is wrong.To know more about database Views: https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenddic_database_views.htm
Read MoreError Message: Unsupported xstream found: ("HTTP Code 200:OK")" while consuming SAP Web Service
I think this is related to incorrect HTTP destination configuration. You can check Web Service using T-Code: SOAMANAGER to verify if HTTP destination is configured properly.
Read More