topic Re: field display as parameter in Application Development and Automation Discussions

field display as parameter

Former Member — Mon, 16 Oct 2006 11:11:02 GMT

hi all,

While displaying field contents of my Z table in SE11, (i.e. in the selection-screen of se11) all the fields of the table are shown as select-option fields i.e. every field is displayed with low and high textboxes. I want all the fields to be displayed as paramters. Is this possible?

Plz let me know

Thanks in advance

Vinny

Re: field display as parameter

Former Member — Mon, 16 Oct 2006 11:37:20 GMT

Yes this is possible

Please check the following Code and see if it is useful for you

DATA: i_fields LIKE TABLE OF sval.

DATA: i_dd03l TYPE STANDARD TABLE OF dd03l.

DATA: wa_dd03l TYPE dd03l,

wa_fields TYPE sval.

PARAMETERS : p_table TYPE tabname.

AT SELECTION-SCREEN.

SELECT * FROM dd03l

INTO TABLE i_dd03l

WHERE tabname = p_table.

LOOP AT i_dd03l INTO wa_dd03l.

IF wa_dd03l-fieldname NE '.INCLUDE'.

wa_fields-tabname = wa_dd03l-tabname.

wa_fields-fieldname = wa_dd03l-fieldname.

APPEND wa_fields TO i_fields.

CLEAR wa_fields.

ENDIF.

ENDLOOP.

CALL FUNCTION 'POPUP_GET_VALUES_DB_CHECKED'

EXPORTING

popup_title = 'Choose Fields'

TABLES

fields = i_fields

EXCEPTIONS

error_in_fields = 1

OTHERS = 2.

The table i_fields will contain the values which you have entered in the popup

Re: field display as parameter

Former Member — Mon, 16 Oct 2006 11:46:36 GMT

hi Dominic,

Thanks for the response.

plz let me kknow, where im supposed to add this code? in the standard program behind the Z table? plz clarify.

Thanks,

Vinny

Re: field display as parameter

Former Member — Mon, 16 Oct 2006 12:04:04 GMT

Hi Vinny

It is not possbible to change the code in SE11.

Why dont you use the code that i have given you and use a report to update the Z table.

Or you could use the Table Maintenance Generator to update your Ztable

Re: field display as parameter

Former Member — Tue, 17 Oct 2006 10:11:41 GMT

Hi,

If you just want a Report to dispaly the contents of the field in ALV or LISt format with selection screen containing only Parameters, You can try using SAP Queries .

( <b>SQ01</b> )

Where u get more options for reporting.

Regards,