topic Re: Synatx error with READ statement in Application Development and Automation Discussions

Synatx error with READ statement

Former Member — Thu, 24 Jan 2008 12:39:37 GMT

Is the below syntax correct

Read table itab1 with key a = it_tab2-a and b = it_tab2-b and c = it_tab2-c.

The above syntax is showing some error

Re: Synatx error with READ statement

Former Member — Thu, 24 Jan 2008 12:41:01 GMT

remove all 'and'

Read table itab1 with key a = it_tab2-a

b = it_tab2-b

c = it_tab2-c.

Re: Synatx error with READ statement

Peter_Lintner — Thu, 24 Jan 2008 12:41:54 GMT

Hi!

The correct syntax is:

Read table itab1 with key a = it_tab2-a

b = it_tab2-b

c = it_tab2-c.

Kind regards,

Peter

Re: Synatx error with READ statement

Former Member — Thu, 24 Jan 2008 12:41:54 GMT

Hope it will help you.

reward if help.

Read table doesn't allow ne operator.

It reads only one record...Either by index or key.

READ TABLE MY_TAB INDEX 1.

READ TABLE MY_TAB WITH KEY CODE = 'ATG'.

these are the results for SY-SUBRC checks after read table

SY-SUBRC = 0:

An entry was read.

SY-TABIX is set to the index of the entry.

SY-SUBRC = 2:

An entry was read.

SY-TABIX is set to the index of the entry. This return code can only occur when you use the COMPARING addition. For further detauls, refer to the COMPARING section of the additions

SY-SUBRC = 4:

No entry was read.

The value of SY-TABIX depends on the table type and whether the BINARY SEARCH addition was specified.

If the table is a SORTED TABLE or a table sorted in ascending order of the type STANDARD TABLE with the BINARY SEARCH addition, SY-TABIX refers to the next-highest index.

Otherwise, SY-TABIX is undefined.

SY-SUBRC = 8:

No entry was read.

This return code only occurs with a SORTED TABLE or a STANDARD TABLE with the BINARY SEARCH addition. SY-TABIX is set to the number of all entries plus 1.

Reading records with keys

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb35f8358411d1829f0000e829fbfe/content.htm

Reading lines with Index

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3730358411d1829f0000e829fbfe/content.htm

Re: Synatx error with READ statement

Former Member — Thu, 24 Jan 2008 12:42:16 GMT

Hi,

Write as below

Data: wa1 like line of itab1.

Read table itab1 into wa1 with key a = it_tab2-a b = it_tab2-b c = it_tab2-c.

Regards,

Satish

Re: Synatx error with READ statement

Former Member — Thu, 24 Jan 2008 12:46:16 GMT

Hi,

The correct syntax is

READ TABLE itab1 WITH KEY a = itab2-field1

b = itab2-field2.

If itab1 and itab2 are defined with header line.

If they do not have a header line then declare work areas for them and read as follows :

READ TABLE itab1 INTO wa1 WITH KEY a = wa2-field1

b = wa2-field2.

Re: Synatx error with READ statement

Former Member — Thu, 24 Jan 2008 12:50:20 GMT

Hi,

Don't use AND in read statement. Try it

Read table itab1 with key a = it_tab2-a

b = it_tab2-b

c = it_tab2-c

L.Velu

Re: Synatx error with READ statement

Former Member — Thu, 24 Jan 2008 12:51:47 GMT

Hi ajay, ur iab1 should contains a, b, c fileds, and it_tab2 also should contain a, b, c fields.

then remove and in ur syntax.

loop at it_tab2.

read table itab1 with key a = it_tab2-a

b = it_tab2-b

c = it_tab2-c.

process code......

endloop.