topic Re: problem faced while converting XML files to IDOCS in Application Development and Automation Discussions

problem faced while converting XML files to IDOCS

Former Member — Wed, 27 Apr 2011 15:43:39 GMT

Hi guys,

I need a bit of help from you people. Firstly I want to congratulate all of you and especially the moderators for making this a very thriving community.

My requirement is I need to convert XML files deposited by our project's Unix team on a server(which is just like a physical drive like C:/ drive) known as Mercator to inbound IDOCS to be posted in a custom table which would be later used to satisfy a business requirement. I have provided the full physical path of the XML files on the Mercator and the Port name as input parameters to the FM IDOC_XML_FROM_FILE. But I am getting a runtime dump which says that the file cannot be opened by OPEN DATSET command.

Can anyone please help me in this regard?

Thanks a lot !

Hasso.

Re: problem faced while converting XML files to IDOCS

former_member191735 — Wed, 27 Apr 2011 15:51:43 GMT

To Open from Open dataset, the file has to be in application server which is in filesystem where the SAP is.

You have to move these files into application server from presentation server.

check out transactions: cg3y and cg3z. you can convert to/from application server.

Re: problem faced while converting XML files to IDOCS

brad_bohn — Wed, 27 Apr 2011 16:15:12 GMT

The file does not have to reside on the application server, as long as the folder/directory is mounted in your system landscape. Your Basis team can map the location so that it is accessible but you are going to reference the location using '/tmp/.../myfolder/...' and not using 'C:\...\...\...' and the location should also be consistent with the inbound file folder settings on the file port you have configured in WE21.

Re: problem faced while converting XML files to IDOCS

Former Member — Thu, 28 Apr 2011 13:08:40 GMT

Brad thnx alot man I think this is the best thing to do .

Edited by: Hasso14 on Apr 28, 2011 3:10 PM

Re: problem faced while converting XML files to IDOCS

Former Member — Thu, 28 Apr 2011 13:09:37 GMT

Hi Sampat I thought of this solution but this will prove cumbersome for many files. Neways thanks a lot

Re: problem faced while converting XML files to IDOCS

former_member191735 — Thu, 28 Apr 2011 14:06:22 GMT

Good you found the solution.

Re: problem faced while converting XML files to IDOCS

Former Member — Thu, 28 Apr 2011 18:58:09 GMT

Brad sorry to say that our Basis team is not sure how to do this-can you please chalk out the steps? It would be very helpful for us. Thanks a lot !

Re: problem faced while converting XML files to IDOCS

Former Member — Mon, 02 May 2011 20:11:44 GMT

someone help please ! basis team is totally in the dark.

Re: problem faced while converting XML files to IDOCS

Former Member — Mon, 02 May 2011 22:16:40 GMT

Hello Hasso,

Request your BASIS team to do the steps that is mentioned in the below steps:-

1) Using Mount command, mount the folder :

Format : Format: mount -t smbfs -o username={user name},password= {folders network location} {mount point} Example : mount -t smbfs -o username=tridge,password=foobar //fjall/test /data/test 2) Set the mount : Format: {folders network location} {mount point} smbfs username={user name},password=

Example: //monkey/Movies /mnt/abbas smbfs username=taco,password=paco

You can find lot of articles over the net.

Thanks,

Greetson