Skip to Content

XI: Importing an R/3 structure or table into Repository not possible?

In recent time I saw questions on the XI forum asking if it’s possible to import an R/3 structure
into Integration Repository.

There’s no easy way as in standard you can only import RFC and IDOCs signatures. But what if
you have a structure that has 300 or 400 parameters? Do you have to do the Data Type manually ?
You can… but if you want you can try this little hint. If your structure is based on a table (table type)
or you want to import the table signature than there might be a way to do it in less then 2 minutes.
All you have to do is to leave your SAPGUI alone. As you may know by know we’ll try to export
the XSD schema definitions from the database. We’ll use MS Access to help us a little.

My example show how you can do it with Microsoft SQL Server
but similar approach can probably be used with any other database that can export data into the XML.

Exporting data from Microsoft SQL Server

Step 1

– create a new empty database in Microsoft Access

Step 2

– choose you table from the database in Enterprise Manager(remembering that transparent tables from R/3 have the same name in the database)

– export the table


Step 3

– now we will use DTS (Data Transformation Services) to export the table from Microsoft SQL Server
into our new Microsoft Access table

– create w new data source pointing to the Access table


Step 4

– choose you database table once more


Step 5

– execute your DTS package and if everything goes right you should see a new table inside the Access database


Exporting the XSD table schema from Microsoft Access

Step 1

– open you new database in Microsoft Access and choose your table

– right click (Export…) and choose XML


Step 2

– on the next popup unselect DATA (XML)

– leave “Data schema (XSD)” selected and proceed with the export

– now you have a file with XML Schema definition of the R/3 table

Importing the XSD table schema into the Integration Repository

Step 1

– create a new External Definition

– chanage the category to XSD

– choose your file (XSD schema)


Now you can use the new structure inside a mapping for instance.


Where you able to do it in less then 2 minutes?
If not try once more… 🙂

I hope that the shown procedure can save a lot of time to anyone who will ever need an R/3 table Data Type inside Integration Repository.

Preparing this article I was using:

Exchange Infrastructure 3.0 SP13
Microsoft Access 2003
Microsoft SQL Server 2000

You must be Logged on to comment or reply to a post.
  • Hi Mike,

    I understand this and this the way even we do in projects, but we use only for table structures.

    How can this be replacement for Importing RFC/IDoc signatures? say for CREMAS.CREMAS03 or
    how can I send/receive Idocs/RFCs using this?


    • hi 🙂

      >>>how can I send/receive Idocs/RFCs using this?

      hmm.. I guess I wans’t clear
      you use standard import (from IR)
      if you want to send receive idocs
      but… if you have a structure
      (flat file for instance) which has the same fields as a table (or structure) from R/3
      then you can either create data type manually
      or you can do it like shown above

      idocs/rfcs are only shown here because if you import then you can do it very quickly

      if you worked with Business connector you may
      remember that in this tool there was a possibility
      not only to import rfc/idoc but also structure signatures and since XI doesn’t have this feature yet
      I decided to show a workaround 🙂


      • 🙂
        okie, got what ya mean…:)

        in one of our scenario we do the same for R/3–>XI–>DB
        where IDoc signature is imported into IR and xsd of DB is used for creating data type.

        But b’cos receiver jdbc has specific formats..
        we only create the name of DT with required structure upto say ‘access’..and then export it as xsd…then use the DB xsd fields –>copy it and paste in the XSD exported by IR.
        Then we reimport the modified xsd…and it has all fields 🙂


        • I guess copy&paste will always be a solution:)

          someone also mentions that you could
          put r/3 structure inside an rfc
          import the rfc and then export xsd…
          and also cut everything except the table…

          but i’m not sure if my approach is not faster:)

          less then 2 minutes with any kind of table 🙂


          • Mike 🙂
            now this time u got me wrong 🙂
            Say in receiver JDBC we cannot directly use XSD
            generated by say XMLSPY by connecting to SQL table.The XSD needs to be modified to suit document format of JDBC.That way using XSD instead of manually creating fields is always better 🙂 (i agree it hardly takes two minutes)