topic Re: run time error in Application Development and Automation Discussions

run time error

Former Member — Thu, 08 Mar 2007 10:13:42 GMT

hi everone

am comipling d code but am getting runtime errors plzz help

vijay

REPORT ZX4 .

TABLES:LFA1,KNA1,MARA.

SELECT-OPTIONS:LIFNR FOR LFA1-LIFNR,

KUNNR FOR KNA1-KUNNR,

MATNR FOR MARA-MATNR.

*DATA ITAB TYPE STANDARD TABLE OF KNA1 WITH HEADER LINE.

*DATA JTAB TYPE STANDARD TABLE OF LFA1 WITH HEADER LINE.

*DATA ATAB TYPE STANDARD TABLE OF VBRP WITH HEADER LINE.

DATA:BEGIN OF ITAB OCCURS 1,

KUNNR LIKE KNA1-KUNNR,

LAND1 LIKE KNA1-LAND1,

NAME1 LIKE KNA1-NAME1,

ORT01 LIKE KNA1-ORT01,

END OF ITAB.

DATA:BEGIN OF JTAB OCCURS 1,

LIFNR LIKE LFA1-LIFNR,

LAND1 LIKE LFA1-LAND1,

NAME1 LIKE LFA1-NAME1,

END OF JTAB.

DATA:BEGIN OF ATAB OCCURS 1 ,

MATNR LIKE MARA-MATNR,

MBRSH LIKE MARA-MBRSH,

MTART LIKE MARA-MTART,

MEINS LIKE MARA-MEINS,

END OF ATAB.

TYPE-POOLs SLIS.

DATA:REPID LIKE SY-REPID,

KNA1_B TYPE SLIS_T_FIELDCAT_ALV,

LAYOUT_B TYPE SLIS_LAYOUT_ALV,

EVENTS TYPE SLIS_T_EVENT.

REPID = SY-REPID.

SELECT KUNNR LAND1 NAME1 ORT01 FROM KNA1 INTO TABLE ITAB

UP TO 20 ROWS WHERE KUNNR IN KUNNR.

SELECT LIFNR LAND1 NAME1 ORT01 FROM LFA1 INTO TABLE JTAB

UP TO 20 ROWS WHERE LIFNR IN LIFNR.

SELECT MATNR VBELN FBUDA PSTYV FROM VBRP INTO TABLE ATAB

UP TO 20 ROWS WHERE VBELN IN MATNR.

CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT'

EXPORTING

I_CALLBACK_PROGRAM = REPID.

PERFORM APPENDBLOCK TABLES ITAB USING 'ITAB'.

PERFORM APPENDBLOCK TABLES ITAB USING 'JTAB'.

PERFORM APPENDBLOCK TABLES ITAB USING 'ATAB'.

CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY'.

FORM APPENDBLOCK TABLES KTAB USING ITAB.

CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'

EXPORTING

I_PROGRAM_NAME = REPID

I_INTERNAL_TABNAME = JTAB

I_INCLNAME = REPID

CHANGING

CT_FIELDCAT = KNA1_B.

CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'

EXPORTING

IS_LAYOUT = LAYOUT_B

IT_FIELDCAT = KNA1_B

I_TABNAME = JTAB

IT_EVENTS = EVENTS

TABLES

T_OUTTAB = KTAB.

ENDFORM.

Re: run time error

Former Member — Thu, 08 Mar 2007 10:17:43 GMT

try using INTO CORRESPONDING FIELDS OF TABLE...

SELECT KUNNR LAND1 NAME1 ORT01 FROM KNA1 INTO CORRESPONDING FIELDS OF TABLE ITAB

UP TO 20 ROWS WHERE KUNNR IN KUNNR.

SELECT LIFNR LAND1 NAME1 ORT01 FROM LFA1 INTO CORRESPONDING FIELDS OF TABLE JTAB

UP TO 20 ROWS WHERE LIFNR IN LIFNR.

SELECT MATNR VBELN FBUDA PSTYV FROM VBRP INTO CORRESPONDING FIELDS OF TABLE ATAB

UP TO 20 ROWS WHERE VBELN IN MATNR.

could u give the details of runtime error .. where it is getting triggered..

reward helpful answers...

sai ramesh

Re: run time error

Former Member — Thu, 08 Mar 2007 10:17:53 GMT

Hello Vijay,

The dump occurs in this select stmt

SELECT LIFNR LAND1 NAME1 ORT01 FROM LFA1 INTO TABLE JTAB
UP TO 20 ROWS WHERE LIFNR IN LIFNR.
" Here u r selecting 4 fields from LFA1 but there are only three fields in the JTAB

DATA:BEGIN OF JTAB OCCURS 1,
LIFNR LIKE LFA1-LIFNR,
LAND1 LIKE LFA1-LAND1,
NAME1 LIKE LFA1-NAME1,
ORT01 like lfa1-ort01 ,  " Addd this field
END OF JTAB.

If useful reward.

Vasanth

Re: run time error

Former Member — Thu, 08 Mar 2007 10:22:13 GMT

Hi vijay,

your table JTAB has 3 fields but your select statement tries to add 4 fields.

Regards

Nicola

Re: run time error

Former Member — Thu, 08 Mar 2007 10:22:31 GMT

am still getting d runtime error..plzz help

vijay

Re: run time error

Former Member — Thu, 08 Mar 2007 10:24:49 GMT

Hello Vijay,

Check this:


DATA:BEGIN OF ATAB OCCURS 1 ,
MATNR LIKE MARA-MATNR,
MBRSH LIKE MARA-MBRSH,
MTART LIKE MARA-MTART,
MEINS LIKE MARA-MEINS,
END OF ATAB.
SELECT MATNR VBELN FBUDA PSTYV FROM VBRP INTO TABLE ATAB UP TO 20 ROWS WHERE VBELN IN MATNR.

" Make the change to the ATAB

Vasanth

Re: run time error

Former Member — Thu, 08 Mar 2007 10:25:49 GMT

hi...

Here in ur program ur selecting 4 fields into jtab and trying to insert in that,where as jtab has only 3 fields in its table definition.........so change the jtab to

DATA:BEGIN OF JTAB OCCURS 1,

LIFNR LIKE LFA1-LIFNR,

LAND1 LIKE LFA1-LAND1,

NAME1 LIKE LFA1-NAME1,

ORT01 LIKE KNA1-ORT01,

END OF JTAB.

with regards

jay.

Re: run time error

Former Member — Thu, 08 Mar 2007 10:27:27 GMT

hi vasanth

still getting d same runtime errors

vijay

Re: run time error

Former Member — Thu, 08 Mar 2007 10:27:53 GMT

Hi,

write INTO CORRESPONDING FIELDS in select statements...

KIshore.

Re: run time error

Former Member — Thu, 08 Mar 2007 10:29:34 GMT

i did dat still getting d runtime error..plz help

vijay

Re: run time error

Former Member — Thu, 08 Mar 2007 10:32:16 GMT

Hello Vijay,

Check this select

SELECT MATNR VBELN FBUDA PSTYV FROM VBRP INTO TABLE ATAB

UP TO 20 ROWS WHERE VBELN IN MATNR.

I have made the changes to the report and now it is giving the correct output. Make the chages whereever u want to make


REPORT ZV_TEST57 .
TABLES:LFA1,KNA1,MARA.
SELECT-OPTIONS:LIFNR FOR LFA1-LIFNR,
KUNNR FOR KNA1-KUNNR,
MATNR FOR MARA-MATNR.



*DATA ITAB TYPE STANDARD TABLE OF KNA1 WITH HEADER LINE.
*DATA JTAB TYPE STANDARD TABLE OF LFA1 WITH HEADER LINE.
*DATA ATAB TYPE STANDARD TABLE OF VBRP WITH HEADER LINE.
DATA:BEGIN OF ITAB OCCURS 1,

KUNNR LIKE KNA1-KUNNR,
LAND1 LIKE KNA1-LAND1,
NAME1 LIKE KNA1-NAME1,
ORT01 LIKE KNA1-ORT01,
END OF ITAB.

DATA:BEGIN OF JTAB OCCURS 1,
LIFNR LIKE LFA1-LIFNR,
LAND1 LIKE LFA1-LAND1,
NAME1 LIKE LFA1-NAME1,
ORT01 LIKE LFA1-ORT01,
END OF JTAB.


DATA:BEGIN OF ATAB OCCURS 1 ,
MATNR LIKE MARA-MATNR,
MBRSH LIKE MARA-MBRSH,
MTART LIKE MARA-MTART,
MEINS LIKE MARA-MEINS,
END OF ATAB.

TYPE-POOLS SLIS.
DATA:REPID LIKE SY-REPID,
KNA1_B TYPE SLIS_T_FIELDCAT_ALV,
LAYOUT_B TYPE SLIS_LAYOUT_ALV,
EVENTS TYPE SLIS_T_EVENT.

REPID = SY-REPID.



SELECT KUNNR LAND1 NAME1 ORT01 FROM KNA1 INTO TABLE ITAB
UP TO 20 ROWS WHERE KUNNR IN KUNNR.

SELECT LIFNR LAND1 NAME1 ORT01 FROM LFA1 INTO TABLE JTAB
UP TO 20 ROWS WHERE LIFNR IN LIFNR.


*SELECT MATNR VBELN FBUDA PSTYV FROM VBRP INTO TABLE ATAB
*UP TO 20 ROWS WHERE VBELN IN MATNR.

CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT'
     EXPORTING
          I_CALLBACK_PROGRAM = REPID.
PERFORM APPENDBLOCK TABLES ITAB USING 'ITAB'.
PERFORM APPENDBLOCK TABLES ITAB USING 'JTAB'.
PERFORM APPENDBLOCK TABLES ITAB USING 'ATAB'.
CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY'.
*---------------------------------------------------------------------*
*       FORM APPENDBLOCK                                              *
*---------------------------------------------------------------------*
*       ........                                                      *
*---------------------------------------------------------------------*
*  -->  KTAB                                                          *
*  -->  ITAB                                                          *
*---------------------------------------------------------------------*
FORM APPENDBLOCK TABLES KTAB USING ITAB.
  CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
       EXPORTING
            I_PROGRAM_NAME     = REPID
            I_INTERNAL_TABNAME = 'JTAB'
            I_INCLNAME         = REPID
       CHANGING
            CT_FIELDCAT        = KNA1_B.

  CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'
       EXPORTING
            IS_LAYOUT   = LAYOUT_B
            IT_FIELDCAT = KNA1_B
            I_TABNAME   = 'JTAB'
            IT_EVENTS   = EVENTS
       TABLES
            T_OUTTAB    = KTAB.
ENDFORM.

Reward Points

Vasanth

Re: run time error

Former Member — Thu, 08 Mar 2007 10:32:29 GMT

HI,

DUDE JUST DEBUG THE PROGRAM FROM THE START AND SEE WHERE THE ERROR IS OR THE STATEMENT WHICH IS TAKING SO MUCH TIME

Re: run time error

Former Member — Thu, 08 Mar 2007 10:32:30 GMT

heay vijay u paste all ur modified code once , we will check that and also the runtime error where ur getting this actually....

use into corresponding fields of table in each select statement.. and check..

Re: run time error

Former Member — Thu, 08 Mar 2007 10:35:16 GMT

chk this select statement

SELECT MATNR MBRSH MTART MEIN FROM VBRP INTO TABLE ATAB

UP TO 20 ROWS WHERE VBELN IN MATNR.

ATAB fields do not match with that in the select fields

Re: run time error

Former Member — Thu, 08 Mar 2007 10:38:52 GMT

its giving me mbrsh as unkown field

vijay

Re: run time error

Former Member — Thu, 08 Mar 2007 10:45:01 GMT

anyone der plzz help....

vijay

Re: run time error

Former Member — Thu, 08 Mar 2007 10:45:52 GMT

Here is ur problem...

DATA:BEGIN OF ATAB OCCURS 1 ,

MATNR LIKE MARA-MATNR,

MBRSH LIKE MARA-MBRSH,

MTART LIKE MARA-MTART,

MEINS LIKE MARA-MEINS,

END OF ATAB.

SELECT MATNR VBELN FBUDA PSTYV FROM VBRP INTO TABLE ATAB

UP TO 20 ROWS WHERE VBELN IN MATNR.

Here ATAB does not contain these fields to place in the target area..

so chamge the declaration of ATAB...

Re: run time error

Former Member — Thu, 08 Mar 2007 10:46:10 GMT

Hi vijay,

One thing i would like to advise is please understand the requirement first and then start coding

If you are not aware what the fields you are using in the report , then it becomes difficult for you

debug the code at each and evry point and understand what is happening

Re: run time error

Former Member — Thu, 08 Mar 2007 10:46:22 GMT

chk the declaration of the table atab. paste ur latest code ..

regards,

madhu

Re: run time error

Former Member — Thu, 08 Mar 2007 10:49:58 GMT

HI ,

U R ATAB FIELD HAS ONLY MATNR FIELD THAT IS MATCHING U R SELECT QUERY

DATA:BEGIN OF ATAB OCCURS 1 ,

MATNR LIKE MARA-MATNR,

MBRSH LIKE MARA-MBRSH,

MTART LIKE MARA-MTART,

MEINS LIKE MARA-MEINS,

END OF ATAB.

SELECT MATNR VBELN FBUDA PSTYV FROM VBRP INTO TABLE ATAB

UP TO 20 ROWS WHERE VBELN IN MATNR.

CHANGE THE STRUCTURE OF ATAB AND INCLUDE THE FOLLOWING IN THAT VBELN ,FBUDA PSTYV .

CHEERS!