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 37 of 58
\\nAnalyzing code coverage results in SAP Design Studio on top of HANA\\n
To consume HANA view, you need to start by creating an ODBC connection to SAP HANA system through odbcad32.exe.Next step is open SAP Design Studio and add a data source by connecting to HANA system and open view as below:This way you can view your SAP HANA view in Design Studio, now to analyze code coverage results, you can refer this SAP blog for step by step process:SAP blog
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 MoreFetch max date and other field from the same row of a table grouped by other fields in SAP HANA
You have done partially correct but just missed one step further to get the desired result. The case where after grouping you need to pick one of the rows from the results, use rank number or rank function.You need to partition your data based on your requirement, then order them as per your requirement again then pick the desired row.ExampleFor e.g. partition your data by Item Number and Shop Id. Then order them in descending order of Date column. Then pick the row with row number as 1select date, Order_Number from (SELECT *, row_number() over ( partition by ...
Read MoreIs Pivot available in SAP HANA
As per my understanding, for requirement #1 you can do something as below:SELECT Prod.Product_ID, JOB.Job_ID, SUM(J.Time) FROM TABLE_1 Prod INNER JOIN TABLE_2 Job ON Prod.Job_Id = Job.Job_ID GROUP BY Prod.Product_ID, Job.Job_IDSAP HANA does not support Pivot built-in as done by SQL but majorly it looks as a UI requirement. So what you can do is send the entire result to report and apply transformation in the report as per your requirement.
Read MoreGetting error message: Scalar type not allowed in SAP HANA
Few points about your code to create a Stored Procedure, that you can edit and tryPROCEDURE "SLT_DELETE"."HCDW.IT.IT::TO_TIMESTAMP_CALL" (IN IN_DATE DECIMAL(15), OUT OUT_DATE TIMESTAMP) LANGUAGE SQLSCRIPT AS --DEFAULT SCHEMA --READS SQL DATA AS BEGIN select to_timestamp(IN_DATE) into OUT_DATE FROM DUMMY; END;In Line32, you have used below:SELECT: ORGID_ARTIKEL intoHowever correct syntax should be like:SELECT "ORGID_ARTIKEL" into
Read MoreCreating Index in Column based tables in SAP HANA
Note that an index not necessary to be NOT NULL. You can create an Index in SAP HANA database by using below query:CREATE INDEX IDX_MY_INDEX ON TABLE1 (MY_COLUMN);To know more about SAP HANA database, Modeling, and Administration features, you can refer our SAP HANA Text and Video tutorials:https://www.tutorialspoint.com/sap_hana/https://www.tutorialspoint.com/sap_hana_online_training/index.asp
Read MoreExposing employee master data from SAP HR system using Web Service
In a general scenario, when you have ICF configured you can expose SAP system business objects and jobs via BAPI. It is very easy to create and expose BAPI as a web service. As there are only few web services for SAP HR module in SAP system however you can transform a BAPI or ABAP function into a web service. If there is no such function you can create one easily.To find details about BAPI from Function module, use T-Code: SE37 and enter Functional module name for SAP HR module. Below is the list of existing HR function modules in ...
Read MoreExposing xsjs file data through web browser in SAP HANA
Note that you have to ensure that Port number 80+ should be open on network. Also URL you are using should be properly built. Below is correct path:server:port/repository_path/file_nameIn your case, you should be using:host: hanacloud port: 8000 (80 + instance_number) SAP HANA Repository tree: mdo -> sap -> sflight -> test -> test.xsjsSo your URL should be in this format:hanacloud:8000/mdo/sap/sflight/test/test.xsjs
Read MoreHow to setup user access limitation on a timely basis in SAP HANA
I must say, you got a pretty odd scenario of permission retraction but it is feasible.Create a stored procedure with entire onus of activating/deactivating the user or you can say authorize and de-authorize user.Create a batch user with privilege to execute the above-created procedures,Then you can set up a job to run the procedures with the help of hdbsql.
Read More