topic Re: Data upload without XI/PI in Application Development and Automation Discussions

Data upload without XI/PI

Former Member — Sat, 05 Nov 2011 12:20:12 GMT

Dear Experts,

I am stuck with some problem and i hope you all there will be able to help me.

Scenario:

client doesn't have Web Services i.e. XI/PI and they want to sync data from one application to SAP. The application extracts XML file to file server which then i need to pick and upload to SAP system.

Problems:

Is it possible to pick up file from 'file server' without XI/PI ? (if yes then how?)

how to convert the file from XML to flat once file is picked?

once there is success/failure of data upload then there should be some log file for the confirmation.

this is the overview of the problem once i break this then i hope i will have some other questions to ask.

Any light on this is highly appreciated and thanks in advance.

waiting for your replies

Cheers !

Re: Data upload without XI/PI

Former Member — Sat, 05 Nov 2011 13:24:00 GMT

Hi,


Is it possible to pick up file from 'file server' without XI/PI ? (if yes then how?)

Yes, use OPEN DATASET and READ DATASET statements


how to convert the file from XML to flat once file is picked?

Search the forum (Google is also your friend), there are plenty of example for this.

Your could e.g. use a transformation to do that.

Here is a first link: http://abapreports.blogspot.com/2008/09/upload-xml-file-from-application-server.html.


once there is success/failure of data upload then there should be some log file for the confirmation.

Well, generate your own one (flat file, excel,..) or you can also use standard application log (managed through SLG1) and set-up with FM BAL_LOG_*, you should also be able to find a lot of example for those.

Kr,

Manu.

Re: Data upload without XI/PI

Former Member — Sat, 05 Nov 2011 17:40:43 GMT

Thanks Manu,

appreciate your help and still looking for more examples.

Cheers