on 11-13-2014 11:22 PM
Hello,
I am going through some problems, I need to access a large number of texts relating to the Purchase Order.
With the help of this topic(Retrieve texts from a sales order by using RFC_READ_TEXT), could use function RFC_READ_TEXT to access one of the purchase orders I needed.
But I need to access more than 22,000 requests per month. And according to the thread I mentioned I can only return one text at a time.
How could I do to extract a set of Purchase Order text with one request using RFC_READ_TEXT?
I really appreciate everyone's attention.
Thanks
Guys,
I discovered the answer to the question i've made "Meanwhile, someone could tell me if there is any way to pass more than one record in the table in a single request using PDI?"
On PDI - SAP Input you can deal with Table structures for input passing an string containing ";".
Ex:
OPTIONS = "TEST TEST TEST TEST ... TEST" < More than 72 chars without ";" (Don't work)
OPTIONS = "TEST TEST; ... TEST; ...TEST; ... TEST" < More than 72 chars with ";" (Works)
Thanks.
Fillipe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Of course, there is my example:
Inputs came from STXH. And i used the answer of this thread to concatenate all fields with ';'.
If you have any issue please contact me.
Best Regards
Hi
Did you try adding multiple records in the table?
IRfcTable table = func.GetTable("TEXT_LINES");
table.Insert();
table[0].SetValue("TDOBJECT", "VBBK");
table[0].SetValue("TDNAME", "3147856016");
table[0].SetValue("TDID", "Z019");
table[0].SetValue("TDSPRAS", "L");
table.Insert();
table[1].SetValue("TDOBJECT", "VBBK");
table[1].SetValue("TDNAME", "3147856017");
table[1].SetValue("TDID", "Z019");
table[1].SetValue("TDSPRAS", "L");
table.Insert();
table[2].SetValue("TDOBJECT", "VBBK");
table[2].SetValue("TDNAME", "3147856018");
table[2].SetValue("TDID", "Z019");
table[2].SetValue("TDSPRAS", "L");
func.Invoke(dest);
return table;
Regards,
Murthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Narasimha Murthy Balla,
Many thanks for the quick response. I am currently using the PDI (Pentaho Data Integration - Kettle) tool with SAP Input Step. It only lets me set a record for the table.
I will try to program something in Java using the Connector sapjco3 to make a code like this you said and post here the results I get.
Meanwhile, someone could tell me if there is any way to pass more than one record in the table in a single request using PDI?
Again thank you, I will do the tests.
Fillipe.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.