topic Re: abap reports in Application Development and Automation Discussions

abap reports

Former Member — Mon, 03 Dec 2007 08:55:00 GMT

how to select records from two tables without any primary key between them?

Re: abap reports

Former Member — Mon, 03 Dec 2007 08:57:23 GMT

Its not possible to create a table wihout a primary key .

Its possible to create a structure without a primary key.

So for every table in SAP there must be a primary key

Rewar dif usefull

Re: abap reports

former_member386202 — Mon, 03 Dec 2007 08:57:41 GMT

Hi,

I think its not possible

Regards,

Prashant

Re: abap reports

Former Member — Mon, 03 Dec 2007 08:58:49 GMT

hi sujit,

welcome to sdn forum.

to retreive data from 2 tables without any key in common.

u can create an internal table using begin of statement.

then use the queries :

select * from table1 into corresponding fields of itab where cond.

select * from table2 into corresponding fields of itab where cond.

loop at itab into wa.

write : wa-f1,wa-f2......

endloop.

Re: abap reports

Former Member — Mon, 03 Dec 2007 09:00:13 GMT

Hi sujit sahoo,

its not possible to create table without a primary key.

If you want to get the fields from two tables means, you can use views.

Re: abap reports

Former Member — Mon, 03 Dec 2007 09:32:44 GMT

Hi,

Sujit

u mean to say there is no relationship between those tables

if u have data in common then it is possible to estabilish connection between thos two tables as concered with the program

try like this

do.

read table tabl1_name where condition.

read table tab2_name where conditon(i.e. data based on the previuosly retrieved)

append work area to internal_table.

if .

some exit condition.

endif.

enddo.

plzzz reward if usefull.

feel free to ask any quiries

my mail id is mutyalasunilkumar@gmail.com

dont forget to reward.