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

Compund data error for query

Hi All,

Iss Of Compund data,

Controlling area is a compound object for cost center.

Suppose .......

Controlling are is - ca01

cost center - cc01, cc02

now while we use thes in report variable.

controlling area value given CA01

for cost center value should be CA01/CC01 AND CA01/CC02.

But in Query it's showing me 3 values

CA01/#

CC01

CC02.

Why this data is is available for cost center.

that should be CA01/CC01 AND CA01/CC02.

i checked master data thes combination record is there and coming in cost center data also.

why CA01/CC01 AND CA01/CC02 is not coming ??

Please reply for this issu

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2008 at 05:20 AM

    Jst try Activating master data for Cost Center and Controlling Area. RClick - Activate Master Data

    CA01/# - This is not assigned - no master data record.

    In query did you do any restrictions ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2008 at 09:39 AM

    Hi,

    if you filter your query with 0CO_AREA = CA01, the keys of the costcentre won't be displayed as "CO_AREA/COSTCENTER"; except perhaps the "not assigned" cost centre: CA01/#.

    CA01/CC01 and CA01/CC02 will therefore be displayed as CC01 and CC02 (since the CO_AREA is known and well defined as CA01)

    If you run the same query with no filter on CO_AREA the system will display the double key.

    CA01/CC01 AND CA01/CC02 will be display as is.

    If you have both object in the drilldown, CO_AREA and COSTCENTRE in this order, the system won't display the double key either...

    CA01/CC01 AND CA01/CC02 will be displayed as

    CA01_____CC01

    CA01_____CC02

    hope this helps...

    Olivier.

    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.