topic Re: display fields in Application Development and Automation Discussions

display fields

Former Member — Wed, 03 Oct 2007 07:01:19 GMT

hi all

i need to display all the field from a table with search help.

User can enter a table name in the input box1. Input box2 will display all the table fields using search help? What must i do ?

Re: display fields

Former Member — Wed, 03 Oct 2007 07:10:20 GMT

Hi Gary,

Use the FM DB_GET_TABLE_FIELDS for this purpose.

Pass the table name in TABNAME parameter and it will return a table (thru the TABLES parameter) which u can capture in an internal table with structure DBFIELD.

Hope i am clear.

Reward points if helpful.

Regards,

Harini.S

Re: display fields

abdulazeez12 — Wed, 03 Oct 2007 07:14:38 GMT

You can create box1 as

PARAMETERS: box1 type RSRD1-TBMA_VAL.

And box2 as:

PARAMETERS: box2(20) type c.

In INITIALIZATIOn event, fetch all the table fields using the function module CACS_GET_TABLE_FIELDS, and save this in a internal table and then use F4 related function module to attach the search help to box2 field.

Hope this helps..

Reward if useful..

Cheers

Shakir

Re: display fields

hymavathi_oruganti — Wed, 03 Oct 2007 07:15:45 GMT

at input box2 write a function modue.

at selection screen on value-request for input2.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

DDIC_STRUCTURE = input1

RETFIELD = '
PVALKEY = ' '

DYNPPROG = sy-repid

DYNPNR = '1000'

DYNPROFIELD = 'INPUT1'

STEPL = 0
WINDOW_TITLE =
VALUE = ' '

VALUE_ORG = 'S'

MULTIPLE_CHOICE = ' '
DISPLAY = ' '
CALLBACK_PROGRAM = ' '
CALLBACK_FORM = ' '

TABLES

VALUE_TAB = <b>itab</b>

FIELD_TAB =
RETURN_TAB =
DYNPFLD_MAPPING =
EXCEPTIONS
PARAMETER_ERROR = 1
NO_VALUES_FOUND = 2
OTHERS = 3

Re: display fields

varma_narayana — Wed, 03 Oct 2007 07:24:43 GMT

Hi..

1) Call the FM DDIF_FIELDINFO_GET

to get the List of Fields for a DB table and returned to an ITAB.

2) Call the FM

POPUP_WITH_TABLE_DISPLAY

to display this Internal table ITAB in a Pop up.

You can also call the FM

F4IF_INT_TABLE_VALUE_REQUEST

<b>REWARD IF HELPFUL.</b>

Re: display fields

Former Member — Wed, 03 Oct 2007 07:41:34 GMT

let say my studenttable gt studentname, adminno, contactno.

how to define the structure for the DBFIELDS . How to create the internal table for this?

CALL FUNCTION 'DB_GET_TABLE_FIELDS'

EXPORTING

FIELD_INFO = 'A'

TABNAME = studenttable

IMPORTING
SUBRC =

TABLES

DBFIELDS =

Re: display fields

Former Member — Wed, 03 Oct 2007 07:44:23 GMT

do u have the fulll sample coding for this as i new to abap?

Re: display fields

Former Member — Wed, 03 Oct 2007 07:53:20 GMT

hi do u hav the full coding for this?