Error in the code

[Former Member]

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.

[RichHeilman]

Moved to ABAP Forum.

Regards,

Rich Heilman

[Former Member]

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.

[Former Member]

Please check this link for ABAP Forum:

/community [original link is broken]

Kind Regards

Eswar

[Former Member]

Hi Eswar,

thanks for ur link.

regards,

sangeet.

[Former Member]

Hi Eswar,

thanks for ur link.

regards,

sangeet.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.