There are different approaches that you can follow −First approach would be that you schedule a job and send the result to a mailbox instead of printing it. Then you can use any programming code to read that email and export in desired format.Other approach would be to check available BAPI’s. These BAPI’s can be called from an external program but for this you need to use SAP ABAP.Checkout this SAP blog that tells how to generate a report in background and send result to user email id −SAP blogYou can define distribution list in T-Code − SO23Read More

This could be cause of usage of different versions of cryptocme2.dllThis is location of CA's file: C:\Program Files\CA\SC\ETPKI\lib\cryptocme2.dll [Additional Info: File Version: Not Available, Timestamp: 2/29/2012 9:43 PM, size 3, 188 KB] Location of SAP's file : D:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\cryptocme2.dll [ Additional Info: File Version 3.0.0.0 , TimeStamp: 2/25/2011 6:55 PM, size: 1704 KB]To fix this issue: you need to rename dll C:\Program Files\CA\SC\ETPKI\lib\cryptocme2.dll to cryptocme2_ca.dllNext is to copy D:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\cryptocme2.dll to C:\Program Files\CA\SC\ETPKI\lib\Next is to uninstall BO XI 4.0 SDK via Control Panel.You have to restart the Box and stop ... Read More

You are correct as XSA supports the custom error pages but classic does not support custom error messages.In case you need to do in any way, then what you can try out is you need to parse all requests through a load balancer or a proxy and then show custom error message. And it is not a easy and maintainable approach.

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.

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 More

Yes, you can do that but if you are thinking of making the changes in the existing PHP script so that it takes care of both the tasks. Then it will be quite tough.But if you want to have two operations in parallel then you can have it.You can go for writing a web service which can do the DB update activity. You can also try using the SAP API to do the updates. SAP API has the most common and used methods to do the updates.So you might be able to find the ones for your requirement.You can also ... Read More

You would require changing the connection.properties file of your local Tomcat Server (Server > Java Web Tomcat 8 Server-config/config_master/connection_data), to point to the HANA database. Here are the usual parameters that need to be configured for HANA database javax.persistence.jdbc.driver = com.sap.db.jdbc.Driver javax.persistence.jdbc.url = jdbc:sap://:/?reconnect=true&autocommit=false javax.persistence.jdbc.user = db-user javax.persistence.jdbc.password = db-pass eclipselink.target-database = 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

In older SAP HANA versions, no XML functions were provided. With HANA 2.0, these two functions are provided- XMLEXTRACT and XMLEXTRACTVALUE for extracting XML string in SAP HANA.Use of XMLEXTRACTXMLEXTRACT(, [, ])Syntax to use −Specifies an XML document of type CLOB, NCLOB, VARCHAR, or NVARCHAR.Specifies an XPath expression of type VARCHAR or NVARCHAR.Specifies a namespace declaration of type VARCHAR or NVARCHAR.DescriptionReturns the matching XML element. The return value is of type VARCHAR/NVARCHAR or CLOB/NCLOB depending on the type given for .If an XML element is empty (for example, ), then an empty result is returned. If an XML element ... Read More

You would require to change the connection.properties file of your local Tomcat Server (Server > Java Web Tomcat 8 Server-config/config_master/connection_data), to point to the HANA database.Here are the usual parameters that need to be configured for HANA databasejavax.persistence.jdbc.driver=com.sap.db.jdbc.Driver javax.persistence.jdbc.url=jdbc:sap://:/?reconnect=true&autocommit=false javax.persistence.jdbc.user=db-user javax.persistence.jdbc.password=db-pass eclipselink.target-database=HANA