on 02-19-2016 3:33 PM
Hi, I am working on a jdbc insert for a parent table (po header) and two children tables (po line item and po service items) using idoc orders.orders05. I had some problems because for e1edc01 there is a header record that I needed to remove. I accomplished this with the below:
My mapping works when there are service items and removes the empty e1edc01. My problem is when the po is a service limit and there are no service items. The service item insert fails. How can I stop this insert when there are no service items?
you can use createif + boolean to create the segment DT_CAZ_PO_SVC_ITEM_DTL only PO service exists.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks, I guess i am struggling because at the child level I need to remove all the segments for E1EDC01 with posex = '0000000000'. This may leave me with zero to many E1EDC01 segments. After the removal, I need to check at the parent level if any E1EDC01 exist? I am not sure when these various things trigger in pi and how I can check just once at the parent level if any E1EDC01 exist?
My insert works fine as long as there are service items:
If I have only a limit line item and no services then I am not able to suppress the insert. I would like to suppress it by checking to see if there are any valid E1EDC01 segments.
Any suggestions would be appreciated.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.