Found 694 Articles for SAP HANA

As far as I know, there is no direct way of inserting an Array using SQL query. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database.

You need to go to SE93 and input your Transaction code. It will display program name behind your transaction code. You can edit the programs using SE80 and SE38.  Below shows Transaction code: SE93 Following shows Transaction Code SE80 to edit an ABAP program by opening ABAP Development workbench: Following shows Transaction Code SE38 to edit an ABAP program by opening ABAP Editor Initial screen and to enter the name of Program −

It is possible that the older version of SAP B1 may not show you all the fields of all the forms. If you have the latest version, you should be able to see the data sources that are mapped to given field. You need to open the forms in SAP Business One Studio. There are a couple of methods to view fields. 1. In SAP Business One, go to TOOLS => select SAP B1 studio suite=>edit active form for Microsoft  visual studio. This will open up the form in edit mode for Microsoft visual studio.2. You can directly use the Microsoft ... Read More

Create a REST service hosted on a server and place java method inside it. Now you can call this REST service from a SAPUI5 application using AJAX by passing required parameters.

You can use RTTS related API to create a Standard table like RANGE which has components like 'LOW', 'HIGH', 'EQ' and 'OPTION'data:    rr_data              type ref to data,    rt_range_string      type range of string,    rs_range_string      like line of rt_range_string,    rt_component         type abap_component_tab,    rs_component         type line of abap_component_tab,    rt_range_components  type abap_component_tab,    ro_struc_descr       type ref to cl_abap_structdescr,    ro_table_descr       type ref to cl_abap_tabledescr,    ro_data_descr        type ref to cl_abap_datadescr.field-symbols type ... Read More

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, AMOUNTRead More

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.

The error you are getting is because there is no ODBC drivers installed for your PHP client. You would require downloading the drivers from any site on the internet. Following steps can be performed to download the drivers: Download the drivers from http://www.easysoft.com/cgi-bin/account/login.cgi after registration or alternatively check the ODBC-ODBC Bridge Client platforms(http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html#platforms).This allows you to access drivers on a remote machine.   2. Install the drivers on the machine where PHP is installed.    3.  Refer to instructions athttp://www.easysoft.com/products/data_access/odbc-sql-server-driver/manual/sql-server-toc.html  to check the environmental variables what values to be set up for LD_LIBRARY_PATH, LIBPATH, LD_RUN_PATH, SHLIB_PATH depending on the driver, platform and linker.Read More

There are different Function Module that you can use depending on BAdi type- classic or fast kernelYou can try using Function module SXO_IMPL_FOR_BADI_READ. To read the coding of class, try using “CL_ENH_BADI_RUNTIME_FUNCTIONS”You can use “GET_BADI_SHORTTEXT” method to know different BAdi’s types.There is a Function modules SEO* - which can be used to read the structure of a class, it’s superclasses and method.

You just need to use the noDataText property to sort out your requirement.You have two options, either you can change in controller or you can change in the XML.Option 1:Call the setNoDataText method in the init methodthis.byId(“”).setNoDataText(“”)Option 2:Add the noDataText property in the XML