on 02-09-2017 8:45 PM
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!
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.