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

Method or function module to display all the possible CVC's , not existing ones


Hi ,

One of my requirement is to display the possible CVC's from a cube through a program based on some selection fields. Like the same way we are getting through transaction /SAPAPO/ MC62. After that I need to validate those possible CVC's and need to create CVC's. I know the FM to create a CVC but I don't have idea to display the posssible CVC's from a Cube. Can any help me on this issue ?

Thank you,

sravan.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 22, 2014 at 02:05 PM

    Hi Sravan,

    You can get data from a cube,with mere database 'SELECT' statements. please find the following suggestions,

    All Cube related data, you can find in the tables with the naming convention ' /BIC/F*CUBENAME'. Typical nomenclature of the database table is '/BIC/F' followed by name of the cube. if your cube name is 'ZALMPOS' then the corresponding name of the fact table will be /BIC/FZALMPOS.

    The data is stored in this table with all keys of DIMENSION tables. If you have to map the keys to dimension tables to get the values of the characteristics. Typical, nomenclature of Dimension tables is '/BIC/D*Characteristicname'.

    Note: Check in RSA1 if all your characteristics are mapped as dimensions in your cube.

    Thanks,

    Santosh KB.

    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.