topic Re: select ERR in Application Development and Automation Discussions

select ERR

Former Member — Mon, 03 Jul 2006 08:01:57 GMT

i made this select and get err

23 when acsesing table mardh

LOOP AT imard ASSIGNING <ls_mard>.

IF <ls_mard>-lfgja < year.

<ls_mard>-s_stock = <ls_mard>-labst.

<ls_mard>-e_stock = <ls_mard>-labst.

ELSE.

CONCATENATE <ls_mard>-lfmon <ls_mard>-lfgja INTO zmon_year.

current period in mard is smaller then s.screen period

IF zmon_year < z_period.

<ls_mard>-s_stock = <ls_mard>-labst.

<ls_mard>-e_stock = <ls_mard>-labst.

ELSE.

SELECT lgort

matnr

lfgja

lfmon

labst

FROM mardh

INTO TABLE imardh

WHERE matnr = <ls_mard>-matnr

AND werks = <ls_mard>-werks

AND lgort = <ls_mard>-lgort.

Re: select ERR

Former Member — Mon, 03 Jul 2006 08:05:54 GMT

LOOP AT imard ASSIGNING <ls_mard>.

IF <ls_mard>-lfgja < year.

<ls_mard>-s_stock = <ls_mard>-labst.

<ls_mard>-e_stock = <ls_mard>-labst.

ELSE.

CONCATENATE <ls_mard>-lfmon <ls_mard>-lfgja INTO zmon_year.

current period in mard is smaller then s.screen period

IF zmon_year < z_period.

<ls_mard>-s_stock = <ls_mard>-labst.

<ls_mard>-e_stock = <ls_mard>-labst.

ELSE.

SELECT lgort

matnr

lfgja

lfmon

labst

FROM mardh

INTO TABLE imardh

WHERE matnr = <ls_mard>-matnr

AND werks = <ls_mard>-werks

AND lgort = <ls_mard>-lgort.

in ur code loop and after select opration used same table how it is updated ...

better to use diffrent internal tables.

Re: select ERR

JoseMunoz — Mon, 03 Jul 2006 08:13:28 GMT

Try that:

LOOP AT imard ASSIGNING <ls_mard>.

IF <ls_mard>-lfgja < year.

<ls_mard>-s_stock = <ls_mard>-labst.

<ls_mard>-e_stock = <ls_mard>-labst.

ELSE.

CONCATENATE <ls_mard>-lfmon <ls_mard>-lfgja INTO zmon_year.

current period in mard is smaller then s.screen period

IF zmon_year < z_period.

<ls_mard>-s_stock = <ls_mard>-labst.

<ls_mard>-e_stock = <ls_mard>-labst.

ELSE.

SELECT lgort

matnr

lfgja

lfmon

labst

FROM mardh

INTO CORRESPONDING FIELDS OF TABLE imardh

WHERE matnr = <ls_mard>-matnr

AND werks = <ls_mard>-werks

AND lgort = <ls_mard>-lgort.

Re: select ERR

Former Member — Mon, 03 Jul 2006 08:18:32 GMT

Can you check into the decaration of the internal table imardh. Declare the internal table in the below order and also use the same order in the select statement.

matnr

lgort

lfgja

lfmon

labst

I suggest you to always select the fields in the order in which there are in the table. One way it always increase the performance of your selection.

rgds,

TM.