Found 1039 Articles for SAP

Creating a variable with dynamic variable type in SAP ABAP

Fendadis John
Updated on 13-Feb-2020 10:12:00

2K+ Views

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

Performing total of a column in a temporary column in SAP

Arjun Thakur
Updated on 05-Dec-2019 07:44:31

145 Views

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

Getting details when a table is modified in SAP HANA DB

Rama Giri
Updated on 05-Dec-2019 07:45:45

2K+ Views

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.

Connecting to SAP HANA using odbc_connect() on PHP

Kumar Varma
Updated on 12-Jun-2020 12:30:18

745 Views

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 https://www.easysoft.com/cgi-bin/account/login.cgi after registration or alternatively check the ODBC-ODBC Bridge Client platformshttp://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 at https://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

Retrieving ABAP BAdi from SAP BW

SAP Developer
Updated on 30-Jul-2019 22:30:20

325 Views

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.

Change no data text for Search in SAPUI5

SAP Developer
Updated on 12-Jun-2020 11:42:15

597 Views

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

Commit changes on SAP BAPI Transaction

SAP Developer
Updated on 12-Jun-2020 12:05:35

659 Views

You are correct that in order for the changes done by BAPI to come into effect, you need to call the commit function.It will commit all the changes which are uncommitted not only the last transaction. You can refer below link to know more about BAPI_TRANSACTION_COMMIT and COMMIT WORK:BAPI_TRANSACTION_COMMIT

Apply CSS on a table cell based on the content in SAPUI5

SAP Developer
Updated on 12-Jun-2020 12:08:05

945 Views

You are having one of the most common requirements in the case of the table. You can achieve the end result using formatter function exposed on the cells of a table.Here is a code snippet for your reference which you can alter as per your use case:cells: [    new sap.m.Text({       text: {          formatter: function(name) {             if (name == "") {                // you can add style class or do your own logic here                this.addStyleClass("Total");             }          }       }    }) ]

Instantiation of Export Options throws an Exception in SAP Crystal Report

SAP Developer
Updated on 30-Jul-2019 22:30:20

178 Views

Even after referencing the correct version of the dll, if you are still getting the error then it means that the runtime for the crystal reports is not properly installed.I think you would have used MSI installer over EXE for the installation of SAP Crystal Reports however it has a shortcoming that the MSI installer does not properly incorporate Crystal Reports with Visual Studio.

Connect to dynamic URL within OData in SAP project

SAP Developer
Updated on 13-Feb-2020 07:15:44

398 Views

You can try and create a URL in your code which you can read from config or XML.Here is a sample code snippet −String uri = // Can read from config or anywhere string odQuery = "?$format=json" var req = WebRequest.Create(uri+"/"+ odQuery); req.Method = "GET"; var streamreader = new StreamReader(stream: request.GetResponse().GetResponseStream()); string response = streamreader.ReadToEnd(); //json responseThis is a sample code snippet but you can modify it as per your use case.

Advertisements