<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic BAPI_CUSTOMER_GETLIST (Question / Understanding) in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-customer-getlist-question-understanding/m-p/10705142#M1871460</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Requirement: Find all Customers that have a Search Term 'SORTL' with 'BM'. The return should be the Company Address Information. In our test SAP system there is one record in the KNA1 table matching this criteria.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now I realize that one could write a custom function for this but with SAP having so many BAPI's why not try to use one out of the box before going custom.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So I found a function: BAPI_CUSTOMER_GETLIST&lt;/P&gt;&lt;P&gt;There are address tables and company tables that will give me what I need.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So when I was testing this function in the Workbench I was under the assumption that I could populate the address table to give me what I wanted but apparently not.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So here is what I did:&lt;/P&gt;&lt;P&gt;Import Params:&lt;/P&gt;&lt;P&gt;MaxRows I set to 100&lt;/P&gt;&lt;P&gt;CPDOnly I set to X&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In Tables I set the following&lt;/P&gt;&lt;P&gt;IDRANGE&lt;/P&gt;&lt;P&gt;So the Row is as Follows: I, CP, *&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;ADDRESSDATA I set&lt;/P&gt;&lt;P&gt;SORTL : BM&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Result: I do get Rows Back but nothing with BM in the SORTL column LOL.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I guess my question is, should my assumption have worked?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in Advance&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 22 Oct 2014 15:08:59 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2014-10-22T15:08:59Z</dc:date>
    <item>
      <title>BAPI_CUSTOMER_GETLIST (Question / Understanding)</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-customer-getlist-question-understanding/m-p/10705142#M1871460</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Requirement: Find all Customers that have a Search Term 'SORTL' with 'BM'. The return should be the Company Address Information. In our test SAP system there is one record in the KNA1 table matching this criteria.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now I realize that one could write a custom function for this but with SAP having so many BAPI's why not try to use one out of the box before going custom.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So I found a function: BAPI_CUSTOMER_GETLIST&lt;/P&gt;&lt;P&gt;There are address tables and company tables that will give me what I need.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So when I was testing this function in the Workbench I was under the assumption that I could populate the address table to give me what I wanted but apparently not.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So here is what I did:&lt;/P&gt;&lt;P&gt;Import Params:&lt;/P&gt;&lt;P&gt;MaxRows I set to 100&lt;/P&gt;&lt;P&gt;CPDOnly I set to X&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In Tables I set the following&lt;/P&gt;&lt;P&gt;IDRANGE&lt;/P&gt;&lt;P&gt;So the Row is as Follows: I, CP, *&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;ADDRESSDATA I set&lt;/P&gt;&lt;P&gt;SORTL : BM&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Result: I do get Rows Back but nothing with BM in the SORTL column LOL.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I guess my question is, should my assumption have worked?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in Advance&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Oct 2014 15:08:59 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-customer-getlist-question-understanding/m-p/10705142#M1871460</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2014-10-22T15:08:59Z</dc:date>
    </item>
    <item>
      <title>Re: BAPI_CUSTOMER_GETLIST (Question / Understanding)</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-customer-getlist-question-understanding/m-p/10705143#M1871461</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Troy,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In function BAPI_CUSTOMER_GETLIST, only table IDRANGE is used for searching data.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;JCD&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Oct 2014 15:55:19 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/bapi-customer-getlist-question-understanding/m-p/10705143#M1871461</guid>
      <dc:creator>JuanCarlosDelga</dc:creator>
      <dc:date>2014-10-22T15:55:19Z</dc:date>
    </item>
  </channel>
</rss>

