Create Table-View (SAP R/3)

[Former Member]

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

[stefan_koehler]

Hello Sebastian,

the following thread should give you the answers:

Regards

Stefan