cancel
Showing results for 
Search instead for 
Did you mean: 

RFC_READ_TABLE Option Text

Former Member
0 Kudos

Hello all. I have two (2) opportunities with the options/text attributes. I am using the following in a local variable and assigning to the options:

<?xml version="1.0" encoding="UTF-8"?><OPTIONS>

<item>

<TEXT>AUFPL EQ '#Transaction.RoutingNumber#'</TEXT>

</item>

<item>

<TEXT> AND VORNR EQ '2010'</TEXT>

</item>

</OPTIONS>

Opportunity 1 - '#Transaction.RoutingNumber#'

Only works if I hard code a value for the routing number. If I do not use the local variable assignment in the options - assign it directly to the options/item/text as '#Transaction.RoutingNumber#', it works.

Opportunity 2 - grouping

I really want this to work as follows:

<?xml version="1.0" encoding="UTF-8"?><OPTIONS>

<item>

<TEXT>AUFPL EQ '#Transaction.RoutingNumber#'</TEXT>

</item>

<item>

<TEXT> AND (VORNR EQ '2010' OR VORNR EQ '2010')</TEXT>

</item>

</OPTIONS>

It does not like to parenthesis.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Try putting a space around the '(' and ')' e.g

AND ( VORNR EQ '2010' OR VORNR EQ '2010' )

vs

AND (VORNR EQ '2010' OR VORNR EQ '2010')

Former Member
0 Kudos

Yes, the space between paranthesis worked. Very good. Thanks.

Any ideas on using the variable to pass the routing number?

Former Member
0 Kudos
"AUFPL EQ '" & Transaction.RoutingNumber & "'" 
Former Member
0 Kudos

No luck.

It works fine as :

<?xml version="1.0" encoding="UTF-8"?><OPTIONS>

<item>

<TEXT>AUFPL EQ '405893'</TEXT>

</item>

<item>

<TEXT> AND ( VORNR EQ '2010' OR VORNR EQ '1030'</TEXT>

</item>

<item>

<TEXT> OR VORNR EQ '1040' OR VORNR EQ '1050'</TEXT>

</item>

<item>

<TEXT> OR VORNR EQ '1060' )</TEXT>

</item>

</OPTIONS>

The 405893 routing number needs to be stored in a variable. I have tried both transaction variables and local variables. Someting with the syntax.

Former Member
0 Kudos

No luck.

It works fine as :

<?xml version="1.0" encoding="UTF-8"?><OPTIONS>

<item>

<TEXT>AUFPL EQ '405893'</TEXT>

</item>

<item>

<TEXT> AND ( VORNR EQ '2010' OR VORNR EQ '1030'</TEXT>

</item>

<item>

<TEXT> OR VORNR EQ '1040' OR VORNR EQ '1050'</TEXT>

</item>

<item>

<TEXT> OR VORNR EQ '1060' )</TEXT>

</item>

</OPTIONS>

The 405893 routing number needs to be stored in a variable. I have tried both transaction variables and local variables. Someting with the syntax.

Former Member
0 Kudos

I put in an asignment to Local.OperationsOptions{/OPTIONS/item/TEXT} just before the RFC_READ_TABLE - as "AUFPL EQ " & "'#Transaction.RoutingNumber#'" and it worked.

Thanks for your help.

Answers (0)