Skip to Content
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

image

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

image

Step 4

– choose you database table once more

image

Step 5

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

image

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

image

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)

image

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

image

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

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member
    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
    BAPI_USER_GET_DETAIL(request/response)
    how can I send/receive Idocs/RFCs using this?

    Cheers
    Sudhir

    (0) 
    1. Michal Krawczyk Post author
      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 🙂

      Regards,
      michal

      (0) 
      1. Former Member
        🙂
        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 🙂

        Sudhir

        (0) 
        1. Michal Krawczyk Post author
          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 🙂

          Regards,
          michal

          (0) 
          1. Former Member
            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)

            🙂
            Sudhir

            (0) 

Leave a Reply