sap

Hi All, I have been reading through this forum for a while and struggling to come up with a solution. In my job we have a spreadsheet that has to have two spreadsheets (downloaded from SAP) daily, these need coping and pasting into a tab on our spreadsheet and completing a SUMIF, now the Macro...

Hi all, I would like to ask what're the best MACRO options out there to automate data into SAP system. The primary focus is to copy a bunch of data (from excel) into SAP Vendor Master Data (XK01) automatically. Based on my limited knowledge, these are the only options I'm aware of: SAP LSMW...

Hi Everyone I'm creating a spreadsheet that will create and issue reservations in our SAP ERP system. The amount of materials that will be in the created reservation is variable so I need to do an if formula or a loop of some kind, so it knows when to end and hit the save button (instead of...

Hi Experts, Sorry for the specific use case and the inclusion of SAP but I have searched the Forum and other resources and I cannot seem to figure this one out. I am hoping someone out there is using SAP at there company and maybe has had the same use case. I am hoping to have a formula (not...

Hi. I'm trying to connect to SAP Logon with VBA but I'm getting the error 429: The ActiveX component can not create the object. In this point 429 error: Set oBapiCtrl = CreateObject ("sap.bapi.1") Set oBapiLogon = CreateObject ("sap.logoncontrol.1") VBA Code: Sub sap() Dim oBook As...

Does anybody have any knowledge of how to extract data from SAP through VBA? I would like to extract data from eg. CKIS (product costing). It would be helpful with any kind of code, that would connect me to SAP.

Hi all I regularly download SAP reports of varying filters but pretty much standardised list of columns. Many of these columns require conversion to number values, column width adjustments, groupings, alignments etc before I am comfortable to put them into a standard report for sharing with...

Hello! i'd like to print the reservations already made.In this case, i have to mark each file that i want to print. i 'd like to insert this code on my script everytime it needs to drop down the bar, otherwise it will stop printing. session.findById("wnd[0]").sendVKey 82 Thanks! Sub Press()...

Hi Everyone I have a code to Automatic log in a website..the website having Image login button. The problem is this code does not click that login button. Anyone knows how to click on this type of image button. VBA Code Sub Auto_login() Set IE = CreateObject("InternetExplorer.Application")...

I am evaluating SAP BO 4.0 for our BI implementation.I have been exploring SAP BO web intelligence. Once of my concern is when creating reports, it often breaks. And the new functionality of bringing in data from excel spreadsheets and merging with existing universe doesn't work as expected...

Hi I've done numerous SAP records in the past with no issues, but am having issues with this particular one. Due to the way the SAP page is set up the only way I can extract the data is via the Spreadsheet option in SAP. When you do this option manually it opens up the spreadsheet as a...

Hi could someone help with a VBA which automatically runs a VBS sap script from excel? i'd like to print the reservations already made.In this case, i have to mark each file that i want to print, manually.So, how do i tell the program that i want to print only the 5 or 10 last reservations made...

Hi, Is there a way to copy data from SAP to excel using SAP? Currently Im doing it manually by copying the data to excel then back to SAP and turn to next page copy again the data, paste and back to SAP then turn to next page and again and again.. Thanks,

This might be a little complex or abstract to understand without seeing or if the process is unfamiliar but I'm stumped so I have to ask.. To explain a little easier it really is just a looping order issue, and how to pick up where I want it to. The input spreadsheet has a value in column 1...

Hi all, I'm retrieving data from the SAP Erp system using a main macro that calls several macros, using a structure like this: sub Main() call Macro1 'get parameters from the Excel worksheet call Macro2 'input some basic parameters in SAP call Macro3 'get first data from a SAP transaction...

I have mention code and it creates pivot table, but concern is it gives error as 1004, I am using excel 2016. Any Idea. Code:- Private Sub CommandButton1_Click() 'Sheets("AG1 Node Down").Select Dim Pt As PivotTable Dim PtCache As PivotCache Dim pageField1 As String Dim pageField2 As String Dim...

Hi, I'm new to the SAP GUI scripting and I'd like to understand some line of codes. Set SAPGUIAuto = GetObject("SAPGUI") 'Get the SAP GUI Scripting object Set SAPApp = SAPGUIAuto.GetScriptingEngine 'Get the currently running SAP GUI Set SAPCon = SAPApp.Children(0) 'Get the first system that...

Is there a way to determine which SAP environment I am logged on (System ID/Client) using VBA?

Hi everyone. I've tried a number of examples to get this thing working but I have looked at so many versions I've confused myself, hoping you can help. Cell holding the formula: E6 I need to look up cell B6 (this will copied down the column, so next row is B7 etc etc) Look up B6 in range 'SAP...

Hi All, I'm new to the forum and pretty new to VBA so be easy with me :) I'm currently trying to write a script that will run a transaction in SAP, and download the output to a specific location. There are 2 ways to download the output, one through the menu structure in SAP which I can code...