SAP Basis Articles - Page 27 of 50

Fetching list of products from SAP: connecting SAP database from .net application

Monica Mona
Updated on 12-Dec-2019 06:53:34

262 Views

You can troubleshoot by trying a telnet to SAP system.Open a command prompt on the system you are running your .net application and try to telnet server having SAP system installed.Telnet 127.0.0.1 3300If you using a local system, try using a hostname instead of loopback IP address and make an entry in host file of the system.How to find host file in the system?Press the Windows key.Type Notepad in the search field.In the search results, right-click Notepad and select Run as administrator.From Notepad, open the following file: c:\Windows\System32\Drivers\etc\hosts.Make the necessary changes to the file. Click File -> Save to save your ... Read More

ABAP dump while creating an entry in SAP system using SAP JCO

Ayyan
Updated on 14-Feb-2020 05:43:45

478 Views

This seems to be a problem at ABAP side and not Java side. This is an ABAP dump and you need to useTransaction code: ST22 on ABAP backend to check functional module inSAP system.Once you get the exact details of ABAP dump you are getting, you need to edit the calling method to create an entry.

Finding where-used list of SAP standard programs

radhakrishna
Updated on 13-Feb-2020 12:48:11

1K+ Views

You would need to SAPRSEUB. This will enable you to use the where-used functionality of standard SAP programs and provide you with indices of the programs. Please note that this program runs for a long time and require some disk space.SAPRSEUB is a standard Executable ABAP Report available within your SAP system.SAPRSEUT Update Object Lists after TransportSAPRSEUB Generate Where-Used List (For All Programs)SAPRSLOG Refresh Navigation Indexes and Object ListsNote −Note that this report needs around 10 GB space in the DB and takes about 2 days to complete.

Benefits of Transaction SE83- SAP reuse library

mkotla
Updated on 13-Feb-2020 12:46:56

612 Views

Reuse library is basically a repository for various function and classes that can be used. One of the main benefits is that it has a number of source code examples for these functions present. These examples are quite useful as these could be used as a base code and you don’t have to start from scratch. I don’t think that it is used for documentation of internal functions, although it varies from user to user and can be used for keeping the documentation.There are no regular updates scheduled with various releases.Menu Path for transaction SE83 −SAP Menu→Tools→ABAP Workbench→Overview→Reuse LibraryTransaction Description: ... Read More

Searching data from the different system in SAP.

seetha
Updated on 30-Jul-2019 22:30:20

248 Views

You need to create a search help with custom data selection by defining a search help exit. To do custom data selection, first, go to the “Definition” tab of search help, remove all the content of “Selection method” input and now input the new function module in the “Search help exit”. The signature of the new module should be same as the F4IF_SHLP_EXIT_EXAMPLE. To do this, you can look into the documentation inside F4IF_SHLP_EXIT_EXAMPLE. Now the data from the second system can be fetched with the help of remote function call.

Viewing an ABAP program outside customer space.

varun
Updated on 13-Feb-2020 12:43:35

303 Views

The program is prefixed with “AQZZ”. This indicates that this is either created by the SAP query via transaction SQ01. You might not be able to look at the query but you can identify the Infoset on which the query relies. You can then enter the Infoset in SQ02 and when you click on ‘Description’ you can find more details. Ad-hoc Queries T-Code: SQ01 You can use this transaction to create ad-hoc queries/SAP Queries for reporting off the infoset in SAP module. When you run this T-code, you have to enter the following: Give the name of the query you want to create ... Read More

Getting age of tracefiles in SAP HANA database

usharani
Updated on 13-Feb-2020 12:40:44

372 Views

In SAP HANA database, you have diagnosis files include log and trace files, a mixture of other diagnosis, error, and information files.These files can be checked for diagnosis to find errors in SAP Hana database.In HANA db, you have trace files stored separated per host, so to get access to the trace files of a multi-node system you have to check for each host individually.To find the location of trace files in SAP HANA you can run the following SQL statement −SELECT* FROM M_DISKS WHERE USAGE_TYPE ='TRACE';To access tracefiles using the command line, you can use cdtrace as below −You ... Read More

Getting month name instead of numeric month number in report in SAP

Sreemaha
Updated on 13-Feb-2020 12:37:25

3K+ Views

There are various methods this can be donea) Use the Function module MONTH_NAME_GET - This Function module is used to return all the month and names in the respective language.b) You can also use the below formula −cstr(monthname(month({inputdate})))where “inputdate” is the date for which month name is required.c) Find the numeric value of month and use if condition. For example -IF month = “01” THEN January

Use of String.compare for a varchar field in SAP

usharani
Updated on 13-Feb-2020 12:36:25

141 Views

Try to use SqlFunctions.DateDiff method overload which requires 3 inputs as follows −var res = from a in db.Set() where SqlFunctions.DateDiff("dd", a.Date, "20161922") >= 0 && SqlFunctions.DateDiff("dd", a.Date, "20161122") < 0 select a

Generate excel from a report in SAP system

Giri Raju
Updated on 30-Jul-2019 22:30:20

388 Views

I am not sure what you are asking, reason being if you are saying that the report is running in the background, then how it will come to know where the file needs to be saved locally (where locally it should be saved).However assuming few things, what can you try out is you can generate the file (translating data into excel is not a big task and get snippets online easily) on AS.Once generated, you can move this file from report running location to location of your choice using any SHELL command. It’s not suggested that you make a connection ... Read More

Advertisements