Showing results for 
Search instead for 
Did you mean: 

How do you filter out unwanted VBELN values using RFC

0 Kudos

I'm using Excel VBA in combination with RFC to pull the VBPA table. I'm only interested in pulling all VBELN values less than 300000. How do I structure the Tables("OPTIONS") statement so that I pull only this range of data?

For example...

MyFunc.Tables("OPTIONS")(1, "TEXT") = "VBELN < '300000' "

...doesn't work. I tried other implementations of this and could not get anything to work. There may be a way to set the "LOW" and "HIGH" parameters, but I can't figure out how to structure the code.

Note that I have other Tables.("OPTIONS") statements in this routine that work properly. For example...

MyFunc.Tables("OPTIONS")(1, "TEXT") = "PARVW IN ('WE', 'AG', 'ZE', 'AP')"

...correctly pulls the partner functions that I want to see from VBPA. Now I just need to limit these results to VBELNs less than 300000.

Thanks in advance!

Accepted Solutions (0)

Answers (0)