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
What will happen if the MySQL AUTO_INCREMENT column reaches the upper limit of the data type?
When the AUTO_INCREMENT column reaches the upper limit of data type then the subsequent effort to generate the sequence number fails. That is why it is advised to use a large enough integer data type for the AUTO_INCREMENT column to hold the maximum sequence value required by us. For example, if we will use TINYINT then AUTO_INCREMENT would be able to generate only 127 sequence numbers and in case of UNSIGNED TINYINT, this value can be extended up to 255.
Read MoreUsing TCP/IP ports for accessing SAP HANA database
To access HANA system on client tools, you need to open different ports to database for these clients. These ports refer to different servers and application service in HANA system.
Read MoreWhy is it not recommended to use the mixture of quoted as well as unquoted values in MySQL IN() function’s list?
Actually, MySQL has different comparison rules for quoted values such as strings and unquoted values such as numbers. On mixing the quoted and unquoted values in IN() function list may lead to the inconsistent result set. For example, we must not write the query with IN() function like below − Select Salary from employee where ID IN(1,’a’,2,3,’c’) Instead of this the better way to write the above query is as follows − Select Salary from employee where ID IN(‘1’,’a’,’2’,’3’,’c’)
Read MoreChange leaves duration from hours to days in SAP Fiori app
In general, customizing Fiori applications involves customizing the parent SAP application. So, if in the application, it defaults to hours then the Fiori app will also inherit the default behavior and show it in hours.Go ahead and change it to days, it will impact your Fiori app and the app will also start showing in days.In case you cannot afford to make a change in SAP application, then you need to handle it in a custom manner which will require you to have a custom implementation in place.
Read MoreIn SAP Class Builder, I am trying to test ABAP classes. When I press F8, it doesn’t show “Create Instance” menu item.
You can access Class Builder by using T-code: SE24 or via Repository Browser SE80 and navigate to class you want to edit. You have to ensure that you set the below parameter to the public. It is also possible that your class implements an interface. It is also possible that class implements an interface. You have to click on magnifying glass icon and you can execute both static and instance methods.
Read MoreCan a class in Java be both final and abstract?
An abstract cannot be instantiated. Therefore to use an abstract class you need to create another class and extend the abstract class and use it. If a class is final you can’t extend it further. So, you cannot declare a class both final and abstract. Example Still if you try to do so you will get a compile time error saying “illegal combination of modifiers:” final abstract class Demo{ public final void display(){ System.out.println("Hello welcome to tutorialspoint"); } } Output C:\Sample>javac Demo.java Demo.java:1: error: illegal ...
Read MoreIntegrating HANA and R using RJDBC
I think there is a typo error. Try correcting your code like classPath="Z:/SAP/hdbclient/ngdbc.jar
Read MoreDynamically creating parameters from table entries in SAP system
Note that parameter statement compiles into selection screen at compile team so it is not possible to declare dynamic parameters as proposed by you. Other approach would be that you could load dynpro and change the screen dynamically. You have to activate and then run the report that calls the changed screen. This same approach is used in T-code SE16 to generate a selection screen from a table.
Read MoreSend an Idoc using SAP.net connector 3.0 from a non-SAP system
As per my knowledge, SAP doesn’t offer any development library for NCo to deal with Idocs. .Net connector is primary used for development of RFC clients.One of a common method to submit idocs to the SAP system using NCo is by using function module “IDOC_INBOUND_ASYNCHRONOUS”. This function module includes multiple table parameters containing idoc data.Function Module: IDOC_INBOUND_ASYNCHRONOUS (IDoc inbound processing via tRFC)Function Group: EDINProgram Name: SAPLEDINFollowing are the parameters:Table IDOC_CONTROL_REC_40 contains the control record, IDOC_DATA_REC_40 contains the idoc data segments.IDOC_DATA_REC_40 contains a field called SDATA. That field contains an Idoc segment data as a single concatenated string with fixed field ...
Read MoreUsing Rounding formula in SAP
Try using below formula:Total = R(Quantity * Unit Price * (100 - Discount%) / 100)You need to take out rounding on each step and shouldn’t use Original Price-Discount
Read More