Generating a number

[Former Member]

Hi folks

Can anyone help me to generate number as specified below.

I want my number to get generated as a combination of region code & and a sequence number which depends on the person cat type

ex

If cat type - I (1000-2000)..i.e the number generating here will start with 1000,1001....and this number has to get concatenated with regoin code while syndicating.........i.e if the person belongs to AP.then the number should be as AP1000.

Is this possible?

[Former Member]

Hi Shifali,

Regarding Number generation you can generate the numbers for remote keys depending on a value of Look up field.

I am assuming Cat-I is stored in Lookup table and this table has Lookup field as "Category" in Main Table then follow these steps for number generation:

1. Unload repository and go to Remote Systems table of your repository in MDM Console.

2. Select a particular remote system and set the "Key Generation" property to "Qualified Range".

3. Set the Lookup Field property to "Category" which is your lookup field.

4. Double Click in the Qualified Range Property Box a pop up will appear. Set the value for cat-type I as From --> 1001 and To -->2000. Load the repository with Update Indices.

Note: These numbers will be generated for remote key of your record and it is not visible in Data Manager or Syndicator but the numbers are generated when we syndicate the data.

For syndicating concatenated data from MDM follow these steps:

1. Open Syndicator for the remote system mentioned in the above steps and go to the "Custom Item" Tab.

2. Right click in Custom Items Pane and select "Add Custom Item " from the Context Menu.

3. In the properties pane double click in the Formula Property

4. Open the Fields menu and select the first field as "Region Code" and then select Remote Keys and select the appropriate remote key.

5. Go to "Item Mapping" tab a Custom field in Lavendar color will be generated. Map this field to your destination field. The destination field will be concatenated as per the formula you mentioned earlier. Execute syndication to see the results.

Try this out. Hope this helps.

Thanks and Regards,

Sagar Sonje

[Former Member]

Generating Sequence number i have already done it...but it generates number after syndicating only

I followed process as u said <regioncode><Vendor remote Key>

But it is not showing any thing in destination.

May be the reason that vendor remote key is the one which generates only after the record gets syndicated.

When trying to add to my region code befor the record gets syndicated it is showing as Empty in destination preview.

Process is correct but not satisfying the req.

[Former Member]

Hi Shifali,

I am able to view the Region Code in my destination preview.

Also the syndicated file has concatenated value AP100.

Try to syndicate the data once and make sure you have selected the remote system as the one for which you have mentioned Key Generation in MDM Console.

Thanks and Regards,

Sagar Sonje

[Former Member]

Can you plz let me the expression u have used in creating Custom field.

Regoin code when alone is used it is showing the code..but when vendor number which has to be generated only by sys.i.e keygeneration yes,in specified range with regoin code in exp the destination preview is empty.

[Former Member]

Hi Shifali,

You will not be able to see the remote key value in the destination preview before syndicating. It will be empty.

Once you syndicate the record then the remote key value will be present in the output file and only for the syndicated record it is visible in the destination preview.

The syndicated file will always have the concatenated string of RegionCode and Remote key.

The expression which I written is as follows:

<country.name[df]><products.[remotekey].[value]>

This expression is available when you right click in the original expression of Formula Property and select "Include Value Only" from the context menu this will syndicate only the values. Otherwise it will give result as fieldname:fieldValue

Thanks and Regards,

Sagar Sonje

[Former Member]

<REGION.CODE:region.code><VENDORS.[REMOTE KEY];vendors.[remote key]>

This is the exp which i have wriiten

Then the XML genereated is

<?xml version="1.0" encoding="UTF-8"?>

<CREMDM04>

<IDOC BEGIN="1">

<E1LFA1M SEGMENT="1">

<MSGFN>005</MSGFN>

{..................many things has to be here but empty...........................}

</E1LFA1M>

</IDOC>

</CREMDM04>

when only remotekey to be generated it is generating while syndicating .......but if i try to attach it to regioncode in custom field as expression it is showing error...i.e empty in genereated xml file.

My requirement is the newly generated number has to be padded with regioncode

[Former Member]

Hi Shifali,

I am getting correct output on my machine. Please check that the remote system for which you have created the Key Generation is the one for which you are syndicating records.

Go to File --> Destination Properties --> Remote System.

Select the remote system for which you have made the Qualified Key Generation in the "Remote Systems" table of MDM Console.

Also when you write the formula in Custom Items tab right click on the

individual field in formula and select "Include Value Only" from the context menu so that your requirement of only concatenated field values is achieved.

Thanks and Regards,

Sagar Sonje

[Former Member]

I am not able to find any option.....Include value Only.

[Former Member]

Hi Shifali,

You have written the formula as:

<REGION.CODE:region.code><VENDORS.REMOTE KEY;vendors.remote key>

First Double Click <REGION.CODE:region.code> in the Formula Property then a cursor will appear and then right click near the cursor and select "Include Value Only" from the context menu.

Similarly Double Click <VENDORS.REMOTE KEY;vendors.remote key> and select "Include Value Only" from the context menu.

Thanks and Regards,

Sagar Sonje

[Former Member]

When i do it as double click it and right click on cursor i am able to c only 3 as fields,remotekeys,others

[Former Member]

Hi Shifali,

You are right clicking very close to the Play Button next to the Formula.

Right click at the field when the cursor appears and not very close to the play button .

Hope this helps.

Thanks and Regards,

Sagar Sonje

[Former Member]

Ya i have selected the include values only for region code one it is showing only code,

but this when remotekey is also added in exp it is still showing empty and also not able to syndicated it.

I want te the generated remotekey as combination of regioncode and seq number generated,which am not able to do it.

[Former Member]

Hi Shifali,

I think the expression which you are using is referring not to the main table remote key value.

If the selected source table is Vendors and Key Mapping is enabled for it then the expression will look like

<region.code><vendors.[remote key].[value]>

but your expression does not have that [value] tag so may be you are in some other table.

Please check these points:

1. You have created a record in Data Manager for the Category which have specified earlier and assigned Range for the same value in Console in Remote Systems table.

2. You have selected the right remote system for which you have made an entry in Remote Systems table in MDM Console.

In Syndicator go to File --> Destination Properties --> Remote System

and check you have entered right remote system.

3. Make sure that you have selected Main Table as the current table which can be seen in the Top left of screen.

It should be Vendors table if you are using Vendor repository.

4. You should select "Include Values Only" for each field in Formula to meet your requirement. If any changes occur in your expression then unmap the Custom Item field first and then Map it again. Make sure that expression looks like

<region.code><vendors.[remote key].[value]>

[value]

should appear at the end if you are selecting the Main Table

5. You will not be able to see value for remote key in Destination preview, Data Manager or Syndicator. Execute Syndication and the concatenated value should be there.

You can refer Syndicator Reference Guide's Part 7 Custom Items for very detailed look into this issue. Please download syndicator reference guide from

https://websmp107.sap-ag.de/~sapidb/011000358700006461962006E

Thanks and Regards,

Sagar Sonje

Mark Helpful Answers

[Former Member]

sorry ur answers are much a lot helpful to me.....i marked them

but in Syndicator am in the main table only i.e vendors

and i can also tell that key mapping is working fine becoz i tried it with out the customfield it is generating number when syndicated...

but am not able to find VALUE for vendor remotekey

[Former Member]

Hi

I have a similarr kind of a question

my number i.e key is generated when the record gets syndicated which depends ion account group

i.e if Account group is XXX the number has to generate from 1000- 2000

and els the number has to generate from 2000- 3000

and while the reecord is getting syndicating i want to get region code to be added befor the generated number.......as

if account group = XXX and region code= AP...i want the number to be AP1000.

Can any one plz help me ASAP.