Cost center Description

[Former Member]

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.

[GauthamV]

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

[Former Member]

Hi,

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

Thanks

Brunda

[Former Member]

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.

[GauthamV]

Table : CEPCT.

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

[Former Member]

Hello

Try table CEPCT

[Former Member]

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.

[Former Member]

Hello

Refer:

[Former Member]

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

[Former Member]

Hi,

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

Regards

Md.MahaboobKhan.