Warning Transformation Task : SELECT INTO - Please use CREATE table AS insted

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

1 Like