Hello
The project isn't all that difficult. I can send what Ive built so far, and that will provide some direction. I need someone to take it to the next step. What I need is - once this script logins to SAP BW-EX (which is the web-based version of SAP), I need the script to open the variables table, insert a number for a cost category, then SAP will bring up a table of basically just a big buget - I want excel then to pull that data back into the spreadsheet.
In VBE, I want this to be in 'ThisWorkbook' and trigger on workbook_open().
Really its fairly simplistic, Ive done things like this before -just dont have time to do it right now. That said, the other thing Ive never done is trigger the variables table > insert a value. There's lots of information online about how to do it, again I just dont have the time to sort through it all and develop something. Once someone contacts me and knows they can do the work, Ill let you know
I'm a SAP BW Consultant and I've done this kind of implementations on BW. But I would like to ask you why don't you use SAP BW Bex Analyzer to get the data directly to Excel.
Any way if you need to get the data in your way thatexplained,I will need some information.
* how many cost category you have.
* is there any other variables that will be change according to category changes such as period or category type etc.
* Will there be only one excel woorkbook that includes all data you need?
*Will this workbook be used only once or should it be a generic implementation?
Please feel free to ask questions.
I am a chartered accountant in India and I have worked on sap for more than 5 years. I am good with excel so I believe I can do the work. I will need your guidance in some ares though.
I have been working as an Accountant for the last 10 years,i am a proficient user of excel and therefore has the ability to meet your requirement. i am also an entrepreneur and believe in independence, hence i work with little or no supervision.
I am committed and dedicated person and once the work is given to me is my pleasure to complete the it before time.
I will be happy for further discussions.
WHATSAPP 00233 209520786
Thanks in advance for your partnership
With over 15 years of working experience in the field of Accounts-Finance-Capital Markets-Forex-Commodities. Presently working with USA-CPA Firm as Manager Finance for their clients Profit & Loss, Balance Sheet, Annual Tax Return, Payroll, Inventory Management etc.
I have SAP and scripting experience and I think I can help you with the problem you have explained. I have experience with R/3, Dynpro screens and Automation testing so this should not be difficult to fix.
Hello Sir, thank you for allowing me to bid on this project and i promise to complete any Administration or Clerical work which involves Data entry, form filling, Excel , Word and any type of posing mostly numerical.