Data manipulation and validation: XI or R3:

[Former Member]

Hi There,

We have an interface server currently in our landscape and it receives data from several legacy applications, in most cases flat files and interfaces to the back end R3.The flat file is raw and the data requires validations and corrections in some cases. The interface server has some data from the back end R3 that is being populated by daily batch jobs. The interface server uses this data to validate and manipulate the incoming file and build a clean record that posts to the back end R3.

We are in the process of replacing the interface server with XI and we are looking for some guidance in terms of where we want the data manipulation and validation to happen. We are currently evaluating the following suggestions in terms of performance issues, ease of development and also SAP best practices. We are open to any new suggestions as well. The technical scenario is that we receive a flat file into XI, and we map into an IDOC that posts into R3 back end.

1. Processing in R3: Only the mapping is done in XI. The data manipulation and validation happens in R3. The place to do that would be in the user exit of the inbound function module.

2. Processing in XI: We replicate the data we require for data manipulation and validation in XI in custom tables with regular updates. The data manipulation and validation is done at the time of mapping and a clean IDOC is posted back to R3.

[Former Member]

Steve,

<i>1. Processing in R3: Only the mapping is done in XI. The data manipulation and validation happens in R3. The place to do that would be in the user exit of the inbound function module.</i>

From this I understand that you are not doing any mapping or validation in XI. Then simply pass the file via FTP from legacy to R3 using XI. Then let R3 pick the file and do all the manipulations and validations. You can check this weblog for detail explanation:

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp

<i>2. Processing in XI: We replicate the data we require for data manipulation and validation in XI in custom tables with regular updates. The data manipulation and validation is done at the time of mapping and a clean IDOC is posted back to R3.</i>

If you want to do manipulations and Validations in XI you can also do it in Message mapping. If it is having complex validations then you can also go for XSLT or Java Mapping.

Also Check this threads which may help you:

Hope this helps.....

---Satish

[moorthy]

HI,

This doc may help u-

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/99593f86-0601-0010-059d-d2d...

REgards,

Moorthy

[Former Member]

Hi,

for the validation in XI check out the following blog

Validation of Messages in SAP NetWeaver Exchange Infrastructure - SDN Member Session EPI213 at SAP TechEd '06 Amsterdam

/people/thorsten.nordholmsbirk/blog/2006/07/24/validation-of-messages-in-sap-netweaver-exchange-infrastructure--sdn-member-session-epi213-at-sap-teched-06-amsterdam

Best regards,

giamma