BAPI_CUSTOMER_GETLIST (Question / Understanding)

[Former Member]

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.

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.

So I found a function: BAPI_CUSTOMER_GETLIST

There are address tables and company tables that will give me what I need.

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.

So here is what I did:

Import Params:

MaxRows I set to 100

CPDOnly I set to X

In Tables I set the following

IDRANGE

So the Row is as Follows: I, CP, *

ADDRESSDATA I set

SORTL : BM

Result: I do get Rows Back but nothing with BM in the SORTL column LOL.

I guess my question is, should my assumption have worked?

Thanks in Advance

[JuanCarlosDelga]

Hi Troy,

In function BAPI_CUSTOMER_GETLIST, only table IDRANGE is used for searching data.

Regards.

JCD