read data element given field name

[Former Member]

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

[former_member195698]

Check the table DD03L

[Former Member]

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.

[former_member188827]

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

[Former Member]

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

[former_member404244]

Hi,

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

Regards,

Nagaraj

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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