Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to read the TEXT/DESCRIPTION

Former Member
0 Kudos

Hi Experts,

I am new to ABAP. I recently got job. I have a small question for you.

I have created a database table with following fields.

CTRC05 "Legacy Cost Center

CTRC06 "Legacy Account

PRCTR "SAP Profit center

PRCTR_TEXT "SAP Profit Center text

KOSTL "SAP Cost Center

KTEXT "SAP Cost center text

And for this DB Table I have written my select statement as below to retrieve the SAP Data if I provide legacy data.

SELECT ctrc05 "Infinium Cost Center

ctrc06 "Infinium Account

prctr "SAP Profit Center

prctr_text "SAP Profit Center Text

kostl "SAP Cost Center

ktext "SAP Cost Center Text

FROM ztt_rga_xreft INTO TABLE gt_outtab

WHERE ctrc05 IN s_lcctr.

Everything works good. But I am not able to retrieve the profit and cost center text in my output.

Can anyone suggest what is wrong with my select statement.

Thanks.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

If this field PRCTR_TEXT "SAP Profit Center text

comes from a text table then your System login Language and the Text table should match otherwise the value will not be outputted.

Also check the screen field type is that of the DB table type.

Regards,

Linda.

Edited by: Linda on Sep 9, 2008 8:30 AM

9 REPLIES 9

Former Member
0 Kudos

Hi,

Congrats for your new job.

Check the attachment between your text field and the corresponding text table .

For detail concept in text table , check http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea9e446011d189700000e8322d00/content.htm

0 Kudos

Hi,

I have checked the text field and text table. Every thing is good. But still it is not working.

0 Kudos

use keyword 'corresponding fields of table' in front of ur internal table... and check ur structure of internal table "gt_outtab" with "ztt_rga_xreft".

former_member181995
Active Contributor
0 Kudos

>

> I am new to ABAP. I recently got job. I have a small question for you.

Congrats

Ps:Do not add these QUOTES in threads.As i can see you added this in some few your threads.

0 Kudos

Sorry. Next time I will not repeat.

Thanks for letting me know abt that.

Former Member
0 Kudos

Hi,

If this field PRCTR_TEXT "SAP Profit Center text

comes from a text table then your System login Language and the Text table should match otherwise the value will not be outputted.

Also check the screen field type is that of the DB table type.

Regards,

Linda.

Edited by: Linda on Sep 9, 2008 8:30 AM

Former Member
0 Kudos

Hi,

Modify the select statement like below and check the output.

SELECT ctrc05 "Infinium Cost Center

ctrc06 "Infinium Account

prctr "SAP Profit Center

prctr_text "SAP Profit Center Text

kostl "SAP Cost Center

ktext "SAP Cost Center Text

FROM ztt_rga_xreft

INTO corresponding fields of TABLE gt_outtab

WHERE ctrc05 IN s_lcctr.

if still you have problem specify the structure of internal table

gt_outtab.

Thanks,

Naveen Kumar.

Former Member
0 Kudos

HI,

Congrats

first of all dont mention that ur new or like that in thread.

ok now tell me have u maintained data for text fields in ur z table?

bcoz ur query seems right.

let me know

Former Member
0 Kudos

hi again

if u have maintained data check the domain / data elements u assigned for source & target tables.

it must be same lenth.