Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC to IDoc (ORDERS05) IDoc

Hi,

My scenario is JDBC (from 2 tables) to single IDoc ORDERS05.

There are 2 source tables , HEAD, ROW. For every row in HEAD I need to create one Sales order through IDoc in R3.

I am doing inner join on HEAD, ROW and say for example I am getting the following rows:

HEAD.ID ROW.ITEM

1 ABC

1 XYZ

1 PQR

2 ABC

2 JKL

3 IOP

Now for each unique HEAD.ID, I need to map to ORDERS05 IDoc. ( In our example I need to create 3 orders).

How do i do this?

And also, I need to map only (ABC,XYZ,PQR) in the first occurrence of ORDERS05, then (ABC,JKL) in the second occurrence and (IOP) in the third occurence.

Could you please help me, how to do this?

Not what you were looking for? View more on this topic or Ask a question