EKKN does not bring the cost center text in a query?

[Former Member]

I want to use the table EKKN to create a query where I can see the cost center value and the text.  I created the infoset and I can see the icon "T" next to the field EKKN-KOSTL.  I created the query in SQ01 and selected the two fields value and text, but when I run the query, the cost center value is shown but the text is empty.  Does somebody know how can I get the text field?  In the infoset I can see that the text field is linked to table CSKT-LTEXT.

Thanks if somebody can help me.

Yoma.

[Former Member]

Dev, The idea with the query is to avoid use a join table because SAP already created the link between the value and the text.

Also when I run  the query using the order and WBS the system works perfectly, but for cost center it does not work.

[former_member183424]

I guess you need the cost center description and value..

Why don't you use SQVI for the query for table join EKKN and CSKT.

I can see the description and value.

[Prasoon]

Hi,

   I think its the behavior with some tables like EKKN.

   Please refer the note: 1918331 - SAP query: text fields are blank in the query result

Regards,

AKPT

[Former Member]

Hi AKPT,

Thank you for your answer.  Previously, I have checked the note 1918331 that you suggested.  In the example on this SAPnote the table MARD-LGORT  had been assigned to the wrong text field.  In my case when I run the report RS_TEST_IDENTIFY_TEXT I get the right information:

The table CSKT-LTEXT include the description of the cost center.

The question in this case is if the field "Type how text determined" = READABLE_W_RECORD  has a special treatment.

Do you know?

Thank you,

[Prasoon]

Hi,

   Did you run the program mentioned in the note for test determination...

   Also, maintain the table entries as mentioned in the note and try again...

Regards,

AKPT