on 05-27-2010 3:16 PM
Hi Experts,
I have to perform value map but in source the number of field is around 13 thousand .
However on target side there is only 6 value .till 5 its okay but last 6th value has to be target for remaining thousand field .
Now the problem is first manual entry of thousand value in value map table is not easy and if it is some how done also then I hope it will be a huge impact on PI server .
so is there any other option by which I can avoid manual entry of table and achieve the desired result.
I have been suggested to keep the table in R/3 side and use RFC lookup . so can we import values in R/3 table or their also we have to go for manual entry in the table secondly can RFC lookup is feasible on such a large table.(kindly suggest on this )
I have thought that perform the value map for first five and if any other value come will pass the 6th value to target but this idea was discarded by team telling the target is very imp field and we don't want to take risk .
Please suggest if you have any other solution for this problem .
Regards,
Saurabh
Hi,
>>>so can we import values in R/3 table or their also we have to go for manual entry in the table
a program to upload excel values into the r3 table is 0,5 -1 day of dev ...
so no need for anything manual
>>>secondly can RFC lookup is feasible on such a large table.(kindly suggest on this )
1000 is not a lot for an RFC (just make sure you do one RFC call per each mapping and not 1000 calls
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Swarup/Michal for you reply however number of field is 13000 not 1000:)
Any ways I have stared working on the RFC lookup option .being novice to ABAP always try to escape that option but seems fianlly got caught
I feel as suggested by you both I have to do these things :
1 Create a table in ABAP having two field key and value.
2 . Write a program to upload values from excel to ABAP table .
3 .Write a RFC to perform simple lookup on these two field values .
4 .Import this RFC in IR and use it in mapping .
Guys kindly share if you have any other views also apart from RFC...
Regards,
Saurabh
Hi,
I will suggest you to go for RFC lookup in this case. It will simplify the scenario and of-course performance wise also it's better.
I have thought that perform the value map for first five and if any other value come will pass the 6th value to target but this idea was discarded by team telling the target is very imp field and we don't want to take risk .
-- This is bit expected, because in this situation 6th value will be kind of deafult value. If source payload has filed value other than those 13 thounds....then also it will covert it to 6th value on target side, which is not good..
Thanks
Swarup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.