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.)
@csongorvarga
5 жыл бұрын
Thanks for the clarification
@SS-eb6wk
2 жыл бұрын
Thanks fo this very informative video. It's perfect!!!
@sidztube
3 жыл бұрын
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
@ivnunitec6687
4 жыл бұрын
Muy bien explicado, me sirvió mucho!!!
@andonii46
5 ай бұрын
Great video! Do you know which roles and so on is needed for a SAP user in order to use this?
@csongorvarga
5 ай бұрын
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.
@henriqueravellyrodriguessa5546
6 жыл бұрын
parabéns, ótimo conteúdo.
@csongorvarga
6 жыл бұрын
Gracias
@madhavanksm
4 жыл бұрын
Hi, Is the sales Order configuration can be changed using BAPI.
@juanlpalmanzar8345
6 жыл бұрын
Muchas Gracias,saludos dede RD.
@mafh60
3 жыл бұрын
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.
@kobethereal
7 жыл бұрын
hey great video:)! continue your good work new subbie here :)!
@merrylamb123
5 жыл бұрын
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?
@csongorvarga
5 жыл бұрын
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.
@kirangharat1401
5 жыл бұрын
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 ?
@csongorvarga
5 жыл бұрын
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.
@kirangharat1401
5 жыл бұрын
@@csongorvarga Thanks for you quick response! Can we go for other scripting applications such as uipath, winshuttle etc. Which one you would suggest?
@dominiquenoel939
7 жыл бұрын
Nice. Thank you.
@ThejaswiS
5 жыл бұрын
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 ?
@csongorvarga
5 жыл бұрын
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.
@ThejaswiS
5 жыл бұрын
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 🙏🏻🙏🏻🙏🏻
@jcvelardes
3 жыл бұрын
@@ThejaswiS Hi, please ¿could you resolver connection issue in excel 64 bits?, many thanks.
@flaviociotola766
3 жыл бұрын
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
@pradhumandhakad9971
3 жыл бұрын
have you working with BAPI with post data
@aparnakadiri7621
2 жыл бұрын
Hello sir, Could you please do videos How to create po using excel sheet through BAPI.
@JuanaMariaGomez
5 жыл бұрын
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?
@csongorvarga
5 жыл бұрын
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.
@JuanaMariaGomez
5 жыл бұрын
@@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
@JuanaMariaGomez
5 жыл бұрын
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 !!
@csongorvarga
5 жыл бұрын
@@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
@danielpedrosa3948
5 жыл бұрын
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?
@swathiaragola1960
5 жыл бұрын
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.
@csongorvarga
5 жыл бұрын
The Api reference is probably missing.
@swathiaragola1960
5 жыл бұрын
@@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
@rogeryu2298
9 ай бұрын
do you know how to read table data within export parameters? thanks
@csongorvarga
9 ай бұрын
I am not sure what you mean. Table data like in SE16?
@rogeryu2298
8 ай бұрын
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
@deepaksinha8010
6 жыл бұрын
I am getting confuse to learn vba with sap do you have any book to learn as beginner
@csongorvarga
6 жыл бұрын
I don't. But there must be a lot of books, online materials and also KZitem videos on Visual Basic or VBA programming. Try those.
@Aldrannt
2 жыл бұрын
hello, do somebody have the links to the dlls please?
Пікірлер: 41