Found 1039 Articles for SAP

Identify SQVI queries formed by a user in SAP project

SAP ABAP Expert
Updated on 06-Dec-2019 06:33:17

258 Views

You need to use the function RSAQ_REMOTE_QUERY_CALL_CATALOG for fetching the list of SQVI queries for a user.

Export Data from a SAP system

SAP ABAP Expert
Updated on 12-Jun-2020 09:03:49

852 Views

Your question seems to be uncertain. SAP stores data in database and SAP database structure is not conventional and quite complex.  You need to code separately on top of SAP to support export data to outside world and you are free to choose format of your choice.Identify the user specific SQVI queries in ABAP/BAPI. With use of QucikViewer (SQVI), it is a tool for generating reports. SAP Query offers the user a whole range of options for defining reports.Transaction Code: SQVI (Quick Viewer)You can check out this link to know more how to generate report:Create Report by usingsqviRead More

Filter output columns in Table in SAP application

SAP ABAP Expert
Updated on 12-Jun-2020 09:04:29

252 Views

I think there can be a better option to do this. What you can try is fetch only the fields of the table which match the fields present in the table. Do not fetch all the fields of the table but the selected fields.// Here Table refers to the JCo.Table for (int j = 0; j < Table.getNumRows(); j++) {    Table.setRow(j);    Iterator iter = displayField.iterator();    // fetch columns present in the current record    while(iter.hasNext()){       String column = (String) iter.next();       String value = Table.getString(column);       // perform your logic here    } }

Sort Datetime Type in SAP ABAP

SAP ABAP Expert
Updated on 30-Jul-2019 22:30:20

491 Views

There are two operation LT (Less than) and GT (Greater Than) which you can use to perform basic comparisons between two variables.You can frame the logic as per your requirement whether you have a set of variables or a table. If it involves set of variables then you need to do manual comparisons.

Connect to SAP system from C# application

SAP ABAP Expert
Updated on 30-Jul-2019 22:30:20

768 Views

There is nothing like standard but you need to specify all required details for a successful connection.XXXX-  H/IP Address/S/Port NumberHere H stands for Host, IP Address is the IP Address, S stands for Port Number

Form a dynamic Query in SAP ABAP

SAP ABAP Expert
Updated on 12-Jun-2020 09:15:33

847 Views

You can indeed achieve it. You just follow the below steps:Step 1 − Define the input parametersDATA:   table_name  TYPE string VALUE  ‘TABLE’, column_name TYPE string VALUE  'COLBNAME', name_value  TYPE string VALUE  'COLVALUE'Step 2 − Create a table type to hold the output results.DATA:   results TYPE REF TO data, TableType TYPE string FIELD-SYMBOLS TYPE STANDARD TABLEStep3 − Create a dynamic query to fill the table 

Authorize a new user in SAP

SAP ABAP Expert
Updated on 12-Jun-2020 09:27:54

418 Views

Basics things first, even if you are using a trial version but you still need to provide the license information and a developer key.Instead of using a DDIC user, you can try using a BCUSER for your requirement as it is a part of the trial version.You can try to include the SAP_ALL profile for your designated user.SAP_ALL get’s generated automatically whenever you transport authorization objects.You can generate SAP_ALL using report RSUSR406 or transaction SU21. This generates SAP_ALL only in the client where this report is executed. You can generate SAP_ALL using report AGR_REGENERATE_SAP_ALL. This report generates SAP_ALL in all ... Read More

Move data from one warehouse to other in SAP MM

SAP ABAP Expert
Updated on 12-Jun-2020 09:29:34

148 Views

You can try using an existing function module “bapi_goodsmvt_create” which will let you do very easily what you require.

Making RFC call from COM/OLE object in SAP

SAP ABAP Expert
Updated on 12-Jun-2020 09:28:53

305 Views

To communicate between SAP systems, there is a need to define a mechanism. One of the most common ways is to define Remote Function Call (RFC Connection) between two systems. By creating a trusted RFC connection between two systems, it allows you to create trusted-trusting relationship between systems wherein, you can communicate and exchange information and data.There are different types of trusted RFC connections.Type 3 ConnectionType I ConnectionType T ConnectionTo know more about SAP RFC connection types, you can refer our SAP Basis tutorial link:SAP Basis Remote Function CallLet us come to case mentioned, OLE object with RFC function has ... Read More

Getting an error on creating an Index in SAP HANA

SAP ABAP Expert
Updated on 12-Jun-2020 09:30:41

480 Views

I think if you would have gone through the documentation or gone through the message “column already indexed” carefully, you would have figured out that the index already exists.If the data type of the column is TEXT then HANA by default creates an index on it. What you can do for better performance is change the data type of the column to BLOB.BLOB − stores large amount of Binary data.

Advertisements