Purchase order Item text mapping in PI, IDOC to cXML (Ariba)

1327 Views Last edit Dec 04, 2017 at 09:24 AM 4 rev

Hi Experts,

We are making use of segment E1EDPT1 of ORDERS-ORDERS05 idoc to send the purchase order item text from ECC to Ariba. As E1EDPT1 is already being used we are passing the value as key-value pair. ie, E1EDPT1-TDID contains the key to indicate item texts (F01, F02...FX) and E1EDPT1-TDLINE contains value (Item Text). As TDLINE is of length 70, we are splitting the item text and passing it into next TDLINE. The structure is as given below.

Purchase order Line ITEM - 1

E1EDPT1

TDID - F01

E1EDPT2

TDLINE - ABC

TDLINE - XYZ

E1EDPT1

TDID - F02

E1EDPT2

TDLINE - PQR

TDLINE - 123

Purchase order Line ITEM - 2

E1EDPT1

TDID - F01

E1EDPT2

TDLINE - MNP

TDLINE - ASD

E1EDPT1

TDID - F01

E1EDPT2

TDLINE - 234

TDLINE - QWE

Our requirement in PI is to

1. Concatenate all TDLINE under F01 for first item

2. Add a line of sepetrators

3. Concatenate all TDLINE under F02 for first item

Pass these concatenated values to Target field of first Iine item

Do the same for second line item

Output should be like below

First Line (Target is single text field)

ABC

XYZ

******

PQR

123

Second Line (Target is single text field)

MNP

ASD

******

234

QWE

Please let me know if this kind of requirement can be achieved. The main issue i am facing here is i am not able to differentiate between the Line text of Line 1 and Line text of Line 2. How can i achieve this in PI mapping.

Looking forward to your valuable inputs.