Connecting to BW using VBA

[Former Member]

Hi All

1) Can anyone provide me with a sample coding on how to connect to business warehouse using VBA?

Also by connecting to business warehouse, do we need a loginid/pwd as I have SAP account already?

2) Is it possible to insert data to SAP using VBA?

regards

TJ

[michael_hobbins · Accepted solution]

Hello TJ, answers in order.

1. I haven't worked with BW, but I assume you ave RFC access link in ERP, for this check the sample on [; or [;. You'll have to find out which function modules/BAPIs serve your purposes.

Regarding logon, yes you need one (as you can see on the first link above). You'll have to create a service user (it's a simple user with USER TYPE= COMMUNICATION set in transaction SU01), and set profiles with appropriate authorizations. Service users can't be used to logon via SAPLogon, they are specially meant for interfases (eg: VBA connecting to SAP)

2. Yes, at least for ERP. You usually have function modules/BAPIs to read and to write data. The sample on the first link mentioned writes data.

Cheers

Michael