In the idoc there are three segment for E1EDK03 with IDDAT and DATUM field name. The idoc will look lik this
E1EDK03
Segment
IDDAT 011
DATUM 20080514
E1EDK03
Segment
IDDAT 028
DATUM 20080514
E1EDK03
Segment
IDDAT 017
DATUM 20080518
My mapping is showing if IDDAT equal 028 then map the DATUM to Paymentdate. With this mapping, the idoc with 1 line of payment is working successfully but if the idoc has multipule line of item then is fail with this error
Cannot produce target element /ns0:MT_InvoicePaymentDatabaseRequest/STATEMENT_NAME/TABLE_NAME/access/SAP_VENDOR_NAME. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd
How can you loop throught the segment with multipule payment to get the date? If I map the IDDAT equal 017 then it work okay. In this case the it seem to select the last segment but it is not the date that I want.
Thanks
Michelle