Convert XML file into ABAP Query

Hi All,

Can we capture a XML file generated from a Non-SAP system in SAP system and convert into ABAP Query to retreive Data from DB and post it back as a XML query to the same Non-SAP system using a Middleware. Can this process be done in cache memory level itself instead of saving in DB.

If it is possible pls do tell the procedure and steps to be followed.

Suggestion and Help will be much Appreciated

Thanks & Regds.

Ramesh