topic Re: Accessing BAPI structures in Excel in Application Development and Automation Discussions

Accessing BAPI structures in Excel

Former Member — Wed, 10 Jan 2007 20:12:40 GMT

I am currently developing an Excel tool that calls BAPI_USER_GET_DETAIL to determine the user's firstname and lastname from the Export structure ADDRESS (BAPIADDR3). I am having trouble in how I should declare a variable to contain the contents of this structure and how to access the FIRSTNAME and LASTNAME fields of the structure. It seems that when I try to access ADDRESS as a string it returns a value of "Error 0". Any help here would help.

Thanks,

John

Re: Accessing BAPI structures in Excel

krzysztof_konitz4 — Wed, 10 Jan 2007 20:30:15 GMT

Hi,

I assume tha you are using Visual Basic...

You can find small example below. Generally structures similar to tables are managed as objects so you should define it as Object... In example I used PartnerList variable to get fields values of returned table.

Dim MyFunc, PartnerList, Row As Object

Dim Result As Boolean

Set MyFunc = Funct.Add("BAPI_FUNCTION_NAME")

Set PartnerList = MyFunc.Tables("PARTNER_LIST")

Result = MyFunc.Call

If Result = True Then

Set PartnerList = MyFunc.Tables("PARTNER_LIST")

For Each Row In PartnerList.Rows

Text = Row("PARTNER_NO") + " " + Row("BPTYPE") + " " + Row("NAME1")

MsgBox Text

Next Row

Else

MsgBox MyFunc.Exception

Funct.Connection.Logoff

End If

regards

Krzys

Re: Accessing BAPI structures in Excel

Former Member — Wed, 10 Jan 2007 21:25:24 GMT

I figured it out....seems I was doing it right all along, just didn't have the right VB to print the fields that I wanted form ADDRESS.

Thanks for the reply, it helped me see my VB mistake.

Regards,

John

Re: Accessing BAPI structures in Excel

Former Member — Fri, 07 Sep 2007 10:30:34 GMT

Hello John,

I am currently developing a Leave Application in VB that calls BAPI_USER_GET_DETAIL. I am facing same problem as u faced it earlier, to determine the user's FullName from the Export structure ADDRESS (BAPIADDR3). I am having trouble in how I should declare a variable to contain the contents of this structure and how to access the FullName fields of the structure. I hope that u overcame this problem.if so please give some details code

Thanks in advance,

Minaxi Shah