Skip to Content
Former Member
Apr 25, 2010 at 04:52 PM

Can we insert/update records in view table using SAP PI JDBC


Hello All,

I am unable to insert/update records to a view table created in SQL server.. I am able to see the view table in the SQL data base. I am getting an error in the CC saying that NULL value cannot be inserted in the Table (actual table name Based on which view table is created).... But in payload I can see all values are passed.. I even tried wiht same mapping but chaging the view name with the actual table name which is showing in the CC error, which successfully created the records with out any issues... Unable to insert/update using view name....

I am sucessfully inserted/updated the records using SAP PI on tables on the same SQL server... But Unable to insert/update records on Views tables.. Wondering is it possible or not possible??

I cant even see the view table structure in the External Defination import tab in ESA.. where as I can see the tables structure.. Can any one throw some light on this.