topic Re: Views in Application Development and Automation Discussions

Views

Former Member — Wed, 29 Aug 2007 18:20:20 GMT

Hi All,

My query is related to views.

If we have two tables ZEMP(employee data) and ZDEP(Depatment data). Using these two tables we want to make a view. Now bothe the tables have following fields in common.

1. client

2. carrid(airline id)

3. department code

But there are few foreign key relations in the table ZEMP, those are:

SCAR-CARRID = ZEMP-CARRID

SCARR-MANDT = ZEMP-CLIENT

where SCARR is the check table.

Could you please tell me how we will define the table join conditions using the Relationships tab and using the fields.

Regards,

Dhiraj

Re: Views

Former Member — Wed, 29 Aug 2007 18:33:32 GMT

goto se11.

give the name of the view and click on crete

under table/join condition.

under tables column give ur two tables.

in join condition give like this

table fieldname table fieldname

zemp client = zdep client

zemp carrid = zdep carrid

zemp department = zdep department

and in view fields give the table and field name that you want to see as output

and if you want to restrict some vlaues then go to selection condtion tab and maintain the condions.

Thanks

mahehs

Re: Views

Former Member — Wed, 29 Aug 2007 18:50:44 GMT

Thanks Mahesh for your note.

Please also let me know that how we can use the foreign key relationship as i have shown in the join conditions. We use the relationship tab on the view maintainence screen to add all the join conditions due to foreign keys, if i am not wrong.

Please help me with this point too.