Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 11 of 58
Making RFC call from COM/OLE object in SAP
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 MoreAuthorize a new user in SAP
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 MoreForm a dynamic Query in SAP ABAP
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
Read MoreFilter output columns in Table in SAP application
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 } }
Read MoreExport Data from a SAP system
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 usingsqvi
Read MoreDifferentiate dynamic parameter from others in SAP
It’s a straight forward way to do the same.You have to go to the transaction RZ11 for the parameter, if the dynamic field checkbox is checked it means that the parameter is a dynamic parameter otherwise it is not a dynamic parameter meaning it is a static parameter.
Read MoreSelecting cut field value of SAP tables using JCo
If you are using FM RFC_READ_TABLE, it is not achievable. In order to read SAP tables or views, SAP RFC_READ_TABLE is used.You can probably write a different Function Module to perform this. Also refer this SAP Note link: Function module RFC_READ_TABLESAP Note
Read MoreIn SAP Crystal Reports, removing extra white space between details sections
I think this can be resolved by navigating to Format Editor tab. You have to check "Can Grow", and deselect the Keep Object together in the subreport as shown in below.
Read MoreUsing Filter to fetch specific data in SAP Crystal Reports
I think you need to setup filtering in Record Selection formula. Navigate to this path to open Record Selection Formula:Report → Selection Formula → RecordThis will open a new window where you can pass your condition and rerun the report.To know more about Record Selection Formula, you can refer this link:1217147 - Crystal Reports Record Selection Formula change order when modifying it via the Select Expert.SAP Knowledge Base 1217147
Read MoreUsing SAP Server for education and training purpose
I think this can be achieved. When you create a copy of your production system, you can select which data you want to copy- you can select no for users and application data.You can use SAP TEST DATA Migration Server TDMS, to transfer limited data to test instance however it involves extra cost and not recommended until it is really required. Refer this link to know more on TDMS:SAP TDMSYou can keep both the instance- Prod and Test synchronized by using Transport Management System TMS where you can schedule transport to load data to training instance. With use of Change ...
Read More