Skip to Content
author's profile photo Former Member
Former Member

Mandatory field missing

Dear all,

I am new to excel vba. I have writen this procedure in excel to retrieve a list of GL accounts from the system but somehow i got this in return.


Set oBapiControl = CreateObject("SAP.BAPI.1")

oBapiControl.Connection.System = "AAA"

oBapiControl.Connection.client = "100"

oBapiControl.Connection.Language = "EN"

Set oConnection = oBapiControl.Connection

If oConnection.logon(0, False) <> True Then

Exit Sub

End If

Set GlgetList = oBapiControl.GetSAPObject("BUS3006")

Dim oCompanyCode, oLanguage, oLanguageiso, oReturn, oAccountList As Object

Set oAccountList = oBapiControl.dimas(GlgetList, "GetList", "AccountList")

GlgetList.GetList Language:="EN", _

Return:=oReturn, _

AccountList:=oAccountList, _

CompanyCode:="1000", _

LanguageIso:=" "


somehow i got this in return -> "Mandatory parameter ACCOUNTLIST was missing". I have declared the AccountList but it still returned this message. What could i missed in the first place??? What is best recommedation on this, please advice. Your help is much appreciated.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2005 at 12:07 PM

    Hello Andrew,

    Everything looks ok in your code.

    But I saw in my system and maybe it is a type problem.

    The parameter name in my system is ACCOUNT_LIST and not ACCOUNTLIST as you typed.

    You can see it using transaction BAPI or SE37 for function module BAPI_GL_ACC_GETLIST.

    Try to change the parameter name to ACCOUNT_LIST.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mauricio,

      Actually after much of a checking i found out that there's no problem with it. In fact i managed to retrieve the data as i wanted from the system but somehow i still get this message..... i will find out more and should there be any findings i will let you know



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.