topic Re: regarding fetching data from diff tables in Application Development and Automation Discussions

regarding fetching data from diff tables

Former Member — Tue, 26 Jun 2007 10:12:55 GMT

hi experts,

i wan to know how cud i fetch data from more than one table.should i use views for this..

regards

raman

Re: regarding fetching data from diff tables

Former Member — Tue, 26 Jun 2007 10:16:12 GMT

Hi,

U can fetch the data from more than one dbtable using select statement or creating a view.

Views are logical views on more than one table..

Check this link...

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm

Look at the below link to create the Database view

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

Regards,

Priyanka.

Re: regarding fetching data from diff tables

Former Member — Tue, 26 Jun 2007 10:25:21 GMT

thanx priyanka,

tell me how can i declare views in my program.

regards,

raman.

Re: regarding fetching data from diff tables

Former Member — Tue, 26 Jun 2007 10:37:37 GMT

You can fetch data from more than one table using JOINS

you join the table using key fields and fetch data

select a_{matnr a}mtart b_{werks c}lgort

into table itab

from mara as a Join marc as b

on a_{matnr = b}matnr join MARD as d

on b_{matnr = c}matnr and

b_{werks = c}werks

where matnr in s_matnr.

Again You can create database View with more than one table and write a select to that view, again in that view tables are to be linked with key fields.

- Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

<b>Reward points for useful Answers</b>

Regards

Anji

Re: regarding fetching data from diff tables

Former Member — Tue, 26 Jun 2007 10:37:39 GMT

Hi Raman,

In the first link they have shown a example.Pls go through it, if doesn't help, reply back.

Best Regards

Kusum

PS: Reward all helpful answers.

Re: regarding fetching data from diff tables

Former Member — Tue, 26 Jun 2007 10:39:55 GMT

as per requirement u can access more than one table through join commands

there is 2 types of join, one inner join and another is outer join. this will solve the problem. if u need I can send the code also.

thanks

Roopesh

Re: regarding fetching data from diff tables

Former Member — Tue, 26 Jun 2007 10:55:54 GMT

hi,

can u plz send me the code if possible.

regards,

raman