Change text of 0calmonth in BEx

[Former Member]

Hi Gurus,

Can we change the description of 0calmonth text table, i know there is no such text table. there should be some place where SAP maintains the data for 0calmonth.

Eg: say we have 012007 --Jan 2007, Can we change jan 2007 to say period 1.

so that in the BEx while restricting it should show up as Period 1 and not as Jan 2007.

There is no need to text variable.

Thanks in advance

Amit

[Former Member · Accepted solution]

Are you referring to text variable, where the period shows as text? If so, you can change the text variable to read only KEY instead of Name(text)

[Former Member · Accepted solution]

No its not a text variable... an Object is created with the reference of 0calmonth.

Can we just change the short or long text of the object which is referecing to 0calmonth...

Note: its not the object's description its the text table description.

Thanks!!

amIT

[Former Member · Accepted solution]

Month is different from period. Still I dont see how changing the text of the values of calmonth is gonna help you. Even though you do it, how would you automate the process of changing texts going forward.

Can we just change the short or long text of the object which is referecing to 0calmonth

You can change 0calmonth but not the referenced object

[Former Member · Accepted solution]

I completely agree with you that period is different from month.

Even if i want to change 0calmonth. can someone tell me how can i change in BW.

Thanks!!

[Former Member · Accepted solution]

I'm not sure if changing calmonth will help, and moreover you need to pay attention that changing this IO may effect all other providers using the same. Anyway

CALMONTH - change - masterdat/texts tab - check texts - save and activate. maintain masterdata - select ur record - edit .. enter the text.

[Former Member · Accepted solution]

Amit,

I don't want you touch 0CALMONTH Text Tables or T009* tables. If you change test in any of the Tables, other application will get effected.

I want you to Create New IO for Calender Month. replace your 0CALMONTH with New one(Z*). Populate text for new IO in the Text table(manually create or programatically. you could see in IO--> Master Data Tab -->Text Table). Display your Query with Text.

or.

I guess, create a new fiscal year variant and Fiscal periods as well(12 periods, Put Text Jan 2007 as Period 1. replace your 0CALMONTH with 0FISCMONTH. In the UR, put constant value for Fiscal Year Variant(put newly created variant).

If you change Text table directly.. it will effect other Queries.

Nagesh Ganisetti.

• assign points if it helps.

[Former Member · Accepted solution]

I completely agree with you guys we should not touch 0calmonth... This is what i call a bad design which i could see here...and i was exploring the possiblites of changing the things with minor changes not affecting other queries and all...

Thanks you all guys..

Regards

Amit

[Former Member · Accepted solution]

You have one more option... You can Change Long Description of 0CALMONTH. Display Your Queries with Long text.

Other application with "Short description".

You could see these in Text table for 0CALMONTH.

Nagesh Ganisetti.

[edwin_harpino]

hi Amit,

the table is T00... something i think, have no access to system now,

but that's not good idea to change the description in that table,

will misleading all other reporting,

perhaps you can change with vba excel-macro, search forum for how to vba excel macro.

hope this helps.

[Former Member]

I suppose T00* is for fiscal variable or fiscal period.

I know its a bad idea to change it.

Also this calmonth is referencing to one object which actually i need show this change.

Anyways thanks for ur answer

Pls suggest solution.