Need to get the texts of fields

Hii,

I have a req in which I need to populate the values from a table and pass it to the front end.

But I need to provide the text of the fields in the internal table also so as to decrease the processing speed in UI.

Scenario is like tis.

SELECT *

FROM zcostcntr_st

INTO TABLE it_costcntr

FOR ALL ENTRIES IN pr_frg_rl_tab

WHERE frg_guid = pr_frg_rl_tab-fragment_guid.

CALL FUNCTION '/CRYSTAL/GET_OSQL_TABLE_INFO'

EXPORTING

tablename = 'ZCOSTCNTR_ST'

TABLES

table_fields = it_field_text

it_costcntr internal table has the values and it_field_text contains the field label of teh fields in the table Zcostcntr_st .

I need to consolidate both these tables into a structure cost_cntr_tab which willl have the structure :

A | A_text | B | B_text | C | C_text

I.e. In column A the values of field A will come and in A_text the field label of field A will come.

suppose field A is carrid then carrid = AA

carrid_text = Carrier ID

Please advice how to achieve this.

Neeraj

Edited by: Neeraj M on Nov 18, 2008 3:19 PM