topic Re: Create view in Application Development and Automation Discussions

Create view

Former Member — Wed, 27 Aug 2008 07:26:36 GMT

Hello!

It is possible create a view that it will be the union of three tables?

For instance we have:

Ztable1: mandt,bukrs,hkont

Ztable2: mandt, hkont

Skb1: mandt, bukrsu2026

And we want display all fields of ztable2 (interaction with skb1) and all fields of ztable1 that have the same bukrs that skb1.

For instance if we have:

Ztable1: 100;002;4760000;

100;008;5760000;

Ztable2: 100;55400000;

Skb1: 100;55400000;002;

100; 5760000;008;

100; 4720000;002; ...

The result of the view would be: (if we select bukrs = "002")

100;002;4760000;

100;002;55400000

It is possible?

Thanks a lot

Former Member — Wed, 27 Aug 2008 07:29:19 GMT

Hi u use maintance view....In maintance view u can view more then three table and u can edit also

Regards:

Prabu

Former Member — Wed, 27 Aug 2008 07:39:20 GMT

hi,

Try to create a database view, U can create it for those three tables with the conditions.. U ll get ur desired results

Success..