Run Time Error

[Former Member]

hi

when i run the below code in debug mode .. it executed smothly but we i directly execute it . it shows run time error . kindly help me

REPORT Z_ITAB.

DATA var TYPE spfli.

DATA: BEGIN OF Show,

carrid(5) TYPE c,

connid(5) TYPE i,

END OF Show.

DATA etab LIKE STANDARD TABLE OF Show WITH NON-UNIQUE KEY carrid.

SELECT * FROM spfli INTO CORRESPONDING FIELDS OF var

WHERE carrid EQ 'AA'.

Show-carrid = var-carrid.

Show-connid = var-connid.

APPEND Show TO etab.

LOOP AT etab INTO Show.

WRITE: / Show-carrid , Show-connid.

ENDLOOP.

ENDSELECT.

[Former Member · Accepted solution]

Hi,

The codes are giving you runtime error because of the COMMIT WORK as you are using LOOP__ENDLOOP within SELECT--ENDSELECT.

If while runtime work process is not available for the select and loop--endloop commit work will not happen and result in Runtime error.As you run program in Debug Mode each step is execute one-by-one and it gets work process available.But you can get runtime error at times in debugmode also.

Try these codes:

REPORT Z_ITAB.

DATA: BEGIN OF Show,
carrid(5) TYPE c,
connid(5) TYPE i,
END OF Show.

DATA etab LIKE STANDARD TABLE OF Show WITH NON-UNIQUE KEY carrid.

SELECT carrid connid FROM spfli INTO table etab
WHERE carrid EQ 'AA'.


LOOP AT etab INTO Show.
WRITE: / Show-carrid , Show-connid.
ENDLOOP.

Regards,

Gurpreet.

[Former Member · Accepted solution]

not working man

[Former Member · Accepted solution]

REPORT Z_ITAB.

DATA: BEGIN OF Show,
carrid(5) TYPE c,
connid(4) TYPE n,                           " It was i in previous codes.
END OF Show.

DATA etab LIKE STANDARD TABLE OF Show WITH NON-UNIQUE KEY carrid.

SELECT carrid connid FROM spfli INTO CORRESPONDING FIELDS OF table etab
WHERE carrid EQ 'AA'.


LOOP AT etab INTO Show.
WRITE: / Show-carrid , Show-connid.
ENDLOOP.

As i was not in front of the computer last time over looked the TYPE I with lenght specification.

Which could have caused you error.

Try the above codes I have Executed them.it will work.

otherwise check with your basis team if it give you Runtime error may be issue can be from the server end.

Regards,

Gurpreet

[Former Member · Accepted solution]

thanku its working