Data upload without XI/PI

[Former Member]

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 !

[Former Member]

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.

[Former Member]

Thanks Manu,

appreciate your help and still looking for more examples.

Cheers