Handling of hash tables in PI

[Former Member]

Hi Experts,

In my scenrio, some of the fields are stored temporarily in hash tables and also they are performing some additions.

My question is, In PI how we will handle those hash tables in mapping?

How we retrive the values from hash table and place in PI?

[Former Member · Accepted solution]

Divya,

As long as you are able to write a query for this at the database level and receive correct records, you can use the same in pi also. You may try your query like this:

SELECT * FROM table WHERE value = hash_fn(whatever_input_you_build_your_hash_value_from)

Proabably your database guys may help you more on this.

Regards,

---Satish

[Former Member]

> My question is, In PI how we will handle those hash tables in mapping?

PI understands only XML, so you need not to do anything special for this. Create your data type, message type, message mapping etc as usual.

> How we retrive the values from hash table and place in PI?

You can create an outbound proxy for this, and then you need to fetch the data from hash tables using select query into some internal table and then pass this internal table to your outbound proxy method.

See the example of OutBound Proxy (Client Proxy)

/people/sravya.talanki2/blog/2006/07/28/smarter-approach-for-coding-abap-proxies

Regards,

Sarvesh

[Former Member]

There is a option called Declaration (Globally..)

which can be accessable through out the mapping...

or declare instance of GlobalContainer.. and store the values needed there and retrieve the same at needed steps

HTH

Rajesh

[Former Member]

Hi

Wich scenario do you use? Use a message mapping o java mapping?

[Former Member]

messagemapping