Insert entry to a view

[Former Member]

Hi All,

i need to insert an entry to a 'Z' view, which is join of 2 tables (TRUG & TRUGT).

for that, i am inserting the entry to table TRUG and able to insert with the program, but i am not able to insert the Description of the text table TRUGT..so, the result is, am getting the values from TRUG to Z view, but am missing the description value in the Z view which is coming form TRUGT..

could anyone help me in inserting an entry to a view..

Thanks,

Pavan

[Former Member]

Hello

You do not need insert values with the programm.

For Reason for Variances maintain use maintance view V_TRUG. Create new record, give description and save.

All data will be in TRUG, TRUGT and your Z-view.

[Former Member]

Hi,

Tnx for the quick reply. but here i am maintaining manually. i need to insert the data from Excel to View..

Regards,

Pavan

[Former Member]

Solved by myself...

[Former Member]

Hello

You can not insert data into view directly because view is SQL operation (create with conditions) not a table.

If you inserted to table TRUG why are you not able to insert data into TRUGT ?

You have error ?

When you insert data into TRUGT that record will be in z-view.