F4 Help for Document Number

[Former Member]

Hi Experts,

I am using document number( BSIK-BELNR ) in my report's selection screen. I couldn't get any F4 Help for that field. Could someone help it out..

Regards,

Swetha

[keyur_pawar]

If you brows BSIK table, then there is no F4 available for BELNR field.

that's why F4 is not reflected on your selection screen.

Regards,

KP

[Former Member]

Hi Mr.Keyur Pawar,

  And i even observed that there is no F4 help for this field in FB03 transaction also. So, how could i get an F4 Help for this field in my report. Is there any function module ?

For eg. we have "FI_F4_ZTERM" for getting F4 help for the Payment Terms..

Regards,

Swetha

[alok_patra]

Hi Swetha,

You need to write code for this :-(. 

Use FM F4IF_INT_TABLE_VALUE_REQUEST to create a customized F4  help.

Thanks,

Alok

[Former Member]

I just wanted to know if there Is any function module for this purpose?

For eg. we have "FI_F4_ZTERM" for getting F4 help for the Payment Terms..

Regards,

Swetha

[alok_patra]

Try FCO_BELNR_READ.

[Ruediger_Plantiko]

Wait a minute ...

Swetha, do you see the F4 help you are missing at any other place in the system?

BSIK-BELNR has data element BELNR_D. If I push "Where-used in F4 helps" for this data type, I get the following list.

You can test the functionality of these search helps in SE11, -> Search Help -> Button "Test..."

If you find one that fits your need, you can attach its ID to your report parameter or select-option with the ammendment "MATCHCODE OBJECT <search_help>", where <search_help> is the DDIC name, with no quotation marks.

Regards,

Rüdiger

Search help	Short description
/SAPNEA/J_SC_DEDUCTIBLE_AP_DOC	Deductible A/P document search help
CREDIT_CARD_DOCUMENT_SHLP	Payment Card Documents that can be Reversed
FIN_FSSC_SH_SDINV	Search help SD Invoice
FMCJ_FI_REFERENCE_DEBI	Search Help to Determine Open Item for Cash Desk
FMCJ_FI_REFERENCE_KREDI	Search Help to Determine Open Item for Cash Desk
FMFGIPACED_SHLP	IPACed search help
FMFG_REFERENCE_NUMBER	Search using reference number
FMKK_F4_AUGBL	Search Help for Clearing Document Number
FMKK_F4_BELNR	Document Number Search Help
H_VBKPF	Parked Documents Help View
J_1IEWT_CHALLAN	Search help for J_1IEWTCHLN table to get clearing docs no
J_1I_GAR7	GAR7 Search help for Internal challan number
J_3RFTSE_SHP	Search help for secondary documents from J_3RTSE table
J_3R_SH_SALE_BOOK	Search help for sale book
MEBZF	Delivery Costs for Bill of Lading
MEBZX	Delivery Costs per Vendor/External Document Number
OIAMA	Fees per vendor
OIAMC	Fees per contract (outline agreement)
OIAMD	Fees per external delivery note
OIAME	Fees per bill of lading
REXCFC_BELNR	Find Documents Using RE Account Assignment
VF_BKPF	Search help for billing documents via FI data

[SharathYaralkattimath]

Hi,

I tested "FMKK_F4_BELNR" & found suitable for the requirement.

[Former Member]

Hi,

If you want to get list of BSIK documents, then please go with FM F4IF_INT_TABLE_VALUE_REQUEST...

Advantage is: You can fetch documents from BSIK table as per your requirement/Conditions....

Regards,

Rajesh Sadula.

[Ruediger_Plantiko]

Rajesh. As a programmer, you always have the full freedom. I just want to point to the following part of the documentation of the function module F4IF_INT_TABLE_VALUE_REQUEST you recommended. For this reason, I asked Swetha to look for existing F4 helps, first.

It's bold in original

Note: Before you use this module at POV (Process on Value-Request),
reconsider whether a search help could not carry out the same task. (...) The F4 help is  automatically available for all users of the data element or structure.

[Former Member]

Hi Rudiger,

I completely agree with you, the above BOLD words are absolutely correct....

We have to use FM F4IF_INT_TABLE_VALUE_REQUEST only when we have custom conditions i.e no standard/existing search help available for our requirement.

Regards,

Rajesh Sadula.

[keyur_pawar]

Try this code,......

***************************************************************************

REPORT  ZBELNR.

tables : BSIK.
types: begin of s_itab,
     belnr type BELNR_D,
   end of s_itab.

   data : itab type table of s_itab.

selection-screen begin of block b1.
parameters : belnr type BSIK-BELNR.
selection-screen end of block b1.


at selection-screen on value-request for belnr.
select belnr from BSIK into table ITAB.

call function 'F4IF_INT_TABLE_VALUE_REQUEST'
           exporting
             retfield        = 'BELNR'
             dynpprog        = sy-repid
             dynpnr          = '1000'
             dynprofield     =  'BSIK-BELNR'  "'T_SERIAL-INFO'
*            stepl           = lv_stepl
             value_org       = 'S'
           tables
             value_tab       = itab
           exceptions
             parameter_error = 1
             no_values_found = 2
             others          = 3.
         if sy-subrc ne 0.
           message id sy-msgid type sy-msgty number sy-msgno
                   with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
         endif.

[sapient_abaper]

Types : begin of zbelnr,

                       belnr type bsik-belnr,

            end of zbelnr.

DATA :   p_retfield    TYPE dfies-fieldname
             pt_shelp      TYPE STANDARD TABLE Zbelnr_ds            

            return_values TYPE STANDARD TABLE Zbelnr_ds

           p_subrc       TYPE sy-subrc .

   DATA : lt_return_values  TYPE STANDARD TABLE OF ddshretval,
         ls_return_values  LIKE LINE OF lt_return_values,
         lv_belnr          TYPE bsik-belnr,
         lv_subrc          TYPE sy-subrc.

   AT SELECTION-SCREEN ON VALUE-REQUEST FOR s_belnr-low.
  PERFORM get_belnr_f4_help.

*&---------------------------------------------------------------------*
*&      Form  GET_BELNR_F4_HELP
*&---------------------------------------------------------------------*
FORM get_belnr_f4_help.

   SELECT BELNR from BSIK   INTO TABLE lt_belnr_f4_help.
  IF sy-subrc = 0.
    SORT lt_belnr_f4_help BY belnr ASCENDING.
    DELETE ADJACENT DUPLICATES FROM pt_belnr_f4_help COMPARING ALL FIELDS.
  ENDIF.

   IF lt_belnr_f4_help[] IS NOT INITIAL.

    CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      retfield        = p_retfield
      value_org       = 'S'
      multiple_choice = 'X'
    TABLES
      value_tab       = pt_shelp[]
      return_tab      = return_values
    EXCEPTIONS
      parameter_error = 1
      no_values_found = 2
      OTHERS          = 3.
  IF sy-subrc <> 0.
    p_subrc = sy-subrc.
  ENDIF.

IF lv_subrc = 0.
      LOOP AT lt_return_values INTO ls_return_values.
        IF sy-subrc = 0.
          lv_belnr = ls_return_values-fieldval.
          CLEAR   s_belnr.
*          REFRESH s_belnr.
          s_belnr-sign   = 'I'.
          s_belnr-option = 'EQ'.
          s_belnr-low    = lv_belnr.
          APPEND s_belnr.
        ENDIF.
      ENDLOOP.
    ENDIF.
  ENDIF.

   ENDFORM.                    " GET_BELNR_F4_HELP

[Former Member]

hi Sweta,

There is a function module to get F4 help on selection screen for those fields which does not have search help of value help or check table attached to it.

   REPORT  ZTEST_RAJ.

TABLES: bsik.

TYPES: BEGIN OF ty_value_tab,
         belnr  TYPE bsik-belnr,
       END OF ty_value_tab.

DATA: lt_value_tab  TYPE STANDARD TABLE OF ty_value_tab,
      lt_return     TYPE STANDARD TABLE OF ddshretval.

PARAMETERS p_belnr  TYPE bsik-belnr.



AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_belnr.
SELECT belnr
  FROM bsik
  INTO TABLE lt_value_tab.
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      RETFIELD               = 'BELNR'
      DYNPPROG               = sy-cprog
      DYNPNR                 = sy-dynnr
      VALUE_ORG              = 'S'
    TABLES
      VALUE_TAB              = lt_value_tab[]
      RETURN_TAB             = lt_return
   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.

[former_member833567]

Use Function Module for F4IF_INT_TABLE_VALUE_REQUEST or create a Search Help through SE11 and add it

[Sandra_Rossi]

There's no search help for BKPF-BELNR (or BSIK-BELNR or whatever table you want).

Instead, you may reuse the concept used in transactions like FB03, with the button "Document List" to run the Document List program RFBUEB00 to select documents and run one transaction code for this selected document (here, it will run FB03):

Type the selection criteria:

The corresponding documents are shown, select one:

The transaction code FB03 is started (again) with the selected document and its detail screen is shown immediately:

For information, if you go back, the list of selected documents is shown again.

Of course, it's not like a search help because the selected document is not returned to the screen field where the search help is invoked.

BUT you may do this little workaround:

1. Create a custom search help which runs RFBUEB00 with a dummy transaction code which just displays a popup with this message: "The document has been selected, go back to the screen where you invoked the search help."
2. After RFBUEB00, read the selected document number (GET PARAMETER ID 'BUK', 'GJR' and one among 'BLD', 'BLM', 'BLV' or 'BLN' depending on BKPF-BSTAT = 'D', 'M', 'V' or other (*)) and return it to the screen field where the search help is invoked.

(*) The logic is coded in the subroutine SET_PIDS of RFBUEB00: