Table Name on JDBC

[Former Member]

Hi Experts,

If I am working on a outbound interface using JDBC (SAP to ODS) on direct insert and update, how can we check the target table name of ODS? I believe it's in somewhere of my Message Type or Message Interface? Or is it at the Communication Channel? I have no idea how can I look for it after several try and error.

Example, the table SAP_INVOICE in ODS is ready for SAP to pump in data, where can I get the SAP_INVOICE value in my XI?

Thanks.

Cheers,

Isaac.

[Former Member]

Thanks.

[Former Member]

Refer this link : [JDBC Message Format|http://help.sap.com/saphelp_nw04/Helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm]

Check the JDBC receiver Message Type.

Or check converted XML in Communication Channel Monitoring (for JDBC).

Thanks

farooq

[Former Member]

Hi,

In the Receiver JDBC structure we need to create the Table Name as element. In the Message mapping you need to map this with source field Name.

Check the field name in the Source Message Type and check in the SXMB_MONI for the table names from the souce side at runtime.

Regards

Goli Sridhr

[dharamveer_gaur2]

Hi

Check Target Structure in Message Mapping, Element name Table might be mapped with Table Name.