topic Re: SAP PI/XI Mapping Split Message By Certain Field Value in Application Development and Automation Discussions

SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:21:48 GMT

Hello Experts,

I have to map an edifact file to IDOC . My problem is that i want to split file everytime field that holds edifact code is BGM. For Example if I have a file like this :

BGM 11111111111111

LIN 22222222222222

LIN 33333333333333

BGM 44444444444444
LIN 55555555555555

I will map this file to a message like this :

code: BGM
mes: 1111111111111

So I need to create a split to create one IDOC everytime code is BGM. In this Example I'll have to create 2 IDOCS . First will have first three lines and second will have the remaining two.

Regards

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:26:45 GMT

Are you using any middleware? It is very simple in Middleware.

e.G for SAP PI/PO in graphical mapping you can map the BGM segment to IDOC node in target structure for this.

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:28:20 GMT

No I don't

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:30:17 GMT

The heading of the post says you are using SAP PI.

Anyway how you are receiving the file? via FTP or you are placing it the local PC/Application server and then trying to read it?

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:31:33 GMT

Sorry my fault,
Yes I'm using SAP XI .

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:37:02 GMT

Then as I said. It is very easy in XI graphical mapping. Only thing you might need to do is to change the XSD of the IDOC to accept multiple occurrence( 1 to unbounded). So you can manually edit the XSD of the Idoc or create an external message and use that as the target structure.

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:40:00 GMT

I've already done this . My problem is splitting lines everytime code is BGM and place them in IDOC.

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 15:54:06 GMT

Oh I see. BGM is not a segment(My bad : I thought you are using EDIFACT) rather a value in segment. Then I don't think them it is possible via graphical mapping. You may want to explore ABAP(If not single stack PO)/Java/XSLT mapping .

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 16:00:16 GMT

Solved it using UDF

Re: SAP PI/XI Mapping Split Message By Certain Field Value

Former Member — Wed, 21 Oct 2015 16:05:48 GMT

Ok great.Glad to know. Please close the thread.