Value Mapping Doubts

[Former Member]

Hi all,

I’m doing an interface between SAP Retail and 3 other legacy systems. Both have different article numbers, so a Value Mapping is required. I started with a simple value mapping group on ID and I called it in IR. Its working fine, but not enough, we need to maintain this table without manually entries. So, I followed some weblogs and in addition the document: “How-to Replicate MDM key mapping in XI value mapping tables”.

Now I’m using the Value Mapping Replication Synchronous interface, I did all the steps for IR, ID and also Java Proxy was activated. Unfortunately, I‘m getting an error 404 not found as a response from my sync call, and in sxi_monitor an internal server error 500 is displayed. If I use this URL generated by HTTP tool in my web browser, I also get the 404 not found web page. I don’t understand, I have all configuration objects activated and also sxi_cache was refreshed…

1 - Anyone knows what is missing?

I also would like to clear some doubts:

2 - How many records can we use in this table? We are expecting more or less 40.000 records.

3 - Do I need to generate a GUID for each GroupId? There is an ABAP function for that or should I generate a Jar file with com.sap.guid classes available in the SAP Web Application Server to use it in graphical mapping? As demonstrated in “How-to Replicate MDM key mapping in XI value mapping tables”.

4 - We don’t have the Update operation for Value Mapping. So, I guess, every time an article is changed, we need to delete it (Delete GroupId) and insert it again. But for that we need to know the GroupId Number only known for XI and not for SAP Retail (ABAP Proxy Out interface). How can we handle this?

5 - In order to use all the capacities of Value Mapping Replication, there is something more that I should know in advance?

Thanks a lot guys

Ricardo.

[MichalKrawczyk]

hi Ricardo,

I see you did your part (you've described all important issues with VMapping)

>>>>>4 - We don’t have the Update operation for Value Mapping. So, I guess, every time an article is changed, we need to delete it (Delete GroupId) and insert it again. But for that we need to know the GroupId Number only known for XI and not for SAP Retail (ABAP Proxy Out interface). How can we handle this?

this is the worse part - think about it - everytime when you create one

material you will have to EXPORT all materials to file etc

so it will go to XI (cache) ... will your users accept that ?

>>>>2 - How many records can we use in this table? We are expecting more or less 40.000 records.

in "How-to Replicate MDM key mapping in XI value mapping tables”

sap says - do not use it when you have many records...

I also asked the same question on SDN forum on got only one answer

(we use up to 10..)

maybe you can use lookup call instead to a SAP table

where you'd store both material numbers ?

this is actually how MDM lookups can work too

(I'll try to post a blog about it one day)

another way (apart from lookups)

you can change the material in user exit

in SAP (when posting the IDOC or RFC)

I know it's not SOA/ESA approach but it always worked

and still works with many interfaces

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member]

Hi,

Thanks a lot Michal, your suggestions are always welcome

Now the problem (first question) is fixed, a little mistake, I forgot to change the Message Protocol from XI 2.0 to XI 3.0 because for XI adapter XI 2.0 comes as a default value for Message Protocol field.

But, now I'm having a fault message saying <b>"The GroupId 433403413241... in item 0 has wrong format".</b> Well, I guess that I reach the 3rd point of my doubts list It seams that a GroupId is required, but I don't know where I sould generate it. If I follow the doc <i>"How-to Replicate MDM key mapping in XI value mapping tables"</i>, this GroupId will only be known for XI and not for R/3 and I think that is needed to mantain this table in future. So, I can presume that I must generate this GroupId on R/3 side with some kind of ABAP function.

The GroupId sould be a GUID with 32 characters or I can use other num range?

Anyone has experience with Value Mapping Replication, which could help me?

Thanks in advance,

Ricardo.

[Former Member]

Hi Michal,

I'm trying to generate the GUID(Group_Id) in XI.Now with a jar as a imported archive, I’m able to call the GUID class using a user-defined function with this code:

Imports com.sap.xi.myGUID.MyGUID;

return MyGUID.GetGUID(GroupI_d);

But, I don’t know why it is always generating the same GUID!!! I’m not a Java developer I took this code from the pdf document mentioned on my first post.

The code:

package com.sap.xi.myGUID;

import com.sap.guid.GUIDGeneratorFactory;
import com.sap.guid.IGUID;
import com.sap.guid.IGUIDGenerator;
import com.sap.guid.IGUIDGeneratorFactory;

public final class MyGUID {
	static public String GetGUID( String StrInput ){
IGUIDGeneratorFactory factory = GUIDGeneratorFactory.getInstance();
	IGUIDGenerator generator = factory.createGUIDGenerator();
	IGUID guid_str = generator.createGUID(StrInput);
	return guid_str.toHexString();
	}
}

Do you know what’s happening; maybe I need to clear a buffer? But I don’t know how to do it

Thanks in advance,

Ricardo.

[bhavesh_kantilal]

Ricardo,

Regarding the Group ID.

1. I remember searching for more info on this last week and I found a thread on SDN that dioscucsses a ABAP Function to create a Unique Group ID.

2 . The group Id should be common between the Key and Value pair. , i.e, when you need to link a Currency and a Country, say DOL for DOLLAR, you will create 2 items containing the corresponding Agency and Scheme and these 2 items should share the same Unique Group Id.

Regards

Bhavesh

Ps: If you learn more on the Update / Delete and how to get the GUID etc do let us know.

[Former Member]

Hi all,

Sorry the delay, I had other issues and as usual no time enough to give a quick answer, but this thread isn’t forget

To create a GUID 32 characters type, we can use GUID_CREATE ABAP function.

As you probably know, we don’t have the Update operation for this kind of table. But, we can do it easily; deleting one GroupId <Operation>DeleteGroup</Operation> and all referenced Agencies and Schemas for this GroupId will be deleted as well. The next step is an insert operation with the record updated from the Source system to replace the deleted entry. For that, we have a ZTABLE with a similar value mapping structure and we are saving the GroupId on that table for these updates.

I hope it helps somebody and thank you all for your helpful answers

Cheers,

Ricardo.