Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

create a View with many tables with the Table-Fieldnames

Former Member
0 Kudos

Hello!

Question 1)

Which kind of view is the correct for joining

many tables together.

Question 2)

What is the solution in case of having several tables

with the same fieldnames by creating a view. How can I choose this fields

into a view. I cant use the same name twice in section

(tab strip) ViewFlds.

Regards

Ilhan

6 REPLIES 6

Former Member

Former Member
0 Kudos

hi Ilhan,

Check out <b>v_equi</b> view for reference.

Regards,

Santosh

0 Kudos

hi,

can you please reply my second question at least?

Reagrds

Ilhan

Former Member
0 Kudos

Hello IIhan ,

1) If the view is only for read purpose , then database view is good.Also, depends wht kindof joins are required to join the tables. Go thru the link below :

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

2) If several tables have the same field, u can give a diff name and use it. But , why do u need the same fields from diff tables ?

0 Kudos

hello,

because I need them for an list output.

But I still don't know how to solve the problem with the same fields.

Reagards

Ilhan

0 Kudos

Hi Ilhan,

There is no problem in the view fieldname you can put something like this :

This is you who choose the view field name so...


View Fieldname         Table           Field
VBAK_VBELN           vbak             vbeln
vbap_vbeln                 vbap             vbeln

Erwan