Errors in view

[Former Member]

Hi experts,

my view is showing errors like, "Filed MSEG-MJAHR does not belomg to base table"

I joined using the condition MSEG.MJHAR = EKBE.GJHAR.

and i have done the below selection

MSEG MBLNR EQ OR

MSEG ZEILE EQ OR

MSEG MJAHR EQ OR

MSEG MATNR EQ OR

MSEG LIFNR EQ OR

MSEG EBELN EQ AND

MSEG EBELP

and getting error like 'OR links only permitted for the same field

field MSEG-EBELP (Type conflict in selection condition)

operator is not allowed in selection condition

Please let me know what could be the problem and what needs to be changed.

thanks in advance

Regards

sai

[Former Member]

Hi Sai,

In this case,

my view is showing errors like, "Filed MSEG-MJAHR does not belomg to base table"

I joined using the condition MSEG.MJHAR = EKBE.GJHAR.

It expectes another base table which is referred by MSG-MJAHR and find that table and included in base table list.

In the follwong case ,

MSEG MBLNR EQ OR

MSEG ZEILE EQ OR

MSEG MJAHR EQ OR

MSEG MATNR EQ OR

MSEG LIFNR EQ OR

MSEG EBELN EQ AND

MSEG EBELP .

When you specify a select condition ,

the syntax is

Table fielname Operator Comparison value AND/OR.

In your aboove statement , you are not specifying any Comparison values after Operators.I think you mentioned AND/OR in place of Comparison value filed.So, it gives error like " operator is not allowed in selection condition ".

I hope, it will help you correct errors.

By

Prasad GVK

[Former Member]

Hi Sai,

Please let me know the selection.means if you want to get data for a specific material 'ABC' then u will give selection as

select * from mara into itap where matnr = 'ABC'.

like above statement please let me know your selection statement.

thanks,

Krishna

[Former Member]

Hi,

Put some condition values after the comparison operator

For Example

Select Single * From MSEG where mjahr EQ '2008' or

mblnr EQ wa_mkpf-mblnr and

bwart in ( '601','602' ) .

Try like this.

other wise press F1 to see the help documents

how to use and solve to error.

Regds

sachhi

Edited by: Sachhidananda Tripathy on Mar 24, 2009 2:58 PM