topic Re: Function Module Name Required in Application Development and Automation Discussions

Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:03:54 GMT

Hi all,

Can anyone please tell me the name of a Function Module to get the fields of a table .

Kindly reply as fast as possible.

Regards,

Vijay

Re: Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:06:10 GMT

HI,

Here is the function module

DB_GET_TABLE_FIELDS

Regards

Sudheer

Re: Function Module Name Required

seshatalpasai_madala — Fri, 07 Sep 2007 12:08:05 GMT

Hi,

You can use

DATA: struc_ref type ref to CL_ABAP_STRUCTDESCR.

DATA: lt_comp TYPE cl_abap_structdescr=>component_table.

struc_ref = CL_ABAP_TYPEDESCR=>describe_by_name ( 'TABLE_NAME' ).

lt_comp = struct_ref->get_components().

Regards,

Sesh

Re: Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:08:13 GMT

Hi Bala,

you can also chk this

Sometimes you may have only a table name and want to retrieve the name of each field of the corresponding table. For example, when you want to use ASSIGN COMPONENT fieldname OF TABLE table.

An ABAPer's first reaction is to read the standard ABAP basis tables DD02L, DD03L, etc

This way of reading fields is very slow. Use methods from the class CL_ABAP_TYPEDESCR instead.

Example:

data: descr_struc_ref TYPE REF TO cl_abap_structdescr.

descr_struc_ref ?= cl_abap_typedescr=>describe_by_name('SFLIGHT' ).

Here is the result of descr_struct_ref after the execution of this piece of code

ABSOLUTE_NAME C 200 \TYPE=SFLIGHT

TYPE_KIND C 1 u

LENGTH I 4 80

DECIMALS I 4 0

KIND C 1 S

STRUCT_KIND C 1 F

COMPONENTS h 8 Table[14x40]

HAS_INCLUDE C 1

The table COMPONENTS is filled with :

LENGTH DECIMALS TYPE_KIND NAME

3 | 0 |C |MANDT

3 | 0 |C |CARRID

4 | 0 |N |CONNID

8 | 0 |D |FLDATE

etc.

Re: Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:08:15 GMT

Hi Vijay,

Use the function module

AMDP_TABLE_CONTROL_GET_FIELDS

tabname = table name

vorgid = X

Regards,

Ravi G

Re: Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:12:32 GMT

Hi,

You can use NAMETAB_GET to get the fields of table with there datelements and length also.

CALL FUNCTION 'NAMETAB_GET'

EXPORTING

langu = sy-langu

only = ' '

tabname = 'MARA'

IMPORTING
HEADER =
RC =

TABLES

nametab = gt_table

EXCEPTIONS

internal_error = 1

table_has_no_fields = 2

table_not_activ = 3

no_texts_found = 4

OTHERS = 5.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Thanks,

Sriram Ponna.

Message was edited by:

Sriram Ponna

Re: Function Module Name Required

former_member480923 — Fri, 07 Sep 2007 12:13:40 GMT

check out : F4_DD_TABLE_FIELDS

Anirban M.

Re: Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:13:49 GMT

Hi ,

Try FM <b>F4_DD_TABLE_FIELDS</b>

Message was edited by:

Alvaro Tejada Galindo

Re: Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:14:52 GMT

Hi,

Use the function module

DDIF_FIELDINFO_GET

Re: Function Module Name Required

Former Member — Fri, 07 Sep 2007 12:19:06 GMT

Hi all,

Thanks a lot for all your replies . Could you please tell me whether these Function Modules also pick up the Custom fields that have been added to the Table.

Kindly reply as fast as possible.

Regards,

Vijay

Re: Function Module Name Required

Manohar2u — Fri, 07 Sep 2007 12:21:24 GMT

Yup....they will show you all fields even from include CI_INCLUDES....