Cannot find either column “sid” or the user-defined function or aggregate “sid.get_MSSQL_LANGU”, or the name is ambiguous

In transaction code ST22, you notice below ABAP dump occurs,

 Database error text: "SQL message: Cannot find either column "sid" or the
  user-defined function or aggregate "sid.get_MSSQL_LANGU", or the name is
  ambiguous."

Solution

There are multiple causes for this issue and we urge you to check, apply the solutioning based on your scenario. By the way, we manage to solve the issue with the assistance of SAP Note 2379616 – Error when accessing CDS views after a homogeneous system copy or refresh.

Repair the existing system by performing the following steps:

• For NetWeaver 7.50 and higher only: Apply note 2914109 using transaction SNOTE if necessary. This will update or create report RSMSSDROPCREGTT. Then run report RSMSSDROPCREGTT and choose “Recreate all GTTs”.
• Run report RUTCNVFUNCCRE1 and use “Force Execution” = ‘X’.
• Run report RUTDDLSCREATE with the option “All DDL Sources”.