IDOC to JDBC Scenario

[Former Member]

Hi All,

I am working on IDOC to JDBC scenario.I am trying for INFREC idoc of purchasing info record. I have not worked on IDOCs before. So can anybody plz help with providing some Documents.

Thanks & Regards,

Ankur

[bhavesh_kantilal · Accepted solution]

Hi Ankur,

Just check this doucment on what is to be done,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cdded790-0201-0010-6db8-beb...

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Ankur,

Refer link

http://sap.ittoolbox.com/groups/technical-functional/sap-r3-ale/how-do-i-trigger-outbound-idoc-files...

Anand More.

[Former Member · Accepted solution]

Hi Anand,

Links which you send was very helpful.Now I am getting mapping exception in MONI.can you plz tell me where can we see the payload of IDOC which is coming from sender.

Thanks & Regards,

Ankur

[Former Member · Accepted solution]

Hi ,

You can see the Payload of the IDoc in transaction SXMB_MONI.

In the sender messages if you open the tree you will have payload.

Regards

Vijaya

Message was edited by: vijaya kumari

[Former Member · Accepted solution]

Hi Vijaya,

In SXMB_MONI, I am getting Ack. & SOAP Header & SOAP body.but there is no a payload folder.Can you plz tell me where to see the payload.

Thanks & Regards,

Ankur

[bhavesh_kantilal · Accepted solution]

Ankur,

Is this what you are checking into,

INBOUND MESSAGE --> PAYLOADS --> MAIN DOUCMENT

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Vijaya,

Now I am able to see the payload.Using that payload when am testing the message mapping it is giving me the following error.

11:00:53 Start of test

Fatal Error: com.sap.engine.lib.xml.parser.ParserException: XMLParser: No data allowed here: (hex) 2d, 20, 3c(:main:, row:2, col:3)

11:00:54 End of test

when I am changing it SRC to Tabular view it is giving 'XML not well formed'.

Below is the XMl structure of payload which is coming from Sender:

<?xml version="1.0" encoding="UTF-8" ?>

- <INFREC01>

- <IDOC BEGIN="1">

- <EDI_DC40 SEGMENT="1">

<TABNAM>EDI_DC40</TABNAM>

<MANDT>800</MANDT>

<DOCNUM>0000000000703158</DOCNUM>

<DOCREL>620</DOCREL>

<STATUS>30</STATUS>

<DIRECT>1</DIRECT>

<OUTMOD>2</OUTMOD>

<IDOCTYP>INFREC01</IDOCTYP>

<MESTYP>INFREC</MESTYP>

<STDMES>INFREC</STDMES>

<SNDPOR>SAPID4</SNDPOR>

<SNDPRT>LS</SNDPRT>

<SNDPRN>XI3400</SNDPRN>

<RCVPOR>XIMDM</RCVPOR>

<RCVPRT>LS</RCVPRT>

<RCVPRN>ID4800</RCVPRN>

<CREDAT>20060526</CREDAT>

<CRETIM>002351</CRETIM>

<SERIAL>20060511174537</SERIAL>

</EDI_DC40>

- <E1EINAM SEGMENT="1">

<MSGFN>009</MSGFN>

<INFNR>5300004146</INFNR>

<MATNR>100-100</MATNR>

<LIFNR>0000001002</LIFNR>

<ERDAT>20060511</ERDAT>

<ERNAM>JOGESHM</ERNAM>

<MEINS>BX</MEINS>

<UMREZ>16</UMREZ>

<UMREN>1</UMREN>

<VERKF>Mr. Schulze</VERKF>

<TELF1>109876543</TELF1>

<MAHN1>10</MAHN1>

<MAHN2>20</MAHN2>

<MAHN3>30</MAHN3>

<URZDT>00000000</URZDT>

<URZLA>DE</URZLA>

<LMEIN>PCE</LMEIN>

<VABME>2</VABME>

<LTSSF>00000</LTSSF>

<LIFAB>00000000</LIFAB>

<LIFBI>00000000</LIFBI>

<ANZPU>0.000</ANZPU>

- <E1EINEM SEGMENT="1">

<MSGFN>009</MSGFN>

<EKORG>1000</EKORG>

<ESOKZ>0</ESOKZ>

<ERDAT>20060511</ERDAT>

<ERNAM>JOGESHM</ERNAM>

<WAERS>EUR</WAERS>

<MINBM>0.000</MINBM>

<NORBM>23.000</NORBM>

<APLFZ>12</APLFZ>

<UEBTO>0.0</UEBTO>

<UNTTO>0.0</UNTTO>

<ANGDT>00000000</ANGDT>

<NETPR>25.00</NETPR>

<PEINH>1</PEINH>

<BPRME>BX</BPRME>

<PRDAT>99991231</PRDAT>

<BPUMZ>1</BPUMZ>

<BPUMN>1</BPUMN>

<WEBRE>X</WEBRE>

<EFFPR>25.00</EFFPR>

<KZABS>X</KZABS>

<MHDRZ>0</MHDRZ>

<BSTMA>0.000</BSTMA>

</E1EINEM>

</E1EINAM>

</IDOC>

</INFREC01>

Thanks & Regards,

Ankur

[bhavesh_kantilal · Accepted solution]

Ankur,

Did you copy the soruce from the Inbound payload message?

<i>- <INFREC01>

- <IDOC BEGIN="1">

- <EDI_DC40 SEGMENT="1"></i>

the "-" is the reason for the problem.

In SXMB_MONI, you have an option to export the XML as file, just click on WINDOW1 / WINDOW2 ( in whichever window the Payload is open) and then use XML saved in the file this while testing your message mapping.

Alternatively, delete all the "-" manually , from the payload after you paste it in message mapping TEST.

Regards,

Bhavesh