Skip to Content
0
Former Member
May 19, 2010 at 07:13 AM

data extraction using Function Midule

34 Views

Dear Experts,

Previously we had a FM to extract data from an ODS into a csv file.

Now we want to extract data from an infocube using a similar method (to save into a csv file again.)

BEFORE we were extracting from ODS transparent table /BIC/AYPU_O1140.

Now I want to extract from the infocube 0CCA_C11.

So I thought I should use /BIC/F0CCA_C11.

But actually the fields are not there. Only dimensions keys are mentionned.

Example:

I want the value type 0vtype, the infoobject is in one of the dimensions of 0CCA_C11.

But in F0CCA_C11, there is only a field KEY_0CCA_C113...

So my question is : were is the data ?

For vtype (dim13) should it be in /BI0/D0CCA_C113 table

And what about navigational attributes (like 0profit_ctr) or KF (like 0mount)?

How can I extract them? Were is the active data stored?

I'm looking froward to reading your suggestions.

Kind regards,

Alice