Syndicatior -Merge and Custom Item tab

[Former Member]

Hi Experts,

In syndicator there are two tabs Custom Item tab and Merrge item

Custom item tab contain (name , table and formula)

Merge tab contains (Name, table, source files, matching field, souce field to merge)

Can onyone one give me some simple example how to use these two tabs.

Thanks

[Former Member · Accepted solution]

Hi,

For use of Custom Item Please Refer:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80eac0fb-ad4a-2b10-af9d-e605b629...

For Merge Item Please Refer this thread:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20dbbca2-fde5-2a10-c68a-95745c1f...

Hope it will Help you,

Thanks,

Mandeep

[Former Member]

Hi Shalini

Examples:

Custom Items: We have say First name and Last Name fields in MDM and while syndicating the data to a target system we need Full Name. Here we will use Custom items with formula concatenating First and last Name fields. You have option of removing the delimiter also.

Merge Items: While syndicating material records target system needs Manufacture name also which is not maintained in MDM but some external excel sheet. Using Merge item we can brose that file and join the manufacturer name along with the record details.

Refer to Syndication Manager refernce guide for further details.

Regards

Ravi

[Former Member]

Hi Shalini,

Custom items are user defined source itmes in the syndicator which can be mapped to any destination items.

The composition of custom items may include

u2022 Source fields from the current table.

u2022 Source attributes from the connected repository.

u2022 Remote keys from the current table and its subtables.

u2022 Raw text entered directly into the custom item.

u2022 Repository name from which the syndicated data originated.

u2022 Date and time of the syndication

For eg. you can have a custom item Repo Name which

can hold the name of your repository in your syndicated file or you want some note to be attached to a field then you can have raw text entered against it.

Merge items are aslo user defined but the basic difference is merge items are used when to get some fields which are not maintained in your repository from an external source.

For eg. You have the Material Id information in the repository corresponiding to which the descritpion is maintained in some other source.This can be done by connecting to that external source andngetting the field imported.

The prerequiste for this is the external source file must be tab delimeted text file.

Hope it helps.

Thanks,

Minaz

[Former Member]

Hi Shalinin,

Custom Items:

- This tab is used to add custom fields dusring syndication,these fields are not added in the mdm repository however at the time of syndication we may need to syndicate some field datafor that we add this tab.

- In the custome tab you can add the Repository fields as well as Data and Time stamps

- There may be a requiremement where in you may need the current time and date of each outputted syndicated time

- In such a case you can add these fields in the formula property under the custom tab.the Date and time fields are dynamically updated.

- You can also add dynamic text such as The Data was outpuuted on <date> at <Time>

You can follow the below link to understand the use of custom items in more details:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80eac0fb-ad4a-2b10-af9d-e605b629...

Merge Item:

- Merge items are used to mege Fields from an external source file with the MDM rep fields.

- Many a times there is a situation where in you have maintained say a couple of fields pertaining a particular master say Business partner and imported data in to the MDM rep

- But you may need some other fields value say Manufacturer details which are not mainatined in MDM but the traget sytem needs it

- In such a case if you have a external flat tab delimited file containing these field details you can merge these fields information in the MDM rep and syndicate it by proper mapping

- For this all you will need is a common key say product id which will can be used for linking.

You can follow the below link to understand the use of merge items in more details:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20dbbca2-fde5-2a10-c68a-95745c1f...

Hope It Helped,

Thanks & Regards

Simona Pinto

[Former Member]

Hi Shalini,

Custom Items: In case if you want a combination of two fields to be mapped with the destination field then navigate to tab Custom Items and in the formula bar select the two field, it will combine the values of both the fields separated by colon(

Merge Items: If you have some external file containing addtional fields not present in the repository and you want those fields to be mapped with the destination structure then you can use Merge tab to merge the structure of the repository and the external file based on some common fields.

Regards,

Jitesh Talreja