topic Re: Hi in Application Development and Automation Discussions

Hi

Former Member — Mon, 30 Apr 2007 13:46:11 GMT

Hi experts,

i have to get a field name from query result.

data:i_field_name type ref_table-field_name.

select single field_name from ref_table into i_field_name.

suppose i_field_name containes "matnr".

i have to write mara-matnr = '001'.

how can i achieve it.

rgds,

bharat.

Re: Hi

alex_m — Mon, 30 Apr 2007 13:47:39 GMT

Pls explain in clear!

Re: Hi

Former Member — Mon, 30 Apr 2007 13:53:12 GMT

Hi,

Try this..

data: itab like standard table of mara.

SELECT field_name from <b>mara into corresponding fields of table itab </b>

WHERE conditions.

Thanks & Regards

Santhosh

Re: Hi

sreeramkumar_madisetty — Mon, 30 Apr 2007 13:54:28 GMT

Have a look on the below query:

data: itab like standard table of mara.

SELECT field_name from mara into corresponding fields of table itab

WHERE conditions

Regards,

Sreeram

Re: Hi

Former Member — Mon, 30 Apr 2007 13:58:39 GMT

Hi,

I understand your query.

Consider this :

DATA mara TYPE mara. " Mara structure.

DATA field TYPE char10.

SELECT SINGLE xxx FROM yyy INTO field WHERE zzz.

Now you want to fill a value in mara-field , right ?

Use this :

FIELD-SYMBOLS : <FS> TYPE ANY.

DATA : fieldname TYPE char20.

CONCATENATE 'mara-' field INTO fieldname.

ASSIGN <fs> TO fieldname. " <fs> now points to mara-field

<fs> = '0001'.

Hope this helps you.

Re: Hi

Former Member — Tue, 01 May 2007 05:30:58 GMT

i think u need to print the frield with respect to table name.. mean sincluding table name u want to prnt it..

if ref_tabname is ur table name then create a field symbol n concate it with the field name then u get ur resulted output.. n this also changes automatically when u change ur table name...

regards,

Re: Hi

Former Member — Tue, 01 May 2007 06:04:14 GMT

Hai,

You can not select field name(s) of a table from that table name.

But you can get them from DD03L table like below.

DATA:

F_NAME(15) TYPE C.

SELECT SINGLE FIELDNAME

FROM DDO3L

INTO ITAB(OR FIELDNAME )

WHERE TABNAME EQ 'REFRENCE_TABLE'.

Then

loop at itab.

"*do your operations here...

endloop.

regds,

Rama chary.

Re: Hi

Former Member — Tue, 01 May 2007 07:16:37 GMT

i have solved it on my own.thanx for the replies.

Re: Hi

Former Member — Tue, 01 May 2007 07:17:34 GMT

i have solved it on my own.thanx for the replies.