Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to create view, with DISTINCT statement ?

Former Member

‎2008 Feb 15 10:25 AM

0 Likes
1,783

Hello,

I'm trying to create a view on a table, in SE11 transaction (type Database View). I would like defined an DISTINCT SQL statement but I don't know how to and where do this.

I also take this thread to ask you, why it's not possible to define join conditions with operators like : > < >= <= ? Only '=' operator is available in tab 'Table/Join Conditions' ?

Another SAP newbie question ... is it possible to define views by taping directly SQL statement ?

Thanks a lot,

GC.

Hello,

I'm trying to create a view on a table, in SE11 transaction (type Database View). I would like defined an DISTINCT SQL statement but I don't know how to and where do this.

I also take this thread to ask you, why it's not possible to define join conditions with operators like : > < >= <= ? Only '=' operator is available in tab 'Table/Join Conditions' ?

Another SAP newbie question ... is it possible to define views by taping directly SQL statement ?

Thanks a lot,

GC.

Reply
5 REPLIES 5
Read only

Former Member

‎2008 Feb 29 8:45 AM

0 Likes
986

nobody ?

Read only

Former Member

‎2008 Mar 19 7:11 AM

0 Likes
986

first you create a view in transaction se11

and while writing sql query in transaction se38

you use distinct statement

reward if useful

Edited by: sathish kumar on Mar 19, 2008 8:12 AM

Read only

Former Member
In response to Former Member

‎2008 Mar 20 5:38 PM

0 Likes
986

Thanks, but I already do that.

My question is, is it possible to create directly a view "useful" (with distinct statement, with join ...) for an BW extractor for example ?

(Thus avoiding extractor based on function modules, when it's not really necessary ...)

Read only

Former Member
In response to Former Member

‎2008 Mar 20 7:27 PM

0 Likes
986

I don't think it is possible. But you could still handle the duplicates on the BW side using an R/3 view. Just load a DSO, and overwrite the dups.