Mass data select to post Idocs and return result from acknowledgements

[Former Member]

Hello,

This is the process:

A JDBC select to a data base (1 tables with header data, 1 with line items) results in a number of entries to be moved to a SAP system.

For each header table line we need to create an Idoc with corresponding line items from the second table.

Then we send the Idocs to SAP to post them.

The system acknowledgement per Idoc is required to do with another JDBC connect a status update on the

header table for each of the Idocs posted.

Positive Ackn. = Update to Status A

Negative Ackn. = Update to Status B

If we send the Idocs as a package to SAP (map to unbounded Idoc) how will we be able to go forward with ALEAUD returned per Idoc posting?

Your input is appreciated.

Best regards

Dirk

[Former Member]

Solved on my own with help from replies.

[former_member206760]

hi dirk,

if u want o consider per idoc processign...u can specify unbounded idoc mapping in the transformation step and after that there will be a block in " par for each " mode ...and inside the block have a async send step..

this arrangement will allow u to send the idocs one by one but in parallel and hence u can tap each idoc processing.

[Former Member]

Ok,

so I understand that sending the Idoc is in the e.g. par for each step and within this block I will receive the ALEAUD and will be able to process it.

But this would mean that I need to respond to the DB table for each single ALEAUD within the par for each line.

Is it then possible to collect the answers in two containers e.g. one for success, one for error and do the update on the DB table with a multiline statement too?

Regards

Dirk

[former_member206760]

after the par for each block u can have a transformation step that will again be a unbounded mapping to cllect the messgaes..and then aother transformation step between that and JDBC structure