SAP Expert has Published 132 Articles

No error while inserting record in child table with no match in master table in SAP

SAP Expert

SAP Expert

Updated on 12-Jun-2020 08:22:34

216 Views

Note that when you perform an insertion using an ABAP program, there is no check on foreign key constraint.  Even when you define checks in data dictionary SE11 still there is no check at database level.When you execute using an ABAP code, this checks consistency at application level and not ... Read More

Sorting Prompt values in SAP BO Webi report

SAP Expert

SAP Expert

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

385 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.

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

SAP Expert

SAP Expert

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

121 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 ... Read More

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

SAP Expert

SAP Expert

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

314 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 ... Read More

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

SAP Expert

SAP Expert

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

2K+ 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 ... Read More

Publishing SAP Xcelsius dashboard without login

SAP Expert

SAP Expert

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

86 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 ... 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

SAP Expert

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

63 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 ... Read More

Footer not working in my SAPUI5 application

SAP Expert

SAP Expert

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

354 Views

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

Handling Exception using JCo 3.0 on JcoContext.end()

SAP Expert

SAP Expert

Updated on 12-Jun-2020 07:11:24

95 Views

As per my understanding, JCoContext.end() method will raise an exception if passed parameter is NULL or you have a bug in JCo. You need to ensure that destination is not null.This method should only be called, if destination is not null i.e.SAP Thread

How to place UI5 code in SAP NetWeaver Server?

SAP Expert

SAP Expert

Updated on 12-Jun-2020 07:10:41

141 Views

It is possible to deploy code from Eclipse /Web IDE to SAP backend server using ABAP developer tools. This will result a BSP page and you can check that in T-code: SE80.SAP Development Tools

Advertisements