Key mapping in Syndication

[former_member283645]

Hi,

I am working on Vendor master data.

The standerd syndication map for Vendor to R/3 system has the authorization groups mapped to BEGRU at target.

Well source is like

- authorization group

[Remote key] -

---

Mapped to-------> BEGRU

Name [DF]

Where as the '[Remote key] ' field does not contain any value!!! and moreover the Name field has the value of authorization!!!

Then why did the [Remote key] FIELD mapped to BEGRU ??

I have worked on key mapping concept where a field is expecting different codes of same data from different systems are maintained in Edit key mapping tab.

This is achived by CLONING the code field and mapping it to remote Key field.

Can anyone help me in this issue!!!

Kind Regards

Eva

[Former Member · Accepted solution]

Hi Eva,

Details as follows

1. in authorization group table create one more field code so now in table two field with Name and Code,

then do key mapping with code and import the data through import manager

or

2. in excel sheet create two column with name and code, Map Name field with Name and

code with remote key and import the data through import manager

Note: after importing data for specific remote system make sure in syndication ---> Map Properties tab desire remote system selected in remote key override option

Hope above mention point will resolve your issue if not revert back

Thanks,

Jignesh Patel

[former_member283645 · Accepted solution]

Hi,

Firstly i wish to clear that

1) in syndicator the table selected is 'Vendor' maintable.

2) structure of vendor is

-- Vendor

- Remote Key

Remote System

Value

+Vendor number

+Account Group

- Authorozation group

Remote key -

---

mapped to --> BEGRU

Name

+ Trading partner

.

.

Now like you said to add a code field at the source end, i have only 1 incoming value, so the NAME field it self is cloned .

it has RS specific data in the EDIT KEY mapping table.

Now, In syndicator if i map Name field to the BEGRU i will get ALL the values which are maintained in the main table RECORD.

If i wish to send the RS specific data only then how to do it??

If i select the Authorization grp Table in Syndicator then i can see the source structure as

-- Authorization grp

- Remote Key

Remote System

Value

Name

Here if i map Value field then i get my Output.

But I guess we need to do the mapping at Main table level to create a single XSD right!!!

Or am i confused..

Please clarify me..

Kind Regards

Eva

[former_member205403 · Accepted solution]

Hi Eva,

You need not to create a new field or clone your name field, but store the code of the authorization group as remote key for authorization group table while importing or adding reference data.

Then while syndication, you will be able to send Code to ECC system. Also, even if you select main table, syndicator allows you to syndicate keys of lookup tables.

For example, store data in MDM in this format in Authorization group table:

Code (store this as remote key ) Name

00001 ABC

00002 XYZ

Now while syndication as Remote key (of authorization group table) -

---

mapped to --> BEGRU, so BEGRU will contain code for the authorization group...

Please revert if any further question.

Best Regards,

Shiv

[former_member283645 · Accepted solution]

Hi,

Thanks for the reply.

I have stored the codes of Name field while uploading the reference table data.

Which means

incoming file has || should be converted to name

0001 ABC

0002 CFR

0004 JJJ

all the keys'(0001,0002,0003) i can see in 'Edit key mapping table'.

now in syndicator of i map Remote keys -

---

>BEGRU

a blank file is getting generated!!

Can i know why i am not able to see the Keys in the file!!!!!

Am i missing someting in map properties ??

Note: in syndicator i selected the Main vendor table.

Please help.

Kind Regards

Eva

[former_member205403 · Accepted solution]

Hi Eva,

Just want to make sure you have mapped remote key of authorization group table to the BEGRU. If you open Vendor main table in syndicator, it will still show remote key item of authorization group under item mapping tab.

I am little confused why you are getting blank file. Have you selected correct remote system while creating syndication map. Is "Suppress unchanged records" property set. If you do not have remote key enabled for vendor table, then make sure "suppress records without key" is not set.

Please revert with your findings.

Best Regards,

Shiv

[former_member283645 · Accepted solution]

Thanks for the response. Issue solved when i selected correct RS.

[former_member205403]

Hi Eva,

While transferring vendor data to ECC, we transfer code instead of name. That's why remote key is mapped with BEGRU and not the name, because as per design remote key stores the unique key for the source system records.

Did you imported remote keys while doing reference data import from ECC system.

Best Regards,

Shiv

[former_member283645]

Hi shiv,

Thanks for the reply.

There is only one field (NAME) in 'Authorization groups' table.

Code field does not exist in the table.

Kind Regards

Eva

[former_member283645]

And moreover

the source side is in this format..

- Authorization group

Remote key

Name

and NOT like

- Authorization group

-Remote key

Remote system

value

Name

Like you said if it want to send the codes which are RS specific then it should be like second case.

But by using first case how can we get it!!

Kind Regards

Eva