cancel
Showing results for 
Search instead for 
Did you mean: 

Compund data error for query

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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 ?