SAP Function BAPI Scripting - Calling RFC FM from Excel
ฝัง
- เผยแพร่เมื่อ 11 ก.ค. 2024
- This is my first video on SAP Functions where I cover the basics by showing how I call a RFC FM in SAP from MS Excel.
Link to the sample Excel file: drive.google.com/file/d/0Bw1X...
GUI Scripting Documentation: drive.google.com/file/d/1SCPj...
All my GUI scripting files on Github (in case you cannot access the above link):
github.com/nygma2004/km/tree/... - วิทยาศาสตร์และเทคโนโลยี
![ชวนน้องลงทุ่ง - เงาะน้อยเพชรบ้านแพง X น้องมายด์ [ Music Video ] Official Saman Music](http://i.ytimg.com/vi/Bq7Hw9culjE/mqdefault.jpg)
Muy bien explicado, me sirvió mucho!!!
Thanks fo this very informative video. It's perfect!!!
Well done, Csongor!
Just to clear up confusion about importing and exporting parameters (at 15:38) of an SAP function:
An import parameter (from the function’s point of view) is exported to the function from the caller’s side. That’s why it is called an export parameter from the caller’s point of view. Likewise, if the function exports a parameter, the caller imports it to its own context. Thus the naming is reciprocated.
Note that table parameters in SAP are import and export parameters at the same time so they are referenced as tables on both sides. (You can use tables for only importing - or exporting - data but then you need different typing for them.)
Thanks for the clarification
parabéns, ótimo conteúdo.
Gracias
Muchas Gracias,saludos dede RD.
Nice. Thank you.
hey great video:)! continue your good work new subbie here :)!
Thanks for the video. I have a query- How to declare the .exports parameter for Bapi IMPORT parameters which have multiple columns. eg IMPORT PARAMETER IT_SYS_RANGE in BAPI GRAC_API_RISK_ANALYSIS
Hi,
Is the sales Order configuration can be changed using BAPI.
hi, i love your video it’s to clear, i have a question, perhaps you can help me, i need to get logged in to sap using nfc i have the .cer and .psi file, i can’t figure out how to do it, i saw a lot of information that using nco 3.0 it’s posible, using c# but i want to do from excel.
Hello Sir, awesome video once again. May i ask- how do you know the exact names of the objects for declaration purposes? Example- "SAPFunctionsOCX.Parameter" & "SAPTableFactoryCtrl.Table"? Are there any helpful object libraries/ web references you can recommend?
Hmm, it was a long time ago, and I don't remember to be honest. After all there are only 3 options, importing and exporting parameters and tables. I probably figured it out from other examples I have stumbled upon.
Great video! Do you know which roles and so on is needed for a SAP user in order to use this?
Sorry, not from the top of my head. But I have the link to the official SAP documentation, if there is anything is should be documented there.
Hi Varga,
Your videos are really helpful. Can you also suggest on SAP web UI specific examples. Like how We can automate processes on CRM web ui ?
That would be awesome, but I believe there is no option to script anything in the WebUI. And probably nothing in the new Fioiri either.
@@csongorvarga Thanks for you quick response! Can we go for other scripting applications such as uipath, winshuttle etc. Which one you would suggest?
when you did this demo where you using a saprouter? how do you do it when you have a sap router? and any other special considerations?
I never use a SAP router. I don't think there is any consideration. GUI scripting does not care how you are connected to the SAP system. You GUI is already connected to SAP when you launch the script.
@@csongorvarga i am getting this error - RFC_ERROR_COMMUNICATION
Message
LOCATION CPIC (TCP/IP) on local host with Unicode
ERROR partner 'xx.xx.xx.xx:3300' not reached
TIME Tue Aug 20 09:45:42 2019
RELEASE 749
COMPONENT NI (network interface)
VERSION 40
RC -10
MODULE D:/depot/bas/749_REL/src/base/ni/nixxi.cpp
LINE 3428
DETAIL NiPConnect2: xx.xx.xx.xx:3300
SYSTEM CALL connect
ERRNO 10060
ERRNO TEXT WSAETIMEDOUT: Connection timed out
COUNTER 18
i had not been able to bypass that one - by the way - what i great video!! and material!! you really are very good!! thank you for this !!
@@JuanaMariaGomez I added a link to the video description for all my SAP materials on GUI scripting. Maybe that has something on SAP router. GUI Scripting Documentation: drive.google.com/file/d/1SCPjAR8EVcZ7TtBewkhynaH1dm8D4Ntx/view?usp=sharing
Your earlier video regarding SAP GUI Scripting helped a lot . After I saw this video , I think I can speed up execution by calling BAPI SAVEDATA directly. You were of great help . Thank you. Now I landed in new issue. Am having 64 bit excel and is throwing activex error for SAP Logon object itself. Is there any solution for this without downgrading to 32 bit excel ?
That is a really good question. I am using it on a 64bit Windows10. I was not aware that Excel itself can be 32bit and 64bit as well. I don't have an answer now.
Csongor Varga oh ok.. noted. I saw some registry setups but I wanted to keep it simple.. anyways will google more towards that’s. Your above video helped a lot. I was finding gui scripting slower compared to sending data to bapi as it goes through each screen. This will help fine tune further if am able to resolve connection issue. Thank you for the video 🙏🏻🙏🏻🙏🏻
@@ThejaswiS Hi, please ¿could you resolver connection issue in excel 64 bits?, many thanks.
Hello all, I'm also trying to connect SAP with MS Excel (2016 64-bit) and indeed having an issue with SAP Logon (interface not registered). Do you have a solution for this error? Many thanks in advance for any help on this
Great video. I'm having a problem. It worked one time. Good. When I click again to reconnect, Excel blocks and reinicialize. Are anyone facing that?
I am getting confuse to learn vba with sap do you have any book to learn as beginner
I don't. But there must be a lot of books, online materials and also TH-cam videos on Visual Basic or VBA programming. Try those.
hello, do somebody have the links to the dlls please?
Great Video! I am new to VB Scripting, just followed your code to and created a script, but I am getting "ActiveX component can't create object error". Request you to comment on this. Any work around.
The Api reference is probably missing.
@@csongorvargaLet me give u a background on the work I have done till now. I am working towards uploading an excel to SAP and execute a RFC.
This Excel is working as expected in a Windows 7, but not working on Windows 10.
The Windows 10 system is a 64 bit processor, Excel is also 64 bit and VBA is also running on 64 bit processor.
I am using the below libraries
1. sapfewse.ocx (SAP GUI Scripting API)
2. wdtaocx.ocx (SAP Table Factory)
3. wdtlog.ocx (SAP Logon Control)
4. wdobapi.ocs (SAP BAPI Control)
5. wdtfunc.ocx (SAP Remote Function Call Control)
Yet I am getting “Run-time error ‘429’: ActiveX component create object” Error, for any createobject statements such as,
1. Set objBAPIControl = CreateObject(“SAP.Functions”)
2. Set LogonControl = CreateObject(“SAP.LogonControl.1”)
3. Set Functions = CreateObject(“SAP.Functions”)
4. Set TableFactory = CreateObject(“SAP.TableFactory.1”)
5. Set objConnection = LogonControl.NewConnection
Please advise, how I can avoid this error and proceed further.
Thanks,
Swathi
have you working with BAPI with post data
do you know how to read table data within export parameters? thanks
I am not sure what you mean. Table data like in SE16?
thanks. for example, export parameter in function module is table type, i cannot find a approach to read table data via VBA. is it possible to read table data? @@csongorvarga
Hello sir,
Could you please do videos
How to create po using excel sheet through BAPI.