topic Re: RFC_READ_TABLE with Excel VB in Application Development and Automation Discussions

RFC_READ_TABLE with Excel VB

Former Member — Mon, 23 Jan 2017 11:01:35 GMT

I want to pass the value to field BEDNR . but I do not have exact value, so I want to pass like *TEST* . means I want to add "*" front and back. when I enter code shown in screen shot, RFC gives no result. How to use '*' to get the related entries from SAP.

Re: RFC_READ_TABLE with Excel VB

Stefan-Schnell — Mon, 23 Jan 2017 11:39:54 GMT

Hello Duraisamey,

try

oRow.Value(1) = "WERKS = '5000' AND BEDNR LIKE '%TEST%'"

Let us know your result.

Cheers
Stefan

Re: RFC_READ_TABLE with Excel VB

Former Member — Mon, 23 Jan 2017 12:08:05 GMT

Hello Stefan....

Thank you so mush for your reply.. Its working correctly.

If you do not mind , I have one more questions.

If I want to exclude some Item , how should I write ? . I want to include Which has TA17 and Want to exclude which has BADTA17

Re: RFC_READ_TABLE with Excel VB

Stefan-Schnell — Tue, 24 Jan 2017 11:59:58 GMT

Hello Duraisamy,

as far as I can see is your SQL statement correct.

I check it with this statement on the table SFLIGHT:

CARRID = 'AA' AND (PLANETYPE LIKE '%-%' AND PLANETYPE NOT LIKE '%300%')

Plantypes are 747-400 and A310-300. With this statement I expect only the flights with 747-400 planetype, and that is what I get.

Cheers
Stefan

Re: RFC_READ_TABLE with Excel VB

Former Member — Wed, 25 Jan 2017 04:10:38 GMT

Hi Stefan,

Thanks for your reply.. Sorry its not working. I am using Visual basic (VB) to download data from SAP table. First statement is working correctly. second is not working.

Re: RFC_READ_TABLE with Excel VB

Stefan-Schnell — Wed, 25 Jan 2017 07:33:39 GMT

Hello Duraisamy,

sure it is not working because the length of your line is to long.

This line is okay, because it is < 72 characters:

WERKS = '5000' AND LOEKZ <> 'X' AND BEDNR LIKE '%TA17%'

But this line is not okay, it is > 72 characters:

WERKS = '5000' AND LOEKZ <> 'X' AND (BEDNR LIKE '%TA17%' AND BEDNR NOT LIKE '%TG%')

OPTIONS is from type SO_TEXT072 (CHAR with a length of 72).

Add a new line.

Cheers
Stefan

Re: RFC_READ_TABLE with Excel VB

Former Member — Wed, 25 Jan 2017 10:09:18 GMT

Hello Stefan, I am getting syntax error. when split it to two lines

Re: RFC_READ_TABLE with Excel VB

Stefan-Schnell — Thu, 26 Jan 2017 06:45:24 GMT

Hello Duraisamy,

try

Set oRow = oTOPT.Rows.Add
oRow.Value(1) = "WERKS = '5000' AND LOEKZ <> 'X' AND "
Set oRow = oTOPT.Rows.Add
oRow.Value(1) = "(BEDNR LIKE '%TA17%' AND BEDNR NOT LIKE '%TG%')"

Cheers
Stefan

Re: RFC_READ_TABLE with Excel VB

Former Member — Sun, 29 Jan 2017 11:27:28 GMT

hello Stefan.. Thank you so much.. Its working Correctly.