Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC cc select into structure with different fields

Hello experts,

I have some interfaces that already work with jdbc sender communication channel. My problem is that database is gonna change structure cause of an update in the third party system . I'd like to know if there is a way to select fields in jdbc cc and insert them into existing message types.

For example lets say existing database field and message type field is ID and the new will be identifier  . Is there a way to select identifier into ID of existing message type so i don't have to change all processes ?

Thank you in advance

Former Member

You can change the select query to use the as clause.Eg:  Select identifier as id and so on.

This will make sure your PI ESR Content will continue to remain the same.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question