JDBC to IDoc (ORDERS05) IDoc
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:
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?