topic Re: Data Dictionary in Application Development and Automation Discussions

Data Dictionary

Former Member — Thu, 10 May 2007 10:16:20 GMT

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

Regards

Sai

Re: Data Dictionary

Former Member — Thu, 10 May 2007 10:26:35 GMT

Hi,

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

Regards

Nilesh

Re: Data Dictionary

hymavathi_oruganti — Thu, 10 May 2007 10:58:51 GMT

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

Re: Data Dictionary

Former Member — Wed, 30 May 2007 08:50:01 GMT

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

Re: Data Dictionary

Former Member — Wed, 30 May 2007 09:08:08 GMT

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

Re: Data Dictionary

former_member196299 — Wed, 30 May 2007 10:26:01 GMT

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

Re: Data Dictionary

Former Member — Wed, 30 May 2007 11:31:27 GMT

hi sai,

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

regards,

seshu.

Re: Data Dictionary

Former Member — Thu, 31 May 2007 09:06:41 GMT

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...!!

Re: Data Dictionary

Former Member — Fri, 01 Jun 2007 14:32:59 GMT

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