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