Data Dictionary

[Former Member]

Hi

How do we Write a Select Statment for View table in program

Regards

Sai

[Former Member]

Hi,

view doesnt have any physical storege like tables, so u cant write select on views.

Regards

Nilesh

[hymavathi_oruganti]

select <data> from <table>/<view> into table <itab>

[Former Member]

Hi Hymavati

Thz for ur answer .ok if i am using more than one table with 4fields from 1 table and 4 fields from 2nd table wat would be the select query

Regards

sai

[former_member196299]

HI ,

For using more than one table with 4fields from 1 table and 4 fields from 2nd table , use a join condition in your select querry ... this should solve your prpblem ...

Regards,

Ranjita

[Former Member]

hello sai,

you can use <b>select * from</b> or its variants only if you are selecting from a database table, projection view or database view. if its a maintance view you can write seperate select queries for each database table.

Regards,

Mithun

[Former Member]

hi sai,

we can write select statement for view as u write select statement for data base table.

regards,

seshu.

[Former Member]

Hi Sai

The select query for view table looks like,

SELECT * FROM DD01V

WHERE DOMNAME LIKE 'CHAR%'

AND DDLANGUAGE = SY-LANGU.

ENDSELECT.

REWARD IF USEFUL...!!

[Former Member]

Hi,

Format of a Select with a join

SELECT A_{FIELD1 A}FIELD2 A_{FIELD3 A}FIELD4

B_{FIELD5 B}FIELD6

from TABLE1 As A TABLE2 as B

where

( Give the where clause)

on (Give the join Condition inner join / outer join & the respective fields)

Kindly reward helpful answers,

Regards,

Gaurav