Tutorialspoint

Generating an IDoc file to generate orders in SAP R/3 system

As per requirement, I have to generate IDoc file to make shop orders available to R/3 system. I can’t use Web Service or BAPI and data should be available only via files. Is [BELNR] requ.....
SAP Expert
Answered on 6th Dec, 2017

BELNR is not required however it is useful. Let us say a customer place an order and as he is not sure he place the order again. Now there are 2 orders you are not sure if there are two IDocs for same order.With BELNR, it has order number of ... Read More

SAP PI messaging service is JMS compliant or not

I want to know if messaging service in SAP PI is JMS compliant or not. I tried to check on various SAP forums but couldn’t able to find this. Anyone can help?
SAP Expert
Answered on 6th Dec, 2017

As per my knowledge, SAP PI Messaging Server 7.4 AEX is compatible with JMS 1.02 and JMS 1.1. Using Java Messaging Service, you can connect messaging systems to the Integration Engine.You can refer to SAP Note: 856346 - J2EE JMS AdapterThis note says common FAQ’s about JMS and I have ... Read More

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

I have two table in SAP system- master table and child table. While using an ABAP program to insert record in child table with no matching record in master table, record is entered in database.....
SAP Expert
Answered on 6th Dec, 2017

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

IN statement in SQL doesn’t accept a wild character (SAP)

Check out the below SQL: SELECT *  FROM Test1 t INNER JOIN TEST2 s ON t.ID = s.RID WHERE t.sdate >= ?1 AND t.edate <= ?2 AND  t.id LIKE ?3  AND t.afdeling IN (?4) AND s.si.....
SAP Expert
Answered on 6th Dec, 2017

Note that IN statement in SQL doesn’t accept a wild character. You have to use OR/AND to make it work as mentioned below:select *from Test1 t INNER JOIN Test2 s ON t.ID = s.RIDwhere t.sdate >= ?1AND t.edate <= ?2AND t.id LIKE ?3AND ('%' = ?4 OR t.afdeling IN (?4))AND ... Read More

Specifying working directory while executing FM SXPG_COMMAND_EXECUTE in SAP system

Is there a way to specify current working directory while executing command by FM SXPG_COMMAND_EXECUTE. I checked T-code: SM69 and SE37 but couldn’t able to find any parameter specific fo.....
SAP Expert
Answered on 6th Dec, 2017

I thought it can be done using a script in SM69 T-code defined as a call to sh with parameters of -c 'cd <dir> && /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 ... Read More

Sorting Prompt values in SAP BO Webi report

I am using a prompt in my Webi report- “Fiscal Month”. How can I custom sort it so that months start with April, May, June…..?
SAP Expert
Answered on 6th Dec, 2017

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

In my application, i have to attach data from SAP system using Oracle Web Logic and Oracle Enterprise Bus. My application is a Windows based app developed in JAVA and this requirement seems tou.....
SAP Expert
Answered on 6th Dec, 2017

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

Converting BLOB to Char in SAP HANA using SQL

I need to cast a BLOB to varchar format in HANA database using SQL query. Below is my code: select  cast("DESCRIPTION" as varchar) "D" from "DESC" I get an error message: “Inconsist.....
SAP Expert
Answered on 6th Dec, 2017

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

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

I have to perform an upgrade of SAP .NET Connector from 2.0 to 3.0. I know that there are lot many changes in 3.0 and I may need to rewrite entire application. Is there any guide that can help.....
SAP Expert
Answered on 6th Dec, 2017

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

I want to find a constant in string in SAP BusinessObjects Webi report. There is a MATCH() function that can be used to find a string pattern as below: =IF(MATCH([Dimension];"def") OR MATCH([D.....
SAP Expert
Answered on 6th Dec, 2017

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

I have a SAP dashboard that I want to publish in my company. Problem is when I export it as flash file it asks for login parameters.  Is there a way we can prevent this and dashboard can .....
SAP Expert
Answered on 6th Dec, 2017

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)

Is there a way to find last date of month using any function? Like 03/15/2017 should return 03/31/2017? Any link over internet would be good?
SAP Expert
Answered on 6th Dec, 2017

You can try using DateSerial() function.DateSerial returns a Date value for the specified year, month and day. It also handles relative Date expressions.Arguments:year 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

Consuming Web Service in C# application (SAP)

I want to consume a Web Service in my C# application. I am using below code however it throws an error: underlying connection established was closed. unexpected format was send". NetworkCreden.....
SAP Expert
Answered on 6th Dec, 2017

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

Footer not working in my SAPUI5 application

I have a SAPUI5 application and I have placed a footer in this application however my footer is displayed at top of page instead of bottom.     return new sap.m.Page({     .....
SAP Expert
Answered on 6th Dec, 2017

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

How do you properly ignore Exceptions in Python?

I have a try-except block in following code and I just want to continue with the code by ignoring the exception block. , The problem is if I leave the ‘except’ block empty or with a.....
Rajendra Dharmkar
Answered on 6th Dec, 2017

This can be done by following codestry: x, y =7, 0 z = x/y except: passORtry: x, y =7, 0 z = x/y except Exception: passThese codes bypass the exception in the try statement and ignore the except clause and don’t raise any exception.The difference in the above codes is ... Read More

Advertisements
Loading...
Unanswered Questions View All