Skip to Content

Message split according to data

Dear All,

I have IDOC to JDBC scenario. I have multiple SQL servers with same stored procedure name. I’m using IDOC ARTMAS to trigger material data from SAP. Once IDOC came to SAP PI server (Single stack without BPM) I want to create multiple messages as per the value in <E1BPE1MARCRT>-<Plant> field.

Eg:- <E1BPE1MARCRT>-<Plant> = “SCCC” Header data + 1st E1BPEMARCRT segment Data should go to sql server A

<E1BPE1MARCRT>-<Plant> = “SCA2” Header data + 2nd E1BPEMARCRT segment Data should go to sql server B

Please help me to resolve this.

scenario.png (31.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 12 at 06:36 AM

    Hi, Buddhika

    Using standard PI message split, node function "createif" and setup 2 different JDBC receiver communication channels can implement your idea.

    1.Set up standard message split in message mapping object in the tab of "Signature." 1st msg is design to go to System A while 2nd msg goes to System B.

    2.Leverage "createif" node function so plant "SCCC" goes to 1st target msg and plant "SCA1" goes to 2nd target msg. Be noticed, make "plant" node in the context of "grand parent" level, in this case it is "MTComposite", rather than a regular one.

    3.Configure 2 different JDBC receiver communication channels to represent different DB.

    Add comment
    10|10000 characters needed characters exceeded