topic Re: raising a n error message in Application Development and Automation Discussions

raising a n error message

Former Member — Mon, 16 Jun 2008 06:31:22 GMT

DATA: BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

MTART LIKE MARA-MTART,

MATKL LIKE MARA-MATKL,

UOM LIKE MARA-MEINS,

LAEDA LIKE MARA-LAEDA,

END OF ITAB.

DATA: WA_ITAB LIKE LINE OF ITAB.

SELECT * FROM MARA INTO TABLE ITAB WHERE MATNR = '521196'.

LOOP AT ITAB INTO WA_ITAB.

WRITE : WA_ITAB-MATKL.

ENDLOOP.

messaging is coming as 'The work area "ITAB" is not long enough.'

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:33:38 GMT

Make data declaration as:

TYPES: BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

MTART LIKE MARA-MTART,

MATKL LIKE MARA-MATKL,

UOM LIKE MARA-MEINS,

LAEDA LIKE MARA-LAEDA,

END OF ITAB.

DATA: WA_ITAB TYPE ITAB.

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:34:26 GMT

Declare the internal table

data: itab like mara occurs 0 with header line.

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:37:30 GMT

Hi,

Ur selecting all feilds fron mara into ITAB but in Itab there only few filds declared.

So use

data itab like mara occurs 0 with header line.

SELECT MATNR MTART MATKL UOM LAEDA FROM MARA INTO TABLE ITAB WHERE MATNR = '521196'.

Reward pts if helpfull.

Regards,

Dhan

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:37:55 GMT

you are selecting all the columns (using SELECT *) but your itab has only five fields...this is the reason for this error msg...

either declare your table as

data itab type table of mara.

modify your select statement to select only the fields that are a part of the internal table

SELECT MATNR MTART MATKL MEINS LAEDA FROM MARA INTO TABLE ITAB WHERE MATNR = '521196'.

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:38:18 GMT

TYPES: BEGIN OF TY_ITAB,
MATNR LIKE MARA-MATNR,
MTART LIKE MARA-MTART,
MATKL LIKE MARA-MATKL,
UOM LIKE MARA-MEINS,
LAEDA LIKE MARA-LAEDA,
END OF TY_ITAB.

DATA: ITAB TYPE TABLE  OF TY_ITAB,
          WA_ITAB TYPE TY_ITAB.

Regards

Kannaiah

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:38:56 GMT

hi,

Itab has

MATNR

MTART

MATKL

UOM

LAEDA only these fields

use

select MATNR

MTART

MATKL

UOM

LAEDA from mara

INTO TABLE ITAB WHERE MATNR = '521196'.

Reward points if helpful

Regards,

priya

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:39:21 GMT

Hi,

You have created an internal table with 5 fields and you are trying to fill that table with all the fields from the table MARA.

SO you either modify the SELECT stmt by changing * to 5 fields or change the structure of the internal table to mara.

SELECT MATNR MTART MATKL MEINS LAEDA LAEDA,

FROM MARA INTO TABLE ITAB WHERE MATNR = '521196'

data : BEGIN OF ITAB OCCURS 0.

include structure mara.

data end of itab.

Thanks and Regards.

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:40:08 GMT

Hi,

Chnage the select statement as below :



DATA: BEGIN OF ITAB OCCURS 0,
MATNR LIKE MARA-MATNR,
MTART LIKE MARA-MTART,
MATKL LIKE MARA-MATKL,
UOM LIKE MARA-MEINS,
LAEDA LIKE MARA-LAEDA,
END OF ITAB.


DATA: WA_ITAB LIKE LINE OF ITAB.


SELECT * FROM MARA INTO corresponding fields of TABLE ITAB WHERE MATNR = '521196'.

LOOP AT ITAB INTO WA_ITAB.
WRITE : WA_ITAB-MATKL.
ENDLOOP.

Thanks,

Sriram Ponna.

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:40:44 GMT

Unable to interpret "OCCURS". Possible causes of error: Incorrect spelling or comma error.

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:41:55 GMT

Hi,

you should use 'CORRESPONDING FIELDS OF 'in the select statement..

Regards,

venkat n

Re: raising a n error message

Former Member — Mon, 16 Jun 2008 06:45:27 GMT

hi,

Tables : mara .

DATA: BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

MTART LIKE MARA-MTART,

MATKL LIKE MARA-MATKL,

UOM LIKE MARA-MEINS,

LAEDA LIKE MARA-LAEDA,

END OF ITAB.

DATA: WA_ITAB LIKE LINE OF ITAB.

SELECT * FROM MARA INTO corresponding fields of TABLE ITAB WHERE MATNR = '521196'.

if sy-subrc = 0.

LOOP AT ITAB INTO WA_ITAB.

WRITE : WA_ITAB-MATKL.

ENDLOOP.

endif.