Skip to Content

Syntax check warning - The database feature "TABLE_LEN_MAX1" is used

Hello,

I am getting a Syntax check warning with message 'The database feature "TABLE_LEN_MAX1" is used here' for the following query-

SELECT so~vbeln ,
so~kunnr ,
soi~posnr ,
soi~matnr ,
soi~kwmeng ,
soi~vrkme ,
cs~name1 ,
mk~maktx
FROM vbak AS so INNER JOIN vbap AS soi ON so~vbeln = soi~vbeln
INNER JOIN kna1 AS cs ON so~kunnr = cs~kunnr
INNER JOIN makt AS mk ON soi~matnr = mk~matnr
INTO TABLE @DATA(lt_so)
WHERE so~vbeln IN @so_vbeln
AND so~erdat IN @so_sodat
AND so~vkorg IN @so_vkorg
AND so~kunnr IN @so_kunnr
AND mk~spras EQ @sy-langu
ORDER BY so~vbeln ASCENDING, soi~posnr ASCENDING.

Can anyone tell me what's the issue with this query?

Regards,

Pritam

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 18, 2017 at 08:58 AM
    • The length of the structure of a database table is restricted in such a way that the requirements of all supported database platforms are met. At SAP, tables can be flagged to allow this restriction to be exceeded if enhancements are used. When tables flagged in this way are accessed using Open SQL, a syntax check warning occurs. The warning indicates that a cross-platform replacement implementation must be made. The class CL_ABAP_DBFEATURES can be used to identify which restriction is supported by the current database system.
    Add a comment
    10|10000 characters needed characters exceeded

    • Well, it's a translation ...

      "cross-platforn" better should have been translated as "platform-independent" here.

      If you are sure, that you only work on platforms that support the DB feature, simply add the respective pragma that can be taken fron the warning's long text. Otherwise, for other platforms, you know now that you have to take care. If the database is extended beyond the limits of the platform, you cannot access it in the same way as on platforms that support the limit.

  • Posted on Dec 18, 2017 at 09:39 AM
    -2

    Just use search function on this side, you might find that this topic was already discussed:

    https://answers.sap.com/questions/102532/system-wide-de-activation-of-certain-slin-syntax-c.html

    Add a comment
    10|10000 characters needed characters exceeded

    • Thank you so much for your time to respond my query. I had checked the link before asking the question. However, I didn't want to turn off this check and I wanted to understand the root cause of it. So I had shared particular query where I was getting that syntax check error. It'll be of great help if you share some insight.

      Thanks again :)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.