Set operator NE in Database View creation in join condition

[Former Member]

Hi Experts,

I have a requirement to set NE(not equal) operator in join condition of Database View creation. Could you please help me how to set in operator.

Join condition :

Ex : BSAK-AUGBL NE BSAK-BELNR.

You know that by default operator is '='. i want to set NE in place of '='.

Thanks,

[Former Member]

Hi Experts,

I have a requirement to set NE(not equal) operator in join condition of Database View creation. Could you please help me how to set in operator.

Join condition :

Ex : BSAK-AUGBL NE BSAK-BELNR.

You know that by default operator is '='. i want to set NE in place of '='.

Thanks,

[RichHeilman]

To me, allowing <> to define a join makes no sense at all. Then you are defining the join condition, you are describing how the records are to be JOINed, you can not join something when the values are not equal.

Regards,

Rich Heilman

[Former Member]

Hi Rich,

I am working with BSAK table . i want to read records where AUGBL ne BELNR. So it is taking more time to execute because of hues data. So i decided to create view by placing the condition BSAK-AUGBL = BSAK-BELNR. So i am creating database view for BASK table. Shall i put the condition NE for database view creation.

Thanks,

[Former Member]

Hi Chinna,

Check whether if there is any possibility or not to include more key fields like bukrs, lifnr, gjahr etc in the where condition, so that you query may result faster. Then, there won't be any necessary to create the view.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa