topic Re: Extracting data from ECC in XML in Application Development and Automation Discussions

Extracting data from ECC in XML

Former Member — Fri, 30 Jul 2010 20:21:04 GMT

Hi Gurus,

I am having a scenario like this:

Sales guy request for cataloge list of his customers online from portal-- ECC system Receives

Reqests and Queues the request for batch processing~~-Once Batch process is done in ECC it should create a Catalogue list for the requested customers in XML~~-LCES Sytem receives the requested XML file--- create a Offline interactive form and so on.

1. How to Queue the request for batch processing once the Sales guy submits his request over portal.

2. how to extract the data from ECC as XML once the batch processing is done.

Since the cataloge list is very huge it has to be done by batch processing only

Please give me some suggestions on this.

Thanks

Ravi

Re: Extracting data from ECC in XML

Former Member — Mon, 02 Aug 2010 06:58:00 GMT

Hi,

when you are speaking about portal I guess R3 <-> Web Dynpro <-> Portal is the big picture.

1. How to Queue the request for batch processing once the Sales guy submits his request over portal.

Once you receive the request from portal Via RFC call submit the program from with in the that FM.

2. how to extract the data from ECC as XML once the batch processing is done.

once extraction is done data should be avalable in some temp tables and another request should be made from portal to get view the data from portal.

if processing won't take much time then you can achive this in single step as Sync call.

if you are talking about receiving reauest from normal website and sending data in XML fomat we have "CALL transformation..." for converting internal table to XML.

Regds,

Re: Extracting data from ECC in XML

Former Member — Mon, 02 Aug 2010 15:44:48 GMT

Hi Suresh,

Thanks for giving me some idea on this.

Actually we are developing Offline interactive form in Adobe Life cycle enterprise suite(LCES), so it can take only XML data. So we need to create an xml with the data extracted from R/3 and place it on LCES server. Once the XML is ready, LCES will generate Offline interactive form and send it to requested user.

Only the initial request for extracting the data from R/3 will be from Portal. So if you can give me some idea, it will be greate.

Process:

Request from Portal for Offline form~~-> Queues the request for Batch Process~~-> Run Batch process~~> Extract data from R/3 as XML~~-> Place it in LCES Server for generation of Offline interactive form.

Thanks

Ravi

Re: Extracting data from ECC in XML

Former Member — Tue, 03 Aug 2010 04:12:10 GMT

How you are getting request from portal and to which system request being made?

I did not worked on Adobe forms.

but my guess is there is web UI tool associated with your LCES server and from there you are sending request to R3 and offline form should generated in xml.

post the same question in Adobe forms forum to get better answers.

Regds,