Skip to main content
Dear everyone, I hope you are all doing okay ! When executing a transformation task (Cancel Invoice for M2C) i get the following warning : Warning! SELECT INTO statements currently only insert 100 rows. Please use CREATE TABLE AS instead I do not understand why this happens since it appears also when i do not use a select into statement but only a distinct count statement See below my script if needed Very thankful for some advice ! Best regards, Antoine SPIRIDON SELECT DISTINCT COUNT (*) FROM EABL JOIN EABLG ON 1=1 AND EABL.MANDT = EABLG.MANDT AND EABL.ABLBELNR = EABLG.ABLBELNR JOIN EVER ON EABLG.MANDT = EVER.MANDT AND EABLG.ANLAGE = EVER.ANLAGE JOIN ERCH ON EVER.MANDT=ERCH.MANDT AND EVER.VERTRAG=ERCH.VERTRAG AND ERCH.BELEGART IN (VA, SA) JOIN ERCHC ON 1=1 AND ERCH.MANDT = ERCHC.MANDT AND ERCH.BELNR = ERCHC.BELNR JOIN ERDK ON ERCHC.MANDT = ERDK.MANDT AND ERCHC.OPBEL = ERDK.OPBEL AND ERDK.INTOPBEL IS NOT NULL JOIN DFKKOP ON 1=1 AND ERDK.MANDT= DFKKOP.MANDT AND ERDK.OPBEL= DFKKOP.XBLNR AND DFKKOP.AUGRD = 05
Hi Antoine, Welcome to the community! I think that this falsly appears because a column name contains the word INTO. You can solve this by saving the result of the query to a table instead of only displaying the output. Best, Leonid