can you please tell me how to reslove the mapping issue?

[former_member270261]

HI Experts,

can you please tell me how to reslove this below mapping .

Each file to sequentially increase by one, beginning with “000001”.

Receiver side we need to populate this:Each file to sequentially increase by one, beginning with “000001”.(Target field=File Sequential Number)

Note:there is no sourse field this map

Sourse:IDOC

receiver:JMS

Thanks

Narendra

[Harish]

Hi Narendran,

you can also try variable %counter:6%. this is given for file adapter but this might work for JMS. refer the below link

Configuring the Extended File/FTP Adapter - Adapter Engine (Java SE) - SAP Library

regards,

Harish

[baskar_gopalakrishnan2]

Another option is insead of table , you can use file lookup using udf ...YOu have to write logic to insert the newly added counter number and read the lookup number for the messge.

http://wiki.scn.sap.com/wiki/display/XI/File+Lookup+in+UDF

[binod8]

Hi Narendran,

Create a custom table and store the sequence number in the table.

While processing the file during mapping make a call (RFC) to the table and increment it by one and pull the latest sequence number as response. Once you have the number as response you may populate the same as file sequence number.

Thanks,

Binod