topic Re: Cannot Use Table BSIK in CTE Query in Application Development and Automation Discussions

Cannot Use Table BSIK in CTE Query

immanuels — Sun, 21 Feb 2021 03:51:37 GMT

I need to query from table BSIK / BSAK and use it in my CTE Query.

But when I use it, it shows an error "Use the associated entity BSIK_VIEW".

Below is my query just for example (simplified).

  with +inv as
  (
  select bukrs, belnr, gjhar from bsik
  ) 
  select * from +inv into table @data(lt_test).

so what is the difference between BSIK and BSIK_VIEW, and why I cannot use table BSIK in my CTE Query ?

Thanks

Re: Cannot Use Table BSIK in CTE Query

Sandra_Rossi — Sun, 21 Feb 2021 07:48:09 GMT

See there: Replacement Objects

In comment of https://blogs.sap.com/2016/07/11/appending-tables-in-s4hana-easy-mbew/, Horst says "Using Extras -> Proxy Object in SE11 you can find out whether a CDS view is replacing a database table. If this is the case, Open SQL accesses the CDS view instead of the table itself."