Two VBA/SAP R/3 Questions

  • Thread starter Thread starter Mark Bigelow
  • Start date Start date
M

Mark Bigelow

Hello,

I would like to do two things:

1. Update forecasts in the R/3 system via Excel VBA. There are two
ways I could do this and I would appreciate help on either one:
a. Through transaction MC94 and a VBA transaction call
b. Directly updating the R/3 table itself.

2. Call report transactions in R/3 through VBA and return the output
to Excel.

Any help would be VERY appreciated.

Thanks in advance!
Mark
 
Hi Mark
IMHO the way to go is to use SAP function modules (BAPI calls). Don'
update the tables directly (you may get problems when updating SAP)

SAP delivers example codes for calling function modules from VB, JAVA,
C++, etc. this should be adaptable to VBA (though i have never done
this).
 
Mark,

Frank is correct regarding updating SAP, use the supplied API. Even if you
could work out how to update directly, you are creating a maintenance
headache when SAP moves on . The API will be protected, the fundamentals
less likely to be.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
And another addition:
Most clients I know have prohibited direct access to the physical
database. The easiest way to do this -> you won't get a database user
:-) Only the SAP application has a DB user assigned to.

If you like, mail me directly and I can provide you some sample
code/definition to access SAP queries / output from SAP's ALV Grid.
You may also check if a real-time update is really requiered. For most
applications a batch oriented procedure works well enough. Just export
your query results by a report to a defined network path/drive (e.g. as
CSV file) and import/process this file (I know this sound like
Mainframe but still it works well)
 
Back
Top