SAP PI/XI Mapping Split Message By Certain Field Value

[Former Member]

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

[Former Member]

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.

R

[Former Member]

No I don't

[Former Member]

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?

R

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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 .

[Former Member]

Solved it using UDF

[Former Member]

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