Writting select staments on Views

[Former Member]

Shall we write the SELECT statement for the views?

If yes, please let me know how can we write differently for HELP, PROJECTION, MAINTAIN and DATABASE views?

Thanks,

Ranjan

[former_member188685 · Accepted solution]

Hi,

Check the help on Database View

http://help.sap.com/saphelp_nw04/helpdata/en/36/74c0358373003ee10000009b38f839/frameset.htm

Help on Projection view

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed20446011d189700000e8322d00/frameset.htm

Help on Maintenace view.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/frameset.htm

Help on Help view

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed13446011d189700000e8322d00/frameset.htm

regards

vijay

[Former Member]

From ABAP syntax side, the SELECT is the same.

The underlying SAP database engine performs the actual JOINs declared within the view to retrieve the results for you.

[former_member181966]

Try the link :

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

http://www.sapdb.org/7.4/htmhelp/a8/cf8c3cc5bc5e16e10000000a114084/content.htm

Hope this`ll give you some guide line.

Thanks

[Former Member]

Hi Rajan,

You can write select statements for data base view similar to the way you are writing select statement for Tables.

Regards,

Lanka

[Former Member]

Hi,

For database views..select is a normal select how you write for any table select statement.