Accessing values during runtime in value mapping

[Former Member]

Hi all,

We have a specific requirement , where in we have a set of fields coming from the source system. All the fields have values expect few. The few which don't have values are reserved for future use, and for each source field there is a corresponding target value and we need map them.

We have used value mapping here, but it doesn't work for fields which don't have values.

We have thought of accessing the fields which do not have values, dynamically or at runtime by connecting the database of the source system.

Is it possible to do this, if yes, please provide with your inputs and alternatives.

thanks,

younus

[Former Member]

Younus,

As per you explaination:

<b><We have used value mapping here, but it doesn't work for fields which don't have values.></b>

If you have used value mapping then definetily you will get the values in your desired fields, and if you don't get them then you can pass some constant (depending upon the requirement).

One important thing about value mapping, as you said you have some empty fields and you want you have a value in these fields by using value mapping, Value mapping will ONLY return any result untill you will pass it somthing (for example as in case of RFC, you pass something and you will get the reslult), So when you don't have anything in your source fields then how can you fetch any data from VALUE MAPPING????

Plz correct me if I am wrong.

<b><We have thought of accessing the fields which do not have values></b>

On what basis you will fetch the data/fill the data??

You have to have something in your source fields to use the value mapping or lookup function.

Alternate solution can be of using CONSTANT values for empty source fields. Just consult with your client or function team.

Regards,

Sarvesh

[Former Member]

Younus,

Can you be more specific on what happens if there is no value in the source?

Are you getting error?

Regards,

Jai Shankar

[Former Member]

Hi ,

As of now there is no value in the source, but for it to work we have populated some values.

But it is not the actual case, we need the values to be fetched from database during runtime. (it deals with how we are populating values in value mapping).

Hope this should make the problem clear,

regards,

younus

[Former Member]

Younus,

I got your problem, you are saying that you are passing the required values to value mapping to fetch the data from data base but when you are using the value mapping you are not getting any value, correct??

IF above is the case then, based on my experience, value mapping takes time once you execute the progaram to populate the vlues (initially my be an hour or more). To check the values coming from value mapping goto RWB -

---

> Cache Monitoring then input the values in "cache server" & "cache objects" and after that enter the values in <b>Agecy, Schema, Value</b> and see if you have got the values there, if yes then your value mapping is ready to use.

Regards,

Sarvesh

[Former Member]

Hi Sarvesh & others,

thanks for taking interest in this problem.

To put it in short. I want to populate the values in value mapping from the database.

How can we achieve this?

Now this you give me a correct answer.

regards,

younus

[Former Member]

Go through this:

http://help.sap.com/saphelp_nw70/helpdata/en/13/ba20dd7beb14438bc7b04b5b6ca300/frameset.htm

<b>To implement Value Mapping, following activities have to be performed:</b>

<b>1.</b> Register Java Proxies. This is one time activity for each installation. Following URL has to be called for registering asynchronous replication scenario:

http://<Server>:<Port>/ProxyServer/register?ns=http://sap.com/xi/XI/System&interface=ValueMappingRep...

<b>2.</b> Application Programming: ABAP program has to be written to perform following tasks:

<b>a.</b> Read Value Mapping data from table.

<b>b.</b> Call Outbound Proxy to push the data into a message to Integration Server.

<b>3.</b> Configuration of Replication scenario in Integration Directory.

Regards,

Sarvesh

[Former Member]

Hi Sarvesh,

I'm back again with the same question.

I have read your response, here the source system is not SAP, but a JDBC database for some interfaces, and DB2 for some other interfaces.

So In this case..how do wel solve the problem.

any help would be appreciated.

thanks once again,

younus

[Former Member]

use a combination of value mapping and Database look ups.

for all the mandatory values,you can use value mapping,for rest all the fields use Data base look up

Thanx

Aamir

[Former Member]

Hi all,

Well i still have problems in solving this query.

Actually we have to populate the value mapping from a JDBC database, i gone throught the blogs but all of them expalin the value mapping replication process where in SAP tables are the source and it includes ABAP programming, where as my source system is a database.

Please provide me with the detailed steps to be carried out in IR and ID to accomplish this task.

Thanks once again.

Younus