No data, Getting SY-SUBRC=4 in SELECT Statement

[Alicealice]

Dear All,

I am facing some problem when created the new report. There is no any data appear on the report. After I debugged , the SY-SUBRC=4 in SELECT Statement. Could someone guide me on this?

Below is my program.

Code: Select all

  TYPES: BEGIN OF ty_lqua,
           lgnum TYPE lgnum,
           matnr TYPE matnr,
           werks TYPE werks_d,
           lgort TYPE lgort_d,
           charg TYPE charg_d,
           bestq TYPE bestq,
           lgtyp TYPE lgtyp,
           lgpla TYPE lgpla,
           verme TYPE lqua_verme,
           wdatu TYPE lvs_wdatu,
         END OF ty_lqua.

  DATA: it_lqua TYPE TABLE OF ty_lqua,
        wa_lqua TYPE ty_lqua.

  SELECT lgnum matnr werks lgort charg bestq lgtyp lgpla verme wdatu INTO TABLE it_lqua FROM lqua
    WHERE lgnum IN s_lgnum
      AND matnr IN s_matnr.

  SORT it_lqua BY lgnum matnr.

  IF sy-subrc = 0.

    LOOP AT it_lqua INTO wa_lqua WHERE lgnum = wa_lqua-lgnum.
      wa_report-lgnum = wa_lqua-lgnum.
      wa_report-matnr = wa_lqua-matnr.
      wa_report-werks = wa_lqua-werks.
      wa_report-lgort = wa_lqua-lgort.
      wa_report-charg = wa_lqua-charg.
      wa_report-bestq = wa_lqua-bestq.
      wa_report-lgtyp = wa_lqua-lgtyp.
      wa_report-lgpla = wa_lqua-lgpla.
      wa_report-verme = wa_lqua-verme.
      wa_report-wdatu = wa_lqua-wdatu.
*        wa_report-line_colour = 'C300'.
*        wa_report-check = 'X'.
      APPEND wa_report TO it_report.
    ENDLOOP.

  ENDIF.

Thank you

[Gothmog]

There's no data corresponding to your selection. Did you check in SE16 on table LQUA ?

[Alicealice]

Yes, I had checked in SE16 on table LQUA. There is a data in the table. Could you please advice? Thanks.

[Gothmog]

What do you have in s_lgnum and s_matnr ?
Does your data in LQUA match these selections ?

[Alicealice]

s_lgnum and s_matnr are for report parameter.
Yes, data in LQUA match the selections. Could you help me?
There is no any data appear in the report, only have data.Thanks.

[Gothmog]

Yes, data in LQUA match the selections.

It seems it doesn't. That's what sy-subrc 4 means after a SELECT.
Are you sure you're not missing leading zeroes in your matnr selection ?

[Alicealice]

I have no idea on it. Any mistake in the SELECT statement? Thanks.

[Rich]

First, as has been pointed out, make sure that your selectoin parameters have been passed through the correct conversion exits. If they are as you say they are SELECT-OPTIONS then this should have already been cdarried out otherwise you will have to do it programatocally.

Second:

Code: Select all

LOOP AT it_lqua INTO wa_lqua WHERE lgnum = wa_lqua-lgnum.

This will not work. How can you provide a filter to a loop clause that is initially empty and then changing with each loop ?

Code: Select all

LOOP AT it_lqua INTO wa_lqua .

Will do the job.

[YuriT]

Like pointed out above by Gothmog and Rich, if you are sure your data actually exists, only thing left is types. Looking at your select statement, MATNR is the most likely suspect.

Try to do following. Create your select statement gradually increasing complexity and see when is it failing.

Start with select * from lqua, then add lgnum then remove it and add matnr, then add them together, try hard-coding matnr and lgnum. This will localize your problem if there ifs one.

[Deeler Stan]

This may seem like a stupid thought, but:

The selection-screen code has not been included with the code extract, so:

Like others I am assuming S_LGNUM and S_MATNR are select options, but am basing this on the fact that they begin S_.

Has Alicealice used parameters rather than select-options, this would fail the select.


Stan