Exporting data from SAP system to an Excel Report

Smita Kapse
Updated on 30-Jul-2019 22:30:20

892 Views

You can write an ABAP program for exporting the data from SAP and then use a remote function call which can be invoked my macro to fetch the data. Also, you can go for creating the file itself if that fits the requirement.You can also opt for SAP GUI Scripting as an alternative. The scripting framework allows you to automate the interface for Windows and Java. It can let you perform a lot of activities.Scripting API provides you with the good number of scriptable objects which wraps the SAP GUI objects. You can use these objects from macros. SAP GUI ... Read More

Double click on ALV Grid to call Transaction and pass information in SAP

Lakshmi Srinivas
Updated on 30-Jul-2019 22:30:20

1K+ Views

You can make use of field - “wa_selrow” to define which column was clicked. Also, change the grid from row selection mode to cell selection mode.wa_selrow contains which field it is calling the transaction regardless or the field you clicked on so based on the content of wa_selrow, you can control the call to the transaction.You can also turn on the debugger and double click on the field to check what value is getting passed into wa_selfield.

Condition Variables within Sub-Query in SAP

Sai Subramanyam
Updated on 30-Jul-2019 22:30:20

191 Views

One line answer - Sub-Queries are not allowed. But if you need to handle your scenario, then you can do the following: Encapsulate your entire query into a stored procedure and then use the stored procedure. Create a view. The view is created to handle either your main query or sub-query. Create a table level variable and store the end results of view in it and then go ahead and fetch the value of table variable in the main query.

Deleting BOM component in SAP

Ankitha Reddy
Updated on 30-Jul-2019 22:30:20

3K+ Views

In order to delete a component of BOM, you can use transaction 'CS02'. CS02 is referred as Change Material BOM. It is further classified within the Logistics - General module. Module: Logistics-General Application Component - Bills of Material Package: CS Package Description: R/3 Application development: PP Bills of Material. But if you require deleting more than one BOM component then you can use LSMW script. Method: 0002 Change Program Name : RCDBI020 Once you have deleted the components if you want to verify the deletion and view the deleted components. You can view them under ... Read More

What should I install to start learning SAP ABAP?

Samual Sam
Updated on 30-Jul-2019 22:30:20

426 Views

SAP NetWeaver is a Java-based stack and its developer edition is available.https://www.sap.com/developer/trials-downloads.htmlIn SAP system, Function modules are like web services. They are used to expose the structure of the data dictionary or to expose business objects.Function modules are sub-programs that contain a set of reusable statements with importing and exporting parameters. Unlike Include programs, function modules can be executed independently. SAP system contains several predefined function modules that can be called from any ABAP program. The function group acts as a kind of container for a number of function modules that would logically belong together. For instance, the function modules ... Read More

How is GENTRAN used in Electronic data interchange EDI in SAP?

Swarali Sree
Updated on 30-Jul-2019 22:30:20

518 Views

Let me give you a basic info about electronic data interchange, it is used to exchange data (usually structured) between firms.Speaking about GENTRAN, it is one of the available EDI tools which can help you parse data in most of the common formats available. If you want to change the format of data from one to another, GENTRAN can do it for you too.Coming up to the most exciting part of it, it provides a drag and drop interface to you where you can program.Usually, when you need to convert a document from one format to another, you need to ... Read More

Displaying popup in SAP STMS

Sharon Christine
Updated on 30-Jul-2019 22:30:20

249 Views

First of all use CALL SCREEN ... STARTING AT ..., then in PBO processing, use Suppress Dialog to bypass the screen (dynpro) processor and an empty screen is not displayed, then use LEAVE TO LIST-PROCESSING in PAI event. Now you can follow it with your WRITE statements to display it as a popup.

Interfacing database to external parties in SAP system

Ramu Prasad
Updated on 30-Jul-2019 22:30:20

260 Views

Interacting directly with SAP databases is not considered a good programming practice. As SAP database is nothing but a normal database, it can interact in any way like any ODBC technique - ADO.NET or other.Remote Function Calls can be used to make calls to databases. ERP Connect supports RFC and can be used for reading data from tables.In case one needs a high customization and control, one can create a custom RFC component to fetch and return the intended data.

Finding code where admin user is created in SAP Hybris

Sai Subramanyam
Updated on 30-Jul-2019 22:30:20

202 Views

There is a method addUserRights at below path in which it is done.hybris/bin/platform/bootstrap/bin → ybootstrap.jar → DMLRecordFactory

Seeing list of all program screens in SAP ABAP

Sai Subramanyam
Updated on 30-Jul-2019 22:30:20

974 Views

If you want to check all Dynpros belongs to one program, you can use table D020S. D020S is known as SAP Table to store screen sources information. This is available within R/3 SAP systems depending on the version and release level. To display or maintain this table, use T-code SM30 You can use T-code SE11 to view the fields in table D020S: It is text table D020T with the key program = sy-repid

Advertisements