Generating Deeply nested XML from a flat file

10-11  Source: Network gathering  Views:0 

Advertisement
Hi All,
I am working on a MQ to IDOC scenario.
I am getting a flat file as input. I need to convert it into XML( so that XI can understand it).
But conversion is into a "Deeply Nested XML from a Flat File" at sender side (JMS Adapter).
Any inputs on this.
Regards,
Vikas
You can only convert flat file into xml structure with 3 levels.
If you need to convert flat file into deep nested xml structure, you have to do java mapping or xslt or abap mapping. There is a tool, I think it's called conversion agent by itemfield (bought by SAP), which can do pretty everything with conversion. Never used it though.
Jayson
Related articles
  • Generating Deeply nested XML from a flat file 10-11

    Hi All, I am working on a MQ to IDOC scenario. I am getting a flat file as input. I need to convert it into XML( so that XI can understand it). But conversion is into a "Deeply Nested XML from a Flat File" at sender side (JMS Adapter). Any input

  • How to load data from a  flat file which is there in the application server 10-11

    HI All,           how to load data from a  flat file which is there in the application server..Hi, Firstly you will need to place the file(s) in the AL11 path. Then in your infopackage in "Extraction" tab you need to select "Application Ser

  • Numbering nodes when loading hierarchy from a flat file. 10-11

    Hi All, I want to load a hierarchy from a flat file. When we number the nodes, do they have to be in a sequence or can I give them any number I want? I want to make the GL account number as the node number since it makes it easy to generate the node

  • Need to create sale order from the flat file & mail has to be sent 10-11

    Hi Experts,           I have a requirement to create a sale order from a flat file and once the oder is created, mail has to be sent to customer as well as to internal user with the order details. I want to know how this process can be implemented an

  • Error while uploading data from a flat file to the hierarchy 10-11

    Hi guys, after i upload data from a flat file to the hierarchy, i get a error message "Please select a valid info object" am loading data using PSA, having activated all external chars still get the problem..some help on this please.. regards Sr

  • What is the best way to load and convert data from a flat file? 10-11

    Hi, I want to load data from a flat file, convert dates, numbers and some fields with custom logic (e.g. 0,1 into N,Y) to the correct format. The rows where all to_number, to_date and custom conversions succeed should go into table STG_OK. If some co

  • Reading special characters from a flat file and inserting into DB 10-11

    I'm reading data with special characters like . etc from a flat file , assigning the data to variable in my anonymous block and inserting into my DB. But the show up as inverted ? s. Any clues about how to do this? If i try to do the insert directly

  • Looking for a program to delete CVCs from a flat file, infocube, ztable. 10-11

    I am looking for a program that will delete CVCs from a flat file, infocube, or ztable. Based on the research I have done, I would imagine the core of such a program would be the use of function module /sapapo/ts_plob_delete. If anyone has such a pro

  • Uploading the data from a flat file into ztable 10-11

    Hi, I have a requirement where I have to upload the data from 2 flat files into 2 z tables(ZRB_HDR,ZRB_ITM).From the 1st flat file only data for few fields have to be uploaded into ztable(ZRB_HRD) .Fromthe 2nd flat file data for all the fields have t

  • Data from a Flat file int a Cube 10-11

    Hi experts! Just a quick one, could we load data from a flat file directly to an infocube? Or we woud need to create a ODS to load that from the flat file there and later on form the ODS to the cube? Thanks you very much for your time!!Hi, You can di

  • Problem in the BDC program to upload the data from a flat file. 10-11

    Hi, I am required to write a BDC program to upload the data from a flat file. The conditions are as mentioned below:- 1) Selection Screen will be prompted to user and user needs to provide:- File Path on presentation server (with F4 help for this obl

  • Uploading Data from a Flat File 10-11

    Hi I am trying to Upload data from a Flat File to the MDS. I have a few questions on the Process. a) XI would be the Interface, and one end would be a file adapter with the Flat File format. On the other end, which Interface should I use - ABA Busine

  • How to read data from a specified line from a flat file 10-11

    hi all im having a filat file like as follows (eg) 1.aaa 2.bbb 3.ccc 4.ddd 5.eee using gui_upload i need to read the data from the flat file from the line number 2 into an internal table. (eg) 2.bbb 3.ccc etc can any one help with thisHi,     First u

  • Error while loading  data into External table from the flat files 10-11

    HI , We have a data load in our project which feeds the oracle external tables with the data from the Flat Files(.bcp files) in unix. While loading the data, we are encountering the following error. Error occured (Error Code : -29913 and Error Messag

  • Error while uploading data from a flat file 10-11

    Hi All, I am trying to load data from a flat file to an ODS. The flat file contains a field, say FLAT01, of numerical type(Type Decimal, Length 18, Decimals 2). I have created an infoobject, say ZIO10, with type CURR and currency field, 0CURRENCY. In

  • How to MODIFY A CUSTOM TABLE  FROM A FLAT FILE 10-11

    Dear Friends,                  I have a requirement where i have to upload data from excel file to my custom table  so i have used a FM 'TEXT_CONVERT_XLS_TO_SAP' and i have collected data into a internal table , till here i am able to get data correc

  • Create Shopping cart (or PO) in SRM/EBP from a flat file 10-11

    Hi all        I am looking for a function module or BAPI or any program that i can use to create shopping cart in SRM from a flat file. Is there a way to set up a break point in ITS transactions that are used to create shopping carts through portal?

  • BAPI_PO_CREATE1 not able to create PO's for multiple rows from the flat fil 10-11

    Hi i am uploading PO's from a flat file into SAP using the BAPI_PO_CREATE1. Everything works fine if the flat file hast only one record. if the flat file has more than one record then while loading the second record the BAPI returns a error message.

  • Conversion of multiple xml idocs to flat file 10-11

    Hi, I did ABAP mapping to convert xml idoc to flat file by using the reference how to do abap mapping in xi3.0.pdf It is working for only one idoc at a time. If I have multiple idocs in a single xml file, the above code is not working. Please let me

  • Multiple idocs from single flat file 10-11

    Hi All I want to send data from a flat file to SAP(file to idoc) My flat file structure is id,name,number,city 2,R1,234,SD 2,R2,457,MD 3,R4,789,HG 3,R6,235.HG The Field 'id' will change..after  every change in 'id' ,seperate idoc should be created. I