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
-
Economics & Finance
SAP Articles
Page 69 of 91
How can I update a third party database outside SAP after completing a Transaction?
As you need to make some changes to happen when an activity gets completed in SAP, I would suggest you to go for services. Services are the best way to communicate when you are dealing with two discrete systems.Firstly you need to create a program on SAP side which can do the following task Fetch the file from a specified directoryConverts the file into a formatted data or send the data to a serverAt the webserver end, have a listener which receives POST requests (send by SAP). You need to have proper authentication set up ...
Read MoreHow to send MATMAS and DEBMAS idoc to other SAP system
I would suggest you to use T-code: BD12 to send the complete IDoc of DEBMAS.
Read MoreHow to avoid memory leakage in SAP B1 DI API
The thumb rule goes like this, if you instantiate a DI API object, you have to release it. if you don't release it explicitly, it will result in memory leaks.You can use a ReleaseComObject method to release the object memory. In case if you try to release a null object, it will throw an exception.So, it will be better to have a null check before you try to release the object.Sample snippet:if (obj != null) System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
Read MoreUsing SAP ABAP, how can I read content of CSV files in a directory to an internal table?
There are many functions that can be used to read csv however many are broken and read part of content. You need to go through each file and then process the file content. I would prefer to perform this manually.You can use the READ DATASET to read data from a file on the application server. Below is the syntax:READ DATASET INTO [LENGTH ].Below is SAP documentation link that you can use to know more about reading data from files:SAP DocumentationExampleIncase you are using binary mode, you can use LENGTH to find the length of data transferred to . ...
Read MoreIn SAP system, auto filling of NAME_1 while entering client number
You should use maintenance view to display name corresponding to customer number. With use of Maintenance view, you can maintain related data in several tables. Check out this link to know more about Maintenance view:SAP LinkTo perform a check for the mandatory, edit the generated screen and in screen flow logic you should add a module to check if the required fields are filled or not. You can also set the field possible to mandatory in the screen field options, however this is not recommended as it will show it as mandatory even for empty lines.SAP Link
Read MoreIn SAP Crystal Reports, Putting 2 pages of data into a single report
You can do this by adding a group based on participant Id as primary key. Then you have to add ran description in group footer.In your group footer settings, check the "New page before" option
Read MoreSystem goes out of memory on establishing connection in a SAP-Delphi integrated project
When you are trying to release the object, make sure that you set the query object to null. When you set it to null, it will release the memory for sure. But the scope also plays a role, so make sure it is local to the procedure.Example Please find a sample snippet for reference myFunction := TSAPFunctions.Create; myFunction.Connection := FConnection; myFunction.RemoveAll; myQuery := mySAPFunction.Add('interface here'); myQuery.Call; myQuery := null; // will clear the memory Hope this helps!
Read MoreFetch max date and other field from the same row of a table grouped by other fields in SAP HANA
You have done partially correct but just missed one step further to get the desired result. The case where after grouping you need to pick one of the rows from the results, use rank number or rank function.You need to partition your data based on your requirement, then order them as per your requirement again then pick the desired row.ExampleFor e.g. partition your data by Item Number and Shop Id. Then order them in descending order of Date column. Then pick the row with row number as 1select date, Order_Number from (SELECT *, row_number() over ( partition by ...
Read MoreModification not working for both internal table and control table in SAP ABAP
There seems to some mistake in your update modle. PFB the updated oneExampleMODULE update INPUT. MODIFY snctab INDEX ctrl-current_line. IF sy-subrc 0. APPEND snctab. ENDIF. ENDMODULE.
Read MoreIs Pivot available in SAP HANA
As per my understanding, for requirement #1 you can do something as below:SELECT Prod.Product_ID, JOB.Job_ID, SUM(J.Time) FROM TABLE_1 Prod INNER JOIN TABLE_2 Job ON Prod.Job_Id = Job.Job_ID GROUP BY Prod.Product_ID, Job.Job_IDSAP HANA does not support Pivot built-in as done by SQL but majorly it looks as a UI requirement. So what you can do is send the entire result to report and apply transformation in the report as per your requirement.
Read More