Interactive Report

[Former Member]

I am trying to develop a interactive report.

TABLES: KNA1,

VBAK,

VBAP.

SELECT * FROM KNA1 ORDER BY KUNNR.

WRITE:/10 KNA1-KUNNR,

25 KNA1-NAME1,

65 KNA1-LAND1.

HIDE KNA1-KUNNR.

ENDSELECT.

AT LINE-SELECTION.

CASE SY-LSIND.

WHEN 1.

SELECT * FROM VBAK WHERE KUNNR = KNA1-KUNNR.

WRITE:/10 VBAK-VBELN,

25 VBAK-ERDAT,

65 VBAK-NETWR.

HIDE VBAK-VBELN.

ENDSELECT.

WHEN 2.

SELECT * FROM VBAP WHERE VBELN = VBAK-VBELN.

WRITE:/10 VBAP-POSNR,

25 VBAP-ARKTX,

65 VBAP-WERKS.

ENDSELECT.

ENDCASE.

Now If the customer does not have any orders I want to display "No orders available" in the next screen. How can I achieve that.

[Clemenss]

Hi Verikat,

just check the SY-SUBRC returned by your select statement.

AT LINE-SELECTION.
  CASE SY-LSIND.
    WHEN 1.
      SELECT * FROM VBAK WHERE KUNNR = KNA1-KUNNR.
      WRITE:/10 VBAK-VBELN,
      25 VBAK-ERDAT,
      65 VBAK-NETWR.
      HIDE VBAK-VBELN.
      ENDSELECT.
      IF sy-subrc <> 0.
        WRITE:/10 'No orders available',
      ENDIF.
* ....

Regards,

Clemens