Message Mapping - creating multiple nodes with static values stored in PI

[Former Member]

Hi

We have a scenario whereby we will receive a single inbound XML message from an external party. In one of the fields in the XML message their will be a Purchase Organization indicator. If this value is set to "ALL" we require in SAP PI to be able to create multiple outbound IDOCS based on the number of Purchase Organizations that 'ALL' represents. This list of Purchase Organizations needs to be stored somewhere in SAP PI, as the Purchase Organization Code needs to be placed on the outbound IDOC messages that are generated.

We thought of trying to use value list or Fixed Values, but this doesn't work as the inbound key is the same for all Purchase Org's (being 'ALL').

Does anybody have any suggestion on how we can cater for this elegantly other than hard coding the Purchase Oganizations into the Message Map?

[Former Member]

Hi

Thanks for the response. The issue with the value mapping is that the key's need to be different. In our scenario we have one input key "ALL" which needs to map to multiple purchase organization's e.g. ACC001, AM003, DA312 etc. I don't believe this type of structure can be stored in a value map and used for our purposes within a map to be able to create a new message per Purchase Organization.

[Former Member]

Hi Ivan

We need the Purchase Org's to be available in SAP PI just for the mapping. We wanted to avoid hard coding them in some mapping incase the Purchase Org's change. That is why a "global" list type structure would be nice, but I dont see any option for us in SAP PI where that is available. From what i've seen it's just fixed values, Value List, or creating a database table possibly on the SAP PI database schema that we could lookup via a UDF - are there any other "clean" options of how we could do it?

[Former Member]

Hi,

So other option is using "value mapping" functionality. See the following link.

[https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/00ee347e-aabb-2a10-b298-d15a1ebf43c5&overridelayout=true|https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/00ee347e-aabb-2a10-b298-d15a1ebf43c5&overridelayout=true]

Regards

Ivan

[Former Member]

Wich Version do you Use.. Well In PI 7.1 you can save a value in the first segment and reply in many segments. Like a global variable.

[Former Member]

Well, not a very clean solution, but it could solve the problem nonetheless.

Develop a simple UDF and hard code the list of PO values in it. In your mapping, first evaluate the content of PO indicator to check "ALL". On success, use all the values from the UDF to achieve the result.

Regards

Jai

[Former Member]

Hi,

what did you mean when you said:

This list of Purchase Organizations needs to be stored somewhere in SAP PI

temporally to use in the same message mapping? or stored in the file system?

Regards

Ivan