09-09-2008 5:49 AM
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.
09-09-2008 7:28 AM
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
09-09-2008 5:53 AM
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
09-09-2008 6:45 AM
Hi,
I have checked the text field and text table. Every thing is good. But still it is not working.
09-12-2008 9:44 AM
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".
09-09-2008 6:02 AM
>
> 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.
09-09-2008 6:07 AM
Sorry. Next time I will not repeat.
Thanks for letting me know abt that.
09-09-2008 7:28 AM
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
09-11-2008 11:19 AM
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.
09-12-2008 12:56 PM
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
09-12-2008 12:59 PM
hi again
if u have maintained data check the domain / data elements u assigned for source & target tables.
it must be same lenth.