Columns in F4 help

[Former Member]

Hi All,

I have a standard report where I have some selections fields.

like pernr.

if I press F4 in that selection field and press enter or continue.

It shows all employee pernr available in the system.

But along with that it show first name , last name and birth date...etc

How to restrict the field birth date from that list.

Pls suggest,

Points will be rewarded.

Thanks.

[former_member186734]

you can use a non-standard F4 help

add to your report the follow event:

at selection-screen on value-request for <b>p_pernr.</b>

  call function 'F4IF_INT_TABLE_VALUE_REQUEST'
    exporting
      retfield        = 'P_PERNR'
      dynpprog        = sy-cprog
      dynpnr          = sy-dynnr
      value_org       = 'S'
      multiple_choice = space
    tables
      value_tab       = it_data
      return_tab      = it_ret
    exceptions
      parameter_error = 1
      no_values_found = 2
      others          = 3.
  if sy-subrc <> 0.
    message id sy-msgid type sy-msgty number sy-msgno
            with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  endif.

the it_data should have the layout you want to appear in F4 window and it_ret should have structure DFIES, witch returns the data selected.

[Former Member]

Press F4, get the column screen then select that column & click context menu, click on personlise, in the "Field Selection Hit List" drag the unwanted field into right column. You will get your desired output

Thanx!!

[Former Member]

Yes that I know.

But I want to restrict the same.

So no one can bring those column back from personalize.

Thanks