on 02-24-2013 4:27 PM
Hello experts,
I have a IDOC to JDBC scenario using one stored proc. The issue is- all the fields in a particular segment (ZE2LTETK) of idoc should go to a target field (TEXT) of the stored procedure in multiple calls i.e.; if the segment has 44 fields, the stored proc should be called 44 times every time taking one value from each field of the segment ZE2LTETK. and mapping with TEXT field of the procedure.
One way is to replicate the structure of the stored proc at the target side as many times as the number of fields present under the idoc segment and direct-map the segment fields to TEXT one by one. But this would lead to a huge data type at the target side.
Another approach can be UDF but i'm not sure how to implement it.
Please guide me with the best solution to achieve this.
Thanks !
Hi.
You can call stored procedure only one time and save the results in a variable.
http://scn.sap.com/people/gabrielsagayaselvam.panneerselvam/blog/2011/05/05/jdbc-lookup-optimization
Regards.
Lucho
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.