IDoc to JDBC ?

[Former Member]

Hi,

We have req to send an IDoc from R/3, it has to update the data in the target Database & it has send the response back...

IDoc is Async & JDBC Sync...

Appreciate your help in advance...

Thanks,

kumar.

[udo_martens · Accepted solution]

Hi Kumar,

you could create a Business Process like:

IDoc -> BP

BP <-> JDBC (synchronous)

BP -> IDoc (ALEAUD)

Regards,

Udo

[Former Member · Accepted solution]

Hi Marten,

Thank for the reply...

How do we map the JDBC response to IDOC (ALEAUD)..

Could you pls explain me ?

Thanks,

kumar.

[udo_martens · Accepted solution]

Hi Kumar:

- E1ADHDR/MESTYP: original message type

- E1ADHDR/E1STATE/DOCNUM: original IDoc number

- E1ADHDR/E1STATE/STATUS: 68 in case of error, 53 in case of success

- E1ADHDR/E1STATE/STATXT: Short description for R/3 user what has happend

Regards,

Udo

[Former Member]

Hi Kumar,

Check this out...

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/file-rfc-file%2528without+bpm%2529&;

In place of receiver you can use file, if possible.

Regards

Arpil

[former_member181955]

Hi

It can be done with the following steps.

1.Rec step

2.Send (Mode:Sych)

3.Send (Mode: Asyn)

Thanks

Prasad Nemalikanti

[Former Member]

you can do it two ways

1) create synch - asynch bridge using BPM

2) create tow asynch scenaro one for IDOC to Database asynch to do the operation on database

create another asynch for database - to - IDOC which continuously polling to database and send message on any update.

regards,

[Former Member]

Is R/3 needs application ack and idoc status ack.

if idoc appl ack then you need to configure the reverse settings too for sending ack i feel.

if idoc status ack then it can be handled much easier

Rajesh