topic Re: Create User with BAPI using "BAPI_USER_CREATE1" from Excel Macros/VBA. in Application Development and Automation Discussions

Create User with BAPI using "BAPI_USER_CREATE1" from Excel Macros/VBA.

Former Member — Thu, 21 Nov 2013 15:32:47 GMT

Hello All,

I am trying to create user at R/3 level using Excel Macros/VBA.

I am able to logon to system from the code.

But i am unable to pass values to parameters for BAPI funtion "BAPI_USER_CREATE1".

I am getting error "Structure member not found" : in second line of code ...

sample code :

Set objBAPIFunc = objBAPIControl.Add("BAPI_USER_CREATE1")

objBAPIFunc.exports("USERNAME") = "support123"

objBAPIFunc.exports("PASSWORD") = "password@123"

objBAPIFunc.exports("LASTNAME") = "support"

Any help on passing parameters to "BAPI_USER_CREATE1" is highly appreciated.

Thanks,

Sudeep

Re: Create User with BAPI using "BAPI_USER_CREATE1" from Excel Macros/VBA.

Former Member — Fri, 22 Nov 2013 04:41:07 GMT

Hi ,

Can you pass the data to USERNAME,LOGONDATA,PASSWORD and ADDRESS Import Parameter as per sequence , these import field's are mandatory , so maintain these fields in VBA Code .

also check below link ....

How to connect to SAP R/3 and call BAPI from MS Excel VBA...

Regard's

Smruti

Re: Create User with BAPI using "BAPI_USER_CREATE1" from Excel Macros/VBA.

Former Member — Fri, 22 Nov 2013 09:58:49 GMT

Hello Smruti,

I am able to call the BAPI Fuction and pass parameter.

I was passing "PASSWORD" as plain text but later found that it needs to be passed as structure like Logondata & Address.

Thanks for your reply.

But now i am stuck with other error.

I am not able to call BAPI function for releases 710 & beyond.

I am facing error "Form of address key is not defined " when i calling BAPI function with :

" objBAPIFunc.Call ".

I found one post to check SAP note 1002015 but is not applicable for releases 710 & beyond.

Please help to resolve the issue.

Thanks,

Sudeep