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

Read the oldest data from the infocube

Hi Experts,

Assume that my cube (say cube name AAAA) has the following characteristics and keyfigures:

Product, Customer, Calendar_month and sold_quantity.

Now i need to read the first month when this product is sold.

For Example, my cube has following data:

Product_A Cust_1 201103 40

Product_A Cust_1 201103 15

Product_A Cust_2 201103 60

Product_A Cust_8 201104 50

Product_A Cust_5 201108 20

Product_A Cust_7 201109 40

Product_A Cust_1 201110 35

Now the output should be

Product_A 201103.

I am using the function module RSDRI_INFOPROV_READ. But the problem is, this function module reads all the data. I could do the ABAP code, it is not a problem. But i don't want to read all the data. I just want to read the first data record from the cube. Is it possible? Do we have some other function module or any other way to read this information?

Thanks and Best Regards,

Suresh

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2011 at 02:28 PM

    Hi,

    I don't think there is any readily available FM which will identify first record for some specific combination. You might be able to get this information directly from table only when you are maintaining such information in table for specific combination by using some record identifier.

    Otherwise I think the approach you are following is fine, you will have to read all the data and then do sorting and then move required data to some other provider for furhter processing.

    Regards,

    Durgesh.

    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.