topic Re: HELPVALUES + GETLIST in Application Development and Automation Discussions

HELPVALUES + GETLIST

Former Member — Fri, 22 Oct 2004 14:19:00 GMT

Hello Friends,

I am trying to call the BAPI 'BAPI_HELPVALUES_GET' for the Business partner, actually I wana see the list of all aviable Business partner avaiable in the system.

Here is my code:

data: des_Table type standard table of BAPIF4E with default key,

wa_myTab like line of des_Table.

data: val_Table type standard table of BAPIF4C with default key,

wa_myTab1 like line of val_Table.

data: help_Table type standard table of BAPIF4D with default key,

wa_myTab2 like line of help_Table.

CALL FUNCTION 'BAPI_HELPVALUES_GET'

EXPORTING

OBJTYPE = 'BUS1006'

OBJNAME = 'BusinessPartner'

METHOD = 'GetDetail'

PARAMETER =

FIELD =

EXPLICIT_SHLP =
MAX_OF_ROWS = 0
DESCRIPTIONONLY = ' '
IMPORTING
RETURN =

TABLES

SELECTION_FOR_HELPVALUES =

HELPVALUES = help_Table

VALUES_FOR_FIELD = val_Table

DESCRIPTION_FOR_HELPVALUES = des_Table

But when i execute the above code, it gives me the following error !

"Field "TABLES" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement."

I have no idea why this error is comming, though I have specified all mandatory tables,

and also can any one help me in identifying what should i have to send in parameter and field, in export parameter.

Many thanks

Marek

Re: HELPVALUES + GETLIST

Former Member — Fri, 22 Oct 2004 14:37:32 GMT

Hi Marek,

Because you have commented out al lot of parameters, but not 'PARAMETER =' and 'FIELD = the ABAP-compiler will read your code like FIELD = TABLES.

So, just put an '*' before both the PARAMETER and FIELD fields if you don't need them.

Regards,

John.

Re: HELPVALUES + GETLIST

Former Member — Fri, 22 Oct 2004 14:43:47 GMT

Hi John,

Many thanks for your response,

can you tell me what should I have to mention in parameter and feild, in order to bring the list of all avaiable sap bp in system.

Many thanks,

Marek

Re: HELPVALUES + GETLIST

Former Member — Fri, 22 Oct 2004 14:52:42 GMT

Hi Marek,

Take a look at the documentation (transaction SE37) for this BAPI; all parameters are documented quiet well.

Furthermore it is always helpful to search for the 'Where-used' to see some examples of this BAPI in the SAP-system.

Hope you succeed in making this work.

Regards,

John.

Re: HELPVALUES + GETLIST

Former Member — Fri, 22 Oct 2004 15:18:43 GMT

Hi John

Thanks for your reply,

I am just confused what can be the parameter value of PARAMETER, cause this parameter is the parameter of method getDetail and the getDetail BAPI of BusinessPartner has only one export parameter which is,BUSINESSPARTNER

and when I write this code,

data: myreturn like BAPIRETURN.

data: des_Table type standard table of BAPIF4E with default key,

wa_myTab like line of des_Table.

data: val_Table type standard table of BAPIF4C with default key,

wa_myTab1 like line of val_Table.

data: help_Table type standard table of BAPIF4D with default key,

wa_myTab2 like line of help_Table.

CALL FUNCTION 'BAPI_HELPVALUES_GET'

EXPORTING

OBJTYPE = 'BUS1006'

OBJNAME = 'BusinessPartner'

METHOD = 'GetDetail'

PARAMETER = 'BUSINESSPARTNER'

FIELD =
EXPLICIT_SHLP =
MAX_OF_ROWS = 0
DESCRIPTIONONLY = ' '

IMPORTING

RETURN = myreturn

TABLES

SELECTION_FOR_HELPVALUES =

HELPVALUES = help_Table

VALUES_FOR_FIELD = val_Table

DESCRIPTION_FOR_HELPVALUES = des_Table

write myreturn.

It shows me this message when "write myreturn" executes,

collective search help BUPA in feild BUT000 has not been processed.

Might be you can provide me with a single clue, that what shold be the value of parameter and feild, ??

Many thanks,

Re: HELPVALUES + GETLIST

Former Member — Fri, 22 Oct 2004 15:30:14 GMT

Hi Marek,

According to the documentation you should also specify the FIELD of the parameter you want to return, which could be for instance BPARTNER (the business partner number).

Regards,

John.

Re: HELPVALUES + GETLIST

Former Member — Fri, 22 Oct 2004 15:41:18 GMT

Hi John,

Even I am sending the following as export parameter

EXPORTING

OBJTYPE = 'BUS1006'

OBJNAME = 'BusinessPartner'

METHOD = 'GetDetail'

PARAMETER = 'BUSINESSPARTNER'

FIELD = 'BPARTNER'

it gives me the following error msg,

Es&038 Collective search help BUPA in field BUT000- has not been processed.

Many thanks, for your kind help!

Marek

Re: HELPVALUES + GETLIST

nablan_umar — Fri, 22 Oct 2004 16:30:32 GMT

In FIELD parameter, you need to pass the value of BPARTNER. For example '1234' not 'BPARTNER'.

Re: HELPVALUES + GETLIST

Former Member — Sat, 23 Oct 2004 08:31:25 GMT

Hi Nablan,

R u sure that I have to specify any specific BPARTNER no, like 1234, than might be It will return me any specific Business partner, but I want to get the complete list of all avaiable Business Partner.

with Regards,

Marek

Re: HELPVALUES + GETLIST

athavanraja — Sat, 23 Oct 2004 09:22:23 GMT

Hi,

Alternatively you could use "BPAR_S_BPCENTRAL_PARTNER_PREP" for BP search help.

Regards

Raja

Re: HELPVALUES + GETLIST

Former Member — Sat, 23 Oct 2004 09:33:37 GMT

Hi Durairaj,

Thanks for your reply

For my more information, is this a BAPI "BPAR_S_BPCENTRAL_PARTNER_PREP", ?

Can you pls suggest something about the code which I mentioned in my above post, what is possibilly wronge, or which value I still has to mentioned. ?

Let me know pls, if you have an example like this it would be nice if you share here, ??

With Regards

Marek

Re: HELPVALUES + GETLIST

athavanraja — Sat, 23 Oct 2004 10:11:18 GMT

Hi Marek,

This is not a BAPI (not a RFC) thus cannot be called from external system.

As far as your other question: i havent used the mentioned BAPI but something did feel quiet right.

You wanted a list of all Business Partners, but you are trying to call GetDetail method - which is meant for getting details of a single BP.

If you debug the function BPAR_S_BPCENTRAL_PARTNER_PREP you sould be able to find how it fetches the BPs list.

Regards

Raja

Re: HELPVALUES + GETLIST

Former Member — Sat, 23 Oct 2004 15:59:49 GMT

hi,

I was calling Getdetail, cause I would like to have the detail of all avaiable SAP Business Partner in the system. now even I have used the GetList method, I am getting the same error!

Your mentioned funtion, also did not help me cause they have not call the BAPI, which I intent to call.

DOES any one have any clue, what is possibly wronge in my code, or what I am missing here !

Many thanks,

Marek

Re: HELPVALUES + GETLIST

athavanraja — Sun, 24 Oct 2004 04:17:54 GMT

> hi,

> I was calling Getdetail, cause I would like to have

> the detail of all avaiable SAP Business Partner in

> the system. now even I have used the GetList method,

> I am getting the same error!

for BUS1006 i dont see a method called GetList

> Your mentioned funtion, also did not help me cause

> they have not call the BAPI, which I intent to call.

Why it has to be a BAPI! r u accessing this information remotely?

> DOES any one have any clue, what is possibly wronge

> in my code, or what I am missing here !

I wil check your code and come back to you.

> Many thanks,

> Marek

Re: HELPVALUES + GETLIST

athavanraja — Sun, 24 Oct 2004 05:34:46 GMT

Hi,

Try the following for 'BAPI_HELPVALUES_GET'

These are the various search helps available for businesspartner.

                                                                            
 BUPAA                          SH Partner by address                        
 BUPAB                          SH Partner by bank details                   
 BUPAI                          SH Partner by Identification Number          
 BUPAP                          SH Partner, general                          
 BU_NSO                         SH Search Help for Unsaved Objects           
 BUPAR                          SH Partners by Role                          
 BUPAY                          SH Partner by Address (Rough Search)         
 BUPAU                          SH Partner According to User                 
 BUPAV                          SH Partner According to Internet User        
 BP_BUPAG                       SH Business Partner                          
 FSBP_ALIAS                     SH FSBP: Business Partner and Aliases

Note: fill the EXPLICIT_SHLP parameter with the desired search help name.

CALL FUNCTION 'BAPI_HELPVALUES_GET'

EXPORTING

OBJTYPE = 'BUS1006'

*OBJNAME = 'BusinessPartner'

METHOD = 'GetDetail'

PARAMETER = 'BUSINESSPARTNER'

*FIELD =

EXPLICIT_SHLP = BP_BUPAG SH (structure)

MAX_OF_ROWS = 0
DESCRIPTIONONLY = ' '
IMPORTING
RETURN =

TABLES

SELECTION_FOR_HELPVALUES =

HELPVALUES = help_Table

VALUES_FOR_FIELD = val_Table

DESCRIPTION_FOR_HELPVALUES = des_Table

Hope it helps.

Regards

Raja

Re: HELPVALUES + GETLIST

Former Member — Fri, 29 Oct 2004 09:57:19 GMT

Hi Durairaj,

I am sorry for the late reply, actually I has having a kind of fever for last few days, and was not able to do any kind of work

Today, I try to slove my old problem as per ur advise.

Pls let me know how u come to know about these help values, and what BP_BUPAG is ?? is it a of structure or what ??, ofcouse I have to define it with Data: satement, so that purpose I need to initilize it. I looked in se11 to check it, if its a type of structure, but seems not to me, pls advise.

Many thanks,

PS: I just want to have a list of all Business Partner avaiable in the system.

Re: HELPVALUES + GETLIST

ssimsekler — Fri, 29 Oct 2004 11:58:47 GMT

Hi Marek

Just for a quick work around I would like to tell something.

I do not have a connection to an SAP system for the moment but I guess "BP_BUPAG" passed to the "EXPLICIT_SHLP" should be the description structure of the search help. You can retrieve it using the function module "F4IF_GET_SHLP_DESCR". Then pass the output of this FM to the "EXPLICIT_SHLP" parameter of "BAPI_HELPVALUES_GET" .

And why you couldn't see the structure is that I guess it is defined in the type-pool "SHLP".

e.g.

TYPE-POOLS: shlp .
DATA ls_shlp TYPE shlp_descr_t.

CALL FUNCTION 'F4IF_GET_SHLP_DESCR'
  EXPORTING
    shlpname = 'BP_BUPAG'
  IMPORTING
    shlp     = ls_shlp .

CALL FUNCTION 'BAPI_HELPVALUES_GET'
  EXPORTING
    OBJTYPE = 'BUS1006'
*OBJNAME = 'BusinessPartner'
    METHOD = 'GetDetail'
    PARAMETER = 'BUSINESSPARTNER'
*FIELD =
    EXPLICIT_SHLP = ls_shlp
*MAX_OF_ROWS = 0
*DESCRIPTIONONLY = ' '
*IMPORTING
*RETURN =
  TABLES
*SELECTION_FOR_HELPVALUES =
    HELPVALUES = help_Table
    VALUES_FOR_FIELD = val_Table
    DESCRIPTION_FOR_HELPVALUES = des_Table .

I hope this will help some...

*--Serdar

Re: HELPVALUES + GETLIST

Former Member — Fri, 29 Oct 2004 14:32:00 GMT

Hello Serdar Jee,

kee haal chal naay ?

Thanks for your kind reply ,

Now I am using the code, as below, but when I execute it, gives me the exception 'TYPE CONFLICT WHEN CALLING A FUNCTION MODULE !'

REPORT Z_HELPVALUES.

TYPE-POOLS: shlp .

DATA ls_shlp TYPE shlp_descr_t.

data: myreturn like BAPIRETURN.

data: des_Table type standard table of BAPIF4E with default key,

wa_myTab like line of des_Table.

data: val_Table type standard table of BAPIF4C with default key,

wa_myTab1 like line of val_Table.

data: help_Table type standard table of BAPIF4D with default key,

wa_myTab2 like line of help_Table.

CALL FUNCTION 'F4IF_GET_SHLP_DESCR'

EXPORTING

shlpname = 'BP_BUPAG'

IMPORTING

shlp = ls_shlp .

CALL FUNCTION 'BAPI_HELPVALUES_GET'

EXPORTING

OBJTYPE = 'BUS1006'

OBJNAME = 'BusinessPartner'

METHOD = 'GetList'

PARAMETER = 'BUSINESSPARTNER'

FIELD = 'BPARTNER'

EXPLICIT_SHLP = ls_shlp

MAX_OF_ROWS = 0
DESCRIPTIONONLY = ' '

IMPORTING

RETURN = myreturn

TABLES

SELECTION_FOR_HELPVALUES =

HELPVALUES = help_Table

VALUES_FOR_FIELD = val_Table

DESCRIPTION_FOR_HELPVALUES = des_Table

write myreturn.

write wa_myTab.

Any idea pls, what is wronge, How I can manage to see all avaiable Business Partner in the SAP System.

Many thanks,

Re: HELPVALUES + GETLIST

Former Member — Fri, 29 Oct 2004 15:42:25 GMT

Hi,

You must pass a structure type BAPISHLP to parameter EXPLICIT_SHLP .

move values from ls_shlp to a structure type BAPISHLP

Regards

Venkat

Re: HELPVALUES + GETLIST

Former Member — Fri, 29 Oct 2004 15:57:29 GMT

hi venkat,

Thanks for your reply

Now I am using this line of code

data: help type BAPISHLP.

CALL FUNCTION 'BAPI_HELPVALUES_GET'

EXPORTING

OBJTYPE = 'BUS1006'

OBJNAME = 'BusinessPartner'

METHOD = 'GetList'

PARAMETER = 'BUSINESSPARTNER'

FIELD = 'BPARTNER'

EXPLICIT_SHLP = help

MAX_OF_ROWS = 0
DESCRIPTIONONLY = ' '

IMPORTING

RETURN = myreturn

TABLES

SELECTION_FOR_HELPVALUES =

HELPVALUES = help_Table

VALUES_FOR_FIELD = val_Table

DESCRIPTION_FOR_HELPVALUES = des_Table

write myreturn.

write wa_myTab.

But myreturn table give msg with E, the complet msg is

ES&038Collective search help BUPA in field BUT000- has not been processed.

ANY clue or any advise pls ??

Marek