Create view

[Former Member]

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]

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

Regards:

Prabu

[Former Member]

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..