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

How to read data from ODS?

<b>Hi Guys,</b>

I am new to APO and I have a requirement where i need to read the data from ODS in APO. Can you tell me is there any FM which reads the data from ODS or else in what ways i can do it.

Thanks in Advance!...

<b>

Regards,

Ramkumar.K</b>

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 01:50 AM

    Hi Ramkumar,

    It would be best if you can elaborate exactly why you need to read data from the ODS. For example, are you trying to load data from the ODS to an InfoCube in APO? or are you trying to read an ODS and store the data in a planning area? We would be able to help you find the best solution if we know what you are trying to build.

    Here are some ways to read data from an ODS:

    1) Read the active table of the ODS. The naming convention is:

    If the ODS is from SAP, the technical name of the active table is /BI0/A<name of ODS>00.

    If the ODS is built by the customer, the technical name of the active table is /BIC/A<name of ODS>00.

    For example, if you have an ODS with the name ZMYODS then the table to read is /BIC/AZMYODS00.

    2) Use function module RSDRI_INFOPROV_READ. This is an FM that was released by SAP for customer use. It can be used to read data from any infoprovider (e.g. InfoCube, ODS, Multi-provider, Remote Cube, InfoSet etc).

    3) If you are mainly loading data from the ODS to a data target (e.g. Infocube or another ODS), please use the standard functionalities in BW (e.g. InfoPackages, Transformation rules etc).

    Hope this helps 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 08:33 AM

    Hi Ramkumar,

    You can use the function module 'RSAN_ODS_DATA_READ' for reading the ODS data.

    Regards,

    Siva.

    Add a comment
    10|10000 characters needed characters exceeded

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.