topic Re: No data showing up in Application Development and Automation Discussions

No data showing up

former_member844813 — Mon, 13 Mar 2023 14:06:40 GMT

i need help with my program not showing any data, help me what did i do wrong

here's the code

*&---------------------------------------------------------------------*
*& Report  ZGETFBL
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*
REPORT  ZGETFBL.

TABLES: BSAS,
        BSIS.

DATA: ITAB TYPE TABLE OF ZDATAGL,
      WA TYPE ZDATAGL.

START-OF-SELECTION.

SELECT MANDT HKONT AUGBL KOSTL DMBTR FROM BSAS
   INTO TABLE ITAB
  WHERE HKONT = '6105001' AND BUDAT BETWEEN '01.09.2022' AND '30.09.2022'.

SELECT MANDT HKONT AUGBL KOSTL DMBTR FROM BSIS
  APPENDING TABLE ITAB
    WHERE HKONT = '6105001' AND BUDAT BETWEEN '01.09.2022' AND '30.09.2022'.

END-OF-SELECTION.
MODIFY ZDATAGL FROM TABLE ITAB.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
  EXPORTING
*   I_INTERFACE_CHECK                 = ' '
*   I_BYPASSING_BUFFER                = ' '
*   I_BUFFER_ACTIVE                   = ' '
*   I_CALLBACK_PROGRAM                = ' '
*   I_CALLBACK_PF_STATUS_SET          = ' '
*   I_CALLBACK_USER_COMMAND           = ' '
*   I_CALLBACK_TOP_OF_PAGE            = ' '
*   I_CALLBACK_HTML_TOP_OF_PAGE       = ' '
*   I_CALLBACK_HTML_END_OF_LIST       = ' '
    I_STRUCTURE_NAME                  = 'ZDATAGL'
*   I_BACKGROUND_ID                   = ' '
*   I_GRID_TITLE                      =
*   I_GRID_SETTINGS                   =
*   IS_LAYOUT                         =
*   IT_FIELDCAT                       =
*   IT_EXCLUDING                      =
*   IT_SPECIAL_GROUPS                 =
*   IT_SORT                           =
*   IT_FILTER                         =
*   IS_SEL_HIDE                       =
*   I_DEFAULT                         = 'X'
*   I_SAVE                            = ' '
*   IS_VARIANT                        =
*   IT_EVENTS                         =
*   IT_EVENT_EXIT                     =
*   IS_PRINT                          =
*   IS_REPREP_ID                      =
*   I_SCREEN_START_COLUMN             = 0
*   I_SCREEN_START_LINE               = 0
*   I_SCREEN_END_COLUMN               = 0
*   I_SCREEN_END_LINE                 = 0
*   I_HTML_HEIGHT_TOP                 = 0
*   I_HTML_HEIGHT_END                 = 0
*   IT_ALV_GRAPHICS                   =
*   IT_HYPERLINK                      =
*   IT_ADD_FIELDCAT                   =
*   IT_EXCEPT_QINFO                   =
*   IR_SALV_FULLSCREEN_ADAPTER        =
* IMPORTING
*   E_EXIT_CAUSED_BY_CALLER           =
*   ES_EXIT_CAUSED_BY_USER            =
  TABLES
    T_OUTTAB                          = ITAB
 EXCEPTIONS
   PROGRAM_ERROR                     = 1
   OTHERS                            = 2
          .
IF SY-SUBRC <> 0.
* Implement suitable error handling here
ENDIF.

Re: No data showing up

FredericGirod — Mon, 13 Mar 2023 14:43:30 GMT

The internal date format of SAP is YYYYMMDD

BETWEEN '22220901' AND '22220931'.

Re: No data showing up

former_member844813 — Tue, 14 Mar 2023 03:06:45 GMT

hi Frederic!

still not showing any data though, can you help me with that

Re: No data showing up

FredericGirod — Tue, 14 Mar 2023 07:07:20 GMT

You have to put a break point (break userid) just before the call of the function and check the internal table is not empty.

If it is empty, check using SE16 transaction if there are some entries with your WHERE conditions

Re: No data showing up

matt — Tue, 14 Mar 2023 08:34:17 GMT

Your biggest mistake is using old technology for your report. Instead of REUSE_ALV_GRID_DISPLAY', use CL_SALV_TABLE. There's many blogs about it.

Re: No data showing up

RaymondGiuseppi — Tue, 14 Mar 2023 10:01:47 GMT

Suggestions

Define the range of date as a select-options and the GL account as a parameter (and then debug and look at the actual values of those fields)
Use an OO ALV class such as CL_SALV_TABLE and not an outdated FM
Update the Z table thru a Function Code managed in the ALV