on 12-18-2012 7:04 AM
Hi All,
We have imported JDBC structure from legacy staging table thru external definations and the problem is
that we could not use that it in our message mapping because we have JDBC receiver adapter.
Can any one suggest us how to add the row,access,table fields in the target structure so as suit JDBC
schema ?
Thanks,
Hi Kumar,
We upload JDBC Structure as External Definition of type 'dbtb' to perform mainly standard function JDBC Lookup. For Receiver JDBC Communication, you need to use the JDBC Structure provided by SAP (above mentioned by Baskar).
Please find a sample scenario for Receiver JDBC: http://saptechnical.com/Tutorials/XI/RFC2JDBC/Index.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1)You cant use imported XSD for receiver JDBC stracuture.
2)Editing XSD manully is not a right idea.
3)You need to created JDBC receiver data type structure as per standard format.
check above links provided by other experts and follow the same.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For jdbc structure, you need to follow the recommended message structure as given by sap help link. You can follow select or update structure accordingly to your requirement as specified by link. Please make sure it matches table name etc as recommended. You can create structure by following the naming syntax given in the xsd using the below link structture.
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
create required structure in a seprate data type for (row , access ,table fields - all control fields) and under it refer your external data type by selecting Data Type option in TYPE section.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.