Found 1044 Articles for SAP

Displaying Records with maximum event number for each group in SAP Crystal Reports

Lakshmi Srinivas
Updated on 11-Dec-2019 07:40:46

381 Views

I would suggest using this logic to suppress details if the current record is not the record with the maximum amount for the group.//Suppress Details if the current record is not the record with the maximum amount for the group {Event.Event_no}maximum({Event.Event_no},{Deal_NO})This will suppress each record except records with the maximum amount each group.

Finding the table from which data is fetched in SAP

Giri Raju
Updated on 13-Feb-2020 12:49:48

798 Views

You can get the data if it is displayed in a transaction. Here are the steps you need to follow.a) First point the cursor on the field for which you want to get the data.b) Press F1 for help. This will open a dialog with heading “Performance assistant”c) Click on the “Technical information” button. This will open up another dialog boxd) You will be able to find “Table name” and “Field name”Generally, this will tell you the table in the database .If you are not able to get the required information, run a trace using ST05. In SAP system, SQL trace ... Read More

Finding where-used list of SAP standard programs

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

756 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

280 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

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

Multiple ALV grids on a single screen in SAP ABAP

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

828 Views

It is not possible to resize or place the grid at the particular position using function modules as ALVs are always displayed in the Fullscreen by using function modules.One of the method this can be done is that you create a screen using custom container and then use the class CL_GUI_ALV_GRID to attach the ALV grids to this container at desired positions.

Suppressing the page header till the last page in SAP Crystal Reports 2008

Samual Sam
Updated on 11-Dec-2019 06:39:18

538 Views

I think you would require to use “OnLastRecord” keyword for page header suppression. Below are details about this function:Function Description:This function returns “TRUE” when the current record being evaluated is the last record in the report.Returns:Boolean ValueAction:This function returns “TRUE” when the current record being evaluated is the last record in the report.Note that any field that you are grouped and you want to suppress on the last record for this group, or use the next () function as shown below:onlastrecord or next({table.field}){table.field} Example:GH1 (using Customer.ID as group) GH2 (using Sales.No as group) Details GF2 - has line drawn on it ... Read More

Viewing an ABAP program outside customer space.

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

169 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

Determining values of parameters of given type on a given selection screen in SAP

varma
Updated on 13-Feb-2020 12:42:12

579 Views

The function module RS_SELSCREEN_INFO will provide you with the list of parameters and selection options once the report name is input. You can see full details about this FM by entering the name RS_SELSCREEN_INFO into the relevant SAP T-code like SE37 or SE80You can call this FM RS_SELSCREEN_INFO as below −CALL FUNCTION 'RS_SELSCREEN_INFO' "    EXPORTING       report =                    " rsvar-report Report Name    TABLES       field_info =                " scr_info     Information about type, reference field, etc.    EXCEPTIONS ... Read More

Getting age of tracefiles in SAP HANA database

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

193 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

Advertisements