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 HANA Articles
Page 30 of 58
Distinguish SAP ABAP code between clients
You can use field “sy-mandt” to identify the client and then accomplish your requirement by doing something like below −IF sy-mandt = '002'. *do something for Client one ELSE. * do something for client two ENDIFThis field is included in almost all the tables which are client dependent so you can freely use this to fulfill your requirement.
Read MoreEntering a condition to perform SELECT in an existing report in SAP system
You have made one of the most common mistakes. In ABAP almost at all the places be careful with SPACE. You need to have a space in method calls so just have a space before and after the brackets as below −SELECT SINGLE * FROM EKPO WHERE EBELN = GT_MSEG-EBELN AND EBELP = GT_MSEG-EBELP AND NOT ( F1 = 'value' AND F2 = '0' )
Read MoreUsing &gt operators in SAP HANA
You probably need to use cdata sections in your query. The term CDATA means, Character Data. CDATA is defined as blocks of text that are not parsed by the parser, but are otherwise recognized as markup. The predefined entities such as , and & require typing and are generally difficult to read in the markup.Following is the syntax for CDATA section −You have to wrap your queries in CDATA as shown below − 50. ]]> For more details about XML CDATA, you can refer below link −https://www.tutorialspoint.com/xml/xml_cdata_sections.htm
Read MoreGetting Error message “Object doesn't support property or method 'attachEvent'” in IE11 to call SAP system
Note that attachEvent is no longer supported in IE11 and you should use addEventListner that can be used to bind specific function to an event.In older versions of IE, you can use like this:object.attachEvent(event, pDisp)Parametersevent [in]Type: StringA String that specifies any of the standard DHTML Events.pDisp [in]Type: ObjectThe Pointer that specifies the function to call when the event fires.Return valueType: BooleanBoolean returns any of the below value:Return value DescriptionTrue The function was bound successfully to the event.False The function was not ...
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 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