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
MySQL query to search a string 'demo' if someone mistakenly types 'deom'?
For this, you can use SOUND along with the LIKE operator. Let us first create a table −mysql> create table DemoTable -> ( -> Name varchar(20) -> ); Query OK, 0 rows affected (0.95 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John'); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable values('Adam'); Query OK, 1 row affected (0.33 sec) mysql> insert into DemoTable values('Johm'); Query OK, 1 row affected (0.29 sec) mysql> insert into DemoTable values('Carol'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('SAMSUNG'); Query ...
Read MoreHow to replace 'Empty set' in a MySQL query?
To replace a record that doesn’t exist, use the COALESCE in MySQL. The COALESCE would help in substituting the NULL values. Let us first create a table −mysql> create table DemoTable -> ( -> Code varchar(20) -> ); Query OK, 0 rows affected (1.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('10'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('45'); Query OK, 1 row affected (0.30 sec) mysql> insert into DemoTable values('78'); Query OK, 1 row affected (0.21 sec)Display all records from the table using select statement ...
Read MoreExecuting SAP RFC creates an error: "The current application triggered a termination with a short dump
This is very generic error and it could be due to any reason: code error, inconsistency in data, or some other issue. You can use T-Code: ST22 to check short dump message in SAP system.This is used to check ABAP Runtime errors- All Client. You need to pass the filter condition, and click on Start
Read MoreHow to create a list in SAPUI5?
I have gone through your code and it looks your list binding is incorrect. When you bind your data, your data should be in a JSON array format. Please find below the updated working code.Examplevar oModelData = [ {Animal: "Kangaroo", Zoo: "Sydney"}, {Animal: "Tiger", Zoo: "Melbourne"}, {Animal: "Lion", Zoo: "Alaska"} ]; var oItem = new sap.m.StandardListItem({ title : "{ Animal }", description : "{ Zoo }" }); var oList = new sap.m.List({ headerText:" Items", items: { path: "/", template: oItem } });Hope it helps!
Read MoreHow can I update a third party database outside SAP after completing a Transaction?
As you need to make some changes to happen when an activity gets completed in SAP, I would suggest you to go for services. Services are the best way to communicate when you are dealing with two discrete systems.Firstly you need to create a program on SAP side which can do the following task Fetch the file from a specified directoryConverts the file into a formatted data or send the data to a serverAt the webserver end, have a listener which receives POST requests (send by SAP). You need to have proper authentication set up ...
Read MoreHow to send MATMAS and DEBMAS idoc to other SAP system
I would suggest you to use T-code: BD12 to send the complete IDoc of DEBMAS.
Read MoreHow to avoid memory leakage in SAP B1 DI API
The thumb rule goes like this, if you instantiate a DI API object, you have to release it. if you don't release it explicitly, it will result in memory leaks.You can use a ReleaseComObject method to release the object memory. In case if you try to release a null object, it will throw an exception.So, it will be better to have a null check before you try to release the object.Sample snippet:if (obj != null) System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
Read MoreUsing SAP ABAP, how can I read content of CSV files in a directory to an internal table?
There are many functions that can be used to read csv however many are broken and read part of content. You need to go through each file and then process the file content. I would prefer to perform this manually.You can use the READ DATASET to read data from a file on the application server. Below is the syntax:READ DATASET INTO [LENGTH ].Below is SAP documentation link that you can use to know more about reading data from files:SAP DocumentationExampleIncase you are using binary mode, you can use LENGTH to find the length of data transferred to . ...
Read MoreIn SAP system, auto filling of NAME_1 while entering client number
You should use maintenance view to display name corresponding to customer number. With use of Maintenance view, you can maintain related data in several tables. Check out this link to know more about Maintenance view:SAP LinkTo perform a check for the mandatory, edit the generated screen and in screen flow logic you should add a module to check if the required fields are filled or not. You can also set the field possible to mandatory in the screen field options, however this is not recommended as it will show it as mandatory even for empty lines.SAP Link
Read MoreIn SAP Crystal Reports, Putting 2 pages of data into a single report
You can do this by adding a group based on participant Id as primary key. Then you have to add ran description in group footer.In your group footer settings, check the "New page before" option
Read More