topic Re: Error in the code in Application Development and Automation Discussions

Error in the code

Former Member — Tue, 31 Oct 2006 06:03:10 GMT

Hi All,

this is Sangeet,I'm new to this community.I've been facing a problem regarding the following code--

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

SELECT lfa1~lifnr

lfa1~name1

ekko~ebeln

ekpo~ebelp

ekko~aedat

ekpo~matnr

mseg~menge

mseg~meins

ekpo~netpr

mseg~waers

mseg~erfmg

ekbe~dmbtr

INTO TABLE itab

FROM ekko INNER JOIN lfa1

ON ekko_{lifnr EQ lfa1}lifnr

INNER JOIN ekpo

ON ekko_{ebeln EQ ekpo}ebeln

INNER JOIN ekbe

ON ekko_{ebeln EQ ekbe}ebeln

INNER JOIN mseg

ON ekko_{waers EQ mseg}waers

WHERE ekko~aedat IN s_aedat

AND ekpo~matnr IN s_matnr.

IF sy-subrc NE 0.

MESSAGE 'DATA NOT FOUND' TYPE 'E'.

ENDIF.

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

It shows a runtime error like--storage_parameters_wrong_set n that when the OS requested for memory there was memory shortage.

Can anyone pls help me out ?

Regards.

Sangeet.

Re: Error in the code

RichHeilman — Tue, 31 Oct 2006 13:27:51 GMT

Moved to ABAP Forum.

Regards,

Rich Heilman

Re: Error in the code

Former Member — Tue, 31 Oct 2006 13:32:17 GMT

You are attempting to select too many records from database.

Remove

"INNER JOIN mseg

ON ekko_{waers EQ mseg}waers"

You should replace waers with document number in this condition.

Re: Error in the code

Former Member — Tue, 31 Oct 2006 13:44:19 GMT

Yes you should make like this

INNER JOIN ekbe

ON ekko_{ebeln EQ ekbe}ebeln

INNER JOIN mseg

ON ekko_{ebeln EQ mseg}ebeln

Regards

Sebastien

Re: Error in the code

Former Member — Mon, 13 Nov 2006 06:11:19 GMT

Hi Rich ,

thanks for ur reply .

Could u pls direct where should i check for ABAp forum ?

Anyways, my query has been resolved .

Thanks.

Sangeet.

Re: Error in the code

Former Member — Mon, 13 Nov 2006 06:13:50 GMT

Hi Tomasz,

thanks for ur reply .

But I guess since waers is not a key field n that I'm preparing the report basing on the document No. so waers I suppose could not be used.

Anyways, my query has been resolved .

Thanks.

Sangeet.

Re: Error in the code

Former Member — Mon, 13 Nov 2006 06:14:27 GMT

Please check this link for ABAP Forum:

/community [original link is broken]

Kind Regards

Eswar

Re: Error in the code

Former Member — Mon, 13 Nov 2006 06:17:17 GMT

Hi Sebastien,

thanks for your reply .

It was very useful ..as when I applied ur suggestion to my problem.I could prepare the reportn I was perhaps selecting too many records.Thanks for your timely reply.Thanks.

Regards,

Sangeet.

Re: Error in the code

Former Member — Mon, 13 Nov 2006 06:21:24 GMT

Hi All,

can anybody suggest me how could I enter text say for e.g; an address in the footer area in Smart Form.

Coz on right clicking it I could find nothing except creating table line, flow logic n folder.

Thanks.

Sangeet.

Re: Error in the code

Former Member — Mon, 13 Nov 2006 06:36:33 GMT

Hi sangeet

Click right button on footer window and write whatever u want

You will get Text when u click right button on footer window

Re: Error in the code

Former Member — Mon, 13 Nov 2006 06:47:07 GMT

Hi r k,

but when I right click I don't get anything except table line, flow logic n folder ,,n no scope for creating a new window.Thats the problem.

regards.

sangeet.

Re: Error in the code

Former Member — Mon, 13 Nov 2006 11:17:25 GMT

Hi Eswar,

thanks for ur link.

regards,

sangeet.

Re: Error in the code

Former Member — Mon, 13 Nov 2006 11:21:11 GMT

Hi Eswar,

thanks for ur link.

regards,

sangeet.