topic Re: Error in this application in Application Development and Automation Discussions

Error in this application

Former Member — Thu, 27 Sep 2007 07:11:40 GMT

CAN any one say why i am gettin the run time error in this application...

i am sending u the code and the error also....

&----

*& Report Z_SB_RP_MATERIAL

&----

REPORT Z_SB_RP_MATERIAL

NO STANDARD PAGE HEADING

LINE-SIZE 200

LINE-COUNT 60(2).

**************************************************************

TABLES DECLARATION *

**************************************************************

TABLES: MARA,

MARD,

MAKT,

MARC,

EINA,

EINE.

**************************************************************

INTERNAL TABLES DECLARATIONS *

**************************************************************

DATA: BEGIN OF ITAB OCCURS 10,

MATNR LIKE MARA-MATNR,

MEINS LIKE MARA-MEINS,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

SPART LIKE MARA-SPART,

MAKTX LIKE MAKT-MAKTX,

LVORM LIKE MARC-LVORM,

EKGRP LIKE MARC-EKGRP,

WERKS LIKE MARC-WERKS,

LABST LIKE MARD-LABST,

SPEME LIKE MARD-SPEME,

LGORT LIKE MARD-SPEME,

END OF ITAB.

DATA: BEGIN OF ITAB1 OCCURS 3,

INFNR LIKE EINA-INFNR,

MATKL LIKE EINA-MATKL,

LIFNR LIKE EINA-LIFNR,

EKORG LIKE EINE-EKORG,

ERDAT LIKE EINE-ERDAT,

ERNAM LIKE EINE-ERNAM,

NETPR LIKE EINE-NETPR,

END OF ITAB1.

**************************************************************

SELECTION-SCREEN *

**************************************************************

SELECTION-SCREEN BEGIN OF BLOCK BLK WITH FRAME TITLE TEXT-T01.

SELECT-OPTIONS: SMATNR FOR MARA-MATNR,

SERSDA FOR MARA-ERSDA,

SWERKS FOR MARC-WERKS,

SLGORT FOR MARD-LGORT.

SELECTION-SCREEN END OF BLOCK BLK.

**************************************************************

TOP-OF-PAGE *

**************************************************************

TOP-OF-PAGE.

ULINE (152).

WRITE:/ SY-VLINE,

02 'S.NO',

06 SY-VLINE,

08 'MATNR',

20 SY-VLINE,

22 'MEINS',

32 SY-VLINE,

34 'ERSDA',

44 SY-VLINE,

46 'ERNAM',

56 SY-VLINE,

58 'SPART',

68 SY-VLINE,

70 'MAKTX',

80 SY-VLINE,

82 'LVORM',

92 SY-VLINE,

94 'EKGRP',

104 SY-VLINE,

106 'WERKS',

116 SY-VLINE,

118 'LABST',

128 SY-VLINE,

130 'SPEME',

140 SY-VLINE,

142 'LGORT',

152 SY-VLINE.

ULINE (152).

**************************************************************

START-OF-SELECTION *

**************************************************************

START-OF-SELECTION.

SELECT T1~MATNR

T1~MEINS

T1~ERSDA

T1~ERNAM

T1~SPART

T2~MAKTX

T3~LVORM

T3~EKGRP

T3~WERKS

T4~LABST

T4~SPEME

T4~LGORT

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM MARA AS T1

INNER JOIN MAKT AS T2

ON T1_{MATNR = T2}MATNR

INNER JOIN MARC AS T3

ON T2_{MATNR = T3}MATNR

INNER JOIN MARD AS T4

ON T3_{MATNR = T4}MATNR

WHERE T1~MATNR IN SMATNR.

**************************************************************

END-0F-SELECTION *

**************************************************************\

END-OF-SELECTION.

DATA: COUNT(4) TYPE N.

LOOP AT ITAB.

COUNT = COUNT + 1.

WRITE:/ SY-VLINE,

02 COUNT,

06 SY-VLINE,

08 ITAB-MATNR,

20 SY-VLINE,

22 ITAB-MEINS,

32 SY-VLINE,

34 ITAB-ERSDA,

44 SY-VLINE,

46 ITAB-ERNAM,

56 SY-VLINE,

58 ITAB-SPART,

68 SY-VLINE,

70 ITAB-MAKTX,

80 SY-VLINE,

82 ITAB-LVORM,

92 SY-VLINE,

94 ITAB-EKGRP,

104 SY-VLINE,

106 ITAB-WERKS,

116 SY-VLINE,

118 ITAB-LABST,

128 SY-VLINE,

130 ITAB-SPEME,

140 SY-VLINE,

142 ITAB-LGORT,

152 SY-VLINE.

HIDE ITAB-MATNR.

ENDLOOP.

ULINE (152).

**************************************************************

AT LINE-SELECTION *

**************************************************************

AT LINE-SELECTION.

SELECT T4~INFNR

T4~MATKL

T4~LIFNR

T5~EKORG

T5~ERDAT

T5~ERNAM

T5~NETPR

INTO CORRESPONDING FIELDS OF TABLE ITAB1

FROM EINA AS T4

INNER JOIN EINE AS T5

ON T4_{INFNR = T5}INFNR.

ULINE (160).

WRITE:/ SY-VLINE,

03 'NUMBER OF PURCHASING INFO RECORD',

30 SY-VLINE,

32 'MATERIAL GROUP',

45 SY-VLINE,

47 'VENDOR ACC.NUMBER',

60 'SY-VLINE',

62 'PURCHASING ORGANIZATION',

80 SY-VLINE,

82 'DATA ON WHICH THE RECORD WAS CREATED',

105 SY-VLINE,

107 'NAME OF THE PERSON WHO CREATED THE OBJECT',

130 SY-VLINE,

132 'NET PRICE IN PURCHASING INFO RECORD',

160 SY-VLINE.

ULINE (160).

LOOP AT ITAB1.

WRITE:/ SY-VLINE,

03 ITAB1-INFNR,

30 SY-VLINE,

32 ITAB1-MATKL,

45 SY-VLINE,

47 ITAB1-LIFNR,

60 SY-VLINE,

62 ITAB1-EKORG,

80 SY-VLINE,

82 ITAB1-ERDAT,

105 SY-VLINE,

107 ITAB1-ERNAM,

130 SY-VLINE,

132 ITAB1-NETPR,

160 SY-VLINE.

ENDLOOP.

ULINE (160).

RUN TIME ERROR:---

Runtime Errors DBIF_RSQL_INVALID_RSQL

Except. CX_SY_OPEN_SQL_DB

Date and Time 27.09.2007 00:51:18

Short text

RSQL error 23 when accessing table "MARA ".

Missing Handling of System Exception

Program !_SB_RP_MATERIAL

Trigger Location of Exception

Program !_SB_RP_MATERIAL

Include !_SB_RP_MATERIAL

Row 102

Module Name START-OF-SELECTION

Source Code Extract

Line SourceCde

72 22 'MEINS',

73 32 SY-VLINE,

74 34 'ERSDA',

75 44 SY-VLINE,

76 46 'ERNAM',

77 56 SY-VLINE,

78 58 'SPART',

79 68 SY-VLINE,

80 70 'MAKTX',

81 80 SY-VLINE,

82 82 'LVORM',

83 92 SY-VLINE,

84 94 'EKGRP',

85 104 SY-VLINE,

86 106 'WERKS',

87 116 SY-VLINE,

88 118 'LABST',

89 128 SY-VLINE,

90 130 'SPEME',

91 140 SY-VLINE,

92 142 'LGORT',

93 152 SY-VLINE.

95 ULINE (152).

96 ULINE (152).

98 **************************************************************

99 * START-OF-SELECTION *

100 **************************************************************

101 START-OF-SELECTION.

>>>>> SELECT T1~MATNR

103 T1~MEINS

104 T1~ERSDA

105 T1~ERNAM

106 T1~SPART

107 T2~MAKTX

108 T3~LVORM

109 T3~EKGRP

110 T3~WERKS

111 T4~LABST

112 T4~SPEME

113 T4~LGORT

114 INTO CORRESPONDING FIELDS OF TABLE ITAB

115 FROM MARA AS T1

116 INNER JOIN MAKT AS T2

117 ON T1_{MATNR = T2}MATNR

118 INNER JOIN MARC AS T3

119 ON T2_{MATNR = T3}MATNR

120 INNER JOIN MARD AS T4

121 ON T3_{MATNR = T4}MATNR

THANX & REGARDS,

PHANINDER

Re: Error in this application

JozsefSzikszai — Thu, 27 Sep 2007 07:21:00 GMT

hi Phaninder,

SQL Error ==> this means that you have to talk to basis guys and ask them!

Re: Error in this application

Former Member — Thu, 27 Sep 2007 07:21:04 GMT

Hi,

you have an error in type declearation for table ITAB.

SPEME LIKE MARD-SPEME,

LGORT LIKE MARD-SPEME,

Regards,

Tanmay

Re: Error in this application

former_member188827 — Thu, 27 Sep 2007 07:26:14 GMT

in declaration:

instead of..

LGORT LIKE MARD-SPEME,

use

LGORT LIKE MARD-lgort,

Re: Error in this application

Former Member — Thu, 27 Sep 2007 07:26:14 GMT

DATA: BEGIN OF ITAB OCCURS 10,

MATNR LIKE MARA-MATNR,

MEINS LIKE MARA-MEINS,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

SPART LIKE MARA-SPART,

MAKTX LIKE MAKT-MAKTX,

LVORM LIKE MARC-LVORM,

EKGRP LIKE MARC-EKGRP,

WERKS LIKE MARC-WERKS,

LABST LIKE MARD-LABST,

SPEME LIKE MARD-SPEME,

LGORT LIKE MARD-SPEME,

END OF ITAB.

check the second last line declaration

Check your all declaration. The error was because it was unable to move data in tabe ITAB

Re: Error in this application

Former Member — Thu, 27 Sep 2007 07:30:02 GMT

<b>SMALL MISTAKE</b>

&----

*& Report Z_SB_RP_MATERIAL

&----

REPORT Z_SB_RP_MATERIAL

NO STANDARD PAGE HEADING

LINE-SIZE 200

LINE-COUNT 60(2).

**************************************************************

TABLES DECLARATION *

**************************************************************

TABLES: MARA,

MARD,

MAKT,

MARC,

EINA,

EINE.

**************************************************************

INTERNAL TABLES DECLARATIONS *

**************************************************************

DATA: BEGIN OF ITAB OCCURS 10,

MATNR LIKE MARA-MATNR,

MEINS LIKE MARA-MEINS,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

SPART LIKE MARA-SPART,

MAKTX LIKE MAKT-MAKTX,

LVORM LIKE MARC-LVORM,

EKGRP LIKE MARC-EKGRP,

WERKS LIKE MARC-WERKS,

LABST LIKE MARD-LABST,

SPEME LIKE MARD-SPEME,

<b>LGORT LIKE MARD-LGORT,</b>

END OF ITAB.

DATA: BEGIN OF ITAB1 OCCURS 3,

INFNR LIKE EINA-INFNR,

MATKL LIKE EINA-MATKL,

LIFNR LIKE EINA-LIFNR,

EKORG LIKE EINE-EKORG,

ERDAT LIKE EINE-ERDAT,

ERNAM LIKE EINE-ERNAM,

NETPR LIKE EINE-NETPR,

END OF ITAB1.

**************************************************************

SELECTION-SCREEN *

**************************************************************

SELECTION-SCREEN BEGIN OF BLOCK BLK WITH FRAME TITLE TEXT-T01.

SELECT-OPTIONS: SMATNR FOR MARA-MATNR,

SERSDA FOR MARA-ERSDA,

SWERKS FOR MARC-WERKS,

SLGORT FOR MARD-LGORT.

SELECTION-SCREEN END OF BLOCK BLK.

**************************************************************

TOP-OF-PAGE *

**************************************************************

TOP-OF-PAGE.

ULINE (152).

WRITE:/ SY-VLINE,

02 'S.NO',

06 SY-VLINE,

08 'MATNR',

20 SY-VLINE,

22 'MEINS',

32 SY-VLINE,

34 'ERSDA',

44 SY-VLINE,

46 'ERNAM',

56 SY-VLINE,

58 'SPART',

68 SY-VLINE,

70 'MAKTX',

80 SY-VLINE,

82 'LVORM',

92 SY-VLINE,

94 'EKGRP',

104 SY-VLINE,

106 'WERKS',

116 SY-VLINE,

118 'LABST',

128 SY-VLINE,

130 'SPEME',

140 SY-VLINE,

142 'LGORT',

152 SY-VLINE.

ULINE (152).

**************************************************************

START-OF-SELECTION *

**************************************************************

START-OF-SELECTION.

SELECT T1~MATNR

T1~MEINS

T1~ERSDA

T1~ERNAM

T1~SPART

T2~MAKTX

T3~LVORM

T3~EKGRP

T3~WERKS

T4~LABST

T4~SPEME

T4~LGORT

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM MARA AS T1

INNER JOIN MAKT AS T2

ON T1_{MATNR = T2}MATNR

INNER JOIN MARC AS T3

ON T2_{MATNR = T3}MATNR

INNER JOIN MARD AS T4

ON T3_{MATNR = T4}MATNR

WHERE T1~MATNR IN SMATNR.

**************************************************************

END-0F-SELECTION *

**************************************************************\

END-OF-SELECTION.

DATA: COUNT(4) TYPE N.

LOOP AT ITAB.

COUNT = COUNT + 1.

WRITE:/ SY-VLINE,

02 COUNT,

06 SY-VLINE,

08 ITAB-MATNR,

20 SY-VLINE,

22 ITAB-MEINS,

32 SY-VLINE,

34 ITAB-ERSDA,

44 SY-VLINE,

46 ITAB-ERNAM,

56 SY-VLINE,

58 ITAB-SPART,

68 SY-VLINE,

70 ITAB-MAKTX,

80 SY-VLINE,

82 ITAB-LVORM,

92 SY-VLINE,

94 ITAB-EKGRP,

104 SY-VLINE,

106 ITAB-WERKS,

116 SY-VLINE,

118 ITAB-LABST,

128 SY-VLINE,

130 ITAB-SPEME,

140 SY-VLINE,

142 ITAB-LGORT,

152 SY-VLINE.

HIDE ITAB-MATNR.

ENDLOOP.

ULINE (152).

**************************************************************

AT LINE-SELECTION *

**************************************************************

AT LINE-SELECTION.

SELECT T4~INFNR

T4~MATKL

T4~LIFNR

T5~EKORG

T5~ERDAT

T5~ERNAM

T5~NETPR

INTO CORRESPONDING FIELDS OF TABLE ITAB1

FROM EINA AS T4

INNER JOIN EINE AS T5

ON T4_{INFNR = T5}INFNR.

ULINE (160).

WRITE:/ SY-VLINE,

03 'NUMBER OF PURCHASING INFO RECORD',

30 SY-VLINE,

32 'MATERIAL GROUP',

45 SY-VLINE,

47 'VENDOR ACC.NUMBER',

60 'SY-VLINE',

62 'PURCHASING ORGANIZATION',

80 SY-VLINE,

82 'DATA ON WHICH THE RECORD WAS CREATED',

105 SY-VLINE,

107 'NAME OF THE PERSON WHO CREATED THE OBJECT',

130 SY-VLINE,

132 'NET PRICE IN PURCHASING INFO RECORD',

160 SY-VLINE.

ULINE (160).

LOOP AT ITAB1.

WRITE:/ SY-VLINE,

03 ITAB1-INFNR,

30 SY-VLINE,

32 ITAB1-MATKL,

45 SY-VLINE,

47 ITAB1-LIFNR,

60 SY-VLINE,

62 ITAB1-EKORG,

80 SY-VLINE,

82 ITAB1-ERDAT,

105 SY-VLINE,

107 ITAB1-ERNAM,

130 SY-VLINE,

132 ITAB1-NETPR,

160 SY-VLINE.

ENDLOOP.

ULINE (160).

Re: Error in this application

Former Member — Thu, 27 Sep 2007 07:31:39 GMT

first let me know in which version u have executed the programme.........................i have tried it in ecc5.0 the problem is in u r start of selection ...dont use into corresponding fields ...if u r fetching the huge number of data...it will search for every field in the itab then it will place.....it will be better using [into table itab].

and one more thing try to declare two different itabs with mara makt as one and mard marc as one and use for all entries .....

dont use join statement for four tables ......even it is performance issue when u use it for 3 tables....

reward points if helpful

Re: Error in this application

Former Member — Mon, 01 Oct 2007 08:57:50 GMT

thanx to all