Mapping IDOCS (ORDERS05) to JDBC and context

[katie_doody2]

Hi, I am trying to map the ORDERS05 idoc and update the values in an oracle database using jdbc. I am trying to get my statement to repeat for each record in the idoc. I have three tables:

outline agreement header - mapped to E1EDK01  (context idoc) mapped to my statement value, access and key

outline agreement line item - mapped to E1EDP01 (context idoc) mapped to my statement value, acccess and key

outline agreement service item - mapped to E1EDC01 (context idoc) mapped to my statement value, access and key

I have set my statements to 1 to unbounded but only the first record comes for each level?

[Former Member · Accepted solution]

you may need to use remove contexts and Split by value function in the mapping, Kindly provide screenshots of your mapping and dispaly queue of input data,

[katie_doody2 · Accepted solution]

Thanks for the reply, I have all the updates now coming in by mapping the statment to the corresponding context.

header - E1EDK01 (IDOC context)

                      update - segment for E1EDK01

                            access - segment for E1EDK01                      

                             key - segment for E1EDK01

line item - E1EDP01 (IDOC context)

                      update - segment for E1EDP01

                             access - segment for E1EDP01

                             key - segment for E1EDP01

service item - E1EDC01 (IDOC context)

                    update - segment for E1EDC01

                           access - segment for E1EDC01

                           key - segment for E1EDC01

The only issue I have now is that it is sending over the E1EDC01 when the POSEX is 0000000000 and I need to suppress that.      

[Former Member · Accepted solution]

if i read it correctly, you need to suppress the service Item - statement when POSEX is 0000...?

use Boolean function 

POSEx

            EQUALS --> NOT -- > IF THEN --- > EDC01 --> Service Item.

00000000 (Const)

[katie_doody2 · Accepted solution]

Thank you, man idocs are fun!!