Skip to Content
0
Former Member
Dec 07, 2011 at 12:23 AM

IDOC to JDBC - mapping test versus actual run

20 Views

Hi

When I test the message mapping for the idoc-to-jdbc sender scneario, where one sales order idoc has multiple line items in segment E1EDP01, the statement => access structures repeat properly for 2 line items. Here I am giving the idoc xml file (data file) in the payload in the test tab of message mapping)

However in the communication channel log (with sql statement log = true), when I try to process an actual idoc from ECC, in the sql log of the processed message, I can see an insert statement only for the first line item of the sales order.

Please can somebody guide me as to what must be the problem?

Statement occ is 1.

tablename occ is 1.

Access structure occ is 0...unbounded.

The segment E1EDP01 is currently mapped to acess node.

The sales order number is repeated over the 2 line items using below mapping -:

E1EDP01 (with context as root) => "useasmany" => split by value => Item no.

Please advise.