https://community.sap.com/t5/application-development-and-automation-discussions/replacing-sql-views-by-cds-views-tables-statement/m-p/12511418#M2004055 <P>I am working on <A rel="nofollow noreferrer" href="https://wiki.wdf.sap.corp/wiki/display/SuiteCDS/VDM+CDS+Replacement+of+SQL+View+Usage">VDM CDS Replacement of SQL View Usage</A>, and there is a specificity when replacing SQL Views on TABLES statements.</P> <P>Example: 'TABLES: bsis.' can't be simply replaced by 'TABLES: bsis_view.'</P> <P>The suggested approach as described in the Wiki is to <EM>"create a dedicated DDIC structure or DDIC view in SE11 as a substitute for the generated SQL view."</EM></P> <P>I am just wondering if anyone followed this approach and what's your feedback on that? Alternatively, is it an option to use the backup tables instead, such as BSIS_BCK in this example?</P> Mon, 31 Jan 2022 12:37:25 GMT goncalo_costa_levy 2022-01-31T12:37:25Z https://community.sap.com/t5/application-development-and-automation-discussions/replacing-sql-views-by-cds-views-tables-statement/m-p/12511418#M2004055 <P>I am working on <A rel="nofollow noreferrer" href="https://wiki.wdf.sap.corp/wiki/display/SuiteCDS/VDM+CDS+Replacement+of+SQL+View+Usage">VDM CDS Replacement of SQL View Usage</A>, and there is a specificity when replacing SQL Views on TABLES statements.</P> <P>Example: 'TABLES: bsis.' can't be simply replaced by 'TABLES: bsis_view.'</P> <P>The suggested approach as described in the Wiki is to <EM>"create a dedicated DDIC structure or DDIC view in SE11 as a substitute for the generated SQL view."</EM></P> <P>I am just wondering if anyone followed this approach and what's your feedback on that? Alternatively, is it an option to use the backup tables instead, such as BSIS_BCK in this example?</P> Mon, 31 Jan 2022 12:37:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-sql-views-by-cds-views-tables-statement/m-p/12511418#M2004055 goncalo_costa_levy 2022-01-31T12:37:25Z https://community.sap.com/t5/application-development-and-automation-discussions/replacing-sql-views-by-cds-views-tables-statement/m-p/12511419#M2004056 <P>Hi,</P><P>in our S/4 syste BSIS is already a CDS view.</P> Tue, 01 Feb 2022 06:29:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-sql-views-by-cds-views-tables-statement/m-p/12511419#M2004056 RobertVit 2022-02-01T06:29:01Z