Calling function module in Infoset In SQ02 , abap

[Former Member]

Hi Expert,

I have requirement to call the custom function module in Info set in  SQ02  and execute through SQ01.

I created info set zcdmc in menubar GOto->Code->Freecoding.

I written following code.

types : BEGIN OF YT_FINAL,
          CREATION_DATE TYPE ZSM_CDMC-CREATION_DATE,
          PROJ_ID TYPE ZSM_CDMC-PROJ_ID,
          KPI_NAME TYPE ZSM_CDMC-KPI_NAME,
          COUNT1 TYPE ZSM_CDMC-COUNT1,
         END OF YT_FINAL.

  data: it_final_result TYPE STANDARD TABLE OF yt_final,
         wa_final_result type yt_final.

  SELECTION-SCREEN BEGIN OF SCREEN 123.
  SELECT-OPTIONS : zPeriod for SY-DATUM .
  SELECTION-SCREEN END OF SCREEN 123.

  CALL FUNCTION 'ZFSOLMAN_CDMC'
    EXPORTING
      ZPROJECT_ID = zPeriod
    TABLES
      IT_FINAL1   = it_final_result.

But when i was execute it through the Dum

i.e. Statement is not accessible

CALL FUNCTION 'ZFSOLMAN_CDMC'

Please suggest me how to resolve it

Please go through attachment of screen short and code.

[Former Member]

Hi Expert,

I have requirement to call the custom function module in Info set in  SQ02  and execute through SQ01.

I created info set zcdmc in menubar GOto->Code->Freecoding.

I written following code.

types : BEGIN OF YT_FINAL,
          CREATION_DATE TYPE ZSM_CDMC-CREATION_DATE,
          PROJ_ID TYPE ZSM_CDMC-PROJ_ID,
          KPI_NAME TYPE ZSM_CDMC-KPI_NAME,
          COUNT1 TYPE ZSM_CDMC-COUNT1,
         END OF YT_FINAL.

  data: it_final_result TYPE STANDARD TABLE OF yt_final,
         wa_final_result type yt_final.

  SELECTION-SCREEN BEGIN OF SCREEN 123.
  SELECT-OPTIONS : zPeriod for SY-DATUM .
  SELECTION-SCREEN END OF SCREEN 123.

  CALL FUNCTION 'ZFSOLMAN_CDMC'
    EXPORTING
      ZPROJECT_ID = zPeriod
    TABLES
      IT_FINAL1   = it_final_result.

But when i was execute it through the Dum

i.e. Statement is not accessible

CALL FUNCTION 'ZFSOLMAN_CDMC'

Please suggest me how to resolve it

Please go through attachment of screen short and code.

[Former Member]

Hi ,

I propose to divide your code between 3 Code Sections:

DATA

types : BEGIN OF YT_FINAL,
          CREATION_DATE TYPE ZSM_CDMC-CREATION_DATE,
          PROJ_ID TYPE ZSM_CDMC-PROJ_ID,
          KPI_NAME TYPE ZSM_CDMC-KPI_NAME,
          COUNT1 TYPE ZSM_CDMC-COUNT1,
         END OF YT_FINAL.

  data: it_final_result TYPE STANDARD TABLE OF yt_final,
         wa_final_result type yt_final.

  SELECTION-SCREEN BEGIN OF SCREEN 123.
  SELECT-OPTIONS : zPeriod for SY-DATUM .
  SELECTION-SCREEN END OF SCREEN 123.

Record Processing

Perform call_function.

Free coding

form call_function.

CALL FUNCTION 'ZFSOLMAN_CDMC'

    EXPORTING

      ZPROJECT_ID = zPeriod

    TABLES

      IT_FINAL1   = it_final_result.

endform.

Regards.

[Former Member]

Hi ,

I  add 4 custom field i.e.

Creation_date

Project_id

KPI_Name

Count1

And in the field code session i past the code  .

Could you please tell me how to achieve result  through sq01.

Regards,

Jayesh

[Former Member]

Hi Jayesh,

Take a look at http://he.scribd.com/doc/87817270/How-to-Create-a-SAP-Query-SQ01-SQ02-SQ03.

Regards