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
SAP Articles
Page 40 of 91
Using ABAP Function module RSAQ_REMOTE_QUERY_CALL, NO_DATA_SELECTED exception using selection parameters
As SAP provides flexible options that allow selection parameters easy to use. As you are using multiple parameters please note the following:Set KIND to “s” only for using select option. If you are using parameters, it should be “P”Instead of using EN, try using internal language “E”RSAQ_REMOTE_QUERY_FIELDLIST- this function module can be used to find the types as below −Use T-code SE37 and enter the FM name → Display
Read MoreABAP dump while creating an entry in SAP system using SAP JCO
This seems to be a problem at ABAP side and not Java side. This is an ABAP dump and you need to useTransaction code: ST22 on ABAP backend to check functional module inSAP system.Once you get the exact details of ABAP dump you are getting, you need to edit the calling method to create an entry.
Read MoreExtracting data from SAP HANA database and load to ORACLE database
There is a number of ways you can achieve this. Here are few of the methods to do the same.a) There are many standard tools in SAP by use of which you can extract the data and also automate the whole process. With the use of an ETL tool, this can be achieved like SAP Data Services, OWB, etc.b) The other option is to write a code in ABAP to fetch the data from the database and the write into a format as per your requirement.c) You can also write a RFC or remote-enable function module which can be called ...
Read MoreReplacing multiple occurrence by a single occurrence in SAP HANA
The code you are using \1+ just removes consecutive occurrences only. You can use the below code.SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL) FROM DUMMYThe output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.
Read MoreUsing Breakpoint in SAP system
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.
Read MoreConcatenate 2 strings in ABAP without using CONCATENATE function
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
Read MoreGetting error- Hard-coded logon parameters not allowed when using a Destination Configuration while connecting to SAP server dynamically
You can try below sample code. I would suggest you to try using this:public class Program { static void Main(string[] args) { SapConnection con = new SapConnection(); RfcDestinationManager.RegisterDestinationConfiguration(con); RfcDestination dest = RfcDestinationManager.GetDestination("NSP"); RfcRepository repo = dest.Repository; IRfcFunction fReadTable = repo.CreateFunction("ZSOMA"); fReadTable.SetValue("I_NRO1", 1); fReadTable.SetValue("I_NRO2", 2); fReadTable.Invoke(dest); var result = fReadTable.GetValue("E_RESULT"); Console.WriteLine(result.ToString()); Console.ReadLine(); } } public class SapConnection : IDestinationConfiguration { ...
Read MoreWhile using SAP .NET connector, I am an getting error: Could not load file or assembly 'sapnco' or one of its dependencies.
You can try any of the below fixes −Go to Run > RegeditOpen “HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\1X.0\WebProjects” and change Use64BitIISExpress from 0 → 1Next is to restart Visual Studio and IISExpress.Other solution would be to try configuring IIS service, and set appPool .Net 4.0. You can try this to fix sapnco dll issue.Go to IIS Manager → Application PoolsOther fix would be to navigate to Project/Properties → Set platform target from “any” to “x86”.
Read MoreMissing SAP Java Connector libraries JCo- librfc32.dll, com.sap.utils and com.sap.mw
Please note that all these library files - librfc32.dll, com.sap.utils and com.sap.mw come under JCo 2.1. With release of JCo 3.0, it’s classes were also relocated from packages com.sap.mw.jco.* to com.sap.conn.jco.*For running with SAP JCo 3.0, you need these files at runtime - sapjco3.jar and sapjco3.dll (on Windows). You can follow below procedure for installation of JCo files:Installing JCo on Windows platform −In Windows OS, you have to copy sapjco3.jar file into ITDI_HOME/jars/3rdparty/others.Copy the sapjco3.dll file into ITDI_HOME/libs. On Windows, JCo 3 requires additional Microsoft Visual C++ 2005 libraries to be installed. Installation details for the package that contains these ...
Read MoreUsage of Operator +n and (n) to pass data in ABAP
If my date format is in the form DDMMYYYY then Z_Period(4) equals DDMM so (4) means first four characters.If my date format is in the form DDMMYYYY then Z_Period +4 equals YYYY so +4 means after the first four characters.So If I say Z_PERIOD+2(2) then this would result MM- i.e. 2 characters after first 2.Let us see how to use them in a program −\Sample program to understand use of +n and n bit operators data: lv_text(10) type c. lv_text = "World". write: / lv_text+2(2).Output of this code would be “rl”“+n” specifies a string offset“n” specifies length of the ...
Read More