How to read a column from ms_sql_server table and store in R3 Table

[former_member189387]

Hi friends ,

Can you please tell me how to read a value from a column of ms_sql_server table and store in a R3 Table

Is any blogs are available ?

Expecting you reply asap

Best Regards

V.Rangarajan

[bhavesh_kantilal · Accepted solution]

Use the sender JDBC adapter to read the data from the SQL Server and then use an idoc / rfc to send the data to SAP.

Regards

Bhavesh

[prateek]

U have to use sender JDBC adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

U may use IDOCs, RFC or ABAP Proxy as receiver

IDOC

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6bd6f69a-0701-0010-a88b-adbb6ee8...

/people/venugopalarao.immadisetty/blog/2007/01/24/troubleshooting-file-to-idoc-scenario-in-xi

Regards,

Prateek