cancel
Showing results for 
Search instead for 
Did you mean: 

How to avoid duplicate record in a file to file

former_member859847
Active Contributor
0 Kudos

Hi Guys,

Could you please provide a soultion

in order to avoid duplicate entries in a flat file based on key field.

i request in terms of standard functions

either at message mappingf level or by configuring the file adapter.

warm regards

mahesh.

Accepted Solutions (1)

Accepted Solutions (1)

prateek
Active Contributor
0 Kudos

Do ur scenario involve appending multiple entries to the same file? If yes, u may maintain a table in any database or SAP system wherein u may store the key field name each time u process a record. Next time when the same key occurs, before inserting, it will perform a RFC/JDBC lookup in mapping to know if that record has already been inserted before. If not then u may proceed with inserting the record.

Regards,

Prateek

former_member859847
Active Contributor
0 Kudos

Hi Prateek,

Thanks,actually my scenario is file to Proxy..

before inserting data in to z-tables,

by using delete adjusant duplicate entries in ABAP.

i can able to avoid it.

but, i request standard function in XI to avoid entries before message mapping( i mean supressing the entries) or using file adapter configuation parameters.

one more thing even if you any udf also fine.

warm regards

mahesh.

prateek
Active Contributor
0 Kudos

The message mapping functions and udf are only applicable on one current payload at a time. They cannot store earlier data. U should access a system (via lookup or any alternate) to find out whether such an entry has already been made or not.

Regards,

Prateek

Answers (4)

Answers (4)

former_member859847
Active Contributor
0 Kudos

Hi,

Thanks for all your helpful answers.

former_member192295
Active Contributor
0 Kudos

HI

Choose ABAP mapping and write adjacent duplicate statement automatically duplicate will be avoid, currently we don't have standard function to stop duplication, depending on requirement developing UDF only

former_member182455
Active Contributor
0 Kudos

hi mahesh,

write module processor for checking the duplicate record in file adapter

or

With a JAVA/ABAP mapping u can eliminate the duplicate records

and check this links

http://help.sap.com/saphelp_nw2004s/helpdata/en/d0/538f3b294a7f2de10000000a11402f/frameset.htm

regards

srinivas

Former Member
0 Kudos

hi

check this blog