Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

for all entries showing problem

Former Member
0 Kudos

Hi

I am getting an error while checking this query.

FOR ALL entries IN i_output

WHERE vbrp~aubel EQ i_output-zuonr AND " Sal doc

vbrp~vbeln EQ i_output-vbeln AND " Bill Doc

i_output-blart eq 'RV'.

error is i_output-blar is unknown

Regards

Sebastian

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi,

think u have not declared i_output-blar in the I_OUTPUT Internal Table. check it out and revert back.

8 REPLIES 8

Former Member
0 Kudos

Hi Sebastian,

Chk out the fields in i_output,

for the cide what you have written:

FOR ALL entries IN i_output

WHERE vbrp~aubel EQ i_output-zuonr AND " Sal doc

vbrp~vbeln EQ i_output-vbeln AND " Bill Doc

i_output-blart eq 'RV'.

error is i_output-blar is unknown

check whether its i_output-blar or i_output-blart

Thanks and Regards

Srikanth.P

former_member555112
Active Contributor
0 Kudos

Hi,

You cannot use "i_output-blart eq 'RV'."

You cannot use the field of the internal table used in 'FOR ALL ENTRIES' in you where clause as a condition.

Please understand that you are selecting from a database table and hence you can olny use the fields of your database table in the where statement.

You are not selecting anything from your internal table.

You are just using it to compare.

Regards,

Ankur Parab

Former Member
0 Kudos

hi,

think u have not declared i_output-blar in the I_OUTPUT Internal Table. check it out and revert back.

Former Member
0 Kudos

Hi,

FOR ALL entries IN i_output
WHERE vbrp~aubel EQ i_output-zuonr AND " Sal doc
vbrp~vbeln EQ i_output-vbeln AND " Bill Doc
i_output-blart eq 'RV'.

You cannot give i_output-blart in where clause. Select statement where clause will consider only the tables which you have in FROM .

i_output is an internal table which you cannot add in select statement where clause.

Regards,

Raghavendra

Former Member
0 Kudos

Hi,

Filter your internal table i_output with doc. type 'RV' before using the select statement or create another int table which has only RV doc type and dont include this condition in the where cond.

Regards,

Pankaj

Former Member
0 Kudos

Hi,

FOR ALL entries IN i_output

WHERE vbrp~aubel EQ i_output-zuonr AND " Sal doc

vbrp~vbeln EQ i_output-vbeln AND " Bill Doc

i_output-blart eq 'RV'.

if you want only records which satisfy i_output-blart eq 'RV'. you might have to right condition before using i_output in forall entries. modify table i_output for which the condition i_output-blart eq 'RV' will satisfy then write the query as below.

FOR ALL entries IN i_output

WHERE vbrp~aubel EQ i_output-zuonr AND " Sal doc

vbrp~vbeln EQ i_output-vbeln.

Former Member
0 Kudos

Thanks

Former Member
0 Kudos

Hi,

i_output-BLAR field is not there thy the error is comming.

regards,

Munibabu.K