ERROR: InfoObject 0CURTYPE is used in both structures of the query

[Former Member]

Hi I am getting above error, even after adding only one infoobject (0CURTYPE) one time  in Column structure. .

File attached .

I have checked the query in RSRTQ , but 0CURTYPE is only showing in Column structure only. Could you please help me, why this error is coming.

Regards,

Seema

[RamanKorrapati · Accepted solution]

Hi,

please remove and re add the rows objects which you added.

Seems like 0curtype may be used in rows as well.

please check each info object or formulas which you used in rows and find 0curtype where its been used in rows.

using RSRT try to debug your query you may find.

Thanks

[Former Member · Accepted solution]

Hi Seema Singh,

Is there any nested RKF, CKF?

You can check that in RSRTQ carefully.

Regards,

Sucheta

[Former Member · Accepted solution]

Hi Ramanuj and Amit, I have checked thoroughly all objects in rows, 0CURTYPE is not available anywhere.

Hi Sucheta, how should I check RKF and CKF in RSRTQ. please explain.

Regards,

Seema

[RamanKorrapati · Accepted solution]

can you try to debug your query from RSRT

[Former Member · Accepted solution]

Hi,

In RSRTQ focus on FIlter, Row/Columns, Cells, Table View. In Formula check RKFs CKFs.

Hope this will help you.

Regards,

Sucheta

[KodandaPani_KV · Accepted solution]

Hi,

in RSRTQ will show overall query view but you need to the check the structure formulas

check the 0CURTYPE used multiple times either columna and rows panel.

[Former Member]

I have thoroughly checked the query in RSRTQ, expanding all the characteristics. And I found 0CURTYPE in some rows (sorry to bother all of you). But there is still some issue:

I am not able to see 0CURTYPE in bex analyser for the same rows. how should I remove the 0CURTYPE from the query if I am not able to view .

Regards,

[Former Member]

Hi All,

Now I found one strange issue :

now I am able to add two 0CURRTYPE in column structure(which is the requirement - I have to show the value in 0CURRTPE = 00 and 0CUTTYPE = 20 in column). But when I add value 00 or 20 through filter into any one of them, it shows me the above error - InfoObject 0CURRTPE is used in both structures of the query ).

Could you please explain me why this is showing so.

[Former Member]

one more thing, when I don't add any value to any of the 0CURTYPE, it doesnot show the error. it only shows error when I add any value.

Regards,

[RamanKorrapati]

in columns if you used 0curtype for all values then it won't allow to restrict at filters.

if your keeping 0curtype in filters and values as 00/20 then why your keeping 0curtype in columns?

columns will hold only key figures.

if we use any filters then based on filter values out report will be displayed. so in such cases 0curtype in columns will won't work if you restricted.

[Former Member]

HI,

1.I am not keeping 0CURTYPE in filter.

2. my requirement is to show cost in two currency type [INR (Actual) and USD (Actual@PR) ] in cloumns.

(shown below) :

[Former Member]

Hi,

Check ROWS. Is 0CURTYPE is used in any of these selections?

Regards,

Sucheta

[Former Member]

Hi Sucheta, I have already checked it 0CURTYPE is NOT there in row.

HI All , any help ?

Regards,

Seema

[Former Member]

Go to SE38 and execute below report to check the query inconsistencies.

ANALYZE_RSZ_TABLES

[former_member199945]

Hi,

Pls select  where used list tab where error coming  in query,there   itself  you can easily identify .

Thanks.

[KodandaPani_KV]

Hi,

please check the each and every formula selection in rows panel

you are using the some where in the 0CURTYPE object

check the rows and column panel of structure.

KF nothing but column structure.

check the column structure.

Thanks,

Phani.

[Former Member]

Hi All ,

I have open the query in RSRTQ and expanded all the options. then searched 0CURTYPE through CTRL+F , found 0CURTYPE only in column side, no where else in rows. and as formulaes are concerned, only the simple algebraic functions has been used . (FYI, I have also manually checked all the rows and columns).

and when I try to debug, it takes me to the error message analysis and not where the actual error is occurring. Could you please tell me what options should I choose in 'Debug Options' while debugging the query.

Please help .

Regards,

Seema

[Former Member]

Hi,

Do you have 0CURTYPE in anywhere in the query folter?

Regards,

Sucheta

[Former Member]

Hi,

If I am right then please check the infoobject 0curtype is

available in the rows and columns as well. Please check whether this is

case.

If you find the elements then you should remove one of these.

It will resolve this issue.

Regards,

Amit