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 40 of 58
Error 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 MoreIn my SAP Fiori custom app, Back button is not working in Launchpad
Try to use “shellHash” property instead of “semanticObject” like below:-------------------------------------------------------- sap.ushell.Container.getService("CrossApplicationNavigation").toExternal({ target: { shellHash: "#" } }); --------------------------------------------------------
Read MoreError while passing an image value to an OData request in SAP
If you ImgData includes an image in Data URI format base64 then add the below line to Imgvalue to convert it to ImgData:var imgData = JSON.stringify(ImgValue);I suggest you to use AJAX to post image through OData as shown in below code:OData.request ({ requestUri:"http://test.test1.net:8081/sap/opu/odata/sap/ SALES_VRS/DailySalesSet", method: "GET", headers: { -Requested-With": "XMLHttpRequest", "Content-Type": "application/atom+xml", "DataServiceVersion": "2.0", "X-CSRF-Token":"Fetch" } ...
Read MoreProperties of SAP ABAP Development Objects
Similar to reflection in JAVA we have RTTS in SAP. RTTS stands for runtime type services. It provides you with ways to retrieve the definitions of variables and lets you create a new variable during program execution. RTTS comprises of two sub-componentsRTTI – Run Time Type IdentificationRTTC – Run Time Type CreationAs the name suggests, RTTI is responsible for retrieving the definitions of variables and types Whereas RTTC is responsible for the creation of new variables with provided definition at run-time.
Read MoreConverting a file into a byte array in SAP ABAP
Here is a code snippet to do the same.data: f_line type xstring. // to get line by line content data: f_file type table of xstring. // to get the final content data: f_filename type string value 'samplefile.txt'. // store the filename of file data: f_len type i. open dataset f_filename for input in binary mode. // read the binary read dataset f_filename into f_line length f_len. // get the number of lines in the file while f_len > 0. // ...
Read MoreGetting details when a table is modified in SAP HANA DB
You can query SYS.M_TABLE_STATISTICS providing name of table and LAST MODIFY DATE. Here is the sample SQL query.SELECT "ABC", "LAST_MODIFY_TIME" FROMSYS.M_TABLE_STATISTICS ORDER BY “LAST_MODIFY_TIME" DESCIn above command, you need to replace “ABC” by your table name.
Read MorePerforming total of a column in a temporary column in SAP
You need to perform select again on your query. Here is the sampleSELECT DATE, FUND_ID, PPT_ID, SOURCE_ID, AMOUNT, SUM (AMOUNT) as TOTAL FROM ( SELECT AD.CHV_DATE.DATE, AD.CHV_FUND.FUND_ID, AD.CHV_PARTICT.PPT_ID, AD.CHV_PARTICT.SOURCE_ID, SUM (AD.CHV_PARTICT.AMOUNT), FROM AD.CHV_DATE, AD.CHV_FUND, AD.CHV_PARTICT, AD.CHV_SOURCE WHERE DC.CHV_SOURCE.FUND_ID=AD.CHV_FUND.FUND_ID AND (DC.CHV_SOURCE.DATE=AD.CHV_DATE.DATE) AND (DC.CHV_PARTICT.PPT_ID=AD.CHV_SOURCE.PPT_ID) AND ( AD.CHV_DATE.DATE IN ('2017-08-02') AND AD.CHV_PARTICT.PPT_ID IN ('PPT0449') ) GROUP BY AD.CHV_DATE.DATE, AD.CHV_FUND.FUND_ID, AD.CHV_PARTICT.PPT_ID, AD.CHV_SOURCE.SOURCE_ID) GROUP by DATE, FUND_ID, PPT_ID, SOURCE_ID, AMOUNT
Read More\\\\\\\\nParsing IDoc files to extract information from SAP system
There are few third party libraries which can be used to perform this task however they involve some cost however best way here is to use an SAP Connector. SAP Connectors are available for almost all prevalent programming languages like JAVA, C#, Python. You can program against these connectors and read data from IDoc. You can do a lot many things with these connectors from reading data to convert them to flat files for further usage.I have used JAVA connector for a similar scenario. You can use SAP Java IDoc class library and SAP JCO libraries for parsing IDoc files. The SAP ...
Read More