Skip to Content
author's profile photo Former Member
Former Member

How to extract PSA data into an external target?

Is there a mean to transfer PSA data into an external target such as a flat file or using XML?

(BW3.5)

Thanks.

LauQ

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2005 at 09:17 AM

    Hi Laurent,

    you can easily export PSA data by:

    • creating an ABAP pgm by which you can extract what you want (consider that PSA is a transparent table with key: request number, data package e record number) and download it with some FM like MS_EXCEL_OLE_STANDARD_DAT

    • creating a datasource against your PSA, feed an ODS (with the same key of your PSA) and then export its content via open hub service

    • XML can be used only for a limited amount of data per call...you can use a query on your PSA data (after its logical loading in infoprovider) and then use SOAP technology to export in this format

    Hope it helps (and please don't forget to assign some points by clickin'on the yellow star to the contributors that help you !!!)

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      My aim is to keep some PSA data in a safe place and to be able to re-load from that place into BW.

      A straightforward solution is Oracle export of the PSA tables but I wanted to know whether BW (within standard license agreement) can cope with this request.

      Thanks.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.