Performing total of a column in a temporary column in SAP

Arjun Thakur
Published on 08-Dec-2017 08:06:05
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 ... Read More

Getting details when a table is modified in SAP HANA DB

Rama Giri
Published on 08-Dec-2017 07:23:45
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 More

Connecting to SAP HANA using odbc_connect() on PHP

Kumar Varma
Published on 08-Dec-2017 07:17:20
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 ... Read More

How to add and remove HTML attributes with jQuery?

Alex Onsman
Published on 14-Dec-2017 15:09:05
To add and remove HTML attributes with jQuery, use the addClass() and removeClass() method.You can try to run the following code to add and remove HTML attributes with jQuery −ExampleLive Demo<html>    <head>       <title>jQuery Example</title>       <script src = "https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>       <script type ... Read More

How to remove all the attributes of an HTML element using jQuery?

Alex Onsman
Published on 14-Dec-2017 08:46:22
To remove all the attributes of an HTML element, the removeAttr() method won’t work. For this, create an array and use removeAllAttrs() to remove all the attributes of a specific HTML element. For example, remove the image by removing the attributes of the img element.You can try to run the following ... Read More

How to remove all style attributes using jQuery?

Alex Onsman
Published on 14-Dec-2017 07:54:05
To remove an attribute from each tag using jQuery, use the removeAttr() method and use the Universal Selector. Let us see how to use the method to remove all style attribute. Use the universal selector also to select all the elements.You can try to run the following code to learn ... Read More

How to remove all style attributes using jQuery?

Sharad
Published on 31-Mar-2018 13:41:58
You can use following −$('.classname').removeAttr('style'); // for a class $('#id').removeAttr('style'); // for a id $('#id').attr('style',''); // for a id

How to remove an attribute from each tag using jQuery?

Alex Onsman
Published on 14-Dec-2017 07:46:06
To remove an attribute from each tag using jQuery, use the removeAttr() method. You can try to run the following code to learn how to remove attribute −ExampleLive Demo<!DOCTYPE html> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <script> $(document).ready(function(){   $("button").click(function(){     $("h1").removeAttr("style");   }); }); </script> </head> <body> <h1 style="color:blue">This is ... Read More

Retrieving ABAP BAdi from SAP BW

SAP Developer
Published on 07-Dec-2017 15:29:30
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 ... Read More

Change no data text for Search in SAPUI5

SAP Developer
Published on 07-Dec-2017 15:30:13
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(“<Your Id>”).setNoDataText(“<Your custom text>”)Option 2:Add the noDataText property in the XML<List noDataText="<Custom text>" />Read More
Advertisements