InfoObject 0CO_ITEM_TX

[Former Member]

hi all,

Encountered and error when executing report on co line item "InfoObject 0CO_ITEM_TX must not be used in the drilldown"

Why we cant use it in the query ?

Thanks

[Former Member]

Hi,

0CO_ITEM_TX is not only 'attribute only' but also it has neither master data nor texts. Because of the latter, no SIDs has been created. IMHO, hence no BEx drilldown is available. You can use it as attribute only.

Best regards,

Eugene

[Former Member]

Hi.

Thanks to all your advise.

Somehow now the error is gone but when i execute the report, it only shows "#" sign. No actual text shows in the report. But when i checked the query content , i can see the text for each document.

Whats still i missed out?

[edwin_harpino]

hi,

if possible try to change 0CO_ITEM_TX to have master data in infoobject maintenance

and try to reupload the master data where 0CO_ITEM_TX been attribute for, change update for 0CO_ITEM_TX to make it upper case/capital with routine :

result = tran_structure-0CO_ITEM_TX.

translate result to upper case.

[Former Member]

hi AHP,

So sorry. Should i create a routine in the infoobject using this code "result = tran_structure-0CO_ITEM_TX.

translate result to upper case."?

Or is it more than that.

[edwin_harpino]

hi,

what's the infoobject has this attribute ?

in that infoobject transfer rule, create the routine for 0CO_ITEM_TX mapping

[Former Member]

hi,

I've set this infoobject set off the attribute only in the misc section of the masterdata.

Can u give me the complete routine for the mapping ? sorry , i'm not a pure programmer.

Thanks

[Former Member]

Hi,

Manage to solve it.

Basically these what i did :

1. Change 0CO_ITEM_TX. Take attribute only and select lowecase letter. No routine needed since .

2. Re-load the data again in the ODS.

Thanks everybody.

[edwin_harpino]

hi,

so you just change back to the original ? no drill down capability in reporting ?

[edwin_harpino]

hi,

infoobject 0CO_ITEM_TX come from SAP 0CO_ITEM_TX with 'attribute only', cannot be used for drill down (navigation), if you need it for drill down/navigation, you have to change it, go to infoobject maintenance (transaction rsd1) and remove the check mark for 'attribute only' in general tab bar - miscellanous. you may also need to translate the data to uppercase.

[Former Member]

hi AHP,

I've changed accordingly but the error still persist.

Actually i want to see the text of the co document in the reprt. Am i missing something .

Thanks

[Former Member]

Hi,

Have log out of BEx and login again?

Best regards,

Eugene

[Former Member]

hi,

Yes gotten log out and login again but still the same.

[edwin_harpino]

hi,

you have to make 0CO_ITEM_TX as navigational attribute first in your infoprovider (0coom_c02 ? 0cca_c11?).

[former_member188975]

Hi Azmin,

Is this a standard query (if yes, then which one) or a custom created one? Are you using 0CO_ITEM_TX anywhere in the query definition?

[Former Member]

hi Gupta,

Its a standard infoobject belong to infosource

0CO_OM_CCA_9 .I create my own query from the std infosource 0CO_OM_CCA_9.

"

Are you using 0CO_ITEM_TX anywhere in the query definition? " --> not sure what you mean by this.

Thanks