How to give input to Options table in RFC_Read_Table to get Data?

[Former Member]

I am using SAP.net connector 3.0  . The function RFC_Read_Table have 5 input parameters and 3 tables (Fields,Data,Options). i have to give the 5 input parameters and input to table options before invoking so that i can get the result in the Data table. But i couldn't find the way to send input to the Options table. i tried the below but still there is no output in Data table.  Could anyone please help me on this?

IRfcFunction FSEName = repo.CreateFunction("RFC_READ_TABLE");

                FSEName.SetValue("QUERY_TABLE", "T001L");

                FSEName.SetValue("DELIMITER", ",");

                FSEName.SetValue("NO_DATA", "Blank");

                FSEName.SetValue("ROWSKIPS", "0");

                FSEName.SetValue("ROWCOUNT", "250");

                IRfcTable FSEoptionsLookup = FSEName["Options"].GetTable();

                FSEoptionsLookup.Append();   

                FSEoptionsLookup.SetValue("TEXT", "WERKS ='CA96'");

   FSEName.Invoke(prd);

[former_member197445]

Try it this way:

IRfcStructure whereOptions = repo.GetStructureMetadata("RFC_DB_OPT");

whereOptions.SetValue("TEXT", "WERKS ='CA96'");

FSEoptionsLookup.Append(whereOptions);