cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation of transactional and master data

Former Member
0 Kudos

Dear all,

I have the following requirement:

I frequently transfer transactional as well as master data between various systems. From what I heard, SAP XI/PI is a plattform to handle the transformation and distribution of such transactional and master data. Unfortunately, the data quality is often not sufficient.

As a consequence, some records need to be manually modified/completed. Let's assume order data needs to be exchanged and an order is characterized by a customer. When the order record contains a faulty CustomerID that does not exist, the CustomerID in the order has to be manually adjusted by a person. And this would require some user interface.

Could I implement something like this in SAP XI/PI? Or would I require another SAP solution?

Some of my relevant applications are in SAP BI/BW. There, I could implement something like this using an ODS for the "problematic" records and some maintenance views. Would you rather suggestion such a solution in BI/BW. But what would I do with the transformation between non-SAP systems?

Best regards, Daniel

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

at the moment there are no user interfaces inside XI.

They should first come with PI 7.1.

/people/stephan.schluchter/blog/2008/03/17/enhancements-in-ccbpm-within-sap-netweaver-process-integration-71

But if it's somehow possible to adjust the data only with functions (without user interface) you have a lot of mapping possibilites in the XI.

Regards

Patrick

Edited by: Patrick Koehnen on Apr 1, 2008 6:01 PM

Former Member
0 Kudos

Hi Patrick,

thanks for your reply, I had a look at the link.

With the existing mapping possibilities in XI/PI: if you need to do more advanced transformation, do you use ABAP or JAVA for the scripting?

Do you know a good reference/link that illustrates the mapping?

Cheers, Daniel

Former Member
0 Kudos

Hi Daniel,

I prefer JAVA mapping.

There is lot you can do with message mapping (the graphical mapping editor):

http://help.sap.com/saphelp_nw04/helpdata/en/49/1ebc6111ea2f45a9946c702b685299/frameset.htm

with the predefined standard functions:

http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/frameset.htm

If this is not enough you can write your own so called user defined functions in JAVA:

http://help.sap.com/saphelp_nw04/helpdata/en/22/e127f28b572243b4324879c6bf05a0/frameset.htm

Also helpful:

Message Mapping Simplified - Part I & II

/people/sravya.talanki2/blog/2005/08/16/message-mapping-simplified--part-i

/people/sravya.talanki2/blog/2005/12/08/message-mapping-simplified-150-part-ii

Mapping Functionality in XI:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9202d890-0201-0010-1588-adb5e89a...

Regards

Patrick

Former Member
0 Kudos

OK, thanks a lot!

Cheers, Daniel