Creation of Data types

[Former Member]

Hello All,

I have some doubts in creation of data types in SAP XI 3.0

I am having some kind of confusion while creating the datatypes. Like when we create data types, when JDBC is receiver, we should maitain something called statement at root node, then comes access field which is of attribute type, then comes action under which we have the table fields.

But this would not be the case for the rest of the adapters.

Does anybody of you have any document/any help where we get some info regarding the creation of data types in different situations?

Priya

[bhavesh_kantilal]

Hi Priya,

In case of JDBC adapters, XI has to convert the data into a corresponding SQL statement and that is why it expects the data in a particular format.

For other adapters like, file , JMS , etc as the Datatype is going to be defined by the format in which the other application is sending the data, we need to create the data in the corresponding format prescribed the the application.

Regards,

Bhavesh

[Former Member]

the reason behind using a special data / message type in case of reciever JDBC is the adapter finally creates a SQL query out of the XML. if you dont follow the sequence / rules then it results into a Syntax error.

For IDocs and RFCs you import them from the target / source R/3 system and hence creation of data types is not required.

For all other cases , wherein a special syntax as such is not required, you can create your own data type which offcourse is governed by your business requirement.

[Former Member]

Hi Priya,

In JDBC scenario we are inturn constructing a query in the receiver data type structure.Thatz y it follows some standard rules.

But generally in all the other adapters , the receiver data type holds the structure of the receiver i.e the format in which the data that is to be presented in the receiver business system.

regards,

aravindh.

[Former Member]

Priya

Datatype creation depends on the system you are talking to , so ultimately the specifics would differ if you talk to a JMS/JDBC(in case of database) depending on the specific interface requirement.Would suggest that you get a hang on creating simple/complex XSDs and then relate how the structure is to be designed for a specific target system.