using NAST WITH DATE RANGE THE ZPROGRAM GIVING DUMP

[Former Member]

Hi Frineds,

i am writing select query from NAST table for PO created time based on date range more than 10 days the program is giving DUMP in Quality System.. but in Developement system the dump is not coming for same date range.

please see the below code......that i ahve written. help me.

IF SY-SUBRC EQ 0.

    SELECT KAPPL
       OBJKY
       KSCHL
       SPRAS
       ERDAT
       ERUHR
       FROM NAST
       INTO TABLE IT_NAST
        WHERE KAPPL = 'EF' AND
              OBJKY IN R_OBJKY AND
               KSCHL IN S_KSCHL
              AND ERDAT IN S_DATE
              AND ERUHR IN  S_ERUHR.
    SORT IT_NAST  BY OBJKY.
    DELETE ADJACENT DUPLICATES FROM IT_NAST COMPARING OBJKY.
  ENDIF.
ENDIF.

regards,

Vijay

Edited by: Rob Burbank on Jan 21, 2010 12:42 PM

[Former Member]

Hi Frineds,

i am writing select query from NAST table for PO created time based on date range more than 10 days the program is giving DUMP in Quality System.. but in Developement system the dump is not coming for same date range.

please see the below code......that i ahve written. help me.

IF SY-SUBRC EQ 0.

    SELECT KAPPL
       OBJKY
       KSCHL
       SPRAS
       ERDAT
       ERUHR
       FROM NAST
       INTO TABLE IT_NAST
        WHERE KAPPL = 'EF' AND
              OBJKY IN R_OBJKY AND
               KSCHL IN S_KSCHL
              AND ERDAT IN S_DATE
              AND ERUHR IN  S_ERUHR.
    SORT IT_NAST  BY OBJKY.
    DELETE ADJACENT DUPLICATES FROM IT_NAST COMPARING OBJKY.
  ENDIF.
ENDIF.

regards,

Vijay

Edited by: Rob Burbank on Jan 21, 2010 12:42 PM

[Former Member]

It would help if you would tell us what sort of dump you are getting.

And please use code tags to format code.

Rob

[Former Member]

Hi,

thanks for your mail..

the dump message

There is no help text for this dump

Either the text was inadvertently deleted or the release of

the kernel differs from the release of the database

Refer to the Note system for further information on this dump.

Regards,

Vijay

[Former Member]

Since there are two ENDIF statements, I assume that there's an IF before that "IF SY-SUBRC EQ 0." ?

And, there's really nothing showing in ST22 transaction?

How is s_date created in your selection screen - select-options s_date for ??? Why do you think the dump is caused by the s_date values?

And, one final check....you didn't remove some code before transporting to the instance?

[Former Member]

Hello Friend,

There is nothing wrong with the SELECT statement....

check 2 things:

1. structure of IT_NAST table...there must be something going wrong

2. R_OBJKY.....check the formation of the range

Hope it will solve the problem.

Thanks

Krish