topic Re: Cost center Description in Application Development and Automation Discussions

Cost center Description

Former Member — Fri, 20 Mar 2009 05:15:40 GMT

Hi,

I need to fetch cost center decription against cost center number. In SE16, When I am looking at the records in table CSKS ( cost center master data) , there is field KTEXT which stores the description. But when i m writing select query in my report for fetching this field , an error is displayed 'Field does not exist in table'.

In SE11 when I am looking the table structure, there is no filed with name KTEXT, but in SE16 when i looking at a particular record , this field is shown with proper value.

I know cost center texts are stored in table CSKT table but i want to know wheather i can fetch cost center description from table CSKS .

Kindly suggest.

Re: Cost center Description

GauthamV — Fri, 20 Mar 2009 05:19:17 GMT

Join CSKS, CSKT tables based on controlling area and cost center.

Re: Cost center Description

Former Member — Fri, 20 Mar 2009 05:20:08 GMT

Hi,

No, You cant fetch cost center text from CSKS table, you have to fetch from CSKT table.

Thanks

Brunda

Re: Cost center Description

Former Member — Fri, 20 Mar 2009 05:26:08 GMT

Hi,

Sorry for the wrong information earlier. The above query which i have asked, is actually for Profit center and the table is CEPC. However the field is same, KTEXT.

Re: Cost center Description

GauthamV — Fri, 20 Mar 2009 05:27:51 GMT

Table : CEPCT.

Note: Plz close the thread once your issue is resolved.

Re: Cost center Description

Former Member — Fri, 20 Mar 2009 05:28:01 GMT

Hello

Try table CEPCT

Re: Cost center Description

Former Member — Fri, 20 Mar 2009 05:36:31 GMT

hi all ,

I know that profit center and cost center description are stored in CSKS and CEPCT table.

What i want to know is about the rational behaiviour, in SE11 and SE16. Field KTEXT is not displayed in SE11 in table structure in table CEPC, but in se16 when I double click on particular record, then i can see this field there with proper values.

Re: Cost center Description

Former Member — Fri, 20 Mar 2009 06:02:45 GMT

Hello

Refer:

Re: Cost center Description

Former Member — Fri, 20 Mar 2009 06:07:44 GMT

Generally ,

tables ending with 'T' stores athe descriptions like makt stores material sdescription.

but these are vailable while using mara table.

so here u need to use CSKT table only even though u get description in csks.

reg

Ramya

Re: Cost center Description

Former Member — Fri, 20 Mar 2009 06:13:31 GMT

Hi,

Yes, Use 'for all entries' to fetch KTEXT field data from table CSKT & CSKS.

Regards

Md.MahaboobKhan.