topic read data element given field name in Application Development and Automation Discussions

read data element given field name

Former Member — Tue, 18 Dec 2007 06:10:52 GMT

Hello All,

I have a DB table and field name, with this information how can i find the data element for this perticular field.

is tehre any Funtion Modules exists for teh same.

Thanks in advance

Amarender Reddy B

Re: read data element given field name

former_member195698 — Tue, 18 Dec 2007 06:13:33 GMT

Check the table DD03L

Re: read data element given field name

Former Member — Tue, 18 Dec 2007 06:14:48 GMT

Hi,

Open table using se11 and check the field type of the field name.

Field type is nothing but the data element. You can doubleclick and check it.

Re: read data element given field name

former_member188827 — Tue, 18 Dec 2007 06:15:14 GMT

go to se11.give table name and click on display.

click on find and give field name.u'll find assocciated data element against da field in data element column

Re: read data element given field name

Former Member — Tue, 18 Dec 2007 06:16:29 GMT

Dataelement : Symantic attributes are called data element and An intermediate object between domain and table type ..U can see in SE11 itself.

Check this function module:

RP_PRINT_GET_DATA_ELEMENT

Regards,

Maha

Re: read data element given field name

former_member404244 — Tue, 18 Dec 2007 06:18:57 GMT

Hi,

GOTO SE11->give ur table name and display...now check ur field in the table,u can find the data element..

Regards,

Nagaraj

Re: read data element given field name

Former Member — Tue, 18 Dec 2007 06:20:20 GMT

Hi all,

thanks for your answers.....

I dint mean going manually to SE11 and check, i need this info in my program.

i have to get the data element provided the table name and field name inside my program.

Re: read data element given field name

Former Member — Tue, 18 Dec 2007 06:21:09 GMT

I dont think there is such FM to display the data element directly

But u can get those details from this table DD04D

use your regular query and try extract the data

Regards

Pavan

Re: read data element given field name

Former Member — Tue, 18 Dec 2007 06:39:26 GMT

Hi Amar,

You can get the data element for a field in a database table using DD03L table.

Check this code.

DATA V_ROLLNAME TYPE DD03L-ROLLNAME.

SELECT ROLLNAME

FROM DDO3L

INTO V_ROLLNAME

WHERE TABNAME = 'MARA' -->Provide table name

AND FIELDNAME = 'PSTAT'. -->Provide field name

WRITE:/ 'Data element is: ', V_ROLLNAME.

Otherwise, use function module KL_TABLE_INFO_GET to get the data element for a field of a database table. Provide table name to I_TABNAME and field name to I_FIELDNAME and you will get the data elemet in the export parameter E_TABFIELD_W-ROLLNAME.

Thanks,

Vinay