Skip to Content
We often have a requirement for converting deep structures into flatfile. SAP XI provides the file content conversion functionality but it is limited to only one level. So when you want to convert any deep XML structure into plain text (CSV), you either need to write adapter module or you need to do that in graphical mapping itself.   The other options available are to use some third party adapters like *SeeBurger or Conversion Agent.*   In this blog we will see, how we can use SeeBurger to define content conversion for deep structure. As there are number of steps involved, I will divide this blog into two parts. In part 1, We will see step by step process for defining the content coversion in SeeBurger using Generator Mapping functionality.  Part 2 (SAP PI/XI : Content Conversion using Generator mapping functionality of SeeBurger : Part 2.  (SAP PI/XI : Content Conversion using Generator mapping functionality of SeeBurger : Part 2.)) will demonstrate the process of deploying the map onto the server and calling it from PI file adapter.   *Part 1 : *  SeeBurger provides graphical tool called BIC Mapping desiner for defining the custom maps for content conversion.   You can use generator mapping functionality of BIC mapping designer, which automatically generates the content conversion maps for you. So you only need to define your structure in *BIC mapping designer* and than you can generate content conversion map as well as XML schema to be used in SAP PI. Step : 1 Create the new message type *CSV* in SeeBurger.  image  2. Export create CSV message onto your desktop.  ” mce_src=”image   3. Create the XML message using *CreateXMLMessage* map provided by SeeBurger. CreateXMLMessage is default map provided by SeeBurger, You can find that in the Generator mapping project.   This is the XML schema which you will import in XI message mapping as target structure.  Use your exported CSV message as Source for executing mapping. Give name to your target XML structure. image Once XML Schema have been generated you can import that into your project.     4. Create XML to CSV mapping using *CreateXMLToEdi* mapping provided by SeeBurger.   Use your exported CSV message as Source , Give appropriate name to the Destination. This is the name of module, which you will be calling from PI adapter. In this case it’s See_X2E_ComplexStruct.xml. image 5. Once the map is generated, You can import that map in SeeBurger and test it locally. SeeBurger provides some auto correction while importing the map, accept the correction.imageimage
To report this post you need to login first.

8 Comments

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

  1. Tejas Bansod
    Hi Dijesh,
    You have explained this topic really well.Its very helpful for people like me who are interested in working on SeeBurger.

    Would like to see more blogs from you.

    (0) 
  2. tazkie tazkie
    Thanks for the blog.

    Wondering if this scenario is just xml to CSV?
    so if we will be having an XML to EDIFACT we need to create new message type EDIFACT on the first step?

    Thanks.

    (0) 

Leave a Reply