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

BAPI to search for customer

dear all

Iam search for a BAPI to be used in search for particular customer using one of its attribute wich is stored in kna1 table

and also search in its details stored in ADRC taple if possible.

and also BAPI for search for equipment using one of its attribute like serial number or sold to party .

thank you

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

10 Answers

  • Best Answer
    Posted on Dec 07, 2010 at 12:59 PM

    Try the generic BAPI : BAPI_HELPVALUES_GET (ref [Providing Input Help (F4 Help)|http://help.sap.com/saphelp_46c/helpdata/en/a5/3eca044ac011d1894e0000e829fbbd/frameset.htm])

    Regards,

    Ramond

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2010 at 10:18 PM

    What's wrong with SELECT??

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2010 at 09:32 AM

    i want BAPI because i will use it in portal application so select is not possible .

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 07, 2010 at 09:51 AM

    Hi lamey ahmed

    ,

    for the first part: use BAPI_BUPA_GET_DETAIL,

    second I don't know.

    You can use transaction BAPI to explore what functions are abailable in what area.

    Regards,

    Clemens

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 07, 2010 at 11:49 AM

    You can use

    BAPI_CUSTOMER_FIND - Search customer

    For equipment you have to write a select as said by Rob 😉

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 07, 2010 at 12:15 PM

    Hi,

    OK, I searched for you: BAPI_EQMT_DETAIL has parameter for serial number.

    Regards,

    Clemens

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2010 at 11:05 AM

    thank you

    Raymond Giuseppi

    i read the documentation of this BAPI_HELPVALUES_GET and it is good but i want to know

    if for example i want to list of customer based on company code and other selection criteria and i have the search help for this

    is this BAPI allow me to set the selection criteria and get list based on it as sap search help do .

    please give me example to use this search help M_DEBID to search for customers on company code 1000 from the BAPI BAPI_HELPVALUES_GET.

    second thing .

    and also what is the diffrence between BAPI_HELPVALUES_GET and BAPI_HELPVALUES_GET_SEARCHHELP.

    Edited by: lamey ahmed on Dec 8, 2010 12:31 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Yes this BAPI can provide you every parameter of the search help, proceed as wrote, perform some test via SE37, it's easy.

      For sample, perform a where used, there are many call in SAP standard like

        lt_sel-select_fld = 'KTGRM'.
        lt_sel-sign       = 'I'.
        lt_sel-option     = 'CP'.
        lt_sel-low        = lv_search.
        APPEND lt_sel.
      
        CALL FUNCTION 'BAPI_HELPVALUES_GET'
               DESTINATION lv_destination-rfc_dest
             EXPORTING
                  objtype                    = 'VBRK'
                  method                     = 'CREATEFROMDATA'
                  parameter                  = 'BillingDataIn'
                  field                      = 'ACCTASGNMT'
                  max_of_rows                = 100
             TABLES
                  selection_for_helpvalues   = lt_sel
                  helpvalues                 = lt_values
                  values_for_field           = lt_val_sel
                  description_for_helpvalues = lt_desc_fld
              EXCEPTIONS
                  communication_failure = 1 MESSAGE lv_mess
                  system_failure        = 2 MESSAGE lv_mess.

      Regards,

      Raymond

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2010 at 10:41 PM

    thank you for your help

    i study the documentation of BAPI_HELPVALUES_GET and i understand SOME PARAMETERS but i cant understand the parameter

    OBJTYPE

    OBJNAME

    METHOD

    PARAMETER

    FIELD

    and where i can fined this attripute for aparticular search help from BOR business object repository as the mentioned

    second what is the parameter SHLPTYPE in the import structure BAPISHLP

    finaly what is the use of the bapi

    BAPI_HELPVALUES_GET_SEARCHHELP

    thank you for your time

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2010 at 08:32 AM

    Hi,

    Use "IDWT_READ_ADDRESS" function module to get the details from adrc table by passing ADRNR as input.

    Regards,

    Thiru

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2010 at 08:21 AM

    thank you for all

    the issues has been fixed

    Add a comment
    10|10000 characters needed characters exceeded

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.