Value mapping of 5000 entries

[Former Member]

Hi Experts,

We have requirement to maitian more than 5000 entries with 4 columns in PI for value mapping.

Please advice on the best approach.

Thanks

Sai

[rajasekhar_reddy14 · Accepted solution]

Hi Sai,

Check below documents

Regards,

Raj

[MichalKrawczyk]

Hi,

>>>We have requirement to maitian more than 5000 entries with 4 columns in PI for value mapping.

1. don't use PI value mapping for that - SAP does not recommend such option for large data sets

2. create a table on ABAP stack (PI or SAP backend like ECC) and use an RFC lookup

(make sure you call the RFC once per mapping and not once per line of strange ideas like that)

Regards,

Michal Krawczyk

[Former Member]

Hi Michal,

The Structure of the message is very complex and it requires minimum 30 to 40 times to call value mapping table for various fields.

If i store my entries in PI ABAP stack and called RFC lockup for 30 times, it will give us lot of performance problems.

Thanks

Sai

[MichalKrawczyk]

Hi,

>>>The Structure of the message is very complex and it requires minimum 30 to 40 times to call value mapping table for various fields.

as you know RFC can have many tables so you can always call it once per all values and just put them in the arrays in the mapping and retrieve them where ever you need - using one call only

value mapping - hard to maintain and will also cause issues if called 30 times.....

Regards,

Michal Krawczyk

[Former Member]

Hi Michal,

As mentioned by you, I will maitian my my mapping entries in PI ABAP stack and will call one time in my mapping using RFC lookup .Can you please advice how to map from the table to each field individually.

Thanks

Sai

[MichalKrawczyk]

Hi,

this is a nice blog from Shabarish on how to call the RFC with multiple values

http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/01/28/graphical-rfc-lookup-and-how-you-...

>>>>an you please advice how to map from the table to each field individually.

there is nothing special here - you have multiple outputs and just link them to different fields

Regards,

Michal Krawczyk

[Former Member]

Hi Michal,

You are referring here that large data sets are not recommended by SAP.

Don't use PI value mapping for that - SAP does not recommend such option for large data sets.

What is the maximum number of entries to be maintained in a value mapping? Is there any value for the total number of entries to be maintained for all the different value mappings?

I'm trying to find information about when and when not to use VM but I am not able to find information about the number of entries.

Many thanks for your time.

Kind regards.