topic Re: Difficulty While reading Table.... in Application Development and Automation Discussions

Difficulty While reading Table....

Former Member — Thu, 01 Jun 2006 07:18:57 GMT

Hi All,

i trying to read data from table with multiple condition but it is giving me error,

my code is :

loop at struct.

ind = sy-tabix.

read table itabMAST with key matnr = struct-matnr and WERKS = company and stlan = '5'.

if sy-subrc = 0.

move itabMAST-stlnr to struct-stlnr.

endif.

modify struct index ind transporting stlnr.

endloop.

and error message is giving is

Unable to interpret "WERKS". Possible causes: incorrect Spelling or Comma error.

Pls Help...

Thanks in Advance,

Yunus

Re: Difficulty While reading Table....

Former Member — Thu, 01 Jun 2006 07:22:45 GMT

Hi Yunus,

You can not use logical conditions in the READ statement.

Remove the AND conditions from the READ statement and it will work. READ statement by default takes the condition as AND.

Reward points if it helps.

Regards,

Amit Mishra

Message was edited by: Amit Mishra

Re: Difficulty While reading Table....

Former Member — Thu, 01 Jun 2006 07:22:48 GMT

Hi,

Your problem is the field WERKS is not available in the internal table itabMAST.

Try to bring in the werks in the internal table itabMAST and then use the READ statement.

Also while using read statement there will not be any key word AND used.

Lakshminarayanan.

Please mark helpful answers for points.

Re: Difficulty While reading Table....

Former Member — Thu, 01 Jun 2006 07:26:54 GMT

but instead od and what can i use...bcoz i want to read table with multiple condition..

regards,

yunus

Re: Difficulty While reading Table....

Former Member — Thu, 01 Jun 2006 07:28:49 GMT

Hi,

1. Chek your itabMAST table, is there WERKS fields ??

2. Remove "AND" statement from your "Read Table" statement.

Regards,

Re: Difficulty While reading Table....

andreas_mann3 — Thu, 01 Jun 2006 07:29:43 GMT

hi,

try:


read table itabMAST with key matnr = struct-matnr 
                             WERKS = company 
                             stlan = '5'.

Andreas

Re: Difficulty While reading Table....

aris_hidalgo — Thu, 01 Jun 2006 07:33:41 GMT

Hi, here is another example:

IF sy-subrc <> 0.

MOVE it_equz-hequi TO it_equz_dum2-hequi.

READ TABLE it_equz_dum1 WITH KEY equnr = it_equz-equnr

hequi = it_equz-hequi

BINARY SEARCH.

IF sy-subrc = 0.

SELECT SINGLE anlnr

shtxt

FROM itob

INTO (it_itob-anlnr, it_itob-shtxt)

WHERE equnr EQ it_equz_dum1-hequi.

IF sy-subrc = 0.

MOVE it_itob-anlnr TO it_finaltab-asset_dum.

MOVE it_itob-anlnr TO it_finaltab-asset.

MOVE it_itob-shtxt TO it_finaltab-description.

endif.

Re: Difficulty While reading Table....

Former Member — Thu, 01 Jun 2006 07:34:16 GMT

Hi Yunus,

Please have a look at the following programs in SE38.

DEMO_INT_TABLES_READ_ASSIGNING

DEMO_INT_TABLES_READ_COMPARING

DEMO_INT_TABLES_READ_INDEX

DEMO_INT_TABLES_READ_INDEX_BIN

DEMO_INT_TABLES_READ_TRANSPORT

DEMO_INT_TABLES_READ_TRANSP_NO

Reward points if it helps.

Regards,

Amit Mishra

Re: Difficulty While reading Table....

Former Member — Thu, 01 Jun 2006 07:35:45 GMT

Hi,

First of all i am not sure why you are using the statement ind = sy-tabix.

Your code should look like this:

loop at struct.

ind = sy-tabix.

read table itabMAST with key matnr = struct-matnr

WERKS = company

stlan = '5'.

if sy-subrc = 0.

move itabMAST-stlnr to struct-stlnr.

modify struct index ind transporting stlnr.

endif.

endloop.

Lakshminarayanan