Found 1039 Articles for SAP

Footer not working in my SAPUI5 application

SAP Expert
Updated on 12-Jun-2020 08:13:30

486 Views

Try embedding page in “sap.m.App control”.This is an example of showing and hiding footer, check this link:UI5 Documentation

Consuming Web Service in C# application (SAP)

SAP Expert
Updated on 12-Feb-2020 11:23:52

636 Views

This error occurs when remote server doesn’t provide a response to your request and connection is broken before request is complete. To fix this issue, first setup a request that includes QaaWsHeader and ReportBlock configuration, then create the Request and in last using ServicesSoapClient, you can make method to send results.Check out the below code and it may help −Sellers.QaaWSHeader qaawsHeaderDatos = new Sellers.QaaWSHeader(); Sellers.GetReportBlock_WBS_Sellers getReportBlock = new Sellers.GetReportBlock_WBS_Sellers(); getReportBlock.login = userWS; getReportBlock.password = passWS; getReportBlock.refresh = true; getReportBlock.startRow = 0; getReportBlock.startRowSpecified = true; getReportBlock.endRow = 1000; getReportBlock.endRowSpecified = true; Sellers.GetReportBlock_WBS_Sellers_Request ... Read More

Is there a way to find last date of month using any function? Like 03/15/2017 should return 03/31/2017? (SAP)

SAP Expert
Updated on 12-Jun-2020 08:15:48

134 Views

You can try using DateSerial() function.DateSerial returns a Date value for the specified year, month and day. It also handles relative Date expressions.Argumentsyear is a whole Number or numeric expression representing a year, example: 1996.month is a whole Number or numeric expression representing a month, example: 12 for December.day is a whole Number or numeric expression representing a day of the month, example: 5.ReturnsA Date value.ActionDateSerial returns a Date value for the specified year, month and day. It also handles relative Date expressions.DateSerial (2000, 6, 15)DateSerial (2004, 1 - 7, 15)DateSerial (2008, 1, 166)Check the below code as it finds ... Read More

Publishing SAP Xcelsius dashboard without login

SAP Expert
Updated on 12-Jun-2020 08:16:33

166 Views

Yes it can be achieved via using Open Document link. To get HTTP link, you need to store object in BO repository and get open document link from BI Launchpad.When you store object in repository, you have to handle necessary credentials and running queries can be handled by this. You can setup SSO in OpenDocument and SSO source can be an Active Directory authentication, or SAP BW.When SSO is setup, clicking the generated OpenDocument link should automatically log you on and open the dashboard and you don’t need to pass additional authentication.In short, you have to follow below steps:Set up ... Read More

Specifying working directory while executing FM SXPG_COMMAND_EXECUTE in SAP system

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

740 Views

I thought it can be done using a script in SM69 T-code defined as a call to sh with parameters of -c 'cd && /path/to/command.However it doesn’t accept wildcards and && is converted to & and script is not working. As per SAP Note 401095 - Wildcards in external commandsSymptom:Customers would like to use wildcards when defining external commandsOther Terms:SM49, SM69, wildcardReason and Prerequisites:Wildcards are not supported in external commands, amongst other things for security reasons.For example:An ls with a wildcard was defined as a command: "ls $1".During execution, the parameter "; rm -R /*" is entered. At operating ... Read More

How to find a constant in a string in SAP BO Webi Report

SAP Expert
Updated on 12-Jun-2020 08:17:24

3K+ Views

You are correct. You can use functions like Match() or Pos(). You can use MATCH([Dimension];"*def*")) and this will get you the output and wildcard will match the beginning of the string.Pos Function is used to return the position of a specific character string.You can also try using Pos() function as below −=Pos("def abc ghi";"def") returns 1 =Pos("def abc ghi";"abc") returns 5 =Pos("def abc ghi";"xyz") returns 0

Upgrading SAP .NET Connector from .NET 2.0 to .NET 3.0

SAP Expert
Updated on 12-Jun-2020 08:18:39

490 Views

You are correct. NET Connector 2.0 uses proxy classes however .NET Connector 3.0 uses generic API. You need to rewrite all code that include NCo interaction..NET Connector 3.0 has many benefits over .NET 2.0:NCo 3.0 Is more stable, robust and supports heavy load.NET 3.0 provides better design of your application by decoupling the connection handling.It consumes less memoryAllows dynamic programming without the need for proxy generationCan dynamically look up metadata (so if something changes in the related ABAP system – e.g. if parameters in a function module signatures are added or the ABAP system is switched from Non-Unicode to Unicode, ... Read More

Attach data from SAP system using Oracle Web Logic and Oracle Enterprise Service Bus

SAP Expert
Updated on 12-Jun-2020 08:20:48

219 Views

As per my knowledge, Oracle Bus Service has a SAP adapter that you can use to get data via queries. With 10.3.1 release of the Oracle Service Bus, you have the following adapters for use within Oracle Service Bus:Oracle AQDatabaseOracle ApplicationsSAPJ.D. Ewards OneWorldSiebelPeopleSoftYou can refer to this link to know more about Oracle Service Bus (OSB):Oracle Service BusYou can use API available with Weblogic and ESB for configuration and for creating end points. To see the list of API’s available for Oracle ESB, refer this link:API's for Oracle ESB

Converting BLOB to Char in SAP HANA using SQL

SAP Expert
Updated on 25-Jun-2020 20:49:59

818 Views

You can perform varchar casting using following query:SELECT TO_ALPHANUM(col) FROM ......

Sorting Prompt values in SAP BO Webi report

SAP Expert
Updated on 12-Jun-2020 08:21:25

587 Views

In Business Objects 4.1, this can be done by following below steps in Universe:Navigate to Parameters and LOVNext is to go Edit SQL option -> write query with order by to get the order.

Advertisements