03-20-2009 5:15 AM
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.
03-20-2009 5:19 AM
Join CSKS, CSKT tables based on controlling area and cost center.
03-20-2009 5:20 AM
Hi,
No, You cant fetch cost center text from CSKS table, you have to fetch from CSKT table.
Thanks
Brunda
03-20-2009 5:26 AM
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.
03-20-2009 5:27 AM
Table : CEPCT.
Note: Plz close the thread once your issue is resolved.
03-20-2009 5:28 AM
03-20-2009 5:36 AM
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.
03-20-2009 6:02 AM
03-20-2009 6:07 AM
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
03-20-2009 6:13 AM
Hi,
Yes, Use 'for all entries' to fetch KTEXT field data from table CSKT & CSKS.
Regards
Md.MahaboobKhan.