Can we create a view involving a standard table and a ZTable ?

[Former Member]

Hi,

I created a view based on 2 tables : EKKO and a Ztable having EBELN field in common.

Now, when i try to create a PO in ME21N , this view should get updated.But,It doesn't happen so.

So i want to confirm that is it not possible to create a view on a Ztable...

Also can anyone suggest any other option to do so...

[Former Member]

of course you can create a view on Ztable.

but the view did not contain data, it's data come from the standard table and ztable,

if the standard transaction did not update the data of Ztable, you can't get data from the view too.

[Former Member]

Hi,

Yes you can create a view using a standard view using a standard Data base table and a custom data base table. But this getting updated would not be done by the standard program of Tcode ME21N, I reckon you need to write the logic of updation in an enhancement.

Regards,

Murthy.