table from sqlserver to maxdb

[Former Member]

hello expert

i met a strange issue about sql expression.

SELECT * FROM /smb/sb_t_004

INTO TABLE ldt_pa_hdr

FOR ALL ENTRIES IN ldt_filename

WHERE soluid = p_sol_source

AND filename = ldt_filename-filename.

the table /smb/sb_t_t004 is defined in development system, but the database server is sql sever.

the test is okey. but after transported into QA system , which is connected with MAXDB server. but the test is short dump.

i don'g why that occurs.

following is information

Short text

SQL error in the database when accessing a table.

Looking forward to your reply

Best Regards,

Kevin

[Former Member]

Hi,

See the theards, it may help u

https://forums.sdn.sap.com/click.jspa?searchID=12748275&messageID=5464235

https://forums.sdn.sap.com/click.jspa?searchID=12748275&messageID=5464631

Regards

Kiran Sure

[Former Member]

more information

Database error text........: "POS(338) Too complicated SQL statement (too much data)"

[Former Member]

SAP Note No. 1001257