Why create table as select statement is not working

[#1]

Hi All,

I have table in S4 schema and i need to create another table in custom schema. I just wrote a simple SQL statement in SQL Console Create Table <TableName> as Select * from S4.<Tablename>. It's getting failed.

I tried in all methods what we can use in SQL but it's getting failed. I'm not sure what i'm missing in conceptual.

[Vitaliy-R]

Can you try with ()

Create Table <TableName> as (Select * from S4.<Tablename>)

?

Please see https://help.sap.com/viewer/c1d3f60099654ecfb3fe36ac93c121bb/2021_4_QRC/en-US/20d58a5f75191014b2fe92...

Regards.