-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: Using functions in Open SQL
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Using functions in Open SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023 Jul 28 11:30 AM
- SAP Managed Tags
- ABAP Development
- SQL
Hi ABAP experts,
What is the issue here? How do I use Open SQL functions without this error?
Message 249 ( is invalid here (due to grammar).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023 Jul 28 1:56 PM
- SAP Managed Tags
- ABAP Development
- SQL
LENGTH( ... ) is only supported since ABAP 7.50
Anything not supported can probably be done with Native SQL (SQL sent directly to the database, by using e.g. ADBC, deprecated EXEC SQL, etc.) but of course .
You can also try workarounds. I don't know your exact context, maybe you can replace LENGTH( ZZZ ) = 1 with ZZZ LIKE '_' (first character = any character an rest of characters = blank)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023 Jul 28 12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023 Jul 28 12:17 PM
- SAP Managed Tags
- ABAP Development
- SQL
Thanks sandra.rossi , are there any functions we can use below 7.5?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023 Jul 28 1:49 PM
- SAP Managed Tags
- ABAP Development
- SQL
Please use the COMMENT button for comments, asking for complements, adding details, replying to a comment or a proposed solution or to the OP question, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2023 Jul 28 1:56 PM
- SAP Managed Tags
- ABAP Development
- SQL
LENGTH( ... ) is only supported since ABAP 7.50
Anything not supported can probably be done with Native SQL (SQL sent directly to the database, by using e.g. ADBC, deprecated EXEC SQL, etc.) but of course .
You can also try workarounds. I don't know your exact context, maybe you can replace LENGTH( ZZZ ) = 1 with ZZZ LIKE '_' (first character = any character an rest of characters = blank)
Bluesky