Advanced searching question with RFC_READ_TABLE

[Former Member]

Hi community!

I have certain experience using RFCs with Visual Studio .Net

By now, I can create a basic and advanced searching of information using the RFC_READ_TABLE.

But I have a case a little complex, and I don't image how can translated into a search with RFCs.

My situation it's easy:

I need download some open documents from BSIS (GMP box); as a requirement (filter), I need use some GL accounts and other easy criterias.

The problem, it's that the user want a list of GL Account when in a part of the value be any number:

0010+++++1

0010+++++2

0010+++++3

0010+++++4

0010+++++5

Then, he want the GL accounts 001000001, 001000011, 001005001.

As resume:

"All the GL accounts that starts with 0010 and ends with 1, 2, 3, 4 or 5".

This kind of search he can do it in SAP (FBL3 transaction); but, they want automate this process (without using of SAP script).

Somebody knows correct sentence to perform this kind of filter through RFCs?

I search something like that:

<<<<< FILTERS >>>>>

0001 - (HKONT = '0010+++++1'

0002 -  OR HKONT = '0010+++++2'

0003 -  OR HKONT = '0010+++++3'

0004 -  OR HKONT = '0010+++++4'

0005 -  OR HKONT = '0010+++++5')

0006 - AND (ZUONR LIKE '%Payroll%'

0007 -  OR ZUONR LIKE '%PAYROLL%'

0008 -  OR ZUONR LIKE '%payroll%')

Thanks in advance!

[Former Member]

Seems that I found the way to solve my own question.

Basically I use a LIKE filter and some brackets.

These are the filters that I used:

0001 - (ZUONR LIKE '%Payroll%'

0002 -  OR ZUONR LIKE '%PAYROLL%'

0003 -  OR ZUONR LIKE '%payroll%')

0004 - AND ((HKONT LIKE '0010%' AND HKONT LIKE '%1')

0005 -  OR (HKONT LIKE '0010%' AND HKONT LIKE '%2')

0006 -  OR (HKONT LIKE '0010%' AND HKONT LIKE '%3')

0007 -  OR (HKONT LIKE '0010%' AND HKONT LIKE '%4')

0008 -  OR (HKONT LIKE '0010%' AND HKONT LIKE '%5'))

I ran the RFC and works fine.

Anyway, I really like to know if exists another way to get the information on these situations.

[Kartik2]

Hi,

This can be achieved using options parameter of function module 'RFC_READ_TABLE'. Please pass the values as:

'HKONT LIKE '0010%1' OR HKONT LIKE '0010%2''

Regards,

Kartik

[Former Member]

Kartik,

Thanks to your prompt response.

I performed the search with both methods.

And I have better results with my method vs. your suggestion:

• My method: 1min, 17 secs.
• Your method: 3mins, 7secs.

Both methods downloaded the same amount of rows.