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 on Trending Technologies
Technical articles with clear explanations and examples
Accessing table data from SAP system
Using Select statement you can read data with a dynamic table name. Try using below code &areDATA: lv_tablename TYPE string, ev_filelength TYPE i. lv_tablename = 'mara'. "e.g. a parameter DATA dref TYPE REF TO data. CREATE DATA dref TYPE TABLE OF (lv_tablename). FIELD-SYMBOLS: TYPE ANY TABLE. ASSIGN dref->* to . SELECT * FROM (lv_tablename) INTO TABLE .
Read MoreUsing 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 MoreEquivalent for Row_Number() in SAP ABAP
When you want to modify the contents and store them into table and also to add a column for the value, use something likeDATA: my_string TYPE StringLOOP AT itab INTO wa_itab. my_string = sy-tabix. CONCATENATE some_text my_string more_text into wa_itab-my_field. MODIFY itab FROM wa_itab. CLEAR my_string. ENDLOOP.
Read MoreHow can we compare data in two MySQL tables?
Sometimes we need to identify the unmatched data from two tables, especially in the case when data is migrated. It can be done by comparing the tables. Consider the example below in which we have two tables named ‘students’ and ‘student1’.mysql> Select * from students; +--------+--------+----------+ | RollNo | Name | Subject | +--------+--------+----------+ | 100 | Gaurav | Computer | | 101 | Raman | History | | 102 | Somil | Computer | +--------+--------+----------+ 3 rows in set (0.00 sec) mysql> select * from student1; +--------+--------+----------+ | RollNo | Name | Subject | ...
Read MoreUsing fast mode in Sybase bcp
In Sybase, when you have indexes on tables it affects transfer speed. When bcp is used on such tables, it automatically uses its slow mode and logs data is inserted in the transaction log. These logged inserts can cause the transaction log to become very large.To control this data excess and ensure that the database is fully recoverable in the event of a failure, you can back up the log with dump transaction.Note that bcp does not fire any trigger that exists on the target table. Fast bcp logs only the page allocations. For copying data in, bcp is fastest ...
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 MoreBinding model to sap.ui.core in SAP UI5 application
Please try below where you need to prefix propertyBinding with models name −var oItemTemplate = new sap.m.ActionListItem({ title : "{checks>title}", ... });
Read MoreUsing sy-datum low and high in ABAP Program
In this code, you have used ‘BT’ i.e. between so select option will hit any date between today and YYYYMMDD ‘99991231’.You should declare high dates at INITIALIZATION so that it is visible on the selection screen and you can change it if required.select-OPTIONS: so_date FOR sy-datum. INITIALIZATION. so_date-sign = 'I'. so_date-option = 'BT'. so_date-low = sy-datum. so_date-high = '99991231'. APPEND so_date.
Read MoreParsing SAP Logon ticket with .NET
SAP provides SAP SSO EXT Lib for parsing SAP Logon ticket. SAP SSO EXT library supports SAP logon tickets as a part of the java based application.You can download SAP SSO EXT library from SAP service marketplace http://service.sap.com/swdc and then search here for SAPSSOEXT.
Read MoreIn SAP UI5 render calling two times in custom control
In your custom control, there are two aggregation updates- setAggregation and addContent. When you use Aggregation mutators, it uses 3rd parameter to suppress invalidation.It will insert the aggregation but suppress the invalidation since whole control will be rendered at the end it.oControl.setAggregation("layout", oSavedButtonHLyt, true); // suppress invalidateYou should think that It should work same for “addContent”.oSavedButtonHLyt.addAggregation("content", manageSavedSearch[index], true);However, it doesn’t work as UI5 cannot determine automatically for the previous parent's suppress cos its aggregation will be moved. You have to note that property, aggregation or an association invalidates control when control does not overwrite its mutator method.
Read More