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
What is the use of Custom Extractor in SAP R/3 system?
In order to extract data from tables, you need to follow steps:Create a View of the required table from where the data needs to be extracted or view over multiple joined tablesNavigate to Transaction SE11 and Select option 'View'. It will ask for a name, name it something like 'View_TableName'.Select which all the fields of the tables needs to be extracted and click on activateGo to Transaction RS02 and create a transaction extractor and name it something like 'Trans_TableName'Specify the position of the created extractor in the component hierarchy.If you want to provide descriptions, add it. Specify the view name ...
Read MoreJShell in Java 9?
JShell is a new concept introduced in Java 9 version. It provides Java with REPL (Read-Eval-Print-Loop) ability. By using JShell, we can test the java-based logic and expressions without compiling it. REPL acts as an immediate feedback loop and has a great effect on productivity in that particular language.Step 1: Open Command Prompt and type JShell.Microsoft Windows [Version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C:\Users\User>JShell | Welcome to JShell -- Version 9.0.4 | For an introduction type: /help intro jshell>Step 2: Type /help (to view JShell commands) in the JShell command window once it starts running.jshell> /help | Type ...
Read MoreAccessing 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 More