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
Converting OData using SAPUI5 libraries to JSON format
This can be done in multiple ways. One of common approach would be by passing user name/password in URL.$.ajax({ url : "http://user:password@url/SERVICE?$format=json", type: "GET", //or POST? dataType: "jsonp", success: function(){alert("ok")}, error: function(){alert("error")} })
Read MoreGetting a carriage return of report field in SAP Crystal Report
You can make use of split as below −// To split the text on carriageLocal Stringvar Array lines: = Split( {table.field}, Chr(20) );// To return carriage 1 less than the number of linesLocal Numbervar delimiters := Ubound(lines)-1;Let us see one more example, how to use split to divide a string in different lines.stringvar array x := split({table.fullname}," "); x[1] stringvar array x := split({table.fullname}," "); if ubound(x) >= 2 then x[2] stringvar array x := split({table.fullname}," "); if ubound(x) >= 3 then x[3]This will split a string in 3 different lines like“Mr”“John”“Harper”
Read MoreIn SAP ABAP, few records are skipped during parallel processing
Check out on code to handle parallel processing-gv_semaphore = 0. DESCRIBE TABLE lt_itab LINES lv_lines. LOOP AT lt_itab INTO ls_itab. CALL FUNCTION 'ZABC' STARTING NEW TASK taskname DESTINATION IN GROUP srv_grp PERFORMING come_back ON END OF TASK EXPORTING ... EXCEPTIONS ... . "
Read MoreBinding OData service to SAP UI5 table
Your service end point is incorrect- var oModel = new sap.ui.model.odata.v2.ODataModel("http://admin- think:88/sap/...",{useBatch : true});.To fix this issue, you need to remove “CoreOpenAppSet()” portion of the variable which is getting passed to ODataModel constructor. You need to pass function import using ODataModel- “oModel.callFunction()”.Once function call is completed, you can bind the result using “setBindingContext” as in below code −var oPromise = oModel.callFunction("/CoreOpenAppSet"); oPromise.contextCreated().then(function(oContext) { oView.setBindingContext(oContext); });
Read MoreCast string to date in specific format in SAP HANA
I think you just need to use ‘TO_VARCHAR’ and ‘TO_DATE’ functions.SELECT TO_VARCHAR(TO_DATE(, 'YYYYMMDD'), 'YYYY-MM-DD') FROM
Read MoreUsing method getBPLIST() to get list of all orders in SAP Business One
I would suggest using recordset with DI API −SAPbobsCOM.Recordset rs = ((SAPbobsCOM.Company)oCompany.GetDICompany()).GetBusinessObject(BoObjectTypes.BoRecordset); rs.DoQuery("SELECT DocEntry, DocNum, DocDate, TaxDate, CardCode, CardName, DocTotal FROM OPOR ORDER BY DocDate ASC"); while (!rs.EoF) { int DocEntry = rs.Fields.Item("DocEntry").Value; //OR DocEntry = rs.Fields.Item(0).Value; rs.MoveNext(); }
Read MoreCan we use MySQL GROUP BY clause with multiple columns like MySQL DISTINCT clause is used?
Yes, it is possible to use MySQL GROUP BY clause with multiple columns just as we can use MySQL DISTINCT clause. Consider the following example in which we have used DISTINCT clause in first query and GROUP BY clause in the second query, on ‘fname’ and ‘Lname’ columns of the table named ‘testing’.mysql> Select * from testing; +------+---------+---------+ | id | fname | Lname | +------+---------+---------+ | 200 | Raman | Kumar | | 201 | Sahil | Bhalla | | 202 | Gaurav | NULL | | 203 | Aarav | ...
Read MoreAccessing Source code of SAP Transport without using SAP system
I don’t think it is possible to check source code without SAP system until you understand SAP Binary code. The format in which the data are stored in the data file is AFAIK, an SAP own format and you can use R3trans to read code using the command.R3trans -l [-w ] [-v ]To know more about R3trans, you can refer to this link −https://archive.sap.com/discussions/thread/1277788
Read MoreTaking schema wise backup in SAP HANA
Data backup in any RDBMS system comes under Data Persistence layer. SAP HANA holds the bulk of its data in memory for maximum performance, but it still uses persistent storage to provide a fallback in case of failure.When you refer a schema in database, it refers to a namespace in the database. It is not possible to take backup schema wise as you do for complete database.However it is possible to export a schema using below command −EXPORT "MY_SCHEMA".* AS BINARY INTO '/tmp/my_schema' WITH REPLACE;SyntaxEXPORT AS INTO [WITH ] [ ]Note that you shouldn’t take schema ...
Read MoreHow to create PowerShell alias permanently?
PowerShell alias can be created permanently by 2 methods below.a) Import / Export AliasTo export all the aliases, you need to use Export-Alias cmdlet. When you use this command it will ask you the path for the file to import.To export the newly created alias, you need to give alias name and the name for the export, so later you can import it with the same name.In the below example, we have created alias name Edit for the Wordpad and we will export all the aliases with the name Alias1, so the newly created alias will also be stored and ...
Read More