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
Articles on Trending Technologies
Technical articles with clear explanations and examples
Negation logic in SAP ABAP
You can use BOOLC to sort out your requirement. It should be like thisVarbool= BOOLC( NOT Logical operation)But be clear in your implementation, as ABAP does not have true bool type. It does not store true or false in bool type rather it stores ‘X’ or ‘’ for true and false respectively.You can also try to use XSDBOOL instead of BOOLC.
Read MoreProblem with division as output is either 0 or 1 when using ifthenelse condition in ABAP program
The problem is that your second parameter is 0 which is an integer, so the output always comes as an integer as ifthenelse takes data type from the second parameter. So, in your case, if the answer is less than .5, it is converted to zeroes and in case more than .5, it is converted to 1. You would require to use cast for the second parameter to convert it to decimal data type as follows ifthenelse(Query.Den= 0, cast(0, 'Decimal(16, 02)'), Query.Num / Query.Den)
Read MoreDeleting from temporary table in SAP HANA
The temporary tables are session specific. So you would require to use truncate instead of delete as followstruncate table #temptable;Also, could you please check your release? In the recent releases, delete also works fine. Here is an example:Drop table #temptable; Create local temporary table #temptable(id integer, str nvarchar(30)); Insert into #temptable values (1,'abc'); Insert into #temptable values (2,'xyz'); Select * from #temptable; --> returns 3 rows Delete from #temptable; Select * from #temptable;--> returns 0 rows
Read MoreSetting up a JDBC connection to remote SAP HANA system
You are using the correct Port number for instance number “00”. Port number 300315, here 00 represents instance number of your HANA system.Try using HANA client jar file ngdbc.jar instead of SAP Jar file.try { Class.forName("com.sap.db.jdbc.Driver"); String url ="jdbc:sap://xx.x.x.xxx:30015/DBNAME"; //IP Address of HANAsystem followed by Port number String user ="user"; String password = "password"; Connection cn = java.sql.DriverManager.getConnection(url, user, password); ResultSet rs = cn.createStatement().executeQuery("CALL Test.STORED_PROC"); // ...Enter the action here } catch(Exception e) { e.printStackTrace(); }
Read MoreDate value is not populating while using Native SQL in SAP to insert an Order
I think you need to put a colon (before variable as below:EXEC SQL. INSERT INTO order VALUES('2', :sy-datum) ENDEXEC.I would also suggest you to use OpenSQL instead of Native SQL here. Native SQL is used when you try to use any features that are database specific.The query you have used is very generic and not exclusive for backend database.
Read MoreFinding minimum value across different columns in SAP HANA
You need to use LEAST instead of min as below:“SELECT ID, LEAST(DAY_1, DAY_2, DAY_3) FROM ...” Please make sure that none of the values in your column in “NULL”.
Read MoreCall screen on clicking the button in SAP ABAP
Please follow the steps below to make it functional.First, open the screen painterNow, double click on the button you want to make functionalAbove “Context Menu Form", you will find a field to enter Functional code where you enter the functional code.This will convert your button to functional trigger theOK code which will run the dynpro “PROCESS AFTER INPUT". Now add a PAI module to this dynpro which indicates the screen you want to call when the button is clicked. Below is the examplecase sy-ucomm. " the ok code when 'Functioncode’. call screen screennumber. when others. ...
Read MoreError while selecting into field-symbol in SAP ABAP
The problem is that you have not declared Field-symbol. Try using the below code.data: ws_bkpf TYPE bkpf_type. SELECT MANDT INTO CORRESPONDING FIELDS OF ws_mandt UP TO 1 ROWS FROM bkpf WHERE belnr = '1700001016'. ENDSELECT.
Read MoreMerging 2 tables with similar column name SAP HANA database
This can be done by using UNION or UNION ALL operator as followsselect id, Empl_name, DeptId from table1 union select id, Empl_name, DeptId from table2 The difference between UNION and UNION ALL is that UNION removes the duplicates while UNION ALL shows duplicates as well.
Read MoreUsing Aggregate function to fetch values from different tables in SAP
First of all, the example you gave has different description for a fund. So, you should know which one to be kept. If you want to keep any description, you can use the below query using aggregation functionsSELECT X1."FundName" ,min( X0."Dscription") , X0."FundId" FROM INV1 X0 INNER JOIN OINV X1 ON X0."FundId" = X1."FundId" INNER JOIN NNM1 X2 ON X1."SourceId" = X2."SourceId" WHERE X1."FundTotal" > 1000 AND X0."FundStart" between [%1] and [%2] GROUP BY X1."FundName", X0."FundId"
Read More