topic problem with the code some where in select query in Application Development and Automation Discussions

problem with the code some where in select query

Former Member — Tue, 20 Jan 2009 09:37:04 GMT

Hi ,

I am having a development in this i have created a selection-screen and on this selection screen i am having select-options with F4 help attached once we opt the select option then we will get the desired output based on this in the classical format, it is working fine when i dnt attach F4 help but as soon as i attach F4 it does not go to the next screen after the select-options where i am going to see the result, i think there is problem in itab or sy-dnnr please see it once sample code present.

TABLES : ZFISALDT. " LINE-SIZE 400 NO STANDARD PAGE HEADING.

DATA ITAB LIKE ZFISALDT OCCURS 0 WITH HEADER LINE.

SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE ABC.

SELECT-OPTIONS : BILLING FOR ZFISALDT-BILLINGDOCU,
                 SALESDOC FOR  ZFISALDT-SALESDOCU.

SELECTION-SCREEN : END OF BLOCK B1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR BILLING-high.


CALL FUNCTION 'F4_FIELD_ON_VALUE_REQUEST'
  EXPORTING
    TABNAME                   = 'ZFISALDT'
    FIELDNAME                 = 'BILLINGDOCU'
*   SEARCHHELP                = ' '
*   SHLPPARAM                 = ' '
   DYNPPROG                  = SY-repid
   DYNPNR                    = sy-dynnr
*   DYNPROFIELD               = ' '
*   STEPL                     = 0
*   VALUE                     = ' '
*   MULTIPLE_CHOICE           = ' '
*   DISPLAY                   = ' '
*   SUPPRESS_RECORDLIST       = ' '
*   CALLBACK_PROGRAM          = 'sy-cprog'
*   CALLBACK_FORM             = ' '
*   SELECTION_SCREEN          = ' '
*   CALLBACK_SELOPT           =
 TABLES
   RETURN_TAB                = ITAB[]
 EXCEPTIONS
   FIELD_NOT_FOUND           = 1
   NO_HELP_FOR_FIELD         = 2
   INCONSISTENT_HELP         = 3
   NO_VALUES_FOUND           = 4
   OTHERS                    = 5
          .
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

SELECT * FROM ZFISALDT INTO CORRESPONDING FIELDS OF TABLE ITAB WHERE  BILLINGDOCU IN BILLING.

The records are coming in this select query when no F4 function module, But Not coming when F4 module is present.

Please see to this code.

Thanks in Advance

Edited by: Julius Bussche on Jan 20, 2009 11:05 AM

Please use code tags

Re: problem with the code some where in select query

Former Member — Tue, 20 Jan 2009 09:41:53 GMT

Hi Sumeet,

When you are calling the F4 function module, you need to pass some values to the internal table, that would be shown in the selection screen, when the user presses F4. That is not done here.

Also, once the user selects any value from F4, then that will be available in "Return Tab" of the function module. That needs to be READ and returned to the screen field.

Kindly check for the help of F4 help FM. or you can search for F4 function module call in sdn. Once you correct that, your issue would be resolved.

Best Regards,

Ram.

Re: problem with the code some where in select query

Former Member — Tue, 20 Jan 2009 09:42:28 GMT

Hi,

Check ur internal table before passing to the FM 'F4_FIELD_ON_VALUE_REQUEST'.

Write ur select query before calling this FM 'F4_FIELD_ON_VALUE_REQUEST'.

Re: problem with the code some where in select query

Former Member — Tue, 20 Jan 2009 09:43:41 GMT

Hi,

you missed start-of-selection before select query, write it and check.

Re: problem with the code some where in select query

Former Member — Tue, 20 Jan 2009 09:47:29 GMT

Hi,

Give select statement inside if.endif.clause..

Regards

Vasavi kotha

Re: problem with the code some where in select query

Former Member — Sat, 07 Feb 2009 04:22:02 GMT

Thanks Experts My problem solved was making a silly mistake closing the thread start-of-selection is missing.

Thanks