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).

--
Regards
Frank Kabel
Frankfurt, Germany

Mark Bigelow wrote:
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

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)

"Frank Kabel" wrote in message
...
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).

--
Regards
Frank Kabel
Frankfurt, Germany

Mark Bigelow wrote:
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

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)


--
Regards
Frank Kabel
Frankfurt, Germany

Bob Phillips wrote:
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.


"Frank Kabel" wrote in message
...
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).

--
Regards
Frank Kabel
Frankfurt, Germany

Mark Bigelow wrote:
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