Read SAP tables in UiPath with RFC_READ_TABLE
ฝัง
- เผยแพร่เมื่อ 5 ก.ค. 2024
- This video provides a tutorial on how to read SAP tables with the remote-enabled function module RFC_READ_TABLE. It makes a case for why we should use it and presents as well some of its limitations. Then it shows a short demo of using it for Purchase Orders and explains how its parameters could be set up to choose which data to be returned and filter through the results.
Thanks to Stefan Schnell for his valuable input here. You can check out his website:
www.stschnell.de/
00:01 Topic and summary of the video
00:52 UiPath Hacks intro theme
01:16 What is the RFC_READ_TABLE
02:03 Example workflow for RFC_READ_TABLE
07:15 How to enter multiple filtering conditions
10:59 Limitations of the RFC_READ_TABLE
12:00 Wrap-up and conclusion
Let us keep in touch:
/ gabrielverzea - วิทยาศาสตร์และเทคโนโลยี
![[TH] VCT Pacific Stage 2 - Week 4 Day 1 // PRX vs RRQ | GE vs GEN](http://i.ytimg.com/vi/iIi2_04jGr0/mqdefault.jpg)
Very new content and very helpful
Thank you !
good technical knowledge !
thx ! :)
Thanks for sharing
My pleasure, Kagi :) Hope it helps.
Nice lecture 👌👌
Thanks a lot
Amazing
indeed, great functionality!
Great video! One question that comes to my mind, what if you want to make SQL queries to several tables using inner join and so on?
How do you do an OR and an AND in the where clause? ex: MATNR = 'MM1' OR MATNR = 'MM2' AND WERKS = 'Plant1'
Hi, i tried to install der package UIpath.SAP.BAPI.Acitvities and got a message:"Unable to load the service index for source ..." After research in some forums i got a tip to install SAP Connectors für Microsoft .NET 3.0 (NCo 3.0) and Microsoft C++ Runtime DLL Version 10.0 . had anyome this problem too and is that really the solution? my employer does not allow to install everything. i have to apply official to install that by our admins. so i want to be sure ,that this could be the solution.
Can we add more than 3 filter/ where clauses ??
Hi Ramya. You mean the filters applied from minute 7:15 onwards ? yes, there should be no real limit. Did you try it and got errors ?
@@UiPathHacks Yes I tried and got as max length issue
@@ramyayadavalli3705 I was not aware of that, I guess I did not try as many filters at the same time.
I want to perform activity after the SAP Report loading the data . what activity we should use. some reports taking 30 sec some takes more than 10 mins . how to handle this.
Hi Rathika. for this purpose, I usually check the status bar on the SAP GUI. There usually we get a message when the transaction finished running. Or I check if a button exists, that only exists after the results screen appears (eg. export button). Does this answer your question ?
@@UiPathHacks I will try and let you know. Thanks for the reply
@@rathikavenkatesh2510 You are welcome !
@@UiPathHacks how to check the excel completedly exported from sap. We dnt have the row count
@@rathikavenkatesh2510 that's a great question. In most cases, we would probably get away with a Delay, even if it is not the most efficient solution. But if the waiting time can be much higher until the file is downloaded, I am thinking about checking the file size every few seconds, and when it stops increasing, it means that the file is completely downloaded.
Can you share the xaml? Thanks
sure! just send me a message on my email or linkedin.
@@UiPathHacks I just sent you an email for it also.
@@melissakeays3122 sent you the file. Hope it helps !