Skip to Content
avatar image
Former Member

Columns in F4 help

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 10, 2007 at 09:24 AM

    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!!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yes that I know.

      But I want to restrict the same.

      So no one can bring those column back from personalize.

      Thanks

  • Sep 14, 2007 at 02:56 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded