Skip to Content
avatar image
Former Member

Create Table-View (SAP R/3)

Hi there,

i want to create a table view with a simple join of 2 Tables. I try to do this with the SE11 transaction. But my problem is that i cannot enter a "select-Statement" like on a normal "SQL-Editor/Browser". I have to use the GUI to enter the select-statement. But the GUI doesn't deliver a full functionality.

e.g.

CREATE VIEW v_test

AS SELECT matnr, nltyp, sum(nistm),

FROM vekp a, ltap b

WHERE a.exidv = b.vlenr

AND nltyp in ('231', '232', '233')

GROUP BY matnr, nltyp,

Problems with SE11

1) i cannot add a "sum()"

2) i cannot add a "in ()"

3) i cannot add a GROUP BY

Does anybody know how to create a more flexble table view in SE11? Does there exist a SQL-Editor ? Or does anybondy know an other transaction to create these table-views ?

Thanks,

Sebastian

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 04, 2010 at 12:53 PM

    Hello Sebastian,

    the following thread should give you the answers:

    group-by-clause-in-database-views

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded